Openbravo Issue Tracking System - Retail Modules
View Issue Details
0039963Retail ModulesCopy Retail Storepublic2019-01-16 13:372019-02-11 11:54
javietxe 
rqueralta 
normalmajorhave not tried
closedfixed 
5
 
RR19Q2 
marvintm
No
0039963: SERQA 5043: Copy stores from excel still is very sensitive to blank characters in some fields
Not 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.
Create 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.
Do the trim in the API when reading the Excel cell in copy stores.
No tags attached.
related to defect 0039701 closed rqueralta SERQA 4931 The Copy stores with Excel file is sensitive to white characters after and before the value. 
xlsx FileCopyStoreWithNewTab888.xlsx (18,368) 2019-01-16 13:37
https://issues.openbravo.com/file_download.php?file_id=12511&type=bug
Issue History
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:37javietxeTriggers an Emergency Pack => No
2019-01-16 13:38javietxeRelationship addedrelated to 0039701
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
---