Spreadsheet Scorecard Implementation in Drools Eclipse Project

[Martin van Schalkwyk]

Hello,

I'm looking to define a scorecard in XLS, add to container and then execute like a DRL file(fireAllRules, etc). Multiple google searches and a few days of research only brings up info on how to create a scorecard via Workbench, which is not what i want to accomplish.

I have looked at this thread: http://drools-moved.46999.n3.nabble.com/rules-users-Location-of-ScoreCard-Spreadsheet-File-td4021435.html; but if i want to parse XLS spreadsheets and execute their rules must i implement them like in this example project: https://github.com/droolsjbpm/drools/blob/master/drools-scorecards/src/test/java/org/drools/scorecards/PMMLDocumentTest.java

Or does the 6.3.0 drools compiler already implement a means to parse the XLS spreadsheet, hence only needing to add it to the container for execution.

Information on this topic is very limited at best. And it seems like they're rather pushing for users to use their Scorecard UI on KIE WB.

Thanks in advance for anyone that can provide assistance.

[Michael Anstis]

AFAIK, in order to include XLS Score Cards within a KJAR, and not compile them yourself (as per the unit tests) you should use the ".sxls"

This is the only mechanism Drools has to differentiate between an XLS Decision Table and a XLS Score Card.

BCC'ed core engine developer for possible additional comment.

--
You received this message because you are subscribed to the Google Groups "Drools Usage" group.
To unsubscribe from this group and stop receiving emails from it, send an email to drools-usage...@googlegroups.com.
To post to this group, send email to drools...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/drools-usage/cf409810-e019-4665-9342-6fea4198278a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Martin van Schalkwyk]

Thanks for the very fast feedback, Michael.

Okay so this ".sxls" you are referring to is the Sealed XLS spreadsheet? I can't find any way of saving my spreadsheet as a ".sxls" extension. I can only find information with regards to the Oracle IRM solution(at this link: https://docs.oracle.com/cd/E16764_01/doc.1111/e12278/idtpusingexcelspreadsheets.htm) for spreadsheets relating to the ".sxls" extension.

Please can you give some guidance as to how to create a ".sxls" spreadsheet. Or any light you can shed on that notion would be appreciated.

Thanks, again, for the help.

[Michael Anstis]

Nope, sxls is the file extension we chose to distinguish XLS Decision Tables from XLS Score Cards.

Just rename your XLS Score Card to SXLS and it *should* be usable in a KJAR.

To view this discussion on the web visit https://groups.google.com/d/msgid/drools-usage/6f912ce2-c3a2-4fc0-81c5-ec145c98dce6%40googlegroups.com.

[Martin van Schalkwyk]

Thanks, Michael.

And should I stick to the format of the scorecards defined in the unit tests for the spreadsheet? Or is there a document which outlines the format and structure of XLS Scorecards?

Thanks

[Michael Anstis]

Yes.. I'd have hoped the format was documented... but I've never looked tbh :(

To view this discussion on the web visit https://groups.google.com/d/msgid/drools-usage/56228ccb-1a62-4b3b-b205-41dc1e74e830%40googlegroups.com.