Hi,

I am trying to import products but while importing I am getting an error:

ProgrammingError: current transaction is aborted, commands ignored until end of transaction block

Any solution for this??


Thanks.

Hi all,

ProgrammingError: current transaction is aborted, commands ignored until end of transaction block

why this error comes and what could be the solution?

Thanks.

I have the same problem and I coud not even know what is the source of it... or even how could I re-produce the problem..

Any idea?

setting u're format data, you make the following data format requirements of the open-ERP data. skewer the requested field when the import process.

i hope it will help u

regards

Hello love, Do you mean this exception: ProgrammingError: current transaction is aborted, commands ignored until end of transaction block
?
How could I re-produce the problem?

for getting the format for importing data, you can export the data that u want to export, then look the format fields name in import data then skewer the field names (in data export) to field name in data import.
because some field have relation on the other fields. so you have fill the field that have teh relations.

i hope it will help.

Hi

For products, the fields you need to import are...

default_code;"ean13";"name";"variants";"categ_id";"procure_method";"cost_method";"supply_method";"standard_price";"list_price";"purchase_ok";"sale_ok";"type";"taxes_id";"supplier_taxes_id";"uom_po_id";"uom_id";"loc_rack";"loc_row";"loc_case"
12345;"0042723140649";"My Product Name";;"My Category";"make_to_stock";"standard";"buy";0;9000;"True";"True";"product";"I.V.I.";"I.V.I.";"MyUnit";"MyUnit";"1";"0";"1"

You need to first define:
* the unit you are using for your product ("MyUnit" in this sample)
* the different categories ("My Category" here)
* the taxes that apply for these products (called "I.V.I" on this sample)

Regards,
Mario

Am getting this error while trying to import products which is on another db.


Error Message:
Line 1 : Database ID doesn't exist: product.product : 1

Hi Coolmanlg

Don't import the database id field.

Check a couple posts up for a guideline on fields to import...

Regards,
-Mario