Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
warehousesexcelimportingodoo10
3 Vastaukset
10440 Näkymät
Avatar
Steve Shaffer

I'm trying to import a large number of locations within a warehouse (stocking bins).  I first hand created a single entry and for the parent I selected OBR/Stock from the dropdown list of parent locations.

Using "OBR" or "OBR/Stock" in the excel spreadsheet yields the error "No matching record found for name 'OBR' in field 'Parent Location' at row 2" during validation.  Obviously some other identifier for the stocking location needs to be used but so far I haven't been able to guess what parameter to use.  Using the ID (as viewed form the warehouses metadata) doesn't work (value for OBR is 40).

How can I deterimine what value to place in the excel spreadsheet for this field? 

I have a similar problem with a custom field that refers to the Product Unit of Measure (the bin locations have a fixed capacity that we need to use)

I'm running Odoo10 community.


Avatar
Hylkää
Avatar
Steve Shaffer
Tekijä Paras vastaus

Ray,

Thank you for the help! I should have thought of exporting the handmade record first! I still got the errors on the next pass but I did finally resolve the parent stock location.

1) Always export and example record and example field value

2) Use the column headers from the example reord exactly.  The ability to match fields does not seem to work

3) very carefully examine the field values from the export in stage one and eliminate any trailing characters (such as spaces)

Avatar
Hylkää
Avatar
Daniel Haynes
Paras vastaus

I held off as long as I could before responding to this. The question describes my situation to a T so I followed the steps that Steve gave after seeing Ray's answer.  Here are the details:

Parent Name: FB/Stock

Parent id: stock.stock_location_stock

Parent location_id: __export__.stock_location_11

I tried all of these in the parent location field of the csv and I always get the error "No matching record found for name"

Does anyone have any ideas?

Avatar
Hylkää
Avatar
Ray Carnes
Paras vastaus

Export the location OBR/Stock (just choose a single field like Location Name) and choose the value that is shown in the first column - "id".

It will be something like:

stock.stock_location_XX

__export__.stock_location_XX


Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
I have hard time getting know of this platform
excel importing
Avatar
Avatar
Avatar
2
syysk. 23
1928
Missing required value for the field 'name' at multiple rows while Importing SO.
excel sale.order importing
Avatar
Avatar
1
elok. 25
1265
How to open an excel file from binary field? Ratkaistu
excel base64 odoo10
Avatar
Avatar
3
helmik. 23
13294
Method of import Excel file Ratkaistu
excel importing odooV8
Avatar
Avatar
1
lokak. 19
13231
[ODOO10] Set up a warehouse as a vendor
purchase warehouses odoo10
Avatar
0
huhtik. 18
4323