Paul Mayer
02-25-2010, 07:35 PM
This below is from the PayWindow Help File. If the export from what you are using is the same, it should work:
TimeTrax Bio Instructions
TimeTrax Bio exports a text file that is a TXT file that PayWindow imports from and the data fields they export are:"Employee Number","Pay Date","Time In","Time Out","Regular Hours","Overtime #1 Hours","Overtime #2 Hours".
We use the Employee Number which you must assign to be the same as the Employee Code assigned in PayWindow so we can match the imported records with the proper employee. In we import the Regular Hours, and two Overtime Hours.
To export the data from TimeTrax Bio, use the instructions from their manual.
The result file should look similar this example:
EmpNo,PchDate,PchIn,PchOut,RegHrs,OT1Hrs,OT2Hrs
070,2010-01-18,17:15,19:15,2:00,,
070,2010-01-18,19:30,21:15,1:45,,
070,2010-01-19,17:15,19:15,2:00,,
070,2010-01-19,19:30,21:15,1:45,,
070,2010-01-20,17:15,19:15,2:00,,
070,2010-01-20,19:30,21:30,2:00,,
047,2010-01-18,17:00,19:15,2:15,,
047,2010-01-18,19:30,21:15,1:45,,
047,2010-01-19,17:00,19:15,2:15,,
047,2010-01-19,19:30,21:15,1:45,,
047,2010-01-20,17:45,19:15,1:30,,
047,2010-01-20,19:30,21:15,1:45,,
047,2010-01-21,17:00,19:15,2:15,,
047,2010-01-21,19:30,21:15,1:45,,
021,2010-01-17,16:00,18:30,2:30,,
021,2010-01-17,18:45,21:00,2:15,,
021,2010-01-18,17:15,19:15,2:00,,
021,2010-01-18,19:30,21:15,1:45,,
021,2010-01-20,17:15,18:30,1:15,,
021,2010-01-21,17:00,19:15,2:15,,
021,2010-01-21,19:30,21:15,1:45,,
085,2010-01-17,16:00,18:30,2:30,,
085,2010-01-17,18:45,21:00,2:15,,
085,2010-01-18,17:00,19:15,2:15,,
085,2010-01-18,19:30,21:15,1:45,,
093,2010-01-17,16:00,18:30,2:30,,
093,2010-01-17,18:45,21:00,2:15,,
093,2010-01-18,17:15,19:15,2:00,,
093,2010-01-18,19:30,21:15,1:45,,
093,2010-01-19,17:00,19:30,2:30,,
093,2010-01-19,19:30,21:15,1:45,,
093,2010-01-20,17:00,19:15,2:15,,
093,2010-01-20,19:30,21:15,1:45,,
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.