Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0005518Openbravo ERP02. Master data managementpublic2008-10-14 12:322008-12-16 11:07
joan 
Dowid 
normalminorhave not tried
closedfixed 
30Debian Etch
2.40 
 
Core
No
0005518: 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.
depends on backport 0005582 closed Dowid Importing Volume with decimal point 
Issue History
2008-10-14 12:32joanNew Issue
2008-10-14 12:32joanAssigned To => cromero
2008-10-14 12:32joansf_bug_id0 => 2165911
2008-10-14 12:34joanNote Added: 0009552
2008-10-20 10:57psarobeStatusnew => scheduled
2008-10-20 10:57psarobeAssigned Tocromero => Dowid
2008-10-20 10:57psarobefix_in_branch => trunk
2008-10-23 15:27svnbotCheckin
2008-10-23 15:27svnbotNote Added: 0009711
2008-10-23 15:27svnbotsvn_revision => 9098
2008-10-24 10:59svnbotCheckin
2008-10-24 10:59svnbotNote Added: 0009735
2008-10-24 10:59svnbotStatusscheduled => resolved
2008-10-24 10:59svnbotResolutionopen => fixed
2008-10-24 10:59svnbotsvn_revision9098 => 9150
2008-12-16 11:07psarobeRegression testing => No
2008-12-16 11:07psarobeStatusresolved => closed

Notes
(0009552)
joan   
2008-10-14 12:34   
Uhm , I think i forgot the next steps.
Press the import product buttons
Check the product and see it has volume to 0
(0009711)
svnbot   
2008-10-23 15:27   
Repository: openbravo
Revision: 9098
Author: dowid
Date: 2008-10-23 15:27:42 +0200 (Thu, 23 Oct 2008)

Issue 0005518: Importing Volume with decimal point
Problem 1

---
U trunk/src/org/openbravo/erpCommon/ad_process/ImportProduct_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=9098&sc=1 [^]
(0009735)
svnbot   
2008-10-24 10:59   
Repository: openbravo
Revision: 9150
Author: dowid
Date: 2008-10-24 10:58:47 +0200 (Fri, 24 Oct 2008)

Fixed bug 0005518: Importing Volume with decimal point
Fixed problem 2

---
U trunk/src-db/database/sourcedata/AD_COLUMN.xml
---

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