Firstly, this would be best targeted at the drools-user forum, as the dev mailing list is the preserve of drools development itself. Secondly, can you advise why you need to access the rules rather than the results inferred by the rules themselves when operating on facts? Once you have your KnowledgeBase you can retireve Rule objects using the API, however they appear to have limited use. Can you explain your use-case more? -----Original Message----- From: rules-dev-bounces(a)lists.jboss.org [mailto:rules-dev-bounces@lists.jboss.org] On Behalf Of Sanjib Karmakar Sent: 30 June 2010 09:04 To: rules-dev(a)lists.jboss.org Subject: [rules-dev] Request help for source code of accessing excel file using Drools 5.0 Hi I am new in drools and in my project I would like to access rules in excel file using drools 5.0 Please provide me the source code for how to access the rules in excel file. I have done the following code KnowledgeBuilder kBuilder = KnowledgeBuilderFactory.newKnowledgeBuilder(); DecisionTableConfiguration dtconf = KnowledgeBuilderFactory.newDecisionTableConfiguration(); dtconf.setInputType( DecisionTableInputType.XLS ); dtconf.setWorksheetName("Tables"); kBuilder.add(ResourceFactory.newFileResource("TeamAllocationExample.xls" ), ResourceType.DTABLE, dtconf); KnowledgeBuilderErrors errors = kBuilder.getErrors(); if (errors.size() > 0) { for (KnowledgeBuilderError error: errors) { System.out.println(error); } throw new IllegalArgumentException("Could not parse knowledge."); } KnowledgeBase kbase = KnowledgeBaseFactory.newKnowledgeBase(); kbase.addKnowledgePackages(kBuilder.getKnowledgePackages()); return kbase; How could I use the POJO for accessing the rule? Please help me. Thanks in advance Sanjib -- View this message in context: http://drools-java-rules-engine.46999.n3.nabble.com/Request-help-for-sou rce-code-of-accessing-excel-file-using-Drools-5-0-tp932651p932651.html Sent from the Drools - Dev mailing list archive at Nabble.com. _______________________________________________ rules-dev mailing list rules-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-dev

No problem. I'd suggest you look into KnowledgeBase's newStatefulKnowledgeSession or newStatelessKnowledgeSession (depending upon your use-case). Once you have these you can insert your POJO (Fact) objects and receive the appropriate results (Actions). I get the feeling you have not read the excellent documentation; this would definitely assist you. With kind regards, Mike ________________________________ From: rules-dev-bounces(a)lists.jboss.org [mailto:rules-dev-bounces@lists.jboss.org] On Behalf Of Sanjib Karmakar Sent: 30 June 2010 13:39 To: Rules Dev List Cc: Rules Dev List; rules-dev-bounces(a)lists.jboss.org Subject: Re: [rules-dev] Request help for source code of accessing excel file using Drools 5.0 Hi Michael Thanks you very much for your quick reply. I am sorry I could not understand the proper classification of the forum. I have already sent the request to the drools-user forum. In fact what I wanted to mean that - I am using the 'TeamAllocationExample.xls' - which is the default example I found searching in net. Here LHS and RHS portions are given - I would like to know how could I execute the rule and get the result what is given under 'ACTION' column? A code snippet could help me to go forward. Thanks again for your time and cooperation. Regards Sanjib Karmakar SkyTech Solutions Pvt. Ltd "Anstis, Michael (M.)" <manstis1(a)ford.com&gt; Sent by: rules-dev-bounces(a)lists.jboss.org 06/30/2010 04:35 PM Please respond to Rules Dev List <rules-dev(a)lists.jboss.org&gt; To "Rules Dev List" <rules-dev(a)lists.jboss.org&gt; cc Subject Re: [rules-dev] Request help for source code of accessing excel file using Drools 5.0 Firstly, this would be best targeted at the drools-user forum, as the dev mailing list is the preserve of drools development itself. Secondly, can you advise why you need to access the rules rather than the results inferred by the rules themselves when operating on facts? Once you have your KnowledgeBase you can retireve Rule objects using the API, however they appear to have limited use. Can you explain your use-case more? -----Original Message----- From: rules-dev-bounces(a)lists.jboss.org [mailto:rules-dev-bounces@lists.jboss.org] On Behalf Of Sanjib Karmakar Sent: 30 June 2010 09:04 To: rules-dev(a)lists.jboss.org Subject: [rules-dev] Request help for source code of accessing excel file using Drools 5.0 Hi I am new in drools and in my project I would like to access rules in excel file using drools 5.0 Please provide me the source code for how to access the rules in excel file. I have done the following code KnowledgeBuilder kBuilder = KnowledgeBuilderFactory.newKnowledgeBuilder(); DecisionTableConfiguration dtconf = KnowledgeBuilderFactory.newDecisionTableConfiguration(); dtconf.setInputType( DecisionTableInputType.XLS ); dtconf.setWorksheetName("Tables"); kBuilder.add(ResourceFactory.newFileResource("TeamAllocationExample.xls" ), ResourceType.DTABLE, dtconf); KnowledgeBuilderErrors errors = kBuilder.getErrors(); if (errors.size() > 0) { for (KnowledgeBuilderError error: errors) { System.out.println(error); } throw new IllegalArgumentException("Could not parse knowledge."); } KnowledgeBase kbase = KnowledgeBaseFactory.newKnowledgeBase(); kbase.addKnowledgePackages(kBuilder.getKnowledgePackages()); return kbase; How could I use the POJO for accessing the rule? Please help me. Thanks in advance Sanjib -- View this message in context: http://drools-java-rules-engine.46999.n3.nabble.com/Request-help-for-sou rce-code-of-accessing-excel-file-using-Drools-5-0-tp932651p932651.html Sent from the Drools - Dev mailing list archive at Nabble.com. _______________________________________________ rules-dev mailing list rules-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-dev _______________________________________________ rules-dev mailing list rules-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-dev

Hi Sameeh Thanks for your reply. What I wanted to mean that - I am using the 'TeamAllocationExample.xls' - which is the default example I found searching in net. Here LHS and RHS portions are given - I would like to know how could I execute the rule and get the result what is given under 'ACTION' column? I am sorry if I make you confuse. Regards Sanjib Karmakar SkyTech Solutions Pvt. Ltd "Sameeh Harfoush [via Drools - Java Rules Engine]" <ml-node+933025-623704239-302007(a)n3.nabble.com&gt; 06/30/2010 05:42 PM To Sanjib Karmakar <sanjibk(a)skytechsolutions.co.in&gt; cc Subject Re: Request help for source code of accessing excel file using Drools 5.0 Hello, what do you mean by "How could I use the POJO for accessing the rule?" you run the rule by inserting your POJO as a fact to your session and is the LHS reasoning match the rule RHS gets executed. Ash. View message @ http://drools-java-rules-engine.46999.n3.nabble.com/Request-help-for-sour... To unsubscribe from Request help for source code of accessing excel file using Drools 5.0, click here. -- View this message in context: http://drools-java-rules-engine.46999.n3.nabble.com/Request-help-for-sour... Sent from the Drools - Dev mailing list archive at Nabble.com.