Bug 1256623

Summary: Not possible to convert XLS table to GDT with blank cells
Product: [Retired] JBoss BRMS Platform 6 Reporter: Anton Giertli <agiertli>
Component: Business CentralAssignee: manstis
Status: CLOSED EOL QA Contact: Lukáš Petrovický <lpetrovi>
Severity: high Docs Contact:
Priority: high    
Version: 6.1.0CC: alazarot
Target Milestone: ER3   
Target Release: 6.2.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2020-03-27 19:10:55 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
EmptySpreadsheetCells.xls
none
Log_EmptySpreadsheetCells
none
Model.jar none

Description Anton Giertli 2015-08-25 06:58:19 UTC 
Description of problem:
If my XLS decision tables has even one cell blank in any column then the conversion to the guided decision table does not happen. The error log and xls dt is attached. (Logs_EmptySpreadsheetCells.txt and EmptySpreadsheetCells.xls)

Version-Release number of selected component (if applicable):
BRMS 6.1.2

How reproducible:
always

Steps to Reproduce:
1. Upload XLS including blank cells into the business-central
2. Try to convert it to Guided Decision Table
3. The conversion fails

Actual results:
The conversion of XLS decision table to GDT fails, if the XLS includes blank cells.

Expected results:
The conversion of XLS decision table to GDT succeeds, even if the XLS includes blank cells.


Additional info:
The xls table is valid, the project can be built successfully, the empty cells should not be simply included in the generated GDT.
Comment 1 Anton Giertli 2015-08-25 06:59:28 UTC 
Created attachment 1066745 [details]
EmptySpreadsheetCells.xls
Comment 2 Anton Giertli 2015-08-25 06:59:49 UTC 
Created attachment 1066746 [details]
Log_EmptySpreadsheetCells
Comment 3 Anton Giertli 2015-08-25 07:00:04 UTC 
Created attachment 1066747 [details]
Model.jar
Comment 6 manstis 2015-09-02 08:59:56 UTC 
I wrote a test using the attached XLS file and, given the referenced fix for GUVNOR-2188, it passed without problem. I suspect the "empty" cells correspond to the subject of the referenced JIRA i.e. "Converting XLS Decision Tables fails a row doesn't contain all necessary cells".
Comment 8 Martin Zilak 2015-10-26 14:28:24 UTC 
I followed the steps above and I was able to convert the XLS table with blank cells to a GDT without problems. I used BRMS 6.2.0.ER4.