I want to connect to the filemaker pro 6 database from servoy.
The reason i am doing this I have an existing filemaker database.
The database has text and container fields.
I want to write a method that can loop through the filemaker records and save the images in the Filemaker container field to disk files. I think there is a function to save media field contents to a file.
Current I have to buy a new plugin for filemaker called Export FM to acheive what I have described above. Since I am going to do this for just one or two times, I do not want to purchase a plugin.
If you share the db by webcompanion you can use http://localhost/FMPro?-db=.fp5&-RecID=38010&=&-img to retrieve images from FMP, you only have to get the RecID for each record somehow (export might help).
Anonymous:
If you share the db by webcompanion you can use http://localhost/FMPro?-db=.fp5&-RecID=38010&=&-img to retrieve images from FMP, you only have to get the RecID for each record somehow (export might help).
Just as an experiment, I used http.getPageData to return a FileMaker container field (with a picture) into a servoy media field. Unfortunately, Servoy does not recognize the input stream as a picture but it was worth a try.
I think I would better buy Export FM plugin. Since this is for one of the final FM projects I would not worry about it. In the future I am sure we would not have these kind of hassles with Servoy.
Jan Blok:
Servoy 1.2 final will have plugin method getMediaData returning the image in binary format,so you could assing to a media dataProvider(blob column)