Events source - CSV file
The extension retrieves data from a CSV file and show these as events. Information about CSV file format is available here. Use "Start date field", "End date field" and etc. parameters to specify mapping between CSV columns and event properties. For example if "Start date field" is set to EventDate value then values of EventDate column from CSV column will be used to populate start date field in events. The following parameters can be configured for this events source:
- Path to CSV file is a path to CSV file. If want to show data from a file which is located in Joomla! directory (or a sub-folder of Joomla! root directory), enter a relative path to the file. For example if want to show data from <joomla_directory>/data/events.csv file, populate the parameter with data/events.csv value. It is also possible to use files from an external sources, for example from another site: http://www.domain.com/storage/my_events.csv
- Remoting method is used to specify a method which will be used to load external CSV files (which are located on another site, server and etc.). For most cases "Auto-detect" value should work fine, but if some problem occurs with showing data from an external CSV file, try to change value of the parameter.
- Heading use the first row from the CSV file as field names or not.
- Auto-detect mode is used to detect what delimiter is used in CSV file (, or tab symbol). If the parameter is enabled, the extension tried to detect delimiter symbol automatically based on several rows otherwise value of Delimiter parameter is used.
- Strict mode is used to enable strict mode. In this mode the extension ignores empty rows and rows with incorrect number of columns.
- File encoding is used to specify file encoding if it is saved in non UTF8 encoding. For example if file is saved in ISO-8859-1 encoding, set the parameter to ISO-8859-1 value to show data from the file correctly.
- Delimiter is used to specify a symbol which is used as data delimiter in the CSV file.
- Enclosure is used to specify a symbol which is used to enclose data.
- All day event is used to mark the events as all data events or not.
- Start date field is name of column from CSV file which will be used to populate start date field in events. This field is mandatory.
- End date field is name of column from CSV file which will be used to populate end date field in events.
- Link field is name of column from CSV file which will be used to populate link field in events.
- Item template is a template which will be used to populate events' title. Possible to use data from CSV files. For this add {$COLUMN_NAME} code to the template. Where COLUMN_NAME is name of column from CSV file which value will be used in the template. For example if want to use value of ProductTitle column, use {$ProductTitle} code.
- Description template is a template which will be used to populate events' description. Possible to use data from CSV files like from Item template parameter.