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

게시판 정보

도움말

Unable to import contacts data linked to existing companies to Odoo CRM

crm fields import contacts json

2 답글

2233 화면

Viet Truong

Hi everyone,

I've already imported a list of companies into Odoo CRM Contact list using is_company = 1. Now I want to import contact data who work at this company. But when I use their company's name as "Related Company" it always returns this error
Unknown error during import: <class 'json.decoder.JSONDecodeError'>: Expecting value: line 1 column 1 (char 0) at multiple rows
Here are some things I've tried to fix the problem:

The problem isn't from any other fields. If I remove the related company field, there are no more errors.
I'm not quite sure if I'm using the right field for linked companies. If I use "Company" instead of "Related Company", it just says No matching records found for the following name in field Company despite all the companies being available in the database and can be looked up in Odoo.
I've also tried converting to csv and importing that instead, same error.
I've removed all filters/formatting in the original excel files before importing
This is a very small subset of my full data. Only 300 contacts out of 40k

Thanks everyone in advance 😅

Jamie

I'm sorry you haven't seen any answers yet, I'm going to try this and I'll report back. I think maybe this might work better using the numerical key field to connect the child record (contact) to the parent record (company). We'll see.

Christoph Farnleitner

베스트 답변

Your import file needs to look like this:

id	email	phone	name	is_company	parent_id
	office@acme.com	1111111111	ACME	1
	person@acme.com	1111111111-22	Person	0	ACME

You'll end up with two Contact-records, one of type Company, one of type Individual:

Alternatively, you can have two import files if you wish to do so. First one to import all the Company type Contacts, second one to import all the Individuals:

File 1:

id	email	phone	name	is_company	parent_id
	office@acme2.com	1111111111	ACME2	1

File 2:

id	email	phone	name	is_company	parent_id
	person@acme2.com	1111111111-22	Person	0	ACME2

The easiest way to identify how an import file is supposed to look like is to create a set of records with the structure desired and then export them (with the flag I want to update data (import-compatible export) set to 'true'). This way you can play around with the available fields until you see a structure that makes sense and try to import it.

See also https://www.odoo.com/documentation/18.0/applications/essentials/export_import_data.html - in here, at Import one2many relationships you can actually find an example for your exact requirement (Customers and their respective contacts).

Victor Darling

I built something that could be of use to you.

🎯 TinyFileConverter is a simple web tool that:

Accepts several spreadsheet file formats
Automatically maps fields (name, phone, email, address, etc.)
Cleans formatting issues before you import into Odoo
Delivers a clean, Odoo-ready CSV in seconds

The current MVP supports importing contacts, with plans to implement other modules

💡 Built with Odoo users and consultants in mind — no fluff, just results.

👉 Try it here: https://tinyfileconverter.vercel.app

I'd love your feedback, and if you find it helpful.

토론이 재미있으신가요? 직접 참여해보세요!

지금 바로 가입하여 독점 서비스를 이용해보고 특별한 커뮤니티와 소통하세요!

가입

관련 게시물	답글	화면
CRM, res_partner and fields 해결 완료 crm contacts	2 6월 25	3118
Multiple contacts on lead/opportunity & aggregate email chatter 해결 완료 crm contacts	1 9월 24	4409
Contact from website --> Opportunity Won in CRM → Company Contact in Contacts app crm contacts	1 8월 24	2417
Can a contact be a contact of multiple other contacts without being created x times? 해결 완료 crm contacts	1 8월 24	2848
update contact list language encountering issue import contacts	0 3월 24	2026

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!