This feature allows one to Add/Update Employee Setup fields for large numbers of employees.
This page can be found under Accountant Menu > Bulk Import - Employees. The file can be created in any spreadsheet program (Excel, GoogleDocs, etc) and uses the headers found at the bottom of this article.
Some headers require specific information ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ - The ExportBlock and WebClock:
This field needs to be either Y or N for yes and no, respectively.
- DeleteCardNumbers:
This field needs to be either Y or N for yes and no, respectively. 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.
Note: you can use this header with the Logins header to replace all Logins.
- Logins (also known as Card Numbers in the TimeWorks system):
Employees are no longer bound to a 3 login max. If you want to add more than 1, just put a comma separated list (1111,2222,3333,4444).
Adding an Employee ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ To add an employee you MUST provide the following headers and information under these headers:
- Employee Code - First Name - Last Name
Updating an Existing Employee ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ 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).
Default Headers ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ First or FN or F Last or LN or L Middle or MN or M Designation or DESI or DES StartDate or Hire EndDate or Term EssPassword or Ess Empl or Emp or E or Code or Num Phone or Ph Email WebClock or WebC Logins ExportBlock DeleteCardNumbers SSN Options Title Department Location Supervisor Home1 Home2 Home3
Other Headers (When specific processing rule is enabled) ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ We will not make a full list here but all currently available headers for a specific client can be found on the Bulk Employee Import Page (it dynamically updates according to which rules are active on the client site).
If you are using the processing rule "PayRates" in TimeWorks Plus the below would be valid in addition to the default headers:
PayRate0
If you add additional pay rates via the processing rule, the below would also be available:
PayRate1 PayRate2 PayRate3 PayRate4 (etc...)
If you are using the processing rule "RoundToSchedule" this will allow for the below to also be imported:
SCHEDULE
If you are using the processing rule "Birthday" this will allow for the below to also be imported:
Birthday
Example ¯¯¯¯¯¯¯¯¯ An example spreadsheet can be seen here:
| |