CSV Import not working properly

[mountainx]

The importer is importing but it’s not correctly importing the start and end dates. They are coming in as 1970 no matter what I do. I did this a couple of months ago and it worked fine then. Can anyone reproduce this??

[Barry]

Hi @mountainx,

I’m sorry to hear you are experiencing problems here. Can you provide a sample of the data you are importing or at least of the date and time formats?

Thanks!

[Barry]

Just checking in here – do you still need help with this one?

[mountainx]

We’ve identified the issue. The export of our events contained the value NULL for start and end time if none was set. However your import script only checks if time is not empty and therefor attempts to convert a date time with NULL in the value. This function fails and returns a date from 1970. I suggest asking your programmers to check for a valid time before adding it to the date. This could better improve date success rates.

Thank you!

[Barry]

(Closing this out as it’s a fairly old thread at this point.)

[Author]

Posts