|
oisin clarke
|
May 19, 2013 at 6:06 am
Hi,
I can’t seem to get the csv import working even with the sample file.
I get the message:
Upload file has been deleted.
Added a total of 1 events to the database.
but no events get added even when I upload another file with more then one event it still gives the same message.
Thanks
|
|
Dean
|
May 20, 2013 at 2:26 am
Hi,
The sample file needs updating, but the import notes state that the dates need to be in the following format 2013-05-20 (YYYY-MM-DD).
So when the dates were not in that format, it failed to upload, but when they are the import works fine.
So can you check the dates in your spreadsheet and modify them and try again please?
|
|
oisin clarke
|
May 20, 2013 at 2:49 am
Hi Dean,
Thanks for the reply, I still can’t seem to get it working below is the contents of the csv file I’m using.
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,Annual Fishing Derby,”””The annual fishing derby sponsored by Monroe Vineyard Church.”””,1234 West Somewhere,Salt Lake City,Utah,USA,84128,801-555-5555,Y,AFD-2009,12-1-2012,12-3-2012,10:00:00 AM,12:00:00 PM,125,10,Y,3,Y,Y,”””***This is an automated response – Do Not Reply***
Thank you [fname] [lname] for registering for [event].
We hope that you will find this event both informative and enjoyable.
Should have any questions, please contact [contact].
If you have not done so already, please submit your payment in the amount of [cost].
Click here to reveiw your payment information [payment_url].
Thank You.””
“,10-10-2011,10-15-2011
|
|
oisin clarke
|
May 20, 2013 at 2:58 am
Sorry I just realised that was the wrong file, this is the correct one I’m using
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,Annual Fishing Derby,”””The annual fishing derby sponsored by Monroe Vineyard Church.”””,1234 West Somewhere,Salt Lake City,Utah,USA,84128,801-555-5555,Y,AFD-2009,2013-07-20,2013-07-21,10:00:00 AM,12:00:00 PM,125,10,Y,3,Y,Y,”””***This is an automated response – Do Not Reply***
Thank you [fname] [lname] for registering for [event].
We hope that you will find this event both informative and enjoyable.
Should have any questions, please contact [contact].
If you have not done so already, please submit your payment in the amount of [cost].
Click here to reveiw your payment information [payment_url].
Thank You.””
“,2013-07-20,2013-07-21
|
|
Dean
|
May 20, 2013 at 3:05 am
Hi,
You have the dates like this 12-1-2012
they need to be like this 2012-01-12 (Year-month-date).
|
|
Dean
|
May 20, 2013 at 3:06 am
Right, just saw your second post, so ignore my previous reply.
Is it possible to get your login details in order to look into this?
If so, please send them via https://eventespresso.com/send-login-details/
NOTE: login details need to be Admin level.
|
|
oisin clarke
|
May 20, 2013 at 3:14 am
Thanks Dean,
I just sent them to you
|
|
Dean
|
May 20, 2013 at 4:03 am
I responded via email.
|
