Quick Import Employees
The "Quick Import
Employees" feature allows you to import employee profiles from an
Excel spreadsheet file. This saves you from having to manually input data
into the TimeForce system.
Click on the "Quick
Import"  icon
located on the right-hand section of the screen.
Note:
Excel limits strings to a maximum of 999 characters per cell. You cannot
import more employees than your serial number allows.
Import File Layout
In order for the TimeForce
system to be able to accept the information in the spreadsheet file, the
imported data must be formatted in a specific layout.
The table below gives you
a detailed description of the required spreadsheet layout.
|
Column Name |
Data Type |
Required |
Description |
|
EmployeeId |
Text (50 characters) |
Required |
The ID of the employee. |
|
FirstName |
Text (50 characters) |
Required |
The first name of the employee. |
|
MiddleName |
Text (50 characters) |
Optional |
The middle name of the employee. |
|
LastName |
Text (50 characters) |
Required |
The last name of the employee |
|
Hire_dt |
Date |
Required |
The date on which the employee was hired. |
|
CardNumber |
Number (10 characters) |
Optional |
The card number of the employee. |
|
UserName |
Text (50 characters) |
Optional |
The user name to log into
TimeForce. |
|
Password |
Text (50 characters) |
Optional |
The user’s password to log into TimeForce. |
Click on the "Download
Excel Template" link to download a pre-formatted spreadsheet file.
Importing Employees
The Select
a File to Import field is located at the top of the screen, directly
below the "Quick Import Employees" header.
Click
on the [BROWSE] icon located to the right of the Select
a File to Import field. Browse
to the location of the spreadsheet file that you would like to import. Highlight
the desired spreadsheet file, and click on [SAVE]. You are returned to
the main "Quick Import Employees" screen. Click on [IMPORT] located
to the far right of the [BROWSE] icon.
The selected spreadsheet
file is imported into the TimeForce database. You are returned to the
main "Add Employees" screen. Once you have finished entering
profiles, click on the  icon
to continue to the next setup step.
Note: Additional employee profiles can be created once you exit
the Setup Wizard and log into the TimeForce system normally.
If you need to return to
the previous screen at any time, click on the  icon.
Click on the  icon
to save your progress and exit the Setup Wizard.
|