I have some mailing-list data in FileMaker I need to move Servoy.
The client wants to click a button either in Servoy or FileMaker to move a list of people across…
I can enable to web-companion in FileMaker and type in a URL in a web browser to request the data as XML.
Then I tried getPageData with my URL in Servoy, but it does not seem to work. Is there any way of getting Servoy to read XML via http:?
There was a “FileMaker to Servoy and back” article on Servoy Magazine, but it is no longer there
The easiest way to get it into servoy I believe is to export is as tab or comma deliminated text file from filemaker. Then use the import deliminated file feature in servoy.
myself:
I now get XML into Servoy with getPageData() from one of FileMaker’s own demo files. I suspect there may be some illegal characters or something like that in the file I tried last night.
Ok. I have been very stupid.
My database were password-protected.
When I tried accessing the XML with IE I was asked for my password.
When accessing with getPageData it does not ask.
You either have to send the password in the URL (risky!) or make sure the data and the layout you are using can be accessed without a password.
I wrote the “FileMaker to Servoy and Back” article a while back (jeez, over a year now). I was basically goofing around and used CDML urls to pass data back and forth.
A couple months ago I wrote a Servoy plugin that access FM6 via the webcompanion Java API (believe it or not, FM has one) and does all the string parsing (the hard part) for you. Works like a charm. It has the following functions: getDatabaseNames (URL, password), getLayoutNames (URL, password, dbName), getFieldInfo (URL, password, dbName, layoutName), getScriptNames (URL, password, dbName), actionFind (this retrieves data from FM), and actionAdd (this adds data to FM or runs a FM script).
The plugin makes hooking Servoy up to a FileMaker app a breeze.
I haven’t released it yet because I haven’t figured out how to lock it down. It took a good amount of work so it’s probably worth a dollar or two contribution to my beer fund. If someone can give some pointers on how to lock down Java plugins, I’ll get it out the door.
david:
A couple months ago I wrote a Servoy plugin that access FM6 via the webcompanion Java API (believe it or not, FM has one) and does all the string parsing (the hard part) for you. Works like a charm. It has the following functions: getDatabaseNames (URL, password), getLayoutNames (URL, password, dbName), getFieldInfo (URL, password, dbName, layoutName), getScriptNames (URL, password, dbName), actionFind (this retrieves data from FM), and actionAdd (this adds data to FM or runs a FM script).
The plugin makes hooking Servoy up to a FileMaker app a breeze.
I haven’t released it yet because I haven’t figured out how to lock it down. It took a good amount of work so it’s probably worth a dollar or two contribution to my beer fund. If someone can give some pointers on how to lock down Java plugins, I’ll get it out the door.
Hi David,
Any progress on this?
Would this plugin also import a xml-file, or even export to a xml-file?
Good news: it works really well. Demo app is done. We are using it in-house daily.
More good news: as soon as the release candidate for Servoy “modular” is out, I will get cracking on converting the demo app into a module. This will allow you to add the module to ANY of your solutions and you will have connectivity to FileMaker just like that – voila. No coding required.
As to your other question, it does not import or export xml files. All you need to do to make this happen is to transform Servoys tab delimited export file to FileMaker’s FMXMLRESULT or FMDORESULT grammer using XSL:T. Reverse the process if you are going the other direction. Both of these transformations are available on FileMaker’s site in the XML section.
