location import (excel) get "No matching record found for name" on parent location

Question

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 paramet

Steve Shaffer · Accepted Answer

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)

Daniel Haynes · Answer

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?

Ray Carnes · Answer

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*

相關帖文	回覆	瀏覽次數
I have hard time getting know of this platform excel importing	2 9月 23	1956
Missing required value for the field 'name' at multiple rows while Importing SO. excel sale.order importing	1 8月 25	1315
How to open an excel file from binary field? 已解決 excel base64 odoo10	3 2月 23	13334
Method of import Excel file 已解決 excel importing odooV8	1 10月 19	13267
[ODOO10] Set up a warehouse as a vendor purchase warehouses odoo10	0 4月 18	4343

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！