Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005582
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 02. Master data managementminorhave not tried2008-10-20 10:572009-03-03 17:16
ReporterjoanView Statuspublic 
Assigned ToDowid 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branch2.40Fixed in SCM revision9191
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version1.5.0_14
OS VersionDebian EtchDatabase version8.1Ant version1.6.5
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005582: Importing Volume with decimal point

DescriptionI 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.
Steps To ReproduceCreate 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0005518 closedDowid Importing Volume with decimal point 

-  Notes
(0009712)
svnbot (reporter)
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 (reporter)
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 (reporter)
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 (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2008-10-20 10:57 psarobe New Issue
2008-10-20 10:57 psarobe Assigned To => Dowid
2008-10-20 10:57 psarobe Status new => scheduled
2008-10-23 15:47 svnbot Checkin
2008-10-23 15:47 svnbot Note Added: 0009712
2008-10-23 15:47 svnbot svn_revision => 9100
2008-10-24 08:34 svnbot Checkin
2008-10-24 08:34 svnbot Note Added: 0009725
2008-10-24 08:34 svnbot svn_revision 9100 => 9127
2008-10-24 12:03 svnbot Checkin
2008-10-24 12:03 svnbot Note Added: 0009736
2008-10-24 12:03 svnbot Status scheduled => resolved
2008-10-24 12:03 svnbot Resolution open => fixed
2008-10-24 12:03 svnbot svn_revision 9127 => 9162
2008-10-24 17:42 svnbot Checkin
2008-10-24 17:42 svnbot Note Added: 0009743
2008-10-24 17:42 svnbot svn_revision 9162 => 9191
2009-03-03 17:16 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker