1 of 1 people found this helpful
This is really vague. What is your goal? If you just need to display graphs in filemaker that were generated in R, you can use containers and export the graph from R as an image. If you need to pass the raw values back and forth, then it probably is going to be more complex. I would look for some R supported ODBC drivers and try to access the data via ESS from FileMaker.
I only know what R is because my wife and some friends are in physics. I've never heard of any sort of integration for Filemaker. Googling it I found this, which may be of some help for you:
Thanks. Yes, that is the only place I found online about R and Filemaker before I posted here. My solution needs to not only pass the values back and forth, but also to be in real-time (dynamic). Once the new data is added, the R will be called to calculate and generate the graph, then Filemaker will display the results on its layout. I don't know if there is new way to do the job other than the one on the web, which was posted almost six years ago.
If you have someone that's handy with R and web programming, I would try to set up some sort of Insert from URL or web viewer return of the data based on a file of data output from FM.
Unfortunately the R program is so complex and specialized, you'll probably have difficulty finding someone that has successfully integrated it.
If Graphing is your only goal, then you might want to consider other graphing methods that have been successfully integrated to FM (IE GoogleCharts or FusionCharts).
Thank you very much. I need both the Graphing and the more complex statistical analysis provided by R. Also, I'm a scientist using both Filemaker and R, and don't have web programming guy around me.
Have you tried the ODBC approach outlined at http://www.medicalnerds.com/r-and-filemaker-on-mac-os-x/...? I know that in recent versions of FM the ODBC driver has been improved significantly since that article and would seem to me to be the best solution since that will allow R to access your FM-stroed data. http://cran.r-project.org/doc/manuals/r-release/R-data.html#RODBC explains how to confiure R to access an ODBC source, so if you combine this with the FM documentation on setting up FM as an ODBC source you should be able to get your data into R through this approach.
If you're then after graphs from R you're likely to still need to take the approach Mike suggested of exporting these from R and importing back into FM since as far as I can see from the R documentation it doesn't really support any form of API to get data back out (other than it being able to update via ODBC tables in FM which may store R-calculated results)
I have not tried yet for three reasons: to see if there are alternative ways; I'm working on Window environment; most important I want FM control the whole process as other users do not know how to use R. Now I may give a try. Thanks.
1 of 1 people found this helpful
For what it is worth:
There appear to be various projects written to interface with R via programming languages that interface with FileMaker (albeit in some cases via a plugin):
- HTTP requests: http://www.omegahat.org/CGIwithR/
- Java: http://www.rforge.net/rJava/
- A TCP Connection: http://stats.math.uni-augsburg.de/Rserve/ (which apparently one can access using client libraries for various programming languages including Java)
Of all of the above:
I'd say that perhaps the first link (CGIwithR) might be the most accessible to you if you are willing to learn some of the nuts and bolts about how to perform a HTTP Post request from within FileMaker (either via a plugin, or functionality added in v.13).
The above links were found at:
Thanks so much.
I have not tried yet for two reasons: to see if there are alternative ways: I'm working on Window environment.
That article complained about the ODBC connections on Mac OS X 10.4. Didn’t WinOS provide decent ODBC drivers?