Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 02. Master data managementminoralways2009-06-01 13:062011-02-04 09:12
ReporterarunkumarView Statuspublic 
Assigned Tormorley 
PrioritynormalResolutionopenFixed in Version
StatusfeedbackFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionmainSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0009260: 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 [^] 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.
TagsNo tags attached.
Attached Filesjpg file icon BusinessPartnerFileloader.JPG [^] (147,942 bytes) 2009-06-01 13:06

txt file icon I_Businesspartner.txt [^] (343 bytes) 2009-06-03 09:49 [Show Content]
png file icon 1-ImportFileLoader.png [^] (44,593 bytes) 2009-06-03 09:49

png file icon 2-ProcessOK.png [^] (32,188 bytes) 2009-06-03 09:49

png file icon 3-ImportBPartner.png [^] (43,112 bytes) 2009-06-03 09:49

png file icon 4-ImportBPEdition.png [^] (70,922 bytes) 2009-06-03 09:49

png file icon 5-ImportBPOK.png [^] (72,373 bytes) 2009-06-03 09:50

png file icon 0-ImportLoaderFormat.png [^] (65,141 bytes) 2009-06-03 09:58

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
rafaroda (developer)
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 [^]
psarobe (manager)
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
rafaroda (developer)
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.

arunkumar (reporter)
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.
rafaroda (developer)
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?


- Issue History
Date Modified Username Field Change
2009-06-01 13:06 arunkumar New Issue
2009-06-01 13:06 arunkumar Assigned To => rafaroda
2009-06-01 13:06 arunkumar File Added: BusinessPartnerFileloader.JPG
2009-06-01 14:15 rafaroda Note Added: 0016812
2009-06-01 14:15 rafaroda Status new => feedback
2009-06-02 11:58 psarobe Note Added: 0016854
2009-06-02 11:59 psarobe Status feedback => scheduled
2009-06-02 11:59 psarobe fix_in_branch => pi
2009-06-03 09:49 rafaroda File Added: I_Businesspartner.txt
2009-06-03 09:49 rafaroda File Added: 1-ImportFileLoader.png
2009-06-03 09:49 rafaroda File Added: 2-ProcessOK.png
2009-06-03 09:49 rafaroda File Added: 3-ImportBPartner.png
2009-06-03 09:49 rafaroda File Added: 4-ImportBPEdition.png
2009-06-03 09:50 rafaroda File Added: 5-ImportBPOK.png
2009-06-03 09:58 rafaroda Note Added: 0016906
2009-06-03 09:58 rafaroda Status scheduled => feedback
2009-06-03 09:58 rafaroda File Added: 0-ImportLoaderFormat.png
2009-06-03 10:22 arunkumar Note Added: 0016907
2009-06-05 09:35 rafaroda Note Added: 0016995
2009-06-05 10:15 arunkumar fix_in_branch pi =>
2009-06-05 10:15 arunkumar Description Updated
2009-06-05 10:15 arunkumar Proposed Solution updated
2009-07-27 11:36 psarobe Type defect => feature request
2009-08-13 14:20 rafaroda Assigned To rafaroda => pjuvara
2011-02-04 09:12 jpabloae Assigned To pjuvara => rmorley

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker