-----Original Message----- From: rules-users-bounces(a)lists.jboss.org [mailto:rules-users- bounces(a)lists.jboss.org] On Behalf Of satjo Sent: 18 November 2009 16:50 To: rules-users(a)lists.jboss.org Subject: [rules-users] Multiple Excel decisiontables - a bug I think following is a bug and I would like to how different users think Issue: If there are multiple Excel decisiontables files, i.e, NOT multiple decision tables in a single spreadsheet, then the 'fireall' does not necessarily give right results as the rule names get repeated in the resolved drl file. How to produce?: One can produce this issue adding multiple Excel files in Knowledbuilder and also one can see the same problem in Guvnor when one uploads multiple Excel decision tables. Reason for the behavior: The rule name (with row number post fix) gets repeated if all the spreadsheets for the given model. Let us say if I have a model 'com.sample.Test' and two spreadsheet decision tables use this model, then the final resolved drl file would have two rules with the same name, e.g. Test_11 etc. I looked into the code 'org.drools.template.model' and name is not unique between different spreadsheets. If this name is unique, e.g. name of the spreadsheet (presuming each spreadsheet is having unique name), then I do get correct results. I want to know if any one has similar experience or comments. -- View this message in context: http://old.nabble.com/Multiple-Excel- decisiontables---a-bug-tp26408909p26408909.html Sent from the drools - user mailing list archive at Nabble.com. _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users

Thomas Thanks for the reply. It makes sense to specify the rule names explicitly. If I have several hundreds of rows (& several spreadsheets), giving a unique name for each rule is time consuming. I guess I can use some Excel functionality to generate the unique names.

What do you think about the feature of auto generating the names? Let us say, if the the name of spreadsheet is appended with 11, 12 etc I can have the rule name generated automatically (of course, presuming I give an unique name for each spreadsheet... which is far less effort).

Swindells, Thomas wrote: > > My advice is always to include a rulename (NAME) column and explicitly > specify all the rule names. > That way the name of the rule is deterministic and doesn't suddenly change > if someone happens to insert a rule in the row above - this is > particularly useful if you log or audit the rules that have fired. > > Thomas > >> -----Original Message----- >> From: rules-users-bounces(a)lists.jboss.org [mailto:rules-users- >> bounces(a)lists.jboss.org] On Behalf Of satjo >> Sent: 18 November 2009 16:50 >> To: rules-users(a)lists.jboss.org >> Subject: [rules-users] Multiple Excel decisiontables - a bug >> >> >> I think following is a bug and I would like to how different users >> think >> >> Issue: If there are multiple Excel decisiontables files, i.e, NOT >> multiple >> decision tables in a single spreadsheet, then the 'fireall' does not >> necessarily give right results as the rule names get repeated in the >> resolved drl file. >> >> How to produce?: >> One can produce this issue adding multiple Excel files in >> Knowledbuilder and >> also one can see the same problem in Guvnor when one uploads multiple >> Excel >> decision tables. >> >> Reason for the behavior: >> The rule name (with row number post fix) gets repeated if all the >> spreadsheets for the given model. >> Let us say if I have a model 'com.sample.Test' and two spreadsheet >> decision >> tables use this model, then the final resolved drl file would have two >> rules >> with the same name, e.g. Test_11 etc. >> >> I looked into the code 'org.drools.template.model' and name is not >> unique >> between different spreadsheets. >> If this name is unique, e.g. name of the spreadsheet (presuming each >> spreadsheet is having unique name), then I do get correct results. >> >> I want to know if any one has similar experience or comments. >> -- >> View this message in context: http://old.nabble.com/Multiple-Excel- >> decisiontables---a-bug-tp26408909p26408909.html >> Sent from the drools - user mailing list archive at Nabble.com. >> >> _______________________________________________ >> rules-users mailing list >> rules-users(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/rules-users > > *********************************************************************** *************** > This message is confidential and intended only for the addressee. If you > have received this message in error, please immediately notify the > postmaster(a)nds.com and delete it from your system as well as any copies. > The content of e-mails as well as traffic data may be monitored by NDS for > employment and security purposes. To protect the environment please do not > print this e-mail unless necessary. > > NDS Limited. Registered Office: One London Road, Staines, Middlesex, TW18 > 4EX, United Kingdom. A company registered in England and Wales. Registered > no. 3080780. VAT no. GB 603 8808 40-00 > *********************************************************************** *************** > > _______________________________________________ > rules-users mailing list > rules-users(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/rules-users > > -- View this message in context: http://old.nabble.com/Multiple-Excel- decisiontables---a-bug-tp26408909p26415670.html Sent from the drools - user mailing list archive at Nabble.com. _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users