Skip to Content
This question has been flagged
importrelatedforeignkeyexternal_idV9
1 Respondre
7747 Vistes
Avatar
Lindsay Slazakowski

I'm on Odoo V9 trying to import 2 files, employees.csv and departments.csv. Employees has a column that references the Department's unique id (which I've mapped to the External ID per Odoo documentation). When mapping the department's unique in Departments I select "External ID" as my field and in Employees I select "Departments/External ID". When I try to validate employees.csv I get: 

insert or update on table "hr_employee" violates foreign key constraint "hr_employee_department_id_fkey" DETAIL: Key (department_id)=(1470) is not present in table "hr_department". at row 18 (3 more)
insert or update on table "hr_employee" violates foreign key constraint "hr_employee_department_id_fkey" DETAIL: Key (department_id)=(1471) is not present in table "hr_department". at row 30 (7 more)
insert or update on table "hr_employee" violates foreign key constraint "hr_employee_department_id_fkey" DETAIL: Key (department_id)=(1473) is not present in table "hr_department". at row 32 (15 more)
insert or update on table "hr_employee" violates foreign key constraint "hr_employee_department_id_fkey" DETAIL: Key (department_id)=(1472) is not present in table "hr_department". at row 392 (8 more)
insert or update on table "hr_employee" violates foreign key constraint "hr_employee_department_id_fkey" DETAIL: Key (department_id)=(1475) is not present in table "hr_department". at row 405 (1 more)

I'm not sure where that department_id is coming from. They are not the External IDs that I imported. I'm having this issue importing other related records as well. This was just the easiest to exemplify.

Avatar
Descartar
Avatar
Lindsay Slazakowski
Autor Best Answer

Alright, I've figured this one out on my own too. Turns out, your unique identifier has to be unique across ALL models. So, if my departments.csv uses 1, 2, 3... as its unique id, employees.csv can't use 1, 2, 3.... I changed them to dept_1, dept_2, dept_3... and emp_1, emp_2, emp_3... and that did the trick!

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Correct import of related records to Odoo
import vendor external_id
Avatar
Avatar
1
de març 23
3760
Weekly imports update the pricing for all our SKU's. Sometimes users create new products before the Import runs. This creates duplicates! How can I manage this? Solved
import external_id v11.0
Avatar
Avatar
1
de març 20
5099
Cannot update product information through External ID
import update external_id
Avatar
Avatar
Avatar
Avatar
5
d’abr. 18
9232
How to rename "External Id" with the "database id".
import .id database_id external_id
Avatar
Avatar
2
de març 15
13713
[13 CE] Automated Action for copy users email to external_id Solved
export import email external_id AutomatedActions
Avatar
Avatar
1
de març 22
3099