By Guest on Thursday, 22 February 2018
Replies 2
Likes 0
Views 795
Votes 0
Hi,

According to this faq item we try to import events into a new calendar.

However, when we do, we get an "1054 Unknown column 'data' in 'field list'" error after we submit the csv file.
The event is imported, but we can't delete or modify it after.

For testing we only have one event in the import file. See the attachment for the import we tried.

According to the faq item, all the required fields are in the import. Is there something else wrong with it? Or is there a bug in the import script?
Hello,

so as per the Documentation:

"CATEGORIES","SUMMARY","LOCATION","DESCRIPTION","CONTACT","X-EXTRAINFO","DTSTART","DTEND","TIMEZONE","RRULE"

MUST be included. You are only including:

"CATEGORIES","SUMMARY","DTSTART","DTEND","TIMEZONE"

Please make sure to follow the spec and try again :-)
·
Thursday, 22 February 2018 12:09
·
0 Likes
·
0 Votes
·
0 Comments
·
DOH!

Thank you very much!

We had that at first, but after we fixed some issues with our datetime format the import gave the feedback only

"CATEGORIES","SUMMARY","DTSTART","DTEND","TIMEZONE" are required. Thats why we removed the other fields since we are not using them.

Anyway, it is working now. Thanks!
·
Thursday, 22 February 2018 15:35
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post