Overslaan naar inhoud
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Deze vraag is gerapporteerd
contactsproductsimporting data from excel file
2 Antwoorden
2799 Weergaven
Avatar
Bruno S

Good morning,

I have odoo online.

I am in my data import phase.

I took my product list from an already existing application with the id corresponding to this application.

I imported my list of products including the id and therefore I imported as an external id.

Everything went well. I now want to import my customer base.

And I have the following message for some clients "when trying to create/update a record of model res.partner found record of different model product.template". 

My customer external id conflicts with my product external id.

For me the external ids are specific to each table, so why this conflict?

Thank you in advance for your response.

Excellent day.

Avatar
Annuleer
Avatar
Thuy Ngoc
Beste antwoord

Hi  SCOCARD Bruno,

Odoo only uses one table to manage external ids, so if you want to create new records, please do not fill in the value in the external id column so that Odoo can generate the external id itself. Filling in the external id is only really useful in the case of updating data for existing records.

Avatar
Annuleer
Avatar
Bruno S
Auteur Beste antwoord

Hi Thuy Ngoc,

Thank you very much for this response.

But in this case, how can I import orders for example and relate them to the products and customers already imported?


So I created an external id like this based on the original software ids:

- for a customer with the original id 370, in external id, I put contact_370 which ultimately gives __import__.contact_370

- for a product with the original id 370, in external id, I put product_370 which ultimately gives __import__.product_370

-For an order with the original id 370, in external id, I put order_370 which ultimately gives __import__.order_370

So I have no conflict and I thought I would keep the relationships between each element.


Regards

Avatar
Annuleer
Thuy Ngoc

Hi SCOCARD Bruno,

This case is a bit strange. Can you take a photo or video describing the steps you took to import?

Bruno S
Auteur

I am referring to the Odoo documentation.

https://www.odoo.com/documentation/16.0/applications/general/export_import_data.html

What’s the difference between Database ID and External ID?

Thuy Ngoc

Regarding this difference, Odoo explains right in the article at the link above in paragraph:
"For the country Belgium, you can use one of these 3 ways to import:

Country: Belgium

Country/Database ID: 21

Country/External ID: base.be"

To reproduce your case more specifically, can you create a few google sheets to fill in some lines of data that you use to import?

Bruno S
Auteur

Hi Thuy Ngoc,
After a few days of reflection, we decided not to go any further with the import. This is to be able to make maximum use of Odoo’s possibilities.
So with the product and customer databases imported, all the subscription documents etc. we will recreate them.
So thank you for your help.
Regards

Gerelateerde posts Antwoorden Weergaven Activiteit
Importing multiple Products via csv
products importing data from excel file
Avatar
Avatar
Avatar
3
apr. 22
3388
how to import customer contacts odoo 10.0
contacts importing data from excel file
Avatar
Avatar
1
feb. 17
14805
Common Product Catalogue and Contact for multi company in Odoo 13 Opgelost
contacts multicompany products Odoo13.0
Avatar
Avatar
1
dec. 19
5999
importing contacts. Getting blocking error: Contacts require a name at multiple rows
contacts
Avatar
Avatar
Avatar
2
okt. 25
907
Blocking Errors
contacts
Avatar
Avatar
1
okt. 25
734