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(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
**************************************************************************************
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
**************************************************************************************