Importing Events in CSV Format
Importing Events in CSV Format
In JEvents 1.5.5/2.0 it is possible to import events from a CSV file. The format of this file is very important - some users find MS Excel doesn't give enought flexibility to set the field delimiter to a comma and it often ends up leaving out the double quotes around the fields. If you have these problems then I'd revommend you try OpenOffice or LibreOffice instead to create the extract.
It must include the following columns:
"CATEGORIES","SUMMARY","LOCATION","DESCRIPTION","CONTACT","X-EXTRAINFO","DTSTART","DTEND","TIMEZONE","RRULE"
Club members can download a sample file.
For non-members - this is an example of the first line of events.
"Sport","Football Match","Football Stadium","This event is just for fun","Contact Name","Whatever extra-info","20100915T150000","20100915T191500","Europe/London","FREQ=DAILY;COUNT=10;INTERVAL=3"
You can use a CSV file whereever you would import an iCal file in JEvents.
Custom Fields
If you are using the Silver member custom fields addon then you can include the value of your custom fields in the CSV file too. For example if you have a URL type field with a name 'field1' then a sample import could look like this:
"CATEGORIES","SUMMARY","LOCATION","DESCRIPTION","CONTACT","X-EXTRAINFO","DTSTART","DTEND","TIMEZONE","RRULE","field1"
"Sport","Football Match","Football Stadium","This event is just for fun","Contact Name","Whatever extra-info","20100915T150000","20100915T191500","Europe/London","FREQ=DAILY;COUNT=10;INTERVAL=3","http://www.mysite.com"
Notice how we include the fieldname in the first row of the CSV file.
| < Prev | Next > |
|---|
