You can import employee data from a payroll system that supports this feature. The Import function also supports the importing of ASCII data.
There are two ways to import employee data. The first way
is with badge ID’s. RealTime also allows the batch entry of badge ID numbers
and also the entry of badge ID numbers using card readers, bar code wands or
just through the keyboard.
By Badge ID
RealTime 2.0 and up Employee Import Specifications - ASCII data
|
Field No.
|
Field Name
|
Maximum Number of Characters
|
Valid Range
|
|
1
|
Clock ID Number
|
7
|
1 - 9999999
|
|
2
|
"Last, First"
|
32
|
text
|
|
3
|
Home Dept
|
6
|
1 - 999999
|
|
4
|
"Payroll ID"
|
50
|
text
|
|
5
|
Lunch Minimum Hours
|
5
|
0 - 8.00
|
|
6
|
Lunch Deduct Amount
|
5
|
0 - 8.00
|
|
7
|
Rate1
|
5
|
0 - $999.00
|
|
8
|
Rate2
|
5 not
used in v2.0
|
0 - $999.00
|
|
9
|
Rate3
|
5 not
used in v2.0
|
0 - $999.00
|
|
10
|
"Sched No"
|
4
|
1 - 9999
|
|
11
|
Active
|
1 Default True *
|
0, -1
|
|
12
|
Seventh Day rule (Y/N)
|
1 no longer used
|
0, -1
|
|
13
|
"Holiday Group Number"
|
15
|
text
|
|
14
|
"Default Job Assignment"
|
15
|
text
|
|
15
|
"Shift No"
|
2
|
0 - 99 or “blank”
|
|
16
|
Shift Differential (Y/N)
|
1 Default False *
|
0, -1
|
|
17
|
"Notes"
|
255 no
longer used
|
text
|
|
18
|
OT Rule Group
|
255
|
text
|
|
19
|
PIN Code
|
255
|
text
|
|
20
|
User Defined 1
|
255
|
text
|
|
21
|
User Defined 2
|
255
|
text
|
This table is current as of 01-01-2010. Contact your RealTime vendor for an up-to-date listing before beginning the
import process.
* Default
True: If no value is supplied, Imported Employees will be set to active as default.
Default False: If no value is supplied, Imported Employees will
be set to inactive as default
Each field must be separated with a comma
All field names in quotes are to
have their data enclosed in double quotes in the ASCII transfer file.
Yes/No
values are 0 for No and -1 for Yes.
Rates1,
Rate2 and Rate3 are currency amounts - if no decimal is provided, one will be assumed at the end - i.e. 1 = 1.00.
Examples:
9,"Jetson,
George",123,"523-56-2134",4,.5,12.23,,,"2002",,,"2222",,"23",-1,,,,,
10,"Jetson,
Jane",123456,"000-99-9009",4,.5,,,,,-1,-1,,,,-1,,,,,
Note that the Name field contains quotation marks so that
the last name, first name comma does not produce an additional field. Each
record has twenty-one (21) fields and is on a separate line.
You are not required to put an employee Clock ID number.
If it is blank, RealTime will automatically enter the next highest number in
your Employee file. If this is a new import, the starting number is 1001 for
the first card number. If you use the numbers through 9999, RealTime will stop
the import process.
Start Import
To start the import, press the import button. If you are
using the ASCII import, the file will be based on directory information set up
in the Company Setup form. You can change this information once the import
begins.
Error Trapping
If you make an error in your input, you can select the
rows of employee data in the Employee Setup form and press the Delete key to
remove them.