how can i import this file format

[yizhaq]

hi, im using tr-515 punch clock that generates this csv file format:


dont know, dont know, employee id, in and out ( 0 for out 1 for in), date, time
001,A10E1,9999000008,0,2011/02/27,19:07:51
001,A10E2,9999000012,1,2011/02/28,08:15:03
001,A10E3,9999000008,1,2011/02/28,08:15:09
001,A10E4,9999000002,1,2011/02/28,08:24:51
001,A10E5,9999000009,1,2011/02/28,08:33:29

i cant import this file
i try to delete oll columns but employee id, date and time but i got this error

ERROR: Failed calling method: Import as part of serivce: APIImportPunch! Exception: postgres7 error: [-1: ERROR: current transaction is aborted, commands ignored until end of transaction block] in adodb_throw(CREATE SEQUENCE system_log_id_seq START 1, )
Arguments: array(3) {
[0]=>
array(3) {
["time"]=>
array(4) {
["default_value"]=>
string(0) ""
["parse_hint"]=>
string(0) ""
["field_name"]=>
string(4) "Time"
["map_column_name"]=>
string(5) "12:34"
}
["employee_number"]=>
array(4) {
["default_value"]=>
string(0) ""
["parse_hint"]=>
string(0) ""
["field_name"]=>
string(10) "Employee #"
["map_column_name"]=>
string(10) "9999000009"
}
["date"]=>
array(4) {
["default_value"]=>
string(0) ""
["parse_hint"]=>
string(5) "d/m/Y"
["field_name"]=>
string(4) "Date"
["map_column_name"]=>
string(10) "20/05/2013"
}
}
[1]=>
array(2) {
["fuzzy_match"]=>
bool(false)
["disable_rounding"]=>
bool(false)
}
[2]=>
bool(false)
}
BackTrace: #0.Debug::backTrace()
#1.ServiceMapper->invokeService(APIImportPunch, Import, Array(3), Array(1))
#2.call_user_func_array(Array(2), Array(4))
#3.SabreAMF_CallbackServer->invokeService(APIImportPunch, Import, Array(3), Array(1))
#4.SabreAMF_CallbackServer->exec()
#5.ServiceMapper->exec()

what i need to change?
thank you

[shaunw]

What version of TimeTrex are you using?

Also could you send us a screenshot of the column mapping step of the import wizard?

[yizhaq]

hi,
my version is 5.3.3
there is a couple of screenshots i made.
thank you

[shaunw]

Can you please attach a copy of the file that you are trying to import so we can run a test here?

[yizhaq]

this the original file from tr515 clock
https://docs.google.com/file/d/0By7JdnM ... sp=sharing
thank you

[shaunw]

Unfortunately TimeTrex isn't able to read that file format, specifically the In/Out column must use "In" or "Out", 0 and 1 will not work.

[yizhaq]

I see. And if ill make macro that will change the 0/1 to in/out will this make the difrent? And do i need to mark it as "type"?

[shaunw]

If you change the 0/1 to In/Out then add a header row to label each column in the file, that should work for you.

[yizhaq]

ok, i changed the file to this
https://docs.google.com/file/d/0By7JdnM ... sp=sharing
still have problems....

[shaunw]

What error messages are you receiving when you try to import that file? As well can you include a screenshot of step 3 in the wizard?

[yizhaq]

https://docs.google.com/file/d/0By7JdnM ... sp=sharing
https://docs.google.com/file/d/0By7JdnM ... sp=sharing
https://docs.google.com/file/d/0By7JdnM ... sp=sharing
https://docs.google.com/file/d/0By7JdnM ... sp=sharing

pictures of steps with new file

[shaunw]

TimeTrex v7 should be released in the next week or so, give it a try on that version and let us know if you continue to have issues.

[shanec]

TimeTrex v7.0 has now been released. Update your install and let us know if you're stilling having this issue.