Hi ,
while importing the records through excel file,it showing the below error.resource_id is not showing in the hr.employee model,but while exporting the records,it showing the error.if, we have many2one field, should we pass the id of the record or name in the excel file?
error like,insert or update on table "hr.employee"violates foreign key constraints "hr_employee_resource_id_fkey" detail key (resource_id) is not present in table "resource_resource" at row 2.like it is showing for all the records in the excel file while importing.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
1
Reply
1686
Views
The module named "VKS Import Excel" can help you solve this problem easily: https://apps.odoo.com/apps/modules/16.0/vks_import_excel.
Please contact me via email anhtuan.acoi@gmail.com if you need further assistance.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
2
Nov 24
|
1554 | ||
|
1
Nov 24
|
1969 | ||
|
5
Nov 23
|
2885 | ||
|
1
Oct 23
|
2708 | ||
|
3
Dec 23
|
20570 |