Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011988Openbravo ERP02. Master data managementpublic2010-01-18 11:272010-03-10 18:28
Reporternetworkb 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version2.50MP9 
Target Version2.50MP11Fixed 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
Summary0011988: 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 feature request 0012087 new jonalegriaesarte Modules IDL to support import of product vendors 
related to defect 0012347 closed jonalegriaesarte Openbravo ERP If you try to import a product with multiple venders you get an error 
Attached Filescsv i_test1.csv (5,285) 2010-01-18 11:27
https://issues.openbravo.com/file_download.php?file_id=2142&type=bug
? Issue_11988_PI_PATCH (7,497) 2010-02-18 18:21
https://issues.openbravo.com/file_download.php?file_id=2242&type=bug
Issue History
Date ModifiedUsernameFieldChange
2010-01-18 11:27networkbNew Issue
2010-01-18 11:27networkbAssigned To => rafaroda
2010-01-18 11:27networkbFile Added: i_test1.csv
2010-01-21 12:16rafarodaNote Added: 0023705
2010-01-21 12:16rafarodaPriorityimmediate => urgent
2010-01-21 12:16rafarodaStatusnew => scheduled
2010-01-28 14:46rafarodaNote Added: 0023849
2010-01-28 14:53rafarodaIssue cloned0012087
2010-01-28 14:53rafarodaRelationship addedrelated to 0012087
2010-01-28 14:58rafarodaNote Edited: 0023849
2010-02-16 17:15rafarodaAssigned Torafaroda => adrianromero
2010-02-18 18:18adrianromeroIssue cloned0012347
2010-02-18 18:18adrianromeroRelationship addedrelated to 0012347
2010-02-18 18:21adrianromeroFile Added: Issue_11988_PI_PATCH
2010-02-18 18:23adrianromeroNote Added: 0024612
2010-02-18 18:23adrianromeroStatusscheduled => closed
2010-02-18 18:23adrianromeroResolutionopen => no change required
2010-02-19 00:01anonymoussf_bug_id0 =>
2010-03-10 18:28anonymoussf_bug_id => 2967982

Notes
(0023705)
rafaroda   
2010-01-21 12:16   
This feature is probably not implemented. It will take some time to implement if completely.

In the meanwhile you can consider using Initial Data Load module http://www.openbravo.com/product/exchange/modules/initial-data-load/ [^]
(0023849)
rafaroda   
2010-01-28 14:46   
(edited on: 2010-01-28 14:58)
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).
(0024612)
adrianromero   
2010-02-18 18:23   
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.