Importing orders fails but error can be found in log only, header of order is kept and hinders newly import.

Description

when trying to import a purchase order I forgot to create the entries in the pricelist before starting. Thus the header was created but now lines where added. The result window showed the number of errors but the lines didn't have a message. Trying again after creating the pricelist again failed, because the header was created and committed. I then could delete the header, but it is even worse, if only some of the lines couldn't be added.

I'll going to created a patch to show the errormessages.

I think it should be possible to run the import again then, without deleting the header. Either by not committing the header (and eventually lines which didn't fail) or by allowing to add lines to an order which is not completed. Even better might be, to import an order completely or not and marking at least the first failing line with an error message.

Environment

None

Activity

Show:
Carlos Ruiz
June 23, 2020, 10:07 AM

Mostly that's the reason why we did the CSV Importer, because the old importers are very bad in transaction management, so I strongly recommend to move to use the new importers which is more capable, transaction wise per document, can prepare/complete documents if needed, and more.

Martin Schönbeck
June 27, 2020, 10:04 PM
Edited

Of course CSV Importer has several advantages. But when you get CSV files e.g. with price lists you’ll have to work on them to be able import them while using the importer you can integrate the conversion within iDempiere. Additionally directly inserting into an i_xxx table is far less problematically than inserting in any other table.

Assignee

Unassigned

Reporter

Martin Schönbeck

Labels

None

Tested By

None

Components

Affects versions

Priority

Minor
Configure