Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1199557

Summary:	B*MS does not accept uploads of CSV format Decision table
Product:	[Retired] JBoss BRMS Platform 6	Reporter:	Spolti <fspolti>
Component:	Business Central	Assignee:	manstis
Status:	CLOSED EOL	QA Contact:	Jakub Schwan <jschwan>
Severity:	medium	Docs Contact:	Dawn Eisner <deisner>
Priority:	medium
Version:	6.0.3	CC:	kverlaen, viyengar
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2020-03-27 20:00:31 UTC	Type:	Enhancement
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Spolti 2015-03-06 15:49:27 UTC

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:

Comment 2 manstis 2015-03-06 15:54:09 UTC

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?

Comment 4 Vidya 2015-03-19 09:40:13 UTC

Updated topic "Decision Tables in Spreadsheets" in the BRMS/BPMS Dev guide.

Comment 5 Vidya 2015-07-14 04:40:36 UTC

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

Comment 6 Jakub Schwan 2015-10-02 10:03:22 UTC

Verified