Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0005582Openbravo ERP02. Master data managementpublic2008-10-20 10:572009-03-03 17:16
joan 
Dowid 
normalminorhave not tried
closedfixed 
30Debian Etch
2.40 
 
Core
No
0005582: Importing Volume with decimal point
I found 2 Problems importing data.

1)When you try to import a product with a volume, it inserts correctly the value you has imported(unless you set it with decimal point) to the intermediate table i_product, but when you press the import products field it doesn't insert in the target table the volume correctly, it inserts 0.

2) When you try to import a product with a volume set with numeric value and this value has decimal point, it ignores the decimal point, also the field of the product doesn't allow to modify the value to set as a decimal. Of course when you save the value in the intermediate table as 1.3 it only inserts the 1. I tested also with weight and all the others warehouse variables of the i_product and it has the same problem.
Create a new import type of products i_product
Create a field with volume
Create the mandatory fields
Create a file with volume with decimal point values, and the mandatory fields completed
Import the file.
Go to import products window
See Volume field(it must be without the decimal point values)
Try to change insert a decimal point (it shows the message that it is a non right format)
Save it(it deletes the decimal point values)
Test in the Weight and others fields
No tags attached.
blocks defect 0005518 closed Dowid Importing Volume with decimal point 
Issue History
2008-10-20 10:57psarobeNew Issue
2008-10-20 10:57psarobeAssigned To => Dowid
2008-10-20 10:57psarobeStatusnew => scheduled
2008-10-23 15:47svnbotCheckin
2008-10-23 15:47svnbotNote Added: 0009712
2008-10-23 15:47svnbotsvn_revision => 9100
2008-10-24 08:34svnbotCheckin
2008-10-24 08:34svnbotNote Added: 0009725
2008-10-24 08:34svnbotsvn_revision9100 => 9127
2008-10-24 12:03svnbotCheckin
2008-10-24 12:03svnbotNote Added: 0009736
2008-10-24 12:03svnbotStatusscheduled => resolved
2008-10-24 12:03svnbotResolutionopen => fixed
2008-10-24 12:03svnbotsvn_revision9127 => 9162
2008-10-24 17:42svnbotCheckin
2008-10-24 17:42svnbotNote Added: 0009743
2008-10-24 17:42svnbotsvn_revision9162 => 9191
2009-03-03 17:16psarobeStatusresolved => closed

Notes
(0009712)
svnbot   
2008-10-23 15:47   
Repository: openbravo
Revision: 9100
Author: dowid
Date: 2008-10-23 15:47:57 +0200 (Thu, 23 Oct 2008)

Issue 0005582: Importing Volume with decimal point
Fix Problem 1

---
U branches/r2.40/src/org/openbravo/erpCommon/ad_process/ImportProduct_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=9100&sc=1 [^]
(0009725)
svnbot   
2008-10-24 08:34   
Repository: openbravo
Revision: 9127
Author: villind
Date: 2008-10-24 08:34:56 +0200 (Fri, 24 Oct 2008)

Merged change 9100. Issue 0005582: Importing Volume with decimal point
Fix Problem 1

---
_U branches/bonware/r2.40/
_U branches/bonware/r2.40/config/setup-tool/
_U branches/bonware/r2.40/eclipse.install.source.launch
_U branches/bonware/r2.40/export.database.launch
U branches/bonware/r2.40/src/org/openbravo/erpCommon/ad_process/ImportProduct_data.xsql
_U branches/bonware/r2.40/src-core/src/org/openbravo/database/OpenbravoDriverManagerConnectionFactory.java
_U branches/bonware/r2.40/update.database.launch
---

https://dev.openbravo.com/websvn/openbravo/?rev=9127&sc=1 [^]
(0009736)
svnbot   
2008-10-24 12:03   
Repository: openbravo
Revision: 9162
Author: dowid
Date: 2008-10-24 12:02:59 +0200 (Fri, 24 Oct 2008)

Bug Fixed 0005582: Importing Volume with decimal point
Problem 2

---
U branches/r2.40/src-db/database/sourcedata/AD_COLUMN.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=9162&sc=1 [^]
(0009743)
svnbot   
2008-10-24 17:42   
Repository: openbravo
Revision: 9191
Author: villind
Date: 2008-10-24 17:42:25 +0200 (Fri, 24 Oct 2008)

Merged change 9162. Bug Fixed 0005582: Importing Volume with decimal point
Problem 2

---
_U branches/bonware/r2.40/
_U branches/bonware/r2.40/config/setup-tool/
_U branches/bonware/r2.40/eclipse.install.source.launch
_U branches/bonware/r2.40/export.database.launch
_U branches/bonware/r2.40/src-core/src/org/openbravo/database/OpenbravoDriverManagerConnectionFactory.java
U branches/bonware/r2.40/src-db/database/sourcedata/AD_COLUMN.xml
_U branches/bonware/r2.40/update.database.launch
---

https://dev.openbravo.com/websvn/openbravo/?rev=9191&sc=1 [^]