Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039963Retail ModulesCopy Retail Storepublic2019-01-16 13:372019-02-11 11:54
Reporterjavietxe 
Assigned Torqueralta 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR19Q2 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerGold
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039963: SERQA 5043: Copy stores from excel still is very sensitive to blank characters in some fields
DescriptionNot all cases have been solved in the solution of the issue https://issues.openbravo.com/view.php?id=39701. [^]

For example, if the roles in the tab user-roles have a blank character after the name, the excel file gives an error.
Steps To ReproduceCreate a file for doing a copy stores with spaces after the name of the roles in the tab "User Roles" (or if you want take the excel file attached)

Do a copy stores with the excel file created in the previous step.

See that the role is not found because of the white character.
Proposed SolutionDo the trim in the API when reading the Excel cell in copy stores.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0039701 closed rqueralta SERQA 4931 The Copy stores with Excel file is sensitive to white characters after and before the value. 
Attached Filesxlsx FileCopyStoreWithNewTab888.xlsx (18,368) 2019-01-16 13:37
https://issues.openbravo.com/file_download.php?file_id=12511&type=bug
Issue History
Date ModifiedUsernameFieldChange
2019-01-16 13:37javietxeNew Issue
2019-01-16 13:37javietxeAssigned To => Retail
2019-01-16 13:37javietxeFile Added: FileCopyStoreWithNewTab888.xlsx
2019-01-16 13:37javietxeOBNetwork customer => Gold
2019-01-16 13:37javietxeTriggers an Emergency Pack => No
2019-01-16 13:38javietxeRelationship addedrelated to 0039701
2019-01-16 14:46guillermogilResolution time => 1549407600
2019-01-16 23:43rqueraltaAssigned ToRetail => rqueralta
2019-01-16 23:44rqueraltaStatusnew => scheduled
2019-01-19 18:31hgbotCheckin
2019-01-19 18:31hgbotNote Added: 0109023
2019-01-19 18:31hgbotStatusscheduled => resolved
2019-01-19 18:31hgbotResolutionopen => fixed
2019-01-19 18:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.copystore.excel/rev/0ceaf0f32238b27830a3925089e86adcf50bcde0 [^]
2019-02-11 11:54marvintmReview Assigned To => marvintm
2019-02-11 11:54marvintmStatusresolved => closed
2019-02-11 11:54marvintmFixed in Version => RR19Q2

Notes
(0109023)
hgbot   
2019-01-19 18:31   
Repository: erp/pmods/org.openbravo.retail.copystore.excel
Changeset: 0ceaf0f32238b27830a3925089e86adcf50bcde0
Author: Rafael Queralta <rafaelcuba81 <at> gmail.com>
Date: Sat Jan 19 12:30:17 2019 -0500
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.copystore.excel/rev/0ceaf0f32238b27830a3925089e86adcf50bcde0 [^]

Fixed issue 39963: SERQA 5043: Copy stores from excel still is very sensitive
to blank characters in some fields

- Removed blank characters of cell value.

---
M src/org/openbravo/retail/copystore/excel/ExcelCopyStoreField.java
---