Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0005262Openbravo ERP02. Master data managementpublic2008-09-25 12:312008-12-16 12:20
plujan 
Dowid 
normalminoralways
closedfixed 
5
2.40 
 
Core
No
0005262: On PostgreSQL, if an Import Loader Format is incorrect I have a "ProcessRunError" message when importing
If I create an Import Loader Format assigning two fields to the same column I have not error or warning message. But when using it at Import File Load process, I get a "ProcessRunError" error message.

There are two issues to correct. One is improve the message. It should says something useful to understand what went wrong.
The other is to improve Import Load Format window to control and warn user about entering values that will lead to an error.
# Login as userA
# Go to Master Data Management->Import Data->Import Loader Format
# Click New and fill:

    * Name "Product"
    * Table "I_Product"
    * Format "Comma Separated"
# Move to Field Format and create new records:
Organization ad_org_id (Constant) 0
Search key value (String)
Name name (String)
Uom_id C_Uom_Id (Number) .
Description description (String)
Product type ProductType (Constant) I
Product category value value (String)

Note that "Search key" and "Product category value" are assigned both to "value"

Go to Import File Loader and import i_products.txt
You get an ProcessRunError message.

Additional Data: You can find the original testcases on http://wiki.openbravo.com/wiki/Acceptance_Testing [^] (cases #6 and #7 of Administration Master Data module). Please note that assigning the same "value" is not part of this cases.
No tags attached.
depends on backport 0005293 closed Dowid On PostgreSQL, if an Import Loader Format is incorrect I have a "ProcessRunError" message when importing 
Issue History
2008-09-25 12:31plujanNew Issue
2008-09-25 12:31plujanAssigned To => cromero
2008-09-25 12:31plujansf_bug_id0 => 2128120
2008-09-25 12:31plujanRegression testing => No
2008-09-29 10:11psarobeStatusnew => scheduled
2008-09-29 10:11psarobeAssigned Tocromero => Dowid
2008-09-29 10:11psarobefix_in_branch => trunk
2008-09-29 18:38DowidNote Added: 0009278
2008-09-30 14:44svnbotCheckin
2008-09-30 14:44svnbotNote Added: 0009289
2008-09-30 14:44svnbotStatusscheduled => resolved
2008-09-30 14:44svnbotResolutionopen => fixed
2008-09-30 14:44svnbotsvn_revision => 8090
2008-12-16 12:20psarobeStatusresolved => closed

Notes
(0009278)
Dowid   
2008-09-29 18:38   
I get the same problem in Oracle.
(0009289)
svnbot   
2008-09-30 14:44   
Repository: openbravo
Revision: 8090
Author: dowid
Date: 2008-09-30 14:44:33 +0200 (Tue, 30 Sep 2008)

Fixed bug 0005262: On PostgreSQL, if an Import Loader Format is incorrect I have a "ProcessRunError" message when importing

---
U trunk/src-db/database/model/tables/AD_IMPFORMAT_ROW.xml
U trunk/src-db/database/sourcedata/AD_MESSAGE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=8090&sc=1 [^]