Import of data by using csv files

[Uwe]

Hi, I´m in trouble regarding the use of a comma as separator for keywords.
I understand that the comma is defined as the separator for fields in csv files as it is regarding more than 1 keyword in the events calendar.
Based on this condition, how can I import more than one keyword by using a csv file to import data?
Is there an opportunity to change the separator for csv files?
Thanks in advance for your help.

[Andras]

Hi Uwe,

That is a great question, thanks for getting in touch with it!

Usually when you have a comma in a textfield that you want to have in a CSV file, then the text field is surrounded with quote marks. Something like this:

 datum,zeit_von,zeit_bis,titel_de,kategorien
9/6/2017,2:00:00 PM,6:00:00 PM,Entspannung,"kategorie 1, kategorie 2"

You can also try changing the separator to semi-colon “;” and check if that gets imported properly.

But the first option definitely works. I just did a quick test with Excel. If you set up your data and save as CSV (CSV UTF-8), then that is how it is going to be saved.

Does this help? Let me know if you have any further questions.

Cheers,
Andras

 

[Uwe]

Hi Andras,
Thanks for your help.
Regarding the use of a semicolon instead of a comma, this did not work as the Events calendars import routine obviously cannot identify semicolons as separators.
Finally I made it by processing the data as follows:
First, I exchanged the commas between the keywords with a dummy like for example [///].
Second, I added a row before and after the row containing the keywords and filled the fields with a different dummy for each row as for example [HHHH] and [KKKK].
It´s important to have 3 different dummies to be able to exchange the right data sections later on.
Third, I saved the Excel file as CSV file and opened the csv file in an editor.
Then, I exchange all semicolons with commas, all [,HHHH,] with [,”] and all [,KKKK,] with [”,] and last but not least all [///] with [,].
That finally worked proper.
Thanks again for your support and greetings from Munich,

Uwe

PS: For all the search/replace work I only used the content in-between the square brackets.

[Andras]

Hi Uwe,

Bin froh zu hören dass du es geschafft hast! Gratuliere!!!

That is also a great approach to use when you don’t have a software on hand that can do this automatically. If you don’t have Excel, you might want to try Google Spreadsheets, I believe that should also be capable of doing a CSV export. Maybe also the free online version of Excel.

Since this is marked resolved I am going to close this ticket, but if you need anything else related to this topic or another please create a new ticket and we’ll be happy to help.

Cheers,
Andras

PS: If you like our plugins, and you didn’t yet do so 🙂 we would be happy to receive a review in the wordpress.org repository. Thanks!
https://wordpress.org/support/view/plugin-reviews/the-events-calendar/

PS2: We’d be also grateful if you would give us feedback on your satisfaction with support. Just click on one of the classy looking emojis below. 🙂 If you can spare a few words, that’s even better. Doublethanks!

 

[Author]

Posts