I unfortunately do not have it handy / saved. I used excel to create column headers using the headings that are shown in the CSV import section, and data filled from there. Im assuming that I was missing a header or had a null value someplace that I was unaware of...My bet is that I didnt specify calendar name to import to. Ill be trying it again today. Saved it as a csv file and ran the import, got a "0 records imported" message....
Having much difficulty with the new CSV import feature, can you point me to any docs or setup to help?
Hi,
Could you send me your CSV to take a look at the columns?
Stachethemes Developer
I unfortunately do not have it handy / saved. I used excel to create column headers using the headings that are shown in the CSV import section, and data filled from there. Im assuming that I was missing a header or had a null value someplace that I was unaware of...My bet is that I didnt specify calendar name to import to. Ill be trying it again today. Saved it as a csv file and ran the import, got a "0 records imported" message....
Without CSV file I'll be unable to debug your issue.
Make sure your CSV file has Title, Start Date and End Date fields.
Start Date and End Date fields must be in format Y-m-d H:i:s (unless specified otherwise in the CSV settings). Example 2019-12-31 12:00:00
Stachethemes Developer
Seems Im still having the issues. Ive attached the test file Ive been using...
Start date 12/12/2019 12:00:00:00 is invalid datetime
End date 12/12/2019 12:30:00:00 is invalid datetime
Remove the last :00 from your time. Example:
Then go to CSV Settings and at the bottom change csv datetimeformat field to:
Stachethemes Developer