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

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

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

crm fields import contacts json

2 Vastaukset

2268 Näkymät

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

Paras vastaus

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.

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
CRM, res_partner and fields Ratkaistu crm contacts	2 kesäk. 25	3165
Multiple contacts on lead/opportunity & aggregate email chatter Ratkaistu crm contacts	1 syysk. 24	4455
Contact from website --> Opportunity Won in CRM → Company Contact in Contacts app crm contacts	1 elok. 24	2439
Can a contact be a contact of multiple other contacts without being created x times? Ratkaistu crm contacts	1 elok. 24	2875
update contact list language encountering issue import contacts	0 maalisk. 24	2043

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!