I am getting errors trying to run import_punches.php
I am running the community edition, Version 8.0.2 Tax Engine Version 1.0.29
On a mac server 10.9.5
I tried running the import_punches.php with the map and csv set.
Here is the CL syntax I use:
php import_punches.php punch_column_map1.txt PunchDetail1.csv
this is what my punch_column_map1.txt file looks like:
timetrex_column, csv_column, default_value, parse_hint
“user_name”,””,””,””
“time_stamp”,””,””,”m/d/Y#H:i:s”
“status_id”,””,”In”,””
this is what my PunchDetail1.csv file looks like:
”henry.ash”,”3/24/2015 15:00:00”,”IN”
”henry.ash”,”3/24/2015 19:00:00”,”OUT”
Here is the output:
PHP Notice: Undefined index: employee_number in /Applications/TimeTrex/timetrex/tools/import/import_punches.php on line 256
PHP Notice: Undefined index: user_id in /Applications/TimeTrex/timetrex/tools/import/import_punches.php on line 259
Column Mappings...
TimeTrex Column: “user_name” => ”” Default: ””
TimeTrex Column: “time_stamp” => ”” Default: ””
TimeTrex Column: “status_id” => ”” Default: ”In”
Importing Punches...
Importing Punch: 1. ................................. Failed!
ERROR: User not found!
Total Errors: 1
Rolling back transaction!
WARNING: Clear TimeTrex cache after running this.
I did not edit the import_punches.php
Why am I getting User not found?
Does this refer to the user in the PunchDetail1.csv?
This user exists as a user in timetrex under employee in the user name field. (spelled exactly the same)
I have tried a different user in the punch csv file to troubleshoot and I got the same output.
Any help would be greatly appreciated.