Export Data From Gradience
--NOTE-- You may click on the attached PDF below and print these instructions if you wish.
--NOTE-- Click here if you need to import data.
Steps:
From within the program, click File > Export Data. Select Export File Type. Click the button at the far right end of the field for Export File to indicate the folder to which you wish to export the file. Click Export > OK. A small popup window will appear indicating that the export is complete. Click OK.
You may export only the fields listed below. Each of the letters on the left indicates a particular column.
|
A Social Security Number |
11 |
123-45-6789 |
|
B Last Name |
20 |
up to 20 characters |
|
C First Name |
20 |
up to 20 characters |
|
D Middle Name |
20 |
up to 20 characters |
|
E Location |
50 |
up to 50 characters |
|
F Department |
50 |
up to 50 characters |
|
G Date Of Hire |
10 |
MM/DD/YYYY (slashes required) |
|
H Full/Part Time |
9 |
Full-Time or Part-Time (only) |
|
I Title |
30 |
up to 30 characters or numbers |
|
J Employee Code |
14 |
up to 14 characters of numbers |
|
K Active Status |
10 |
Active, Inactive, Terminated |
If you have Gradience Records installed, your text file can also include the following fields:
|
L Date of Birth |
10 |
MM/DD/YYYY (slashes required) |
|
M Address 1 |
30 |
up to 30 characters or numbers |
|
N Address 2 |
30 |
up to 30 characters or numbers |
|
O Home Phone |
30 |
800-123-4567(dashes required) |
|
P City |
30 |
up to 30 characters or numbers |
|
Q State (2 character) |
2 |
2 characters, i.e., FL |
|
R Zip Code |
15 |
33325-1234 (-1234 can be omitted) |
|
S Salutation |
5 |
Mr. – Ms. – Mrs. – Dr. (only) |
|
T Employee Security Level |
16 |
up to 16 characters or numbers |
|
U Security Clearance Date |
10 |
MM/DD/YYYY (slashes required) |
|
V Race |
25 |
Must match a valid race on the detail tab. |
|
W EEO Category |
25 |
Must match a valid category on the detail tab. |
|
X Sex M/F |
1 |
M or F only |
|
Y Driver’s License Number |
15 |
up to 15 characters or numbers |
|
Z I9 Renewal Date |
10 |
MM/DD/YYYY (slashes required) |
|
AA Veteran Status |
25 |
Disabled -VietnamEra - Other Veteran – |
|
AB Office Phone & Ext. |
30 |
800-123-4567Ext. 123 |
|
AC Fax |
30 |
800-123-4567 |
|
AD Email address |
30 |
up to 30 characters or numbers |
|
AE Address Effective Date |
10 |
MM/DD/YYYY (slashes required) |
Comments
Article is closed for comments.