Punches Import Wizard has vanished

[bdrayer]

Hi,

My Timetrex system has been automatically updated to 8.0 and when I try to import punches using the wizard it does not appears on the list of wizard available.

Is there a way to get this back? I really need it quickly because I have no way to import data otherwise.

[gpapke]

I have the same problem. Is there another way to import punches? Or is there any way to get the Import Punches wizard back?

[bdrayer]

Yes you can do it using command line under tools/import but it's more complicated.

[bdrayer]

If someone use a Safescan Stamper, I have done a script that can be started using a cron to download once a day data and import them automatically into TimeTrex

[jairo]

If someone use a Safescan Stamper, I have done a script that can be started using a cron to download once a day data and import them automatically into TimeTrex

Hello bdrayer,

I would like to see that script and please also share the safescan model.

Thanks

[ph4acid]

Yes you can do it using command line under tools/import but it's more complicated.

Can you provide some instructions on how to do this via command line?
It takes a while to get set up and running and I would hate to have to uninstall current version to set up the v7.

[aprill]

Same problem here. I am going to attempt running from CL.


*** Can you please bring this feature back in the next version???****

[ph4acid]

Can you provide some instructions on how to do this via command line?
It takes a while to get set up and running and I would hate to have to uninstall current version to set up the v7.

I found this in the forum:
c:\timetrex\php\php.exe c:\timetrex\timetrex\tools\import\import_punches.php
Usage: import_punches.php [OPTIONS] [Column MAP file] [CSV File]

There are is are two sample punch csv and a punch column map file in the ...tools\import directory.

I was hoping to have functionality to allow the administrator/supervisor to import punches when logged in from another computer without having to be on the server where the application is hosted. Really hoping the import punch functionality via GUI comes back!

[aprill]

I tried running the import_punches.php with the map and csv set.

I get errors like:
Importing Punch: 328. ................................. Failed!
ERROR: User not found!
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
Importing Punch: 329. ................................. Failed!

this is what my map file looks like:
timetrex_column, csv_column, default_value, parse_hint
"employee_number","","",""
"time_stamp”,””,””,”m/d/Y#H:i:s”
"status_id","","In",""
"disable_rounding","","0",""

this is what my punches file looks like:
19,3/2/2015 15:00:00,IN
19,3/2/2015 19:00:00,OUT
19,3/2/2015 19:15:00,IN
19,3/2/2015 23:30:00,OUT

Any help would be greatly appreciated.

[aprill]

If someone use a Safescan Stamper, I have done a script that can be started using a cron to download once a day data and import them automatically into TimeTrex

Hello bdrayer,

I would like to see that script and please also share the safescan model.

Thanks

I would also like to see your script. It might give me insight as to what I have wrong when trying to import my punches from CL.