TITAN CMS - Upload iCal - ICS Naming Standards

In the Workstation, users can upload event content that was exported in standard iCal format (.ICS file) from third party calendar tools like Microsoft Outlook or Google Calendar.  The data table/schema Data Upload Heading must follow standards.

Upload iCal Data

Benefit:  In the Workstation, users can upload event content that was exported in standard iCal format (.ICS file) from third party calendar tools like Microsoft Outlook or Google Calendar.  The data table/schema Data Upload Heading must follow standards.

ICS Standards

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

Since ICS is a well-defined standard, we need to create columns in the table that match the well-known fields for that format.  The key will be making sure that the “Data Upload Heading” is set to match the ICS Field.

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 futur
e

COMMENT

Textarea, Freeform

 

CONTACT

Textbox

 

RESOURCES

Textbox

 

* Textbox means “Basic text input (one line)”

** Textarea means “Basic text input (large)”

Titan CMS Training

Check out upcoming Titan CMS Training Classes
 

Learn at Northwoods 

Workshops
 

Titan CMS Support

(414) 914-9200
Submit Questions
 

Northwoods Web Solutions

p: (414) 914-9100