Skip to Content
This question has been flagged
errorimportstatevendor
1 Respondre
6254 Vistes
Avatar
Mark Flavin

Forgive me if this seems trivial but I have spent a considerable amount of time trying to make this work. In trying to import the very first list, in this case, Vendors,  with only two input lines into a new instance of Odoo using the TEST IMPORT command. Odoo posts a message: "No matching record found for external id 'base.state_us_' in field 'State' at row 3." Using the "Get all possible values" lists a number of cities none of which are in the US are shown. The only way to clear the error is to hard code "base.state_us_**" putting the actual numeric code for the state in the csv file where I have shown **.

What am I doing wrong? I have googled this for hours, searched the community blog, read all the documentation I can find to solve the problem. This should not be this difficult.

Your help would be greatly appreciated.

Avatar
Descartar
Avatar
Sushma
Best Answer

Hi Mark,

Please do check with state id should be exists in odoo DB, for example country is US and state id = 2 for country US.

Import file should be "state_countrycode_state.id" like following:

name                 state_id/id             country_id/id

Vendor Name base.state_us_2     base.us

Thanks!


 

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Multiple matches for state in vendor import Solved
import vendor
Avatar
Avatar
1
de gen. 23
8106
Odoo12 babel error Solved
error import
Avatar
Avatar
1
de nov. 19
7991
Bug following a contact import : column res_partner_bank.active doesn't exist
error import
Avatar
Avatar
1
de març 15
5253
Error Can't Import Web Pages (Theres a Bug)
error import webpage
Avatar
Avatar
2
de jul. 25
3123
Importing Web Pages Seems Impossible Solved
error import webpage
Avatar
Avatar
Avatar
2
de jul. 25
3435