Description

The format of the event import file is quite flexible. There are only a few simple requirements:

List of Recognized Fields

The following table lists each of the recognized import field names.

The first column is an internal field name used by the program, the second column lists the valid recognized field names that you may use in the first row of the import file. These recognized field names are associated with the internal field during the import. The final column simply indicated whether or not the field is exported by the export feature.

Important Note: If you have customized the names of the event fields in the Customize Event Database screen the names you've customized will be recognized as well. For example, if you've renamed Category to Department then Department would be recognized.

An Example

A very simple example ASCII import file follows. The first line has the list of fields, the second line contains a single example event. This file was exported from MS Excel using the .csv format.

  subject,start date,category,location
  "Example, with comma",12/31/2001,Financial,New York

A second example shows the same data formatted for semi-colon delimited text. This file has every field quoted which is acceptable but not necessary.

  "subject";"start date";"category";"location"
  "Example, with comma";"12/31/2001";"Financial";"New York"
  • Note: This import file format is nearly identical to that used by the ASCII Front End mode. Please see that help file for more information.