Hi Florian, It appears that RapidMiner has a Java API<http://rapid-i.com/api/rapidminer-5.1/index.html>. If your intention is to ultimately use Jess to reason over a rulebases of sheet-metal forming rules, then those rules will have to be in Jess code. In theory, you could use RapidMiner's Java API and Java proper to generate Jess rules directly -- just pipe the output from RapidMiner into a Java class that generates Jess rule code. Alternately, if you must keep the intermediate Excel files, you could write a Java class that generates Jess rules from your Excel spreadsheets. Then, if you were to update your Excel source, your Jess rulebase (e.g. Jess *.CLP files somewhere) could be automatically updated, too. For this, you may find the Apache Poi <http://poi.apache.org/>API useful to read/write Excel files from Java.
Hope that helps! Cheers, Jason ------------------------------------------------------ Morris Technical Solutions LLC consult...@morris-technical-solutions.com (517) 304-5883 On Wed, Feb 23, 2011 at 12:21 PM, Flogger <flog...@drfaltus.de> wrote: > Thank you, > > let me try to explain what we are planning to do and why our first thought > was using an excel sheet. > We are doing research on sheet metal forming and my tutor is doing some > simulation and using rapidminer to create rules explaining the forming. > These rules are formulas expressing the natural strain. He wants to store > these rules in a multidimensional database (many sheets in an excel > workbook). One sheet stands for one geometrical object. > I know it is not the best idea but we do not know what would be the best > way of storing our rules. > It is important that the rules are not stored directly into jess code, > because my tutor wants to autogenerate his new rules without working with > jess. > > Thank you again > Florian > > Am 23.02.2011 17:50, schrieb Friedman-Hill, Ernest: > > Jess rules are textual, like program code. Typically what you're going to >> store in a spreadsheet is a decision table, which some simple rule engines >> will execute directly. That isn't what Jess does. You could write a Jess >> program to *implement* a decision table runner, or you could try to store >> Jess rules as text in spreadsheet cells (although I have no idea why anyone >> would ever want to do that!) >> >> -----Original Message----- >>> From: owner-jess-us...@sandia.gov >>> [mailto:owner-jess-us...@sandia.gov] On Behalf Of Flogger >>> Sent: Wednesday, February 23, 2011 11:13 AM >>> To: jess-users >>> Subject: JESS: Storing rules in an excel sheet >>> >>> Hi Folks, >>> >>> first of all I want to introduce myself. >>> My name is Florian. I am from Germany. I am 22 years old and I am >>> writing my bachelor thesis about expert systems. >>> My tutor wants me to store my rule database in excel because >>> he wants to >>> automatically generate it using a data mining software. >>> My question right now is: Is it possible? And if yes, how? >>> I read "Jess in action" but there was only an explanation for >>> storing in >>> xml files. >>> >>> Thank you. >>> Florian >>> >>> >>> -------------------------------------------------------------------- >>> To unsubscribe, send the words 'unsubscribe jess-users >>> y...@address.com' >>> in the BODY of a message to majord...@sandia.gov, NOT to the list >>> (use your own address!) List problems? Notify >>> owner-jess-us...@sandia.gov. >>> -------------------------------------------------------------------- >>> >>> >> >> -------------------------------------------------------------------- >> To unsubscribe, send the words 'unsubscribe jess-users y...@address.com' >> in the BODY of a message to majord...@sandia.gov, NOT to the list >> (use your own address!) List problems? Notify owner-jess-us...@sandia.gov >> . >> -------------------------------------------------------------------- >> >> >> > > > -------------------------------------------------------------------- > To unsubscribe, send the words 'unsubscribe jess-users y...@address.com' > in the BODY of a message to majord...@sandia.gov, NOT to the list > (use your own address!) List problems? Notify owner-jess-us...@sandia.gov. > -------------------------------------------------------------------- > >