Few simple Questions

[ar_malik]

Hi, I am a FileMaker beginner . I have a few questions.

1)Is it possible to use timer in a FileMaker Pro application. eg a script would run every day at 9 am.?

2)Can we have a script to download all .zip files from a given ftp site?

3)Can we unzip the .zip file in a FileMaker Application?

4)Can we read all .xml files in a given directory?

Thanks in advance.

[Fenton]

Few simple answers :-]

1) zippScript plug-in, free, from: http://www.zipptools.com/

or Troi Activator plug-in

2) MooPlug plug-in, free, from http://mooplug.com/features

3) Same as above

4) Same as above, to List Folder Contents

Then you would need a FileMaker script with a Loop to import each file.

You would need an XSL stylesheet(s) to transform your xml files to FileMaker syntax xml.

Every XML file is different (to some extent), that's what the "X" stands for: "Extensible"

So a custom-built XSL file is needed for each Import into FileMaker.

There could be multiple "levels" of data in the XML file, so a separate Import may be needed for each, with a (slightly) different XSL file. Same logic as importing from another multi-table database, an import per table.

There's a lot of examples here. But likely none exactly fitting your XML data. Show us a smallish example. Zip and upload it as an attachment to the post, as the PHP parser will mangle it somewhat if you copy/paste into a post.

[ar_malik]

Thanks a lot for your kind response and this valuable information. Yes I have idea about XSLT requirements for importing data. Will return to you if required.

Again Thanks for the help.