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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0041450
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Advanced Warehouse Operationsminoralways2019-07-24 17:522019-09-16 17:47
ReporterngarciaView Statuspublic 
Assigned Tocollazoandy4 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionbfa0c09772b2
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned ToSandrahuguet
Regression introduced in release
Summary

0041450: AWO EDL Template for StorageBinGroupListLine should include "SeqNo" column instead of "Seq No" column

DescriptionAWO EDL Template for StorageBinGroupListLine should include "SeqNo" column instead of "Seq No" column:

https://docs.google.com/spreadsheets/d/1YqEI9jBH05nvTD9P0Rz9TUtHLBrExXBTId37OEXkKOQ [^]
Steps To ReproduceAs system admin role:
   Install Advanced Warehouse Operations External Data Load module

As group admin role:
   Apply the module's dataset from Enterprise module management window
   Create at least the following CSV files from the template:
      Warehouse.csv
      InternalRoutingArea.csv
      StorageBinGroup.csv
      StorageBinGroupList.csv
      StorageBinGroupListLine.csv

    Open the last file and check it includes a column with "Seq No" name

    Copy all the files in /tmp/awo/ folder (defined in EDL for AWO Configuration)
    Reschedule the 'External Data Load for AWO' background process
    Check in EDL Request window that the 'StorageBinGroupListLine-OBAWO_Locator_Gr' record finished with Error:
      Error while importing an item: Value of property SeqNo is null but it does not accept null values

   Edit Line Data field in Request Line tab, change "Seq No" with "SeqNo"
   Process and check it is imported correctly
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0113627)
ngarcia (developer)
2019-07-24 18:12

 The column name is also wrong in templateForImport/AWO EDL Template.xlsx file
(0113884)
collazoandy4 (reporter)
2019-08-07 15:15

 Test Plan
  As system admin role:
    Install Advanced Warehouse Operations External Data Load module

v As group admin role:
    Apply the module's dataset from Enterprise module management window
    Create at least the following CSV files from the template:
      Warehouse.csv
      InternalRoutingArea.csv
      StorageBinGroup.csv
      StorageBinGroupList.csv
      StorageBinGroupListLine.csv
      Copy all the files in /tmp/awo/ folder (defined in EDL for AWO Configuration)
      Reschedule the 'External Data Load for AWO' background process
      Process and check in EDL Request window it is imported correctly
(0114588)
hgbot (developer)
2019-09-16 17:46

 Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations.edl
Changeset: bfa0c09772b2aacb64b8c5c7ebce8b52f2befa23
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Wed Aug 07 09:10:36 2019 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations.edl/rev/bfa0c09772b2aacb64b8c5c7ebce8b52f2befa23 [^]

Fixes issue 41450: AWO EDL Template for StorageBinGroupListLine should include
"SeqNo" column instead of "Seq No" column

A csv for StorageBinGroupListLine created from the template can be imported from the
process because it's contains a Seq No column, but this column is mapped as SeqNo

The column name in the template was updated to the mapping value 'SeqNo'

---
M templateForImport/AWO EDL Template.xlsx
---
(0114589)
Sandrahuguet (developer)
2019-09-16 17:47

 code review + testing ok

- Issue History
Date Modified Username Field Change
2019-07-24 17:52 ngarcia New Issue
2019-07-24 17:52 ngarcia Assigned To => Triage Finance
2019-07-24 17:52 ngarcia Issue Monitored: ngarcia
2019-07-24 17:52 ngarcia Issue End Monitor: ngarcia
2019-07-24 17:52 ngarcia Issue Monitored: networkb
2019-07-24 18:12 ngarcia Note Added: 0113627
2019-07-25 11:26 martinsdan Issue Monitored: martinsdan
2019-08-06 15:00 Sandrahuguet Assigned To Triage Finance => collazoandy4
2019-08-07 15:15 collazoandy4 Note Added: 0113884
2019-08-07 15:15 collazoandy4 Status new => scheduled
2019-09-16 17:46 hgbot Checkin
2019-09-16 17:46 hgbot Note Added: 0114588
2019-09-16 17:46 hgbot Status scheduled => resolved
2019-09-16 17:46 hgbot Resolution open => fixed
2019-09-16 17:46 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations.edl/rev/bfa0c09772b2aacb64b8c5c7ebce8b52f2befa23 [^]
2019-09-16 17:47 Sandrahuguet Review Assigned To => Sandrahuguet
2019-09-16 17:47 Sandrahuguet Note Added: 0114589
2019-09-16 17:47 Sandrahuguet Status resolved => closed
2022-09-06 17:18 caristu Category Advance Warehouse Operations => Advanced Warehouse Operations

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker