Example CSV File

Employee Update:

ID.profileId,jobTitle,emailAddress
123456,Sales Manager,becky.smith@acme.com
222456,Warehouse Operator,john.jackson@acme.com

The above Employee Update file example updates two existing employee records’ Title and Email fields.

Employee Add:

firstName,lastName,profileId,startDate,emailAddress,locationId.name,createLogin,sendLoginEmail
James,Johnson,741268,2015-05-15,james@email.com,Branch 123,Y,Y
Cynthia,Williams,654741,2015-05-20,c.williams@email.com,Branch 222,Y,Y

The above Employee Add file example creates two new employee records. The unique identifier that was used for this update was the Employee ID (i.e. profileId). Directives have also been included to create login credentials and email the credentials to the employee so that they may access the employee portal and complete Section 1 of the I-9 form.

While it is not necessary to make distinct “add” and “update” files, your organization may find it easier to mass update or insert in this fashion.