Import

[Mattias]

I try to import a csv-file with locations but it when I press Preview It only give me the option to map the first two columns. Then there are no more drop down menus.

I have tried separating the columns with quots, using “,” tab and #;”. Nothing works.

How do I do if I need to import rows that contains comas?

[Hunter]

Hello,

Please review the following documentation relating to importing CSV-related content and let me know if they help answer your questions. You can compare our example files to ensure you’re following proper procedure:

• CSV file examples for importing
• Importing Data from a CSV File

Thanks and have a pleasant rest of your day. Cheers!

[Mattias]

Thank you for the reply, but it still does not work. See attached screenshot (import.png).

I am trying to import “places”. My CSV-file contains five columns, but it breaks after the second column and I get no drop down for column 3,4 and 5.

I have escaped the comas (\,) in the csv-file.

The file in UTF-8 encoded.

Futermore, I did not see any documentation on importing places on this page:
https://theeventscalendar.com/knowledgebase/csv-files-options-and-examples/

[Mattias]

I solved it. It seems like the CSV HAVE to contain column headlines. It also seems like the csv must conting all kolumns. I thought you could hav a csv that only containd the fileds that you actually want to import.

[Hunter]

Hey Mattias 🙂

I appreciate the update and am happy to hear the issue has been resolved. Thanks for sharing what you learned so others can benefit from your hard work. Please open a new thread if you have any more questions. Cheers!

[Author]

Posts