[rules-users] Multiple Excel decisiontables - a bug

[Swindells, Thomas]

> 
> 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.
Excel is fairly clever so if you have cell whose content ends with a number when you drag the black box to copy the contents into the cells below it will automatically increment the value. If you have just a single rules table then this won't take long at all, I do agree however that if you have lots of rules tables this could get tedious.

 
> 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).

Sounds sensible to me, and from what I have seen shouldn't be that hard to change the code to do this. 

I've got a whole list of features that I'd like to do to improve the spreadsheet support, the project I'm working on is using them and I'm hoping to get some time to work on it but as it is currently running behind I'm not sure if that is going to happen or not.

Thomas
> 
> 
> 
> 
> 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 at lists.jboss.org [mailto:rules-users-
> >> bounces at lists.jboss.org] On Behalf Of satjo
> >> Sent: 18 November 2009 16:50
> >> To: rules-users at 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 at 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 at 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 at 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 at 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 at 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
**************************************************************************************