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

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

CRM
e-Commerce
Бухгалтерия
Склад
PoS
Проекты
MRP

All apps

Все посты Люди Значки

Теги (Смотреть все)

odoo accounting v14 pos v15

Об этом форуме

Помощь

Trying to import xls file to create employees.

import odoo12

4 Ответы

13241 Представления

Hunain

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

Лучший ответ

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.

Rodrigo Negrete Perez

Hi. I did the same as you and it works fine. There´s a little detail though. When I imported employees I assigned the same name to the resource as to the employee which is the default behavior. The problem came when I realized that having thousands of employees, more than one employee had their names repeated. In this case I ended up with more than one employee pointing to the same resource since odoo assigned the employee to the existing resource. I ended up making the employee name unique to solve this. Cheers

Perry Gy

you may have a screenshot how the columns should looks like. ?

Thuy Ngoc

Hi Hunain,

I think this video can help you:

https://www.youtube.com/watch?v=VMJ0UI1crz4&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=3

Fathi Ghaiati

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

Niyas Raphy (Walnut Software Solutions)

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	3440
How to import user in odoo12 ? Решено import users odoo12	2 июл. 19	7499
Issue with import and comma in Excel File (odoo 19) import	0 сент. 25	234
Importacion de Atributos y Valores import	2 мая 25	2264

Этот вопрос был отмечен

Не оставайтесь в стороне – присоединяйтесь к обсуждению!