The spreadsheet plugin creates out of a spreadsheet file, events which can be displayed in DPCalendar. The file has to be locally on your web server.
The file on your server must have the proper permissions to access it as web server user. Make sure that the file is accessible to DPCalendar through your Joomla hosting server.
The spreadsheet plugin comes with an example Opendocument format file which has a structure that works out of the box. For every spreadsheet calendar you can define a column name which is mapped to an event attribute. For example if the title of the event is in a column with the name sps_title then fill that value as option in the external calendar configuration.
The following example should give you a rough idea about the structure. The first row defines always the columns of the file.
"title","alias","rrule","start_date","end_date","all_day","location","color","url","description","show_end_time" "Yearly recurring","yearly","FREQ=YEARLY;UNTIL=20220514T000000Z","2019-01-01 00:00:00","2019-12-31 23:59:59","0",,"27CC37",,"Sample description",1 "Single day","single-event",,"2019-12-29 22:00:00","2007-12-29 22:20:00","0",,"A32929",,,1 "All day","allday",,"2019-12-29 00:00:00","2017-12-30 00:00:00","1",,"A32929",,,1 "Weekly recurring","weekly","FREQ=WEEKLY;BYDAY=TU,TH,SA","2017-12-10 20:00:00","2017-12-10 22:30:00","0","New York",,"http://www.digital-peak.com","This event also ends at 22:30 but the show end time flag is set to false, so it is not shown.",0 "Dayli recurring","dayli","FREQ=DAILY","2017-12-11 20:00:00","2017-12-11 21:30:00","0","London",,"http://jooml.digital-peak.com","<p>Desc</p><ul><li>with HTML</li><li>content</li></ul><p><strong>Strong text</strong></p>",1
Spreadsheet files are in binary format and can be edited with Excel or Libre Office apps. In either case the file will be broken down into cells.
The Spreadsheet plugin also supports to export DPCalendar entities like events, locations, bookings or tickets in the back end and front end. When activated then an export button will appear in the respective lists.
While configuring the plugin, it is also possible to fine tune the export behavior. The site admin can define the field order, hidden fields, if HTML tags should be stripped or configure the output of custom fields.
These settings are the same for every calendar configured in the plugin.
Comments (0)