Thursday, 22 February 2018
  2 Replies
  796 Visits
0
Votes
Undo
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?
Thursday, 22 February 2018 12:09
·
#197885
Accepted Answer
0
Votes
Undo
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 :-)

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

Thursday, 22 February 2018 12:09
·
#197885
Accepted Answer
0
Votes
Undo
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 :-)

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

Thursday, 22 February 2018 15:35
·
#197896
0
Votes
Undo
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!
  • Page :
  • 1
There are no replies made for this post yet.