Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005661Openbravo ERP02. Master data managementpublic2008-10-27 09:542009-03-03 17:16
ReporterDowid 
Assigned ToDowid 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed 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
Summary0005661: Import Order process problem
Description1. When importing orders with "mixed" order lines in the *.csv file, incorrect orders are created.

2. When importing the same *.csv file twice the process creates orders with the same Order dates and Document No
Steps To Reproduce1) Import order following the steps in [1]

For the CSV, TXT file use the following data format:

BB7747FFQQ,POS Order,bellphone,beer,500,10.6,100
BB7747FFQQ1,POS Order,Millman,beer,500,10.6,100
BB7747FFQQ1,POS Order,Millman,beer,500,10.6,100
AA875875875RRTT,Standard Order,Millman,beer,100,10.5,102
AA875875875RRTT,Standard Order,Millman,shirts,400,13.4,102
BB7747FFQQ1,POS Order,Millman,beer,100,10.6,100
BB7747FFQQ1,POS Order,Millman,beer,200,10.6,100
AA875875875RRTT,Standard Order,Millman,beer,100,10.5,102
AA875875875RRTT,Standard Order,Millman,beer,100,10.5,102
BB7747FFQQ,POS Order,Millman,beer,500,10.6,100

2) Import this file twice.

3) Go to the orders imported in 'Sales Management || Transactions || Sales Order'.

Please notice that the orders have been inserted incorrectly.



[1] http://wiki.openbravo.com/wiki/QA_test_plan_2.50/Test_cases [^] [^]
Proposed SolutionReview the import process and sort by DocumentNo and DateOrdererd before importing from the temporary table, also review the logic that checks for existing orders.
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0005633 closed Dowid Import Order process problem 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-10-27 09:54psarobeNew Issue
2008-10-27 09:54psarobeAssigned To => Dowid
2008-10-27 09:54psarobeStatusnew => scheduled
2008-11-26 10:52svnbotCheckin
2008-11-26 10:52svnbotNote Added: 0010692
2008-11-26 10:52svnbotStatusscheduled => resolved
2008-11-26 10:52svnbotResolutionopen => fixed
2008-11-26 10:52svnbotsvn_revision => 10594
2008-11-26 18:33svnbotCheckin
2008-11-26 18:33svnbotNote Added: 0010742
2008-11-26 18:33svnbotsvn_revision10594 => 10639
2009-03-03 17:16psarobeStatusresolved => closed

Notes
(0010692)
svnbot   
2008-11-26 10:52   
Repository: openbravo
Revision: 10594
Author: dowid
Date: 2008-11-26 10:52:37 +0100 (Wed, 26 Nov 2008)

Bug fixed 0005661: Import Order process problem

---
U branches/r2.40/src/org/openbravo/erpCommon/ad_process/ImportOrder.java
U branches/r2.40/src/org/openbravo/erpCommon/ad_process/ImportOrder_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=10594&sc=1 [^]
(0010742)
svnbot   
2008-11-26 18:33   
Repository: openbravo
Revision: 10639
Author: villind
Date: 2008-11-26 18:33:25 +0100 (Wed, 26 Nov 2008)

Merged r10594. Bug fixed 0005661: Import Order process problem

---
_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/ImportOrder.java
U branches/bonware/r2.40/src/org/openbravo/erpCommon/ad_process/ImportOrder_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=10639&sc=1 [^]