On 2017-07-16 12:20, Richard PALO wrote: > Continuing my adventure with openerp2tryton, I come across a new challenge. > > Part of the migration includes adapting the default accounting plan with a > csv file. > PM: I am using account_fr for the French PCG. > > I use the following header: > >id,name,active,code,kind,parent,party_required,reconcile,deferral,type > > everything seems okay until I get to the VAT accounts (4452xx and 44566x, > where "Autres" is not a unique name in account.account.type.template (nor in > account.account.type) > and thus gives an error. > > There doesn't seem to be any Parent parsing, so prepending a parent > (eg 'Créances d'exploitation\Autres') doesn't seem to work nor does replacing > the the 'name' with the id directly (tag nor value)... > > Looking at the code for import_data() in modelstorage.py I thought I'd try > using 'type:id' in the header and 'account_fr.creances_autres' in the value > but then I get the following: > > psycopg2.IntegrityError: ERREUR: une instruction insert ou update sur la > > table « account_account » viole la contrainte de clé > > étrangère « account_account_type_fkey » > > DETAIL: La clé (type)=(196) n'est pas présente dans la table « > > account_account_type ». > > it appears that import_data uses account.account.type and not > account.account.type.template where the db_id retrieved is > indeed the id of the type but which appears not to be maintained in > account.account.type. > > Is this a bug in account.account.type structure (that is, losing the valid > ids)?
It is not a bug, it is how the account module is designed (look at the target of the type Many2One). > Other ideas on how to import these VAT accounts? The CSV importation is a very fragile methods, it is used on openerp2tryton to manage simple case. For more complex case, you should write a module to complete (or create) the chart of account template. -- Cédric Krier - B2CK SPRL Email/Jabber: [email protected] Tel: +32 472 54 46 59 Website: http://www.b2ck.com/ -- You received this message because you are subscribed to the Google Groups "tryton" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/20170716113514.GW30717%40kei.
