Using proper date field formats for importing Classes using the Import Event tool in the administrator

In the Classes app, administrators have the option of importing Classes to Soapbox using a CSV file. A sample file can be downloaded from the Events > Import view in the administrator to use as a starting point for the column structure of the file.

When populating data in the spreadsheet, you will need to use the following formats for date field columns so the values are imported correctly:

• start_date: YYYY-MM-DD HH:MM:SS
• end_date: YYYY-MM-DD HH:MM:SS
• repeat_ends_on: YYYY-MM-DD
• ticket1_begin: YYYY-MM-DD HH:MM:SS
• ticket1_deadline: YYYY-MM-DD HH:MM:SS
• ticket2_begin: YYYY-MM-DD HH:MM:SS
• ticket2_deadline: YYYY-MM-DD HH:MM:SS
• ticket3_begin: YYYY-MM-DD HH:MM:SS
• ticket3_deadline: YYYY-MM-DD HH:MM:SS

NOTE: The inclusion of HH:MM:SS for Ticket fields is not required and times are not currently supported by Soapbox for ticket availability. However, this formatting matches what is present in the sample file and is noted above for the sake of consistency. 00:00:00 can be used for these values. The data is formatted in this way in the Soapbox database in planning for future support of time values in ticket start and end times.