| Header | Description | Req. | Notes |
| User | This column is for designating the assigned user. | Y | This must be the user's full name as it appears under Management-->Users. In place of the User column you can also use the column name User Login, in which case the username/login ID of the assignee must be used. |
| Project | This column is for the assigned project or task. | Y | This must be a scheduled project or task. |
| Scheduled Work | This column is for the scheduled work in hours for this assignment. | Y | |
| Scheduled Start | This column is for the scheduled start date of this assignment. | Y | Must be in YYYYMMDD format. |
| Scheduled End | This column is for the scheduled end date of this assignment. | Y | Must be in YYYYMMDD format. |
| Assignment ID | This column is for identifying an existing assignment. | N | This field is only required if you are editing an existing assignment. The ID for an existing assignment can be displayed in Assignment reports under Reports->Standard Reports. If there is no Assignment ID for an assignment row in the import file, the assignment will be created as a new record. |
| Assignment Name | This column is for specifying the text name of the assignment | N | This is a text string with the name of the assignment. Assignments are given names automatically by the system on assignment creation. This can be used along with the Assignment ID to change the name of an assignment. Assignment names are useful for searching for assignments. |
| Assignment Pay Rate | This column is for specifying a pay rate for this assignment. | N | Numeric value without a currency character ($ or £). Cannot contain commas, but can contain a decimal point and two numbers to the right of the decimal. |
| Assignment Bill Rate | This column is for specifying a bill rate for this assignment. | N | Numeric value without a currency character ($ or £). Cannot contain commas, but can contain a decimal point and two numbers to the right of the decimal. |
| Any Custom Fields that you add to your assignments can be imported in this file. Just add a column for each field that you want to import. The Header must exactly match the name you gave the field. The field size was determined when you created the field. You can create new fields by going to Configuration→Custom Fields. Values for Custom Fields will always be imported, even if blank, unless the value found in the field is the special string "JX_NO_MODIFY" (without the quotes). | |||