Hi all, On Thursday, 27 March 2014 06:26:21 UTC-6, Paul Leverett wrote: > > > Now that I've go a basic example working I'm a lot happier in progressing > various different imports - thanks for the help >
I'm still trying to get my basic example working before I can be a lot happier... ;-) I am trying to import products (parts) and a BOMs from a commercial database application called Parts&Vendors (P&V) (see [8] for an ascii-art BOM tree). After some trial-and-error, I was able to import all the product from P&V using a simplified version of the csv exported from P&V ([1] is the csv as exported from P&V, [2] is the simplified version that I actually imported). Problem 1. If I view the detail of a specific product in Tryton (menu Products > Products, select a specific product, "Switch view" to see product detail), and then try to "Switch view" back to the grid view showing all product, Tryton will warn that the record has been modified and ask if I want to save it - even though I did not knowingly edit it. What can cause this? Is it because my import csv is missing some required field, and if so, how can I know which fields are required? I thought perhaps the "blue" highlighted fields in the Import/Export "All fields" window are required, but I was able to import [2] without error - and without most of the "blue" fields (there are so many blue fields!). Problem 2. The P&V BOM table includes two foreign key constraints to the P&V part table. Each row in [3] represents a child part on a BOM, PLListID is the PNID of the parent product in [1], and PLPartID is the PNID of a child product on the BOM. Other fields in [3] give the quantity on BOM, the "use-as" UOM, the item number on the BOM listing, etc. Can Tryton import multiple BOMs from a single csv file having this structure? Will someone give me a hint as to the field names? Problem 3. P&V product data ([1]) includes a number of attributes not defined in the Tryton product module. I have installed the product-attribute module, created attributes corresponding to those in P&V (and entered values for several products manually), but I don't understand how to import these attributes from csv. Is it possible to import these additional attributes at the same time as products are imported? I read the Tryton wiki page on Export/Import Limitations ([4]), and the pages on importing csv on the spanish-language Tryton site ([5], [6] and [7]), but right now importing seems very close to magic. Why are two csv files required, one for "Template: name, price..." and another for "product code, description..." ([6]). Perhaps if I understand this, all will be clear (but right now, importing seems more like magic. ;-)) Thanks for your help, Dale [1] https://github.com/dalers/maestro/blob/master/scc/csv-1/pv_pn.csv [2] https://github.com/dalers/maestro/blob/master/scc/ods/product-tryton-product.csv [3] https://github.com/dalers/maestro/blob/master/scc/csv-1/pv_pn.csv [4] https://code.google.com/p/tryton/wiki/ImportData [5] http://doc.tryton-erp.es/trytond_doc/tryton_import_export.html [6] http://www.tryton-erp.es/categories/importacion.html [7] http://www.tryton-erp.es/posts/importacion-de-terceros-mediante-csv.html [8] https://github.com/dalers/maestro/blob/master/tryton-proposed/001-initial-setup-and-import.md#create-bills-of-materials-boms
