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

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Import related record using unique identifier (External ID)

import related foreignkey external_id V9

1 Odpowiedz

7775 Widoki

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.

Lindsay Slazakowski

Autor Najlepsza odpowiedź

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!

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Correct import of related records to Odoo import vendor external_id	1 mar 23	3790
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? Rozwiązane import external_id v11.0	1 mar 20	5105
Cannot update product information through External ID import update external_id	5 kwi 18	9247
How to rename "External Id" with the "database id". import .id database_id external_id	2 mar 15	13733
[13 CE] Automated Action for copy users email to external_id Rozwiązane export import email external_id AutomatedActions	1 mar 22	3101

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!