Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0018727Openbravo ERP09. Financial managementpublic2011-10-07 11:392012-05-10 12:12
shuehner 
mirurita 
normalminorhave not tried
newopen 
5
 
 
Core
No
0018727: Validation Error when importing an accounting csv file does not mention which line/account failed in UI
When trying to import a accounting csv file in which (at least) one line fails a validation something like the following error is shown in the UI:

Property FinancialMgmtElementValue.elementLevel, value () is not allowed, it should be one of the following values: [D, E, S, C] but it is value

which gives the user no indication which of the many lines in the csv file is wrong.

The technical exception in the openbravo.log file does contain also:
ERROR org.openbravo.erpCommon.businessUtility.COAUtility - insertElementValuesInDB() - Not inserted account with value: 0038

which gives that indication about the line for account '0038' failed.
Take existing accounting file.
Edit one line to have a non-allowed value in a column (Example 'Test' in column 'elementLevel'
Try to import the file.
Add the account number of the failing line to the error message shown to the user.
VMA-Reviewed
Issue History
2011-10-07 11:39shuehnerNew Issue
2011-10-07 11:39shuehnerAssigned To => jonalegriaesarte
2011-10-07 11:39shuehnerModules => Core
2012-02-15 19:04iciordiaAssigned Tojonalegriaesarte => vmromanos
2012-02-16 16:49vmromanosTag Attached: VMA-Reviewed
2012-03-12 16:24vmromanosTypedefect => feature request
2012-05-10 12:12gorka_gilAssigned Tovmromanos => mirurita

There are no notes attached to this issue.