Shaun,
I am still having a time with the punch import. I am not getting data in the database.
here is my mapping file:
Code: Select all
timetrex_column, csv_column, default_value, parse_hint
"user_name","","",""
"type_id","","Normal",""
"status_id","","In",""
"time_stamp","","","m/d/y#g:i A"
Here is my punch file:
Code: Select all
"user_name","type_id","status_id","time_stamp"
"jsmith","","In","9/17/2009 08:00 AM"
"jsmith","","Out","9/17/2009 12:00 PM"
"jsmith","","In","9/17/2009 01:00 PM"
"jsmith","","Out","9/17/2009 06:00 PM"
Here is the command line result with the -n option to show you feed back that indicates it is reading data:
Code: Select all
Column Mappings...
TimeTrex Column: user_name => user_name Default:
TimeTrex Column: type_id => type_id Default: Normal
TimeTrex Column: status_id => status_id Default: In
TimeTrex Column: time_stamp => time_stamp Default:
Sample Punches...
Sample Punch: 1
user_name: jsmith
type_id: Normal
status_id: In
time_stamp: 9/17/2009 08:00 AM
Sample Punch: 2
user_name: jsmith
type_id: Normal
status_id: Out
time_stamp: 9/17/2009 12:00 PM
Importing Punches...
Importing Punch: 1. jsmith...........................
What am I doing incorrectly?
Lloyd