[jboss-jira] [JBoss JIRA] (DROOLS-1382) "No RuleTable cells in spreadsheet"

[John Dunning (JIRA)]

    [ https://issues.jboss.org/browse/DROOLS-1382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13339862#comment-13339862 ] 

John Dunning commented on DROOLS-1382:
--------------------------------------

*I have resolved this as follows*

Using Intellij

navigated to src/main/resources 

added the rule folder that contains all the rules by right clicking and selecting new Directory brnc2.rules

added all the rules into this folder.  All compiles fine until I add the templates and then No RuleTable Error

Now, delete the folder and go back and right click and select New Directory brnc2
then repeat and select new Directory rules

now add all the rules into this folder (still displayed as brnc2.rules) and now it works with the templates as well
--

In summary - Drools resolves all the other files using a package like structure so brnc2.rules will work

However, the Template-Data.xls is not resolved by package and so the folder brnc2.rules is not the same as brnc2/rules

However, you see no visible difference between brnc2.rules and brcn2/rules in the resources folder of Intellij

> "No RuleTable cells in spreadsheet"
> -----------------------------------
>
>                 Key: DROOLS-1382
>                 URL: https://issues.jboss.org/browse/DROOLS-1382
>             Project: Drools
>          Issue Type: Bug
>          Components: decision tables
>    Affects Versions: 6.3.0.Final, 6.5.0.Final
>         Environment: OSX 10.12
> Excel for Mac
> Drools 6.3.0.Final and Drools 6.5.0.Final
> Intellij IDEA  Ultimate 2016.1
> second machine  Intellij IDEA CE 2016.2
>            Reporter: John Dunning
>            Assignee: Mario Fusco
>            Priority: Blocker
>
> Mac OSX Drools 6.3.0.Final and recreated in Drools 6.5.0.Final
> Checked out the Drools6.3.0 example code, and also example code from Mastering Drools 6 book for RuleTemplates using spreadsheets as template data.
> Both projects compile and work in their own environment.
> Replicated similar for a Government Project and KnowledgeBase compilation fails with "No Ruletable cells in Spreadsheet".
> This ruleset is one ruleset in a multi-ruleset project that is configured using kmodule.xml.  Other rulesets include DRL and Decision Tables.
> The rules for this ruleset are in the same package in src/main/resources of a project that also includes all the executable code.  The fact model is also included in the executable code. Created an excel spreadsheet using Excel for Mac, and created the DRT file. The rules also include a DRL file.  Got the "No Ruletable cells in Spreadsheet" error when building the knowledge base. 
> Removed the DRL file and the KnowledgeBase built.  Put the DRL file back and the KnowledgeBase still built.
> Copied the project and the problem recurred.
> Created separate projects for each ruleset - each with its own kmodule.xml.  Each ruleset is a Maven Module in a Maven Project.  This ruleset contains only one DRT, one DRL and and XLS with data only.  It also contains java code for one fact.
> Cannot create a KnowledgeBase from this ruleset even when dependencies for all other rulesets are commented out.  None of the other rulesets use templates but they do use decision tables, DRL files and have facts specific to the ruleset.
> Moved the RuleSet from a Maven Module to a separate Maven Project.  Problem still recurred.  Separated the Fact Model (single fact) into a separate Maven Project.  Problem still recurred.
> Wondered if it may be a issue with Excel for Mac so copied the xls and DRT files from both Drools 6.3 examples and Mastering Drools examples and neither compiles when copied and pasted into a new project - same error  "No Ruletable cells in Spreadsheet".
> Moved Drools to 6.5.0.final and problem recurred
> IDE - Intellij IDEA Ultimate 2016.1 
> second machine
> Mac OSX Drools 6.3.0.Final and recreated in Drools 6.5.0.Final
> I can be contacted for more information and/or an example project that replicates the problem.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)