Error "current transaction is aborted.." on import CSV in v7

Question

Hello..
i'm trying to import this dl.dropboxusercontent. com/u/57978373/sample.partner.csv
But keep getting this error current transaction is aborted, commands ignored until end of transaction block .
What should I do? Thanks

Martin · Accepted Answer

You are seeing a PostgreSQL database error. OpenERP began an insert transaction which then failed. It ignored that failure and continued trying to use the SAME TRANSACTION to run another insert . PostgreSQL threw the exception on the second, correctly formed insert because OpenERP tried using a broken transaction to do additional work. Correctly, PostgreSQL does not allow this.

I think it is certain that your file sample.partner.csv contains illegal Comma Separated Value (CSV) formatting that O

marocsys, marocsys · Answer

please try to update your module
that means the fields of python file not the same of the table in database

Guillaume LEBOURG · Answer

Hi i had the same error, and i found it's when you put in a cell an enumration of several id : you must do like this "31, 51" and not "31,51" you need a space after the coma

Gerelateerde posts	Antwoorden	Weergaven
Where to document import structures as a community? v7 importing	2 nov. 16	7539
What does it mean when an import validate ends in pink? validate v7 importing	0 mrt. 15	5399
Company under Company customer v7 company	1 mrt. 15	10806
Export customer data to CSV/XLS in openERP v7? Opgelost export customer v7	4 mrt. 15	31096
Share customized dashboards with other users v7 customer v7 dashboard	0 mrt. 15	5991

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!