User manual

1. Create a text file in C:\PROGRAM FILES\TAS2KSQL folder with name
“EMPLOYEE.TXT”. One of the methods is to have the list in Excel and then use ‘save
as’ in CSV format.
2. First line of EMPLOYEE.TXT is the header of field names, separated by comma. Second
and subsequent lines contain actual data.
3. File must contain following data at the minimum:
a. Employee ID (header Emp_Id)
b. Employee Name (header Emp_Name)
c. Cost Centre Code (header Supervisor_Code)
In addition to above, you may also import other fields if being used, subject to availability of
information. Please note:
-Whatever codes are being used in employee records (Shift, Department, Trade), those codes
should have been added in their respective masters before importing employee data. Otherwise
invalid records will be rejected.
-If date field is used (default value is the date on which import is done), year must be YYYY
(4 digits). The DD and MM order should be as per Regional Settings. For example, if date of
joining is February, 26
th
‘05, and Regional settings is dd-mmm-yy, then it should appear in the
text file as 26-02-2005.
-All employees must have same Employee ID length (1 to 7) and Proxy ID length (1 to 14), as
defined in configuration.
4. List of field that can be imported are (+ in remarks means mandatory field):
Header Type Size in
text
Remarks
Emp_Id Text 1-7 +
Emp_Name Text 25 +
BirthDate Date/Time 10
Trade_Code Text 2 Used in Job reports
Joining_Date Date/Time 10
Shift Text 2 Default is A1
Department_Code Text 2
Supervisor_Code Text 9 + (This is cost center)
Tea_Boy Yes/No 3/2 No Auto Deduction-1
Tea_Boy2 Yes/No 3/2 No Auto Deduction-2
Weekly_Off Number 1=Sun, 6=Fri, 7=Sat
Previous_Scan_DOA Date/Time 10
Previous_Scan_Shift Text 2
Last_Scan_Time Date/Time 10 Records earlier than this
are rejected
PresentLasTDay Yes/No 3/2 Whether present on last
working day of previous
period
EmpType Text 2 SE or HW
SNH Number Normal Hours to work in a
Part 8