Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002248Openbravo ERP02. Master data managementpublic2007-11-09 14:152008-06-19 10:44
Reporteruser71 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40alpha-r3 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0002248: Product Import fails because of wrong field size
DescriptionOpenbravo Version 2.35
Oracle

Product-CSV-File with no VendorProductNo.


Action:
Importing products with the import mask (Master Data Management/Import Data/Import Products). Note: No VendorProductNo is given in the cvs file and so, no Number is mapped.

Problem:

After pressing "Import Products", I_Product.Value (SearchKey) is copied automatically into I_Product.VendorProductNo if no value is given for I_Import.VendorProductNo.

The size of I_Product.VendorProductNo and M_Product_PO.VendorProductNo is 30.

The size of I_Import.Value is 40.

The entire import fails (with no error message on the screen) if the value in I_Product.Value is longer than 30.


Kind regards
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-06-19 10:44plujanStatusresolved => closed

Notes
(0005837)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1828957 [^]
(0002626)
alostale   
2008-02-05 11:37   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1500722
Originator: NO

What do you mean by I_import?
(0002627)
user71   
2008-02-05 13:24   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1908265
Originator: YES

Sorry, I misstyped I_Product, whenever you see I_Import, read I_Product instead.
(0002628)
marvintm   
2008-05-21 11:34   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1952914
Originator: NO

We have tested this bug in the subversion repository and it has just been fixed.

Note that the only supported version of the application is the one in subversion. So it is possible that this was a bug in a previous version that is already fixed.
(0002629)
marvintm   
2008-05-21 11:34   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1952914
Originator: NO

Increased the size of M_PRODUCT_PO.VENDORPRODUCTNO and I_PRODUCT.VENDORPRODUCTNO from 30 to 40, which is the size of I_IMPORT.VALUE.
(0002630)
psarobe   
2008-05-29 17:22   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1500703
Originator: NO

It only has been changed in the database but not in the application dictionary
(0002631)
marvintm   
2008-05-30 09:55   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1952914
Originator: NO

We have tested this bug in the subversion repository and it has just been fixed.

Note that the only supported version of the application is the one in subversion. So it is possible that this was a bug in a previous version that is already fixed.
(0002632)
marvintm   
2008-05-30 09:55   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1952914
Originator: NO

Column sizes changed in the application dictionary.