Trying to import xls file to create employees.

Question

whenever I tried to import xls file to create employees. This error occurs.
insert or update on table "hr_employee" violates foreign key constraint "hr_employee_resource_id_fkey" DETAIL: Key (resource_id)=(370) is not present in table "resource_resource".  at row 2

Ali Mahmoud · Accepted Answer

I had the same problem and I solved it by adding 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.
Just sharing it for the people who may face the same problem.

Thuy Ngoc · Answer

Hi
Hunain,
I think this video can help you:
https://www.youtube.com/watch?v=VMJ0UI1crz4&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=3

Fathi Ghaiati · Answer

This error occurs if exists repeated External ID in import file. Check all External IDs are unique.

Niyas Raphy (Walnut Software Solutions) · Answer

Hi,
Seems that importing data is referring to a record in the model resource.resource and that record with the given ID is not existing in the database. So Check the database and see whether there is a record present in the given ID.
Activate the developer mode and navigate to *Settings -> Technical -> Resource -> Resources* and check for the record existence.

For getting the sample import template of the Employees in odoo12,

Thanks

المنشورات ذات الصلة	الردود	أدوات العرض
Can't import account_payment module module import odoo12	1 أكتوبر 23	97
O12 Product Import - Chatter information on the right is missing تم الحل product import odoo12	2 سبتمبر 21	3447
How to import user in odoo12 ? تم الحل import users odoo12	2 يوليو 19	7515
Issue with import and comma in Excel File (odoo 19) import	0 سبتمبر 25	234
Importacion de Atributos y Valores import	2 مايو 25	2270

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!