Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009260Openbravo ERP02. Master data managementpublic2009-06-01 13:062011-02-04 09:12
Reporterarunkumar 
Assigned Tormorley 
PrioritynormalSeverityminorReproducibilityalways
StatusfeedbackResolutionopen 
PlatformOS5OS Version
Product Versionmain 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009260: Error message should be displayed properly while doing Import file loader for Business partner
DescriptionError 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.
Steps To Reproduce    * 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 http://wiki.openbravo.com/wiki/Acceptance_Testing/Format_loader_script [^] 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesjpg BusinessPartnerFileloader.JPG (147,942) 2009-06-01 13:06
https://issues.openbravo.com/file_download.php?file_id=1363&type=bug
jpg

txt I_Businesspartner.txt (343) 2009-06-03 09:49
https://issues.openbravo.com/file_download.php?file_id=1373&type=bug
png 1-ImportFileLoader.png (44,593) 2009-06-03 09:49
https://issues.openbravo.com/file_download.php?file_id=1374&type=bug
png

png 2-ProcessOK.png (32,188) 2009-06-03 09:49
https://issues.openbravo.com/file_download.php?file_id=1375&type=bug
png

png 3-ImportBPartner.png (43,112) 2009-06-03 09:49
https://issues.openbravo.com/file_download.php?file_id=1376&type=bug
png

png 4-ImportBPEdition.png (70,922) 2009-06-03 09:49
https://issues.openbravo.com/file_download.php?file_id=1377&type=bug
png

png 5-ImportBPOK.png (72,373) 2009-06-03 09:50
https://issues.openbravo.com/file_download.php?file_id=1378&type=bug
png

png 0-ImportLoaderFormat.png (65,141) 2009-06-03 09:58
https://issues.openbravo.com/file_download.php?file_id=1379&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
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

Notes
(0016812)
rafaroda   
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 http://wiki.openbravo.com/wiki/Acceptance_Testing#Administration_master_data [^]
(0016854)
psarobe   
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 http://wiki.openbravo.com/wiki/Acceptance_Testing#Administration_master_data [^] [^] but instead of using constant for ad_org_id you have to use string
(0016906)
rafaroda   
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.

Thanks.
(0016907)
arunkumar   
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.
(0016995)
rafaroda   
2009-06-05 09:35   
Arun,

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?

Thanks.