Skip to Content
This question has been flagged
3 Replies
4421 Views
Avatar
ITS Jamaica

Hi,

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.

 

Avatar
Discard
Avatar
Richmond Ang
Best Answer
  1. 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.
     
  2. _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)

 

Avatar
Discard
Avatar
ITS Jamaica
Author Best Answer

That didnt help at all, I really need to get this info asap 

Avatar
Discard
Avatar
Ludo - 21South
Best Answer

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.

Avatar
Discard