Uploading ICS Data

Pam wrote a helpful article on the documentation site that covers this. Here's a quick snippet from that article to help identify the ICS fields that you can use as Data Upload Headings in your calendar data tables.

Also, here's the link to the IETF's doc on the ICS format which was the basis for the uploader handling of ICS files.

ICS Standards

Before uploading ICS files with the upload utility, you need to make sure you have a table correctly configured for the data in that file.

The table below defines the most likely candidates for uploading into Titan. There are other ICS Fields, though they are less likely to be useful in TitanCMS. 

The iCal standard requires start date to be an actual occurrence date. If it isn’t, the iCal file won’t be recognized in Outlook or other calendar tools that import ical files.

Typically, you will hook up the DTSTART field as a Recurring Date column… but you could also make it a regular Date or Date Time column. The only way to get recurrence patterns from the ICS data is to use the Recurring Date column.

ICS Field	Column Type	TitanCMS Property Linking / Notes
SUMMARY	Textbox*	Page Name, Workstation Name
DESCRIPTION	Textarea**, Freeform	Meta/Short/Long Description
CREATED	Date Time	Start Date
LAST-MODIFIED	Date Time
LOCATION	Textbox
ORGANIZER	Textbox
URL	Textbox	Not LinkParameter
UID	External Data Source Key
DTSTART	Date, Date Time, Recurring Date	Not Start Date
DTEND	Date, Date Time	End Date
ATTACH	Textbox	Could possibly use File column type
CATEGORIES	Textbox, Textarea	MetatagKeywords; Not yet ready for Tags/Lookups, maybe in future
COMMENT	Textarea, Freeform
CONTACT	Textbox
RESOURCES	Textbox