Download Jarrison Time - Time and Attendance | Clocking Systems

Transcript
Bulk Import of Employees
Employees can be imported into JT from a CSV file created from an existing Payroll or Access Control system etc., without affecting any
existing employees. However during this process an existing employee will be updated with the details found in the import file if they both
have the same employee number. To import employees into JT, click ‘Action’, ‘Bulk Employee Import’ and then browse for the import
file and select ‘Import’.
Bulk Employee Import File Requirements and Sample
This must be in CSV format (Comma Separated Values).
Must include the header line (Case sensitive).
There must be no commas ‘,’ in any fields whatsoever, as converting to CSV will distort the file.
An example is shown below. (The Red and Black fonts shown below simply allow for easy analysis in this manual.)
Employee Number,Name,Surname,ID Number,Company,Department,Class,Occupation,Hire
Date,Finger1,Finger2,Finger3,Finger4,Finger5,Finger6,Finger7,Finger8,Finger9,Finger10,Device ID,Custom 1,Custom 2,Custom
3,Custom 4,Custom 5,Custom 6,Custom 7,Custom 8,Custom 9,Custom 10
ABC123,Jeff,Radebe,5612185740086,VIP,Welding,Contractor,Fitter,26/02/2002,023600625AFF8080B4829F83A28EA499999BAE9C8
C8E97AC909E6FAC85918C7752903D8B62798170606C835E7955C54E9255AA97A39CA7AA958DCB986FBD78A987A5919791B65B
B079B795804D9754A35E96859075905F923D904D8A5F7F7B778A744D7174528B579F6CC675CD77B96EA572B37922A9AECB5DD
7BF6410A1D5A9EFB1E60000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000,0232005756FF8080BEB9D080709CA28E499347616C737E75B27
88F6E88667F5A864FC0677D47A24BBC4BD1A4C7A1D4A17899AA99B899C090589A9AAA7E9295939E8EBD81477561807F81B480
5177425F54636B7F696D796DAF77BE7C836D8A6C5E5AC4765446B351C250CE506FCF42DDCCFD771B124211D2FA6EFF000000
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000,,,,,,,,123, Custom 1, Custom 2, Custom 3, Custom 4, Custom 5, Custom 6,
Custom 7, Custom 8, Custom 9, Custom 10
One can open the ‘Excel Import Template.xls’ file for the import layout, found on the installers CD. (Or create your own using MS
Excel).Copy and paste the employee numbers into column A, then names into column B etc. Then save the XLS file as a CSV file (File,
Save as, File type CSV).
This will place the necessary commas between the columns. If a ‘Department’ ,‘Class’, ‘Company’ or ‘Occupation’ field does not
already exist in JT, the import will automatically add it to JT and automatically assign it to the employee.
Bulk Import of Initial Flexi Time Balance
All employees’ initial flexi time balance can be imported into JT from a CSV file. An existing employee’s flexi balance will be updated with
the details found in the import file. To import the balance into JT, Click ‘Action’, ‘Bulk Employee Import’, select ‘Flexi Time - Initial
Balance’ then browse for the import file and select ‘Import’.
Initial Flexi Balance Import File Requirements
This must be in CSV format (Comma Separated Values).
Must include the correct header line (Case sensitive).
There must be no commas ‘,’ in any fields whatsoever, as converting to CSV will distort the file
The time must be in decimal format (Five and a half hours would be 5:30 in time format and 5.5 in decimal format).
JT will zero-fill any numeric employee numbers if the zero-fill option has been selected in the configuration.
JT will identify various formats of the time input Example +5.5 and 5.5 and 05.5 and 05.50 and 5.49999 and 000.50005 would all be
interpreted as five and a half hours positive balance.
Similarly if a ‘-‘(minus) sign is prefixed to the decimal time entry, JT will import the flexi balance as a negative initial balance.
An example is shown below. (The Red and Black fonts shown below simply allow for easy analysis in this manual.)
Employee Number, Flexi Balance
ABC123,5.5
Page 7 of 58