Home      Ask a Question      My Stuff      Help   
  
TimeWorks Plus: "Bulk Import - Employees" feature
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:


ID
970
Category
<Unassigned>
Date Created
8/6/2013 10:18:28 AM
Date Updated
3/4/2016 9:46:07 AM
Back to Search Results