Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0009260Openbravo ERP02. Master data managementpublic2009-06-01 13:062011-02-04 09:12
0009260: Error message should be displayed properly while doing Import file loader for Business partner
Error message should be displayed properly while Importing the file for product, business partner, taxes if the data type in the field format has been changed when creating Import Loader format.
    * Login as userA
    * Go to Master Data Management->Import Data->Import Loader Format
    * Click New and fill:
          o Name "Businesspartner"
          o Table "I_BPartner"
          o Format "Comma Separated"
    * Move to Field Format and create new records:

Otherwise use this link [^] to load the field formats for Business partner & Taxes Import.

In the above field formats for Organization field give the data type as String in stead of Constant.

# Login as userA
# Go to Master Data Management->Import Data->Import File Loader
# Select the file I_Businesspartner.txt and the format for the products
# Click OK. This is only to verify that the file is well format
# Select again the file and the format. Click Process

In automation we will check for the title message "Process completed successfully". We will not verify the records inserted into the temporary table.
No tags attached.
jpg BusinessPartnerFileloader.JPG (147,942) 2009-06-01 13:06

txt I_Businesspartner.txt (343) 2009-06-03 09:49
png 1-ImportFileLoader.png (44,593) 2009-06-03 09:49

png 2-ProcessOK.png (32,188) 2009-06-03 09:49

png 3-ImportBPartner.png (43,112) 2009-06-03 09:49

png 4-ImportBPEdition.png (70,922) 2009-06-03 09:49

png 5-ImportBPOK.png (72,373) 2009-06-03 09:50

png 0-ImportLoaderFormat.png (65,141) 2009-06-03 09:58
Issue History
2009-06-01 13:06arunkumarNew Issue
2009-06-01 13:06arunkumarAssigned To => rafaroda
2009-06-01 13:06arunkumarFile Added: BusinessPartnerFileloader.JPG
2009-06-01 14:15rafarodaNote Added: 0016812
2009-06-01 14:15rafarodaStatusnew => feedback
2009-06-02 11:58psarobeNote Added: 0016854
2009-06-02 11:59psarobeStatusfeedback => scheduled
2009-06-02 11:59psarobefix_in_branch => pi
2009-06-03 09:49rafarodaFile Added: I_Businesspartner.txt
2009-06-03 09:49rafarodaFile Added: 1-ImportFileLoader.png
2009-06-03 09:49rafarodaFile Added: 2-ProcessOK.png
2009-06-03 09:49rafarodaFile Added: 3-ImportBPartner.png
2009-06-03 09:49rafarodaFile Added: 4-ImportBPEdition.png
2009-06-03 09:50rafarodaFile Added: 5-ImportBPOK.png
2009-06-03 09:58rafarodaNote Added: 0016906
2009-06-03 09:58rafarodaStatusscheduled => feedback
2009-06-03 09:58rafarodaFile Added: 0-ImportLoaderFormat.png
2009-06-03 10:22arunkumarNote Added: 0016907
2009-06-05 09:35rafarodaNote Added: 0016995
2009-06-05 10:15arunkumarfix_in_branchpi =>
2009-06-05 10:15arunkumarDescription Updated
2009-06-05 10:15arunkumarProposed Solution updated
2009-07-27 11:36psarobeTypedefect => feature request
2009-08-13 14:20rafarodaAssigned Torafaroda => pjuvara
2011-02-04 09:12jpabloaeAssigned Topjuvara => rmorley

2009-06-01 14:15   
Hi Arun,

Are the acceptance test steps correct? Usually, Organization uses to be a constant value defined in the Import Loader Format [^]
2009-06-02 11:58   
The problem comes because instead of saying the route of the problem it gives an strange problem. To reproduce the issue what the developer needs to do is to follow the test case [^] [^] but instead of using constant for ad_org_id you have to use string
2009-06-03 09:58   
Hi Arun and Pablo,

Please review the process that you followed. I did the following:
1) Use I_BussinessPartner.txt file attached (where Organization is a value and not a constant).
2) Create the Import File Format for business partner including in first place the organization as a sting, not as a constant (see 0-ImportLoaderFormat.png)
3) Testing the import of that file clicking OK in Import File Loader (1-ImportFileLoader.png).
4) Process the file importing it into temporary I_Bpartner table (2-ProcessOK.png).
5) See the imported records in grid (3-ImportBpartner.png) and in edition view (4-ImportBPEdition.png).
6) Finally process those records to include them into C_Bpartner table (5-ImportBPOK.png).

Let me know your progress.

2009-06-03 10:22   
Hi Rafa

The process you have given is correct.The same steps I followed in openbravomainpsg context. I have got that issue.
2009-06-05 09:35   

Could you please rewrite the description and steps of this issue in order to clarify that when clicking Process button there should be a check that validates that the number of values to insert matches the number of non-constant columns of the Import Loader Format?