On 26 Mar 15:10, Raimon Esteve wrote: > 2014-03-26 12:48 GMT+01:00 Paul Leverett <[email protected]>: > > Hi, I'm struggling with importing csv data into Products. > > > > From previous posts I understand that "CSV import is not the direct opposite > > of csv Export", but I still can't get my head around how to import data that > > includes mandatory pick-list fields. I can do a text-only import OK, but > > can't get anything to work with look-ups. > > > > e.g. As a test I try to import a single Product record CSV with the minimal > > mandatory fields: > > << > > Cost Price,List Price,Name,Type,Default UOM/Name,Cost Method > > 9.000,11.000,Minimal fields test product3,goods,Unit,fixed > >>> > > > > This doesn't work and gives me a server error. > > > > Can you give me any specific information about why this doesn't work?
Can you give us information about the error first? > > For look-ups do I need to use an ID instead of a name? > > UOM need an ID, not name > That's false. import_data for many2one accepts name: http://hg.tryton.org/trytond/file/8e5623672cdc/trytond/model/modelstorage.py#l555 > You have examples in doc.tryton-erp.es (1) (2) (Use a translator to > translate Spanish to another language) > > (1) http://doc.tryton-erp.es/trytond_doc/tryton_import_export.html > (2) http://www.tryton-erp.es/posts/importacion-de-productos-mediante-csv.html I could have proposed a correction if it was in English. -- Cédric Krier - B2CK SPRL Email/Jabber: [email protected] Tel: +32 472 54 46 59 Website: http://www.b2ck.com/
pgpNOVc5nT_SA.pgp
Description: PGP signature
