http://in.compucrete.com/index.php?action=history&feed=atom&title=Payroll%3A_Timecard_Import_from_Spreadsheet_.CSV_files
Payroll: Timecard Import from Spreadsheet .CSV files - Revision history
2026-05-15T16:13:43Z
Revision history for this page on the wiki
MediaWiki 1.40.0
http://in.compucrete.com/index.php?title=Payroll:_Timecard_Import_from_Spreadsheet_.CSV_files&diff=476&oldid=prev
WikiAdmin: 1 revision imported
2023-07-14T13:00:34Z
<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:00, 14 July 2023</td>
</tr>
<!-- diff cache key my_wiki:diff::1.12:old-475:rev-476 -->
</table>
WikiAdmin
http://in.compucrete.com/index.php?title=Payroll:_Timecard_Import_from_Spreadsheet_.CSV_files&diff=475&oldid=prev
Intra>User: 1 revision imported
2017-01-10T00:02:07Z
<p>1 revision imported</p>
<p><b>New page</b></p><div>Build a Template .csv File:<br />
<PRE><br />
SELECT 'REG' "Code",EMP_ID "EmpID",First_Name "Fname", ' ' "Mname",Last_Name "Lname",' ' "ShiftName", Dept_no "Dept",<br />
'01/01/2009' "Date",'Worked' "HrType",0.00 "Hrs"<br />
from prtemployee e<br />
where dept_no between :Beg_Dept and :End_Dept and e.HOUR_SAL_FLAG='H'<br />
UNION<br />
SELECT 'SAL' "Code",EMP_ID "EmpID",First_Name "Fname", ' ' "Mname",Last_Name "Lname",' ' "ShiftName", Dept_no "Dept",<br />
'01/01/2009' "Date",'Worked' "HrType",1.00 "Hrs"<br />
from prtemployee e<br />
where dept_no between :Beg_Dept and :End_Dept and e.HOUR_SAL_FLAG='S'<br />
</PRE><br />
<br />
TCFILE.INI:<br />
<PRE><br />
[Files]<br />
Plant 1=C:\IMPORT\TC1.TXT,TIMEFORCE<br />
Plant 2=C:\IMPORT\TC2.TXT,TIMEFORCE<br />
<br />
[TimeForce]<br />
ImportDepartment=Y ;imports TimeForce department as Keystone department<br />
</PRE><br />
<br />
<br />
TCIMP.INI:<br />
<PRE><br />
[Links]<br />
Regular=REG<br />
Overtime=OT<br />
Holiday=HOL<br />
Vacation=VAC<br />
Double=DBL<br />
Sick=SICK<br />
Bonus=BONUS<br />
Other=OTHER<br />
<br />
[WorkComp]<br />
;setup workers comp class translations here as follows:<br />
;<timeforce department value> = <keystone workers comp class><br />
<br />
[Department]<br />
;setup department translations here as follows:<br />
;<timeforce department value> = <keystone department><br />
</PRE><br />
<br />
<br />
See: [[Payroll: Supported Time Clocks]]</div>
Intra>User