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

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

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

crm fields import contacts json

2 Odpowiedzi

2443 Widoki

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

Najlepsza odpowiedź

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.

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
CRM, res_partner and fields Rozwiązane crm contacts	2 cze 25	3469
Multiple contacts on lead/opportunity & aggregate email chatter Rozwiązane crm contacts	1 wrz 24	4570
Contact from website --> Opportunity Won in CRM → Company Contact in Contacts app crm contacts	1 sie 24	2522
Can a contact be a contact of multiple other contacts without being created x times? Rozwiązane crm contacts	1 sie 24	2982
update contact list language encountering issue import contacts	0 mar 24	2137

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!