The included file, “ExampleFile.csv” is an example of this layout. The employee “Bob” already exists, and is updated by two data rows (each with different address information). The employee “Fred” is being inserted into the system, and the Employee Number and Assignment Number are both left blank to force the system to generate them. In this case, the Assignment Identifier “LocalID_1” is used to indicate that the row of data following the insert should be an update to “Fred.” The employee “Joe” already exists, but the import is inserting a new assignment for him.
Below are 3 comma-delimited samples files
Things to Note
Importing data or updating the value of ASSIGNMENT!INACTIVE field is not supported. This field can still be updated using the checkbox on the Assignment screen.