time clocks
Time Clocks
Software
Support
Contact Us      
Home > Support >FAQ > FAQ | Electronic Time Clock | Updates | Downloads
Sundial Support Help Center

Knowledgebase Home | Glossary | Favorites | Login Knowledgebase Home | Glossary | Favorites | Login
Search the Knowledgebase Browse by Category
RealTime Advanced: Importing Employee Data
Article Details

Last Updated
16th o March, 2010

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.

Visitor Comments
No visitor comments posted. Post a comment
Post Comment for "RealTime Advanced: Importing Employee Data"
To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.
   Your Name:
   Email Address:
* Your Comment:
* Enter the code below:
 
Related Articles
No related articles were found.
Attachments
No attachments were found.

Sundial Employee Time Clock selection
        © 2008 Sundial Time Systems, all rights reserved.