csv import ERROR: In punches cannot occur after an out punch

Topics brought up by the TimeTrex open source community.
Post Reply
mablower
Posts: 14
Joined: Tue Apr 21, 2015 10:27 am
Location: Willits, CA
Contact:

csv import ERROR: In punches cannot occur after an out punch

Post by mablower »

Having an issue with importing punch data from previous time system.

ERROR: In punches cannot occur after an out punch, in the same punch pair

Need some help figuring out why its throwing out this error. Data seems correct. Have tried standard and military times and timestamp format. "m/d/y#g:i A" and "m/d/y#G:i A"

See data, map file and error examples:


timetrex_column, csv_column, default_value, parse_hint
"company_id","","1",""
"user_id","","",""
"user_name","","",""
"employee_number","","",""
"type_id","","Normal",""
"status_id","","In",""
"branch_id","","19",""
"department_id","","",""
"job_id","","",""
"task_id","","",""
"quantity","","",""
"bad_quantity","","",""
"disable_rounding","","0",""
"time_stamp","","","m/d/y#g:i A"
"start_type_id","","Normal",""
"start_time_stamp","","","m/d/y#g:i A"
"end_type_id","","Normal",""
"end_time_stamp","","","m/d/y#g:i A"


user_id,user_name,department_id,quantity,bad_quantity,disable_rounding,start_time_stamp,end_time_stamp
,michael.blower,6,1,2,0,04/14/2015 05:30 AM,04/14/2015 07:00 AM
,michael.blower,6,1,2,0,04/14/2015 08:10 AM,04/14/2015 12:00 PM
,michael.blower,6,1,2,0,04/14/2015 12:30 PM,04/14/2015 06:21 PM
,michael.blower,6,1,2,0,04/15/2015 09:30 AM,04/15/2015 12:00 PM
,michael.blower,6,1,2,0,04/15/2015 12:30 PM,04/15/2015 05:58 PM
,michael.blower,6,1,2,0,04/16/2015 09:14 AM,04/16/2015 12:30 PM
,michael.blower,6,1,2,0,04/16/2015 01:00 PM,04/16/2015 06:01 PM

Importing Punch: 145. michael.blower................... Time Stamp: 145. 04/
14/15 5:30 AM (1429014600)
1. Success! 2. Success!
Importing Punch: 146. michael.blower................... Time Stamp: 146. 04/
14/15 8:10 AM (1429024200)
1. Success! 2. Success!
Importing Punch: 147. michael.blower................... Time Stamp: 147. 04/
14/15 12:30 PM (1429039800)
1. Success! 2. Success!
Failed!
ERROR: In punches cannot occur after an out punch, in the same punch pair

Importing Punch: 148. michael.blower................... Time Stamp: 148. 04/
15/15 9:30 AM (1429115400)
1. Success! 2. Success!
Importing Punch: 149. michael.blower................... Time Stamp: 149. 04/
15/15 12:30 PM (1429126200)
1. Success! 2. Success!
Failed!
ERROR: In punches cannot occur after an out punch, in the same punch pair
Importing Punch: 150. michael.blower................... Time Stamp: 150. 04/
16/15 9:14 AM (1429200840)
1. Success! 2. Success!
Importing Punch: 151. michael.blower................... Time Stamp: 151. 04/
16/15 1:00 PM (1429214400)
1. Success! 2. Success!
Failed!
ERROR: In punches cannot occur after an out punch, in the same punch pair
Michael Blower
Dripworks, Inc.
it@dripworks.com
Post Reply