콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
4 답글
6274 화면

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"

아바타
취소

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

작성자

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

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

베스트 답변

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


아바타
취소

how can i avoid it ?

베스트 답변

how can i avoid resource id in my excel file ?



아바타
취소
베스트 답변

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

아바타
취소
베스트 답변

Hi  Aurel,

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

아바타
취소
관련 게시물 답글 화면 활동
1
7월 23
2541
1
4월 23
7876
2
10월 22
2683
import in odoo 14 해결 완료
1
6월 21
2949
1
8월 24
1946