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

Post Terkait	Replies	Tampilan
Where to document import structures as a community? v7 importing	2 Nov 16	7541
What does it mean when an import validate ends in pink? validate v7 importing	0 Mar 15	5401
Company under Company customer v7 company	1 Mar 15	10806
Export customer data to CSV/XLS in openERP v7? Diselesaikan export customer v7	4 Mar 15	31097
Share customized dashboards with other users v7 customer v7 dashboard	0 Mar 15	5991

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!