Field

Description

Format

Name

Project name. If this field is present in the CSV data then a value is required, and is always required when adding new projects.

Text (80 chars max)

ID

Project ID. This field is not required, but if present and the value is not blank then it must be unique for all projects.

Text (80 chars max)

Description

A description of this project.

Text (255 chars max)

Status

Project status. Possible value are:

Text

Planned Start Date

Planned project start date.

Date

Planned Finished Date

Planned project finish or end date.

Date

Planned Work

Planned number of hours to complete this project.

Number

Actual Start Date

Actual project start date.

Date

Actual Finished Date

Actual project finish or end date.

Date

Permissions

The list of employees and groups given special permission on this object. Multiple permissions have each value separated by a carriage return (also called a "hard" carriage return in Excel, entered using ALT+ENTER). Each value is of the form:

Object Name=Permission Level (Object Type)

Where Object Name is the name of the group or the login of the employee, Permission Level is the permission level to give the employee or group on this object, and Object Type is the whether this is an Employee or Group that is being given permission. Here is an example of a group and an employee assigned to an object:

GroupA=Timekeeper (Group)

jmeyers=Manager (Employee)

Note that the permission level and object type are optional. If the permission level is not specified then it will be set to the employee's default permission level. If the object type is not specified the system will first check for a group with a matching name, then look for an employee with a matching login name. Only if you have group names and employee logins that might be the same do you need to specify the object type.

Text

Notes

Notes about this project.

Text (2000 chars max)