Payroll: Timecard Import from Spreadsheet .CSV files

Build a Template .csv File:

SELECT 'REG' "Code",EMP_ID "EmpID",First_Name "Fname", ' ' "Mname",Last_Name "Lname",' ' "ShiftName", Dept_no "Dept",
'01/01/2009' "Date",'Worked' "HrType",0.00 "Hrs"
from prtemployee e
where dept_no between :Beg_Dept and :End_Dept and e.HOUR_SAL_FLAG='H'
  UNION
SELECT 'SAL' "Code",EMP_ID "EmpID",First_Name "Fname", ' ' "Mname",Last_Name "Lname",' ' "ShiftName", Dept_no "Dept",
'01/01/2009' "Date",'Worked' "HrType",1.00 "Hrs"
from prtemployee e
where dept_no between :Beg_Dept and :End_Dept and e.HOUR_SAL_FLAG='S'

TCFILE.INI:

[Files]
Plant 1=C:\IMPORT\TC1.TXT,TIMEFORCE
Plant 2=C:\IMPORT\TC2.TXT,TIMEFORCE

[TimeForce]
ImportDepartment=Y   ;imports TimeForce department as Keystone department

TCIMP.INI:

[Links]
Regular=REG
Overtime=OT
Holiday=HOL
Vacation=VAC
Double=DBL
Sick=SICK
Bonus=BONUS
Other=OTHER

[WorkComp]
;setup workers comp class translations here as follows:
;<timeforce department value> = <keystone workers comp class>

[Department]
;setup department translations here as follows:
;<timeforce department value> = <keystone department>

See: Payroll: Supported Time Clocks