importing employee and contracts

Question

Hi,

I'm getting this error while trying to import employees contracts in Employee module :

*insert or update on table "hr_employee" violates foreign key constraint "hr_employee_resource_id_fkey" DETAIL: Key (resource_id)=(2583) is not present in table "resource_resource".*

I double checked all the columns the are exactly the same I exported before

Thank you

Gabsi Nihel · Answer

Check if you have deleted an employee after exporting the list containing employees external ids

Waleed Ali Mohsen · Answer

Add Resource Column to the imported table, and checked the option "create if not existed" while importing. it wasn't the resource record duplicated, actually the record doesn't exist and that's the problem.
Trying to import xls file to create employees. | Odoo [1]

[1] https://www.odoo.com/forum/help-1/trying-to-import-xls-file-to-create-employees-148537

Bài viết liên quan	Trả lời	Lượt xem
Need Help in Odoo Reporting. hr reporting v15	0 thg 12 22	1621
Automated actions when updating a field V15 Đã xử lý hr recruitment v15	2 thg 11 22	3532
How to count number of absent days of employee in hr attendance based on date interval? Đã xử lý hr attendance employees absent	2 thg 3 23	8013
Connect biometric Device Ronald jack in Odoo 15 hr attendance biometric v15	2 thg 12 22	4067
Connecting Employee and Documents Đã xử lý hr employee documents v15	1 thg 11 23	2442

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!