Bulk Employee Import - TWP
This article applies to TimeWorksPlus. If you are looking for the TimeWorks version, please see Bulk Import - TimeWorks.
When adding new employees, at minimum you will need the following columns:
- Employee Code - identified by Code or Empl or Emp or E or Code or Num
- First - identified by First, FN or F
- Last - identified by Last, LN, or L
Attached to this article is an example of a spreadsheet formatted for import.
Headers and Explanation
- ExportBlock - Y or N to configure the employee so that they are excluded from the payroll export
- WebClock - Y or N to disable/enable WebClock
- DeleteCardNumbers - Y or N, but if nothing is entered, it will default to no. If set to yes, it will wipe out all current logins/card number for that employee. This can be useful if you have existing employees in the system and want to erase their card numbers and/or replace them with new numbers.
- Logins - also known as Card Numbers, are the values used to identify the employee at the clock. This could be a PIN number, a card number or a login name. You can have multiple logins in this column if you separate them with commas (1111,2222,3333,4444), however, only the first three can be used as WebClock/ESS or Biometric logins.
Updating Existing Employee(s)To update an employee you MUST have an employee code for that employee. When updating employee's information, the employee code is the field that ties the update to the employee (Not the names).
Additional Column Headers
- Middle or MN or M
- Designation or DESI or DES
- StartDate or Hire
- EndDate or Term
- EssPassword or Ess
- Phone or Ph
- WebClock or WebC
Headers that Require a Processing Rule Enabled
If you are using the processing rule PayRates in TimeWorks Plus the below would be valid in addition to the default headers:
If you add additional pay rates via the processing rule, the below would also be available:
If you are using the processing rule RoundToSchedule this will allow for the below to also be imported:
Did you find this article helpful?