CSV Format

The Swifting CSV file format conforms to the standard of CSV files. The comma separated text file should begin with one header row (first row) that specifies the fields to import. Swifting will detect the separator character automatically.

You may use any of the following field separators:

  • Comma (,)
  • Semicolon (;)
  • Tab
  • Pipe (|)
  • Colon (:)

Note that the header row may only contain one of the field separators above.

The field names are case insensitive and you may use the local translation for the field or the field id, for example "Assigned to" or "assigned_to" on an English server. Available fields (with field id:s) are described below:

Text fields

Text fields are imported without any modifications.

  • Title (title)
  • Goal description (goal_descr)
  • Result description (result_descr)

Status field

The status field in Swifting is hard coded to three values.

  • Not started (0)
  • In Progress (1)
  • Completed (2)

Resource fields

A field that specifies a user, group or role. You may use id, name or email to specify a resource. Name and email are case insensitive.

  • Assigned to (assigned_to)
  • Assigned by (assigned_by)
  • Visible to (visible_to)

Date fields

A date can be specified in local format ("dd/MM/yyyy" on an English server) or in internal format ("yyyy-MM-dd").

  • Start date (started_date)
  • End date (completed_date)
  • Due date (due_date)

Number fields

Decimal number may use a decimal dot or a decimal comma. Invalid values are replaced by 0.

  • Work done (work_done)
  • Work remaining (work_left)

Example file

Title;Assigned to;work_done;work remaining;Status;Due date
My Project;Bill;10,2;2.1;In progress;
"Text with a ; char";moc.gnitfiws|adnil#moc.gnitfiws|adnil;0;20;0;2011-01-01