Import CSV

Jan 28, 2015 at 2:57 PM
Is possible to import a CSV file?
Or what is the best way?

thanks
Fabio
Coordinator
Jan 29, 2015 at 2:12 PM
Ok, here goes

There is a hidden functionality for data import export. It's hidden because there is no documentation or video yet, but we use it for various projects so it should be stable.

How to get there? Well, open a normal admin-dialog, go to export or something and then copy the URL of the IFrame in the dialog. It will be something like this:

http://2sxc.org/en/Learn/ctl/import/mid/681/AppId/2?popUp=true

Then, replace the word Import with "dataexport" or "dataimport", so it will be a bit like

http://2sxc.org/en/Learn/ctl/dataexport/mid/681/AppId/2?popUp=true
or
http://2sxc.org/en/Learn/ctl/dataimport/mid/681/AppId/2?popUp=true

It should be very self-explanatory, but since it's not officially released, there are things in it which aren't 100% ready. For example, avoid importing/exporting any of the content-types starting with a "|" symbol, these should actually be hidden.

Good luck :)
Feb 4, 2015 at 2:26 PM
try but don't work for CSV
Feb 4, 2015 at 2:31 PM
try to export one XML

made a simple modify import and obtain

Try to import: test import.xml
File contains the following errors:
Selected content-type does not match the content-type in the XML file.
Feb 4, 2015 at 2:33 PM
I try more and more times, but the error is always the same
van you please send me a small example of file to import thaat don't return error?
Coordinator
Feb 5, 2015 at 3:41 PM
Hi rmartin

The idea is that you first export a file (so you get a template for the desired structure), then fill that using excel or something - then re-import it.
Feb 5, 2015 at 5:40 PM
Yes, Is exactly what i have made, but I always receive the same error
"wrong contentype"

I export and try to import the same file

Thanks
Fabio
Coordinator
Feb 9, 2015 at 1:34 PM
I would have to guess, but it's probably better you send me a link and login to info at 2sxc.org