Menu

#8376 Spreadsheet plugin

Parent Category:
DPCalendar
Category:
Calendar plugins
Last Updated:
Allon Moritz, Tuesday, 22 October 2024 12:44
Created:
Tuesday, 02 February 2021 15:58
Hits:
3121

This feature is part of the DPCalendar Professional subscription.
SubscribePHP 7.4PHP 8Joomla 3.10Joomla 4.4Joomla 5

Introduction

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.

It can also export events, bookings, tickets or locations, either from the front end lists or the back end administration tables.

File Format

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.

Remarks

The following list gives some practical hints about the data in the Spreadsheet file:

  • The date must be in ISO 8601 format
  • All day events must have the end date one day later as this is how ical data is represented.
  • The alias setting is only used during import
  • The timezones must be set correctly
  • The CSV structure must be readable by a CSV parser

Main options

  • Uri
    Per calendar there is a field which defines the uri of the file. If the file is on your server it must have proper permissions to access it. Make sure that the file is accessible to DPCalendar through your Joomla hosting server. If the file is not physically on your server you can define an url like http://example.com/data/test.xlsx. To get remote files the server must be able to open connections to the remote server. Ask your hosting company first if outbound connections are included in your hosting plan.
  • Timezone
    When the events in the CSV file are defined in a different timezone, it's possible to adjust that parameter here.

Libre Office, Openoffice or Excel

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.

Export of DPCalendar data

The Spreadsheet plugin also supports the export of 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 fields with a custom ordering, if HTML tags should be stripped or configure the output of custom fields.

Spreadsheet export

DPCalendar Options

These settings are the same for every calendar configured in the plugin.

Uri [Type: Text]
An uri to an online file like http://www.example.com/files/data.csv or a local path like plugins/dpcalendar/csv/examples/example.csv. If the uri is a file and starts with a '/' DPCalendar will interpret it as an absolute path otherwise relative to the joomla installation folder.
Delimiter [Type: Text] [Default: ,]
The delimiter of the CSV file.
Enclosure [Type: Text] [Default: "]
The enclosure of the CSV file.
Has Header Row [Type: Radio] [Default: Yes]
Does the CSV file have a header row.
The following options are available:
  1. Yes
  2. No
Timezone [Type: Timezone] [Default: UTC]
The timezone of the events in the file.
The following options are available:
  1. UTC
Title Column [Type: Text] [Default: title]
The column for the title.
Start Date Column [Type: Text] [Default: start_date]
The column for the start date.
End Date Column [Type: Text] [Default: end_date]
The column for the end date.
All Day Column [Type: Text] [Default: all_day]
The column for the all day.
Show End Time Column [Type: Text] [Default: show_end_time]
The column for the show end time.
Description Column [Type: Text] [Default: description]
The column for the description.
RRule Column [Type: Text] [Default: rrule]
The column for the recurrence rule.
Location Column [Type: Text] [Default: location]
The column for the location.
Url Column [Type: Text] [Default: url]
The column for the url.
Alias Column [Type: Text] [Default: alias]
The column for the alias.
Colour Column [Type: Text] [Default: color]
The column for the colour.
SSL Verification [Type: Radio] [Default: Yes]
Is SSL verification activated? Disable only when you know what you are doing as it can cause security issues. When disabled the connection the remote host can't be trusted anymore.
The following options are available:
  1. Yes
  2. No

Plugin Options

Custom Field Value Type [Type: Radio] [Default: Value]
The value type of the custom field. Raw returns the stored value from database and value means the display value.
The following options are available:
  1. Value
  2. Raw Value
Strip HTML [Type: Radio] [Default: No]
Strip the HTML tags during export.
The following options are available:
  1. Yes
  2. No
Separator [Type: Text] [Default: ,]
Separator of the exported file.
Event Fields [Type: Subform] [Default:
  1. field=id
  2. field=title
  3. field=catid
  4. field=color
  5. field=url
  6. field=start_date
  7. field=end_date
  8. field=all_day
  9. field=rrule
  10. field=description
  11. field=location_ids
  12. field=featured
  13. field=state
  14. field=access
  15. field=access_content
  16. field=language
  17. field=created
  18. field=created_by
  19. field=modified
  20. field=modified_by
  21. field=uid
  22. field=timezone
]
The fields to export in the given order.
Booking Fields [Type: Subform] [Default:
  1. field=uid
  2. field=state
  3. field=name
  4. field=email
  5. field=telephone
  6. field=country
  7. field=province
  8. field=city
  9. field=zip
  10. field=street
  11. field=number
  12. field=price
  13. field=options
  14. field=net_amount
  15. field=processor
  16. field=user_id
  17. field=book_date
  18. field=event_id
  19. field=event_author
  20. field=event_calid
  21. field=timezone
]
The fields to export in the given order.
Ticket Fields [Type: Subform] [Default:
  1. field=uid
  2. field=state
  3. field=name
  4. field=event_title
  5. field=start_date
  6. field=end_date
  7. field=email
  8. field=telephone
  9. field=country
  10. field=province
  11. field=city
  12. field=zip
  13. field=street
  14. field=number
  15. field=price
  16. field=user_id
  17. field=created
  18. field=type
  19. field=event_calid
  20. field=timezone
]
The fields to export in the given order.
Location Fields [Type: Subform] [Default:
  1. field=id
  2. field=title
  3. field=alias
  4. field=country
  5. field=province
  6. field=city
  7. field=zip
  8. field=street
  9. field=number
  10. field=rooms
  11. field=latitude
  12. field=longitude
  13. field=url
  14. field=description
  15. field=color
  16. field=state
  17. field=language
  18. field=created
  19. field=created_by
  20. field=modified
  21. field=modified_by
  22. field=xreference
]
The fields to export in the given order.

Plugin Options

Caching [Type: List] [Default: Joomla]
Select whether to cache the calendar data.
The following options are available:
  1. Joomla
  2. Database
  3. Never
Cache Time [Type: Text] [Default: 900]
The time for the cache in sec.
Sync Start [Type: Text] [Default: -3 year]
The relative start date to sync from.
Sync End [Type: Text] [Default: +3 year]
The relative end date to sync from.
Sync Steps [Type: Text] [Default: 1 year]
The sync steps.

Comments (0)

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.

Ok Decline
More information