Red Hat Bugzilla – Bug 1256623
Not possible to convert XLS table to GDT with blank cells
Last modified: 2016-04-22 00:50:43 EDT
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):
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
The conversion of XLS decision table to GDT fails, if the XLS includes blank cells.
The conversion of XLS decision table to GDT succeeds, even if the XLS includes blank cells.
The xls table is valid, the project can be built successfully, the empty cells should not be simply included in the generated GDT.
Created attachment 1066745 [details]
Created attachment 1066746 [details]
Created attachment 1066747 [details]
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".
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.