Red Hat Bugzilla – Bug 1199557
B*MS does not accept uploads of CSV format Decision table
Last modified: 2016-10-14 10:12:17 EDT
Description of problem: The documentation says the CSV format is supported, but it is not possible imports it into business-central. From docs: Red Hat JBOSS BRMS supports managing rules in a spreadsheet format. Supported formats are Excel (XLS) and CSV; accordingly, a variety of spreadsheet programs (such as Microsoft Excel) can be utilized. (https://access.redhat.com/documentation/en-US/Red_Hat_JBoss_BRMS/6.0/html/Development_Guide/sect-Decision_Tables.html) Version-Release number of selected component (if applicable): How reproducible: Create a decision table using the CSV format. Steps to Reproduce: 1. Build an decision table 2. save as CSV 3. Upload into business-central or try to parse using the source code from branch master: https://github.com/droolsjbpm/drools/blob/6.1.x/drools-decisiontables/src/main/java/org/drools/decisiontable/parser/xls/ExcelParser.java Actual results: From business-central: The file type is not supported. From the source code test: Exception in thread "main" java.lang.IllegalArgumentException: Your InputStream was neither an OLE2 stream, nor an OOXML stream Expected results: From business-central: Successfully uploded. Type successfully parsed. Additional info:
Whilst it is true the Engine ("BRE") supports XLS and CSV decision tables; Business Central does not support, nor has ever supported, uploading CSV decision tables. I have therefore changed this BZ to be an enhancement. Perhaps the documentation should be clarified for 6.2.x?
Updated topic "Decision Tables in Spreadsheets" in the BRMS/BPMS Dev guide.
You can verify the changes here: http://documentation-devel.engineering.redhat.com/site/documentation/en-US/Red_Hat_JBoss_BPM_Suite/6.1/html-single/Development_Guide/index.html#sect-Using_Decision_Tables_in_Spreadsheets
Verified