Job Import File Layout
The data file must be formatted
correctly in order to be imported by the TimeForce system. The file format
is displayed on the right-hand side of the main "Import Jobs"
screen.
IMPORTANT:
Unless specifically noted as "Optional," all fields in the import
file require a value. To skip a certain type of data, insert a "0"
into the field instead of leaving the field blank.
The job file layout is
as follows:
|
Column Name |
Data Type |
Required |
Description |
|
Job Name |
Text (50 characters) |
Required |
The name of the job. |
|
Job Description |
Text (200 characters) |
Optional |
The description of the job. |
|
Job Code |
Text (10 characters) |
Optional |
The code of the job. |
|
Job Number |
Number |
Required |
The job number. |
|
Job Department Number |
Number |
Optional |
Default department number. |
|
Job User Defined 1 |
Text (50 characters) |
Optional |
User defined field. |
|
Job User Defined 2 |
Text (50 characters) |
Optional |
User defined field. |
|
Job User Defined 3 |
Text (50 characters) |
Optional |
User defined field. |
|
Job User Defined 4 |
Text (50 characters) |
Optional |
User defined field. |
|
Job User Defined 5 |
Text (50 characters) |
Optional |
User defined field. |
|