Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012347Openbravo ERP02. Master data managementpublic2010-02-18 18:182011-10-29 16:09
Reporteradrianromero 
Assigned Tojonalegriaesarte 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version2.50MP9 
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
Summary0012347: If you try to import a product with multiple venders you get an error
DescriptionIf you try to import a product with multiple venders you get an error.
The csv is defined with the same product in different rows but with different vendors for each row in order to include more than one supplier for product,
wich can be done manually.

The i_product table is loaded via the csv file (attached), however when running the Import Products process the following
error is issued for any duplicate value. ERR=Value not unique
Not even the first row is imported so no m_product is created. If there is only one vendor or no vendor the record
processes correctly.

The issue here is that you are not allowed to have the duplicate i_product.value defined in your import file.

If you look at the Business Partner process this allows for multiple i_bpartner.value for each location and contact associated with the them.
You have to press the import business partner button twice. First to create the Business Partner and the second time created additional location or location/contact combination for the same Business Partner 'value'.

The Import Product process should work the same way. The first run should create the one m_product and one m_product_po if you have entered the vendor data. Then on the second run additional m_product_po should be created for the same m_product.
Steps To Reproduce-Try to import the attached csv with product on the Import File Loader process.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00119882.50MP11 closed adrianromero Openbravo ERP If you try to import a product with multiple venders you get an error 
related to feature request 0012087 new jonalegriaesarte Modules IDL to support import of product vendors 
Attached Files? Issue_11988_PI_PATCH (7,497) 2010-03-10 10:55
https://issues.openbravo.com/file_download.php?file_id=2328&type=bug
Issue History
Date ModifiedUsernameFieldChange
2010-02-18 18:18adrianromeroNew Issue
2010-02-18 18:18adrianromeroAssigned To => adrianromero
2010-02-18 18:18adrianromeroIssue generated from0011988
2010-02-18 18:18adrianromeroRelationship addedrelated to 0011988
2010-03-10 10:55rafarodaNote Added: 0025204
2010-03-10 10:55rafarodaIssue Monitored: rafaroda
2010-03-10 10:55rafarodaFile Added: Issue_11988_PI_PATCH
2010-03-10 10:55rafarodaNote Added: 0025205
2010-03-10 12:20rafarodaRelationship addedrelated to 0012087
2011-06-03 11:00dalsasuaAssigned Toadrianromero => dalsasua
2011-07-20 18:11dalsasuaAssigned Todalsasua => jonalegriaesarte
2011-10-29 16:09psarobeNote Added: 0042318
2011-10-29 16:09psarobeStatusnew => closed
2011-10-29 16:09psarobeResolutionopen => no change required

Notes
(0025204)
rafaroda   
2010-03-10 10:55   
Steps that describe the current behaviour:

* Create a product to import in Master Data Management || Import Data || Import Products:
** Search Key = npa
** Name = New Product A
** Business Partner = McGiver Supplies (select a vendor/provider)
* Click on Import Products button: product is imported successfully.
* Navigate to Product tab in Master Data Management || Product
* Look for New Product A
* Navigate to Purchasing tab: record has been created for McGiver Supplies (one could also expect that this record appears in Business Partner field of Product tab, not in Purchasing window).
* Taking into account the current behavior, create a second product to import in Master Data Management || Import Data || Import Products:
** Search Key = npb
** Name = New Product B
** Business Partner = McGiver Supplies (select a vendor/provider)
* Create a second record for the same product but select a different business partner:
** Search Key = npb
** Name = New Product B
** Business Partner = Turtle Logistics (select a vendor/provider)
* Click on Import Products button: error message displays: "No products could be imported. Products not imported: 2; Product inserted: 0; Product updated: 0; ProductPO inserted: 0; ProductPO updated: 0" and in Import Error Message ="ERR=Value not unique,"

You were expecting that because you created two records with the same product search key and name but different business partner, a single record would be created in the Product window (New Product B) with two records in the Purchasing tab (McGiver Supplies and Turtle Logistics).
(0025205)
rafaroda   
2010-03-10 10:55   
A diff that solves the problem to the partner is attached here, and a new clone of this issue has been created to track the issue.
(0042318)
psarobe   
2011-10-29 16:09   
This is the intended behaviour. In any case in 3.0 this has been discontinued from core and it has been created a new module that contains everything related to import cvs as it was in 2.50