Hi Cédric, thanks for your feedback. On Wednesday, 2 July 2014 07:39:14 UTC-6, Cédric Krier wrote: > > On 02 Jul 06:05, Dale Scott wrote: > <snip> > > > > 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? > > Some data are not in the right format. So the client after displaying > it, re-format it and detect a change in the value. >
Could you describe in a general way how you would investigate this? > > 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? > > I did not look to close to your data structure but any way, csv import > only works for very basic/simple cases. Any even a little bit complex > import should be done using a proteus script. Python is an the ETL > (https://en.wikipedia.org/wiki/Extract,_transform,_load) > Is the csv import capable of importing one single-level BOM, but no more complex? > > 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? > > Attributes is a Dict field and there is no format in csv for this kind > of field. But it is supported by proteus. OK, I know I must eventually learn how to use proteus. 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. ;-)) > > This is because you have to deal with the internal data structure of > Tryton. If you want to understand, you have to read the code of the > Models. > OK. Thanks.
