CSV Upload Instructions
This form provides for uploading of event data in a Comma Separated Values (CSV) text file to the NIC Cal Calendar.
Order of columns is; title, venue id, contact id, category id, date, start time, end time and description. The first row of the CSV file, used for column descriptions, is ignored.
A sample CSV file can be downloaded here.
Table of Venues/Contacts
The CSV file uses id numbers to specify venues and contacts. These correspond to entries in the Links section. For your calendar, the table of Links is as follows:
ID | City | State | Company |
---|---|---|---|
1 | Default: Information shown in event description. |
Table of Categories
The CSV file also uses id numbers to specify categories. These correspond to entries in the Categories section. For your calendar, the table of Categories is as follows:
ID | Category |
---|---|
1 | NIC |
2 | __Approved |
4 | __Cancelled |
5 | __Closed |
3 | __Submitted |
Table of Groups
The CSV file also uses id numbers to specify groups. These correspond to entries in the Groups section. For your calendar, the table of Groups is as follows:
ID | Group |
---|---|
1 | NIC |