Skip to Content
This question has been flagged
importemployeesv14
4 Replies
7956 Rodiniai
Portretas
ATBiv Services, Aurel Balanay

I got this error when importing excel file in hr.employee.


ERROR: insert or update on table "hr_employee" violates foreign key constraint "hr_employee_resource_id_fkey"

Portretas
Atmesti
Andrew Dekker

Did you find a solution? I am having the same issue.

ATBiv Services, Aurel Balanay
Autorius

need to add to your column the working schedule of the employee

noga

check if there is any data for this employee that is the same as another employee such as attendance user ID

Portretas
OdooTech Solutions, Bhushan vagh
Best Answer

you can avoid resource_id or assign resource import first then pass excel with resource id 


Portretas
Atmesti
Perry Gy

how can i avoid it ?

Portretas
Perry Gy
Best Answer

how can i avoid resource id in my excel file ?



Portretas
Atmesti
Portretas
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi

In this case, occur based on the resource id. because once the user_id is added to the database and we tried to import the employee details with the record you will get this type of error. so there is possible solution is that you need to try to import the employee details without resouce_id and the given contract id, after importing you can add the contract details separately

Hope it works

Portretas
Atmesti
Portretas
Thuy Ngoc
Best Answer

Hi  Aurel,

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

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
Many2many Fields
import v14
Portretas
Portretas
1
liep. 23
3857
Import button is missing Solved
import v14
Portretas
Portretas
1
bal. 23
9291
How to import employees without create contact ?
import employees
Portretas
Portretas
Portretas
2
spal. 22
3856
import in odoo 14 Solved
import v14
Portretas
Portretas
1
birž. 21
4100
Update odoo records based on custom field
import update employees
Portretas
Portretas
1
rugp. 24
3267