Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

ลูกค้าสัมพันธ์
e-Commerce
ระบบบัญชี
สินค้าคงคลัง
PoS
โปรเจกต์
MRP

All apps

All Posts คน เหรียญรางวัล

แท็ก (View all)

odoo accounting v14 pos v15

เกี่ยวกับฟอรั่มนี้

ช่วยเหลือ

CSV Import of attendance disabled by default?

import v7 attendance

2 ตอบกลับ

9880 มุมมอง

Laura Jarvenpaa

In my company only office people are using openERP to sign in/out directly and for the others this attendance data should be imported. However, when I try to import attendance data it is not imported. Also, OpenERP doesn't show any error message but there appears a red line in place where error message should come.

My test file looks like this:

id,action,name,employee_id/id

28,Sign Out,2013-08-02 09:23:18,__export__.hr_employee_98

27,Sign In,2013-08-02 08:22:57,__export__.hr_employee_98

where id is based on next id number after the previous data (which ids I checked by exporting existing attendance) I have also tried to import this file so that I have left the field id empty but it didn't work either. Importing any other data e.g. employees works as it should. So I started to wonder if it is possible to import attendances at all (e.g. because it would enable easy false data import)? But if it is so why any error message is not shown?

Has anyone else tried to import attendances to OpenERP? If so what did you do to make it work?

Edit: I noticed that it is possible to update existing attendances by using import so this problem seems to occur only if you are importing new data.

Edit 2: I also noticed that it is possible to double import same sign in/out data for same day with different ids (resulting in two sign ins and sign outs at same time for same day) but if I change day or time it won't import any data.

gunnar

if someone will have to enter Attendance by hand for 20, or let's say 50 people because csv import won't work ... poor fella!!! No one with a hint about this? ... As I look at this a little closer ... you have 'name' to match the actual time. Can this be the problem? (Or is 'name' just a weird way of saying 'yyyy-mm-dd hh:mm:ss' ?)

Laura Jarvenpaa

ผู้เขียน

'name' in attendance module refers to the date when sign in/out has happened. It seems that in OE in each table there has to be column 'name' and in attendance table it just happens to be the date.

Laura Jarvenpaa

ผู้เขียน คำตอบที่ดีที่สุด

Found the problem, order of sign in and sign out is reversed when importing as compared to exported data i.e. exported data looks like this:

id, action, name, employee_id/id

__export__.hr_attendance_301, Sign Out, 2013-09-17 03:35:17, __export__.hr_employee_98

__export__.hr_attendance_300, Sign In, 2013-09-17 02:35:17, __export__.hr_employee_98

But when importing same data it should look like this:

"action","name","employee_id/id"

"Sign In","2013-09-17 10:35:17","__export__.hr_employee_98"

"Sign Out","2013-09-17 11:35:17","__export__.hr_employee_98"

Andreas Brueckl

If you just want to import data you should not use the field id in the import.

For me the following import data works fine (assuming that administrator is currently signed in):

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

I am using the database ID instead of the External ID, but his should not be any problem (if the external ID exists). You could also use "employee_id" and write the name of the employee.

Laura Jarvenpaa

ผู้เขียน

It still doesn't work for me I tested it also on 15 days trial of OpenERP in case there was a problem in my version but it didn't work there either. Which version of OpenERP you are using?

Andreas Brueckl

I am using 7.0. Have you check whether the order of signIn/signOut is correct? Is there no error message?

Laura Jarvenpaa

ผู้เขียน

Yes I have checked it and tried also with your example (changed only employee id) as I have said in my question there is no error message there appears only red line in place where the error message should be nothing else.

Laura Jarvenpaa

ผู้เขียน

found the problem when importing stuff the order of sign in sign out is reversed to one it is when data is exported which could have been seen also from your example when inspecting dates however you example needs sign in on 2013-09-13 which was not existing so OE didn't import that one also because it is not legal. It weirdc that OE didn't give any error message thou.

sridhar

@ All, I use the same format but it is not working. the Error Message is "warning -- ValidateError Error occurred while validating the field(s) action: Error ! Sign in (resp. Sign out) must follow Sign out (resp. Sign in)" How to identify employee_id/id _export_hr.attendance_10_20 and How to import Attendance in OpenERP 7, Help me.

Matthew Crowder

The problem is you must change the above example so that the sign in comes before the sign out... like this: "action","name","employee_id/.id" "Sign In","2013-11-13 08:35:17",2 "Sign Out","2013-11-13 17:35:17",2

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
How to import multiple lines text fields with CSV ? แก้ไขแล้ว import v7	5 ก.ย. 25	24843
How to import an existing chart of accounts? import v7	2 ก.ค. 16	13863
Current record in massive import import v7	1 มี.ค. 15	5322
What is the best method to upload a large quantity of records? import v7	3 มี.ค. 15	9950
Import Invoices while maintaining date invoice import v7	0 ต.ค. 25	4054

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!