It is possible to import attendances for same day at same time as previous data otherwise not

[Laura]

I have tried to get importing attendances to work with no success however during that process I noticed that even if importing new attendances for new dates fails (without any error) it is possible to import new attendances for the days that already have attendance data if the sign in and sign out times are same as for previous data (see screenshot).

So it seems that something in validity checks of importing attendances fails because it is possible to import invalid data but not valid data.

Edit:

Found out why I couldn't import correct data previously but it didn't prevent doing double import for same data.

If you want to get test this first import this file:

"action","name","employee_id/.id"
"Sign In","2013-09-16 10:35:17",1
"Sign Out","2013-09-16 11:35:17",1

which imports the data as it should (my problem earlier was that as in exported file the lines are reversed I copied syntax there but couldn't import data) after this import this file:

"action","name","employee_id/.id"
"Sign Out","2013-09-16 11:35:17",1
"Sign In","2013-09-16 10:35:17",1

And you have a double sign in sign out for the same day and time and OpenERP doesn't give any error even if it should.

[Twinkle Christian(OpenERP) (tch-openerp)]

Hello,,

I have checked this issue with latest trunk as well with 7.0, but I am not getting any issue with this. Would you please check it again and correct me with more information if I am wrong.

Thanks & waiting for your answer.

[Laura (laura-jarvenpaa)]

I created myself an account for 15 days trial and at least in that one I could reproduce this (see attachemnt). Note that when you _export_ data from openERP the dates in csv will be in UTC timezone but when you _import_ data the dates in csv has to be in your own timezone (I think this is also weird behavior but that is how it currently works) so after you have exported the data you have created aside of modifying ids you have to also change the time to correspond the times in your OpenERP attendance view because like I said OE doesn't allow importing attendances except if there is already created data which date and time are exactly same (remember also seconds).

[Laura (laura-jarvenpaa)]

Found out why I couldn't import correct data previously but it didn't prevent doing double import for same data.

If you want to get test this first import this file:

"action","name","employee_id/.id"
"Sign In","2013-09-16 10:35:17",1
"Sign Out","2013-09-16 11:35:17",1

which imports the data as it should (my problem earlier was that as in exported file the lines are reversed I copied syntax there but couldn't import data) after this import this file:

"action","name","employee_id/.id"
"Sign Out","2013-09-16 11:35:17",1
"Sign In","2013-09-16 10:35:17",1

And you have a double sign in sign out for the same day and time and OpenERP doesn't give any error even if it should.

[Twinkle Christian(OpenERP) (tch-openerp)]

Hello laura,

I am facing same issue with this. Thanks for provideing csv file.

So, I am confirming this issue.

Regards,

[Sunil Sharma(OpenERP) (sunil.sharma-openerp)]

Hello,

It has been Fixed in https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-bug-1223230-ssh

revision-id: 9060

revno: <email address hidden>

It will be available in trunk soon.