Import changing event name & date to 1970

[Matt]

Hi guys,

I’m using the plugin on a website to show opening times.

It’s pretty much impossible to enter every opening and closing time for my client manually 365 times for each year so I purchased the pro version to import from a spreadsheet.

However, when I import the feed (in exactly the same format as the sample feed you provide) it changes some event names and some event dates to 1970. It is very important to add that some entries import perfectly fine, while others have the above errors – yet they are in exactly the same format.

All events are simply named after the day of the week. So for example, Monday, Tuesday, Wednesday. The strange thing is, after the import, the event names that the import changes are still days of the week, but just the incorrect one.

Attached is a sample of the import file.

Can somebody please explain how I can resolve this error in the importer, or another way round this issue?

Thanks

[Nico]

Hi there Matt,

Thanks for getting in touch with us and sorry to hear about this issue 🙁

Let me run some tests with the file and I’ll get back to you soon.

Best,
Nico

[Matt]

Thanks Nico, appreciated.

Did you have any luck?

[Nico]

Sorry Matt, couldn’t get to this today! I’ll review this tomorrow and will let you know about it!

Best,
Nico

[Nico]

Hey Matt,

Thanks for the patience while I worked this out!

I could reproduce the issue with the dates not getting correctly set and I’m mostly sure the culprit is the date format. Can you try modifying the dates to the YYYY-MM-DD format?

Please give this a try and let me know about it,
Best,
Nico

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts