Thursday, 22 February 2018
  2 Replies
  793 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.

Members Area

Show your support

Unlike many Joomla calendars we do not charge to download JEvents - please show your support for this project by becoming a member of the JEvents Club Club members get access to early releases, exclusive member support forums, and Silver and Gold members can use many exciting JEvents addons

Your membership will ensure that JEvents continues to be the best events calendar for Joomla.