|
Adal Bermann
|
June 13, 2014 at 5:12 pm
This has caused me hours of grief. There seems to be a bug where you have to add an additional blank field for the import to work correctly.
This single event import (used for example) did not work correctly (it created super weird results in the database and no listing in the wp admin):
0,event_name,event_desc,address,city,state,country,zip,phone,display_desc,event_identifier,start_date,end_date,start_time,end_time,reg_limit,event_cost,allow_multiple,additional_limit,send_mail,is_active,conf_mail,registration_start,registration_end
1,An event title,”An event description”,super simple address,,,,,,Y,event0001,09/19/2014,09/19/2014,10:45:00 AM,11:45:00 AM,60,0,N,3,Y,Y,,04/20/2014,09/21/2014
However for some unknown reason, this did (note the extra comma after the address field):
0,event_name,event_desc,address,city,state,country,zip,phone,display_desc,event_identifier,start_date,end_date,start_time,end_time,reg_limit,event_cost,allow_multiple,additional_limit,send_mail,is_active,conf_mail,registration_start,registration_end
1,An event title,”An event description”,super simple address,,,,,,,Y,event0001,09/19/2014,09/19/2014,10:45:00 AM,11:45:00 AM,60,0,N,3,Y,Y,,04/20/2014,09/21/2014
So there seems to be a bug that is potentially causing others to get really frustrated too.
|
|
Dean
|
June 14, 2014 at 12:57 am
Hi Adal,
The issue with the first structure is that there are only 6 commas, meaning 5 spaces, whereas there should be 7 commas equalling 6 spaces.
These six spaces refer to address2, city, state, country, zip and phone.
Basically the first structure was missing a column value, which will cause errors. In total there are twenty six columns. Your first example had 24 and the second 25. Now 25 is ok as the last column can be left blank, but the 24 started putting incorrect data in incorrect columns.
|
|
Adal Bermann
|
June 15, 2014 at 2:08 pm
Hey Dean,
That’s EXTREMELY confusing, because your official documentation (and example CSV) do not mention at all the existence of the address2 column.
https://eventespresso.com/wiki/how-to-import-events/
I really suggest you fix those two help items.
Adal
|
|
Dean
|
June 16, 2014 at 12:42 am
Hi Adal,
My apologies that the documentation was incorrect, we have fixed that now.
The sample file that can be downloaded from the import page does have the correct number of columns, and can be used to add all your data in for import (I double checked this when first answering your query).
|
|
Adal Bermann
|
June 16, 2014 at 12:49 am
Glad that was fixed Dean, and I hope that EE4 will have an even better import tool, a feature that I use a lot.
Cheers,
Adal
|
