From FMahalakshmi at nyx.com Fri Jun  4 09:26:50 2010
Content-Type: multipart/mixed; boundary="===============8444768790703741505=="
MIME-Version: 1.0
From: Fnu Mahalakshmi <FMahalakshmi at nyx.com>
To: rules-users at lists.jboss.org
Subject: [rules-users] -Doubt using HSSFWorkbook and multiple inputs
Date: Fri, 04 Jun 2010 09:26:46 -0400
Message-ID: <994758E35590274E955FA75763C5AA5002D01070@MTEXMBXP01.ad.NYX.com>

--===============8444768790703741505==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

Hi,

I have a real basic question about the working of drools.
I figured it to be this way:
We load our input data (our facts) - fire the rules on this data - get the =
modified out put in our output file.
Doubt:
I am reading all my input data from a text file.
1. How can I load all the data contained in my text file into the memory at=
 the same time? Like we used HSSF workbook concept for the excel file?
And fire all the rules at the data at once.?
2. Again When I have multiple input files, Shouldn't I be loading all the i=
nput files in the memory and firing rules on them? How can I do that? I sho=
uld have different test files for different input datasets?? (for example l=
ike the ExcelDataRulesTest.java file in the example)

I am still stuck with the procedural way of thinking- read lines and run ru=
les and generate output.

Please help!!! I am really new to this and going round and round.

Thank you.
M
</pre>

<P><hr size=3D1></P>
<P><STRONG><font color=3Dgreen>Please consider the environment before print=
ing this email.</font></STRONG></P>
<P><STRONG>Visit our website at <a href=3D"http://www.nyse.com">http://www.=
nyse.com</a> <br>

***************************************************************************=
**
<br>
Note:  The information contained in this message and any attachment to it i=
s privileged, confidential and protected from disclosure.  If the reader of=
 this message is not the intended recipient, or an employee or agent respon=
sible for delivering this message to the intended recipient, you are hereby=
 notified that any dissemination, distribution or copying of this communica=
tion is strictly prohibited.  If you have received this communication in er=
ror, please notify the sender immediately by replying to the message, and p=
lease delete it from your system.  Thank you.  NYSE Euronext.

</STRONG></P><pre>

--===============8444768790703741505==
Content-Type: text/html
MIME-Version: 1.0
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"

PGh0bWwgeG1sbnM6bz0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6b2ZmaWNlIiB4
bWxuczp3PSJ1cm46c2NoZW1hcy1taWNyb3NvZnQtY29tOm9mZmljZTp3b3JkIiB4bWxucz0iaHR0
cDovL3d3dy53My5vcmcvVFIvUkVDLWh0bWw0MCI+Cgo8aGVhZD4KPE1FVEEgSFRUUC1FUVVJVj0i
Q29udGVudC1UeXBlIiBDT05URU5UPSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9dXMtYXNjaWkiPgo8bWV0
YSBuYW1lPUdlbmVyYXRvciBjb250ZW50PSJNaWNyb3NvZnQgV29yZCAxMSAoZmlsdGVyZWQgbWVk
aXVtKSI+CjxzdHlsZT4KPCEtLQogLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8KIHAuTXNvTm9ybWFs
LCBsaS5Nc29Ob3JtYWwsIGRpdi5Nc29Ob3JtYWwKCXttYXJnaW46MGluOwoJbWFyZ2luLWJvdHRv
bTouMDAwMXB0OwoJZm9udC1zaXplOjEyLjBwdDsKCWZvbnQtZmFtaWx5OiJUaW1lcyBOZXcgUm9t
YW4iO30KYTpsaW5rLCBzcGFuLk1zb0h5cGVybGluawoJe2NvbG9yOmJsdWU7Cgl0ZXh0LWRlY29y
YXRpb246dW5kZXJsaW5lO30KYTp2aXNpdGVkLCBzcGFuLk1zb0h5cGVybGlua0ZvbGxvd2VkCgl7
Y29sb3I6cHVycGxlOwoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9CnNwYW4uRW1haWxTdHls
ZTE3Cgl7bXNvLXN0eWxlLXR5cGU6cGVyc29uYWwtY29tcG9zZTsKCWZvbnQtZmFtaWx5OkFyaWFs
OwoJY29sb3I6d2luZG93dGV4dDt9CkBwYWdlIFNlY3Rpb24xCgl7c2l6ZTo4LjVpbiAxMS4waW47
CgltYXJnaW46MS4waW4gMS4yNWluIDEuMGluIDEuMjVpbjt9CmRpdi5TZWN0aW9uMQoJe3BhZ2U6
U2VjdGlvbjE7fQotLT4KPC9zdHlsZT4KCjwvaGVhZD4KCjxib2R5IGxhbmc9RU4tVVMgbGluaz1i
bHVlIHZsaW5rPXB1cnBsZT4KCjxkaXYgY2xhc3M9U2VjdGlvbjE+Cgo8cCBjbGFzcz1Nc29Ob3Jt
YWw+PGZvbnQgc2l6ZT0yIGZhY2U9QXJpYWw+PHNwYW4gc3R5bGU9J2ZvbnQtc2l6ZToxMC4wcHQ7
CmZvbnQtZmFtaWx5OkFyaWFsJz5IaSw8bzpwPjwvbzpwPjwvc3Bhbj48L2ZvbnQ+PC9wPgoKPHAg
Y2xhc3M9TXNvTm9ybWFsPjxmb250IHNpemU9MiBmYWNlPUFyaWFsPjxzcGFuIHN0eWxlPSdmb250
LXNpemU6MTAuMHB0Owpmb250LWZhbWlseTpBcmlhbCc+PG86cD4mbmJzcDs8L286cD48L3NwYW4+
PC9mb250PjwvcD4KCjxwIGNsYXNzPU1zb05vcm1hbD48Zm9udCBzaXplPTIgZmFjZT1BcmlhbD48
c3BhbiBzdHlsZT0nZm9udC1zaXplOjEwLjBwdDsKZm9udC1mYW1pbHk6QXJpYWwnPkkgaGF2ZSBh
IHJlYWwgYmFzaWMgcXVlc3Rpb24gYWJvdXQgdGhlIHdvcmtpbmcgb2YgZHJvb2xzLjxvOnA+PC9v
OnA+PC9zcGFuPjwvZm9udD48L3A+Cgo8cCBjbGFzcz1Nc29Ob3JtYWw+PGZvbnQgc2l6ZT0yIGZh
Y2U9QXJpYWw+PHNwYW4gc3R5bGU9J2ZvbnQtc2l6ZToxMC4wcHQ7CmZvbnQtZmFtaWx5OkFyaWFs
Jz5JIGZpZ3VyZWQgaXQgdG8gYmUgdGhpcyB3YXk6PG86cD48L286cD48L3NwYW4+PC9mb250Pjwv
cD4KCjxwIGNsYXNzPU1zb05vcm1hbD48Zm9udCBzaXplPTIgZmFjZT1BcmlhbD48c3BhbiBzdHls
ZT0nZm9udC1zaXplOjEwLjBwdDsKZm9udC1mYW1pbHk6QXJpYWwnPldlIGxvYWQgb3VyIGlucHV0
IGRhdGEgKG91ciBmYWN0cykgJiM4MjExOyBmaXJlIHRoZSBydWxlcyBvbgp0aGlzIGRhdGEgJiM4
MjExOyBnZXQgdGhlIG1vZGlmaWVkIG91dCBwdXQgaW4gb3VyIG91dHB1dCBmaWxlLjxvOnA+PC9v
OnA+PC9zcGFuPjwvZm9udD48L3A+Cgo8cCBjbGFzcz1Nc29Ob3JtYWw+PGZvbnQgc2l6ZT0yIGZh
Y2U9QXJpYWw+PHNwYW4gc3R5bGU9J2ZvbnQtc2l6ZToxMC4wcHQ7CmZvbnQtZmFtaWx5OkFyaWFs
Jz5Eb3VidDo8bzpwPjwvbzpwPjwvc3Bhbj48L2ZvbnQ+PC9wPgoKPHAgY2xhc3M9TXNvTm9ybWFs
Pjxmb250IHNpemU9MiBmYWNlPUFyaWFsPjxzcGFuIHN0eWxlPSdmb250LXNpemU6MTAuMHB0Owpm
b250LWZhbWlseTpBcmlhbCc+SSBhbSByZWFkaW5nIGFsbCBteSBpbnB1dCBkYXRhIGZyb20gYSB0
ZXh0IGZpbGUuPG86cD48L286cD48L3NwYW4+PC9mb250PjwvcD4KCjxwIGNsYXNzPU1zb05vcm1h
bD48Zm9udCBzaXplPTIgZmFjZT1BcmlhbD48c3BhbiBzdHlsZT0nZm9udC1zaXplOjEwLjBwdDsK
Zm9udC1mYW1pbHk6QXJpYWwnPjEuIEhvdyBjYW4gSSBsb2FkIGFsbCB0aGUgZGF0YSBjb250YWlu
ZWQgaW4gbXkgdGV4dCBmaWxlCmludG8gdGhlIG1lbW9yeSBhdCB0aGUgc2FtZSB0aW1lPyBMaWtl
IHdlIHVzZWQgSFNTRiB3b3JrYm9vayBjb25jZXB0IGZvciB0aGUKZXhjZWwgZmlsZT88bzpwPjwv
bzpwPjwvc3Bhbj48L2ZvbnQ+PC9wPgoKPHAgY2xhc3M9TXNvTm9ybWFsPjxmb250IHNpemU9MiBm
YWNlPUFyaWFsPjxzcGFuIHN0eWxlPSdmb250LXNpemU6MTAuMHB0Owpmb250LWZhbWlseTpBcmlh
bCc+QW5kIGZpcmUgYWxsIHRoZSBydWxlcyBhdCB0aGUgZGF0YSBhdCBvbmNlLj88bzpwPjwvbzpw
Pjwvc3Bhbj48L2ZvbnQ+PC9wPgoKPHAgY2xhc3M9TXNvTm9ybWFsPjxmb250IHNpemU9MiBmYWNl
PUFyaWFsPjxzcGFuIHN0eWxlPSdmb250LXNpemU6MTAuMHB0Owpmb250LWZhbWlseTpBcmlhbCc+
Mi4gQWdhaW4gV2hlbiBJIGhhdmUgbXVsdGlwbGUgaW5wdXQgZmlsZXMsIFNob3VsZG4mIzgyMTc7
dCBJCmJlIGxvYWRpbmcgYWxsIHRoZSBpbnB1dCBmaWxlcyBpbiB0aGUgbWVtb3J5IGFuZCBmaXJp
bmcgcnVsZXMgb24gdGhlbT8gSG93IGNhbgpJIGRvIHRoYXQ/IEkgc2hvdWxkIGhhdmUgZGlmZmVy
ZW50IHRlc3QgZmlsZXMgZm9yIGRpZmZlcmVudCBpbnB1dCBkYXRhc2V0cz8/IChmb3IKZXhhbXBs
ZSBsaWtlIHRoZSBFeGNlbERhdGFSdWxlc1Rlc3QuamF2YSBmaWxlIGluIHRoZSBleGFtcGxlKTxv
OnA+PC9vOnA+PC9zcGFuPjwvZm9udD48L3A+Cgo8cCBjbGFzcz1Nc29Ob3JtYWw+PGZvbnQgc2l6
ZT0yIGZhY2U9QXJpYWw+PHNwYW4gc3R5bGU9J2ZvbnQtc2l6ZToxMC4wcHQ7CmZvbnQtZmFtaWx5
OkFyaWFsJz48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L2ZvbnQ+PC9wPgoKPHAgY2xhc3M9TXNv
Tm9ybWFsPjxmb250IHNpemU9MiBmYWNlPUFyaWFsPjxzcGFuIHN0eWxlPSdmb250LXNpemU6MTAu
MHB0Owpmb250LWZhbWlseTpBcmlhbCc+SSBhbSBzdGlsbCBzdHVjayB3aXRoIHRoZSBwcm9jZWR1
cmFsIHdheSBvZiB0aGlua2luZy0gcmVhZApsaW5lcyBhbmQgcnVuIHJ1bGVzIGFuZCBnZW5lcmF0
ZSBvdXRwdXQuPG86cD48L286cD48L3NwYW4+PC9mb250PjwvcD4KCjxwIGNsYXNzPU1zb05vcm1h
bD48Zm9udCBzaXplPTIgZmFjZT1BcmlhbD48c3BhbiBzdHlsZT0nZm9udC1zaXplOjEwLjBwdDsK
Zm9udC1mYW1pbHk6QXJpYWwnPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvZm9udD48L3A+Cgo8
cCBjbGFzcz1Nc29Ob3JtYWw+PGZvbnQgc2l6ZT0yIGZhY2U9QXJpYWw+PHNwYW4gc3R5bGU9J2Zv
bnQtc2l6ZToxMC4wcHQ7CmZvbnQtZmFtaWx5OkFyaWFsJz5QbGVhc2UgaGVscCEhISBJIGFtIHJl
YWxseSBuZXcgdG8gdGhpcyBhbmQgZ29pbmcgcm91bmQgYW5kCnJvdW5kLjxvOnA+PC9vOnA+PC9z
cGFuPjwvZm9udD48L3A+Cgo8cCBjbGFzcz1Nc29Ob3JtYWw+PGZvbnQgc2l6ZT0yIGZhY2U9QXJp
YWw+PHNwYW4gc3R5bGU9J2ZvbnQtc2l6ZToxMC4wcHQ7CmZvbnQtZmFtaWx5OkFyaWFsJz48bzpw
PiZuYnNwOzwvbzpwPjwvc3Bhbj48L2ZvbnQ+PC9wPgoKPHAgY2xhc3M9TXNvTm9ybWFsPjxmb250
IHNpemU9MiBmYWNlPUFyaWFsPjxzcGFuIHN0eWxlPSdmb250LXNpemU6MTAuMHB0Owpmb250LWZh
bWlseTpBcmlhbCc+VGhhbmsgeW91LjxvOnA+PC9vOnA+PC9zcGFuPjwvZm9udD48L3A+Cgo8cCBj
bGFzcz1Nc29Ob3JtYWw+PGZvbnQgc2l6ZT0yIGZhY2U9QXJpYWw+PHNwYW4gc3R5bGU9J2ZvbnQt
c2l6ZToxMC4wcHQ7CmZvbnQtZmFtaWx5OkFyaWFsJz5NPG86cD48L286cD48L3NwYW4+PC9mb250
PjwvcD4KCjwvZGl2PgoKPHByZT48L3ByZT4KCjxQPjxociBzaXplPTE+PC9QPgo8UD48U1RST05H
Pjxmb250IGNvbG9yPWdyZWVuPlBsZWFzZSBjb25zaWRlciB0aGUgZW52aXJvbm1lbnQgYmVmb3Jl
IHByaW50aW5nIHRoaXMgZW1haWwuPC9mb250PjwvU1RST05HPjwvUD4KPFA+PFNUUk9ORz5WaXNp
dCBvdXIgd2Vic2l0ZSBhdCA8YSBocmVmPSJodHRwOi8vd3d3Lm55c2UuY29tIj5odHRwOi8vd3d3
Lm55c2UuY29tPC9hPiA8YnI+CgoqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq
KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKgo8YnI+Ck5vdGU6ICBUaGUg
aW5mb3JtYXRpb24gY29udGFpbmVkIGluIHRoaXMgbWVzc2FnZSBhbmQgYW55IGF0dGFjaG1lbnQg
dG8gaXQgaXMgcHJpdmlsZWdlZCwgY29uZmlkZW50aWFsIGFuZCBwcm90ZWN0ZWQgZnJvbSBkaXNj
bG9zdXJlLiAgSWYgdGhlIHJlYWRlciBvZiB0aGlzIG1lc3NhZ2UgaXMgbm90IHRoZSBpbnRlbmRl
ZCByZWNpcGllbnQsIG9yIGFuIGVtcGxveWVlIG9yIGFnZW50IHJlc3BvbnNpYmxlIGZvciBkZWxp
dmVyaW5nIHRoaXMgbWVzc2FnZSB0byB0aGUgaW50ZW5kZWQgcmVjaXBpZW50LCB5b3UgYXJlIGhl
cmVieSBub3RpZmllZCB0aGF0IGFueSBkaXNzZW1pbmF0aW9uLCBkaXN0cmlidXRpb24gb3IgY29w
eWluZyBvZiB0aGlzIGNvbW11bmljYXRpb24gaXMgc3RyaWN0bHkgcHJvaGliaXRlZC4gIElmIHlv
dSBoYXZlIHJlY2VpdmVkIHRoaXMgY29tbXVuaWNhdGlvbiBpbiBlcnJvciwgcGxlYXNlIG5vdGlm
eSB0aGUgc2VuZGVyIGltbWVkaWF0ZWx5IGJ5IHJlcGx5aW5nIHRvIHRoZSBtZXNzYWdlLCBhbmQg
cGxlYXNlIGRlbGV0ZSBpdCBmcm9tIHlvdXIgc3lzdGVtLiAgVGhhbmsgeW91LiAgTllTRSBFdXJv
bmV4dC4KCjwvU1RST05HPjwvUD48cHJlPgo8L3ByZT48L2JvZHk+Cgo8L2h0bWw+Cg==

--===============8444768790703741505==--