1 of 1 people found this helpful
First of all you may consider using FileMaker Go instead of iformbuilder - then your import problems will all just disappear!
If you were to use FileMaker GO on the iPhone and FileMaker Pro on your server then the data would be updated live. If I form builder can get the data into an SQL database then FileMaker can access it live using ESS technology. Otherwise you'll need to build a periodical import - but FileMaker will do that for you with a single click of the mouse when you import the data for the first time - simply select the option to perform a repeated import.
FileMaker can import only one excel worksheet at a time but you can write two imports to import the two worksheets one after the other. You can have one table in FileMaker if both imports share the same ID, the second import is an update with matching ID.
Prob xls is your best choice. Xls analytics I don't know. If you meant XML that's also a possibility but you need to write your own XSLT transformation. JSON is not a supported format; you could import it as a text field and parse it yourself but it's a lot of work. Any XML format is potentially importable.
Regarding the image URLs: FileMaker 12 has a new script step to download items from a URL and so it is possible to download the image residing at a URL into a container Field.
Hope that helps!
Thanks for the info MrWatson!
You make a good point about Filemaker Go... Don't know if the company would go for it as they already have a lot in place with it, but worth a shot.
If we can't access it with ESS, how "periodical" is the periodical import you mentioned (seconds, minutes, hours?) I did mean XML, sorry about that.
Would you be able to point me in the right direction for that script to download items from a URL?