Skip to Content
Dette spørgsmål er blevet anmeldt
csvimporting data from excel fileodoo10.0
1 Svar
10922 Visninger
Avatar
Silviaa

I created products with demo data. I need to use this created product to the another table, so i gave the "product_id/id" as "External ID" in the csv file. while import the csv file it shows an error like "No matching record found for external id 'demo_addon.demo_product_5' in field 'Product' at row 2".

My import data:

         product_id/id
         demo_addon.demo_product_5
         demo_addon.demo_product_6
         demo_addon.demo_product_7

can anyone guide me to resolve this issue. 

Avatar
Kassér
Avatar
Levenez Morgan
Bedste svar

hi product_id this field maтy2one or other field with the ratio of the corresponding id should be with the table referenced to the example

 "product.product_product_7"
or
"product.product_product_7_product_template"
Avatar
Kassér
Silviaa
Forfatter

I used like as you mentioned, but it still shows this error "No matching record found for external id 'product.product_product_5' in field 'Product' at row 2"

Levenez Morgan

so in your database there is no object with this id, the number in external_id corresponds to the id in the table of the database postgresSQL check whether there is such an object in the corresponding database table

Related Posts Besvarelser Visninger Aktivitet
Import csv file with related field other than id, external id, name
import csv importing data from excel file
Avatar
Avatar
Avatar
Avatar
4
nov. 24
12727
[Odoo 10.0] Hide Pro-Forma Invoices to Employees in the Accounting Module
csv account.invoice odoo10.0
Avatar
0
aug. 17
3825
Differ context on test import and real import Løst
import csv importing data from excel file odoo11
Avatar
1
jan. 25
6295
security /groups structure and explanation with example Løst
security csv groups odoo10.0
Avatar
Avatar
1
aug. 18
15793
TypeError: error.data.arguments is undefined
csv typeerror odoo8.0 importing data from excel file
Avatar
0
jan. 17
5888