Skip ke Konten
Pertanyaan ini telah diberikan tanda
importemployeesv14
4 Replies
5900 Tampilan
Avatar
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"

Avatar
Buang
Andrew Dekker

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

Aurel Balanay
Penulis

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

Avatar
Bhushan vagh
Jawaban Terbai

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


Avatar
Buang
Perry Gy

how can i avoid it ?

Avatar
Perry Gy
Jawaban Terbai

how can i avoid resource id in my excel file ?



Avatar
Buang
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Jawaban Terbai

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

Avatar
Buang
Avatar
Thuy Ngoc
Jawaban Terbai

Hi  Aurel,

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

Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
Many2many Fields
import v14
Avatar
Avatar
1
Jul 23
2217
Import button is missing Diselesaikan
import v14
Avatar
Avatar
1
Apr 23
7554
How to import employees without create contact ?
import employees
Avatar
Avatar
Avatar
2
Okt 22
2371
import in odoo 14 Diselesaikan
import v14
Avatar
Avatar
1
Jun 21
2598
Update odoo records based on custom field
import update employees
Avatar
Avatar
1
Agu 24
1623