Imported event start dates are incorrect

[Justin Roper]

Hi I’ve tried importing a CSV file of event dates. Dates and times are in the correct format in Excel. The events preview correctly during the import process, however when the import process is completed and viewed on my site, event start dates default to 1/1/1970. How do I fix this?

[Sky]

Hi Justin,

I’m sorry to hear you’re having issues when importing events via CSV. I’ll try to help you figure out the problem.

Can you upload the CSV that you’re trying to import? You can post it in a private reply if you want. I’d like to try importing into my test environment to see if I can replicate the issue.

Thanks!
Sky

[Justin Roper]

Hello Sky

I’m replying directly as when I click on the support tickets page all I get
is a page not found error.

I’ve attached the spreadsheet for you to try.

Kind regards

Justin Roper
e-Learning | ICT | Assessment | Systems
Haslingden High School
Broadway, Haslingden, Lancashire BB4 4EY
*www.haslingdenhigh.com *

—

This e-mail contains information intended for the addressee only. It may
be confidential and may be the subject of legal and/or professional
privilege. If you are not the addressee you are not authorised to
disseminate, distribute, copy or use this e-mail or any attachment to it.
The content may be personal or contain personal opinions and unless
specifically stated or followed up in writing, the content cannot be taken
to form a contract or to be an expression of Haslingden High School’s
position. Haslingden High School reserves the right to monitor all incoming
and outgoing email.

Haslingden High School has taken reasonable steps to ensure that outgoing
communications do not contain malicious software and it is your
responsibility to carry out any checks on this email before accepting the
email and opening attachments.

[Sky]

Justin,

Sorry, I don’t see the file attached to your last reply. You can use the “add media” button to upload and insert the CSV file.

Thanks,
Sky

[Justin Roper]

This reply is private.

[Sky]

This reply is private.

[Justin Roper]

Hi I’ve reimported the dates in US format (mmddyyyy) and I’m still seeing dates presented as 1st Jan 1970.

I’ve attached the updated import file for you.

Please note I’d like to be able to manage dates in ddmmyyyy format for the UK.

Kind regards

[Sky]

Justin,

I was able to successfully import this CSV file without the date errors this time.

Can you check the following:

Delete previous versions of the events that you are importing. If they go into the “ignored” group, select and “permanently delete.”

In Events > Settings > Imports > Event Update Authority, make sure that “Overwrite my event with any changes from the original source” is checked.

When you go to re-import the events, make sure that each column heading is assigned to the correct data type in the import preview. Any data that doesn’t apply to the event should be marked “do not import.” The preview scrolls to the right, so make sure you set all available columns.

With these steps and settings in mind, can you try importing again?

As far as formatting goes, please check out this bit from our knowledgebase:

Date – Accepts formatted dates. Preferably use the ISO 8601 date format YYYY-MM-DD as it is unambiguous (ex. 2015-12-31). If you wish to use the North American “middle-endian” format, slashes are recommend (ex. MM/DD/YYYY). If you wish to use the international little-endian format separate it with dashes (ex. DD-MM-YYYY).

Let me know if you are able to get a successful import implementing any of this information.

Thanks,
Sky

[Justin Roper]

Thanks for your help – all sorted now! Using yyyymmdd did the trick and by playing around with the column headers

Justin

[Sky]

Justin,

Awesome! Glad that worked for you.

Please let us know in the future if you have any other questions or issues.

Take care,
Sky

[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