Invintus Importer Specification for Comma-Separated Value (CSV) Files

• General Rules
• Formatting
• Example CSV File with two Events

General Rules

1. The first row of the CSV file must be this string exactly (case-sensitive); this is the "Header row"

title,customID,startDateTime,description,encoder,category,location

Formatting for each column can be found below

2. Each row thereafter must belong to one (and only one event).

3. Each row of Event data must adhere to the order of items in the Header.

4. The customID may not include white-spaces, but may itself be empty (e.g.: ,,)

5. It's best to wrap your title and description entries in double quotes so that, if the description contains a comma the parser does not misinterpret it as the beginning of the next column.

6. For Estimated Run Times (estRuntime), the hours must be padded with a zero if less than 10. For example for an Estimated Run Time of 1 hour, the format would look like: 01:00. Defaults to 1 hour if no value given

Formatting

Example CSV File with two Events

title,customID,startDateTime,description,encoder,category,location
"New Years Day",,2020-01-01 00:00:00,,,,Holiday,"Times Square, New York City",01:30,TRUE
"Independence Day",,2018-07-04 00:00:00,"July 4th BBQ",,,,,,