I am trying to export all my products in my inventory with the sub heading Product Number, Product description, and Suppliers Name. but whenever I download this information the suppliers name does not show up with I would get _export_.product_supplierinfo.
So I try to export the complete supplier listing from OpenERP but I dont see anything thats matches this to do a cross refrenece.
- In the export window, choose "Export all Data" as your Export Type. You should be able to have lots more choices on what you can download. On note though, you may not be able to import the same csv file back to OpenERP.
- _export_.product_supplierinfo is probably the external identifier of the supplier record. If you want to map out all 3 models (product->external_id->supplier name) you will have to also export the External Identifier data. This is available if your account's Access Rights is enabled with Technical Features. Go to Settings -> Technical -> Sequences & Identifiers -> External Identifiers. (ir.model.data)
Neither is your comment. If it does not help, then what did you expect? I read richmond ang's solution and would have said more or less the same thing.
The only thing I can imagine is digging down into the tree-structure when exporting, this would reveal something like "product_supplierinfo_supplierinfoline_partner_id_name". It really is several layers deep and since it's also an one2many relationship (multiple suppliers for 1 product), don't be suprised if you get multiple lines for a single product.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 7/10/14, 12:58 PM|
|Seen: 694 times|
|Last updated: 3/16/15, 8:10 AM|