Filemaker 6 and the Web

[mikemccloskey]

I am completely mystified. I would like to set up a website/page that collects information into an online database (sql?) that then integrates or downloads this collected info into FMP6. I see info on plugins, odbc, etc., but am stuck trying to understand this. Can anyone help? Thanks

[Garry Claridge]

I believe many ways may exist to achieve this.

One way would be to have FM "scan" the MySQL database periodically for any new data. You may be a ble to do this with AppleScript. The AppleScript could call a PHP script on the hosting server which returns new records.

Good Luck.

Garry

[mikemccloskey]

Thanks Garry, will I need to have a plugin to accomplish this?

Mike

[Garry Claridge]

No Plugin needed :

Garry

[mikemccloskey]

Hmmm. Don't know how to configure Applescript for this. Any other thoughts?

Thanks

Mike

[Garry Claridge]

Here is the AppleScript I've used in a Scriptmaker "Perform AppleScript" step:

tell application "URL Access Scripting"

download "http://10.0.1.22/all/tests/fmsync/index.php" to "Library:WebServer:Documents:all:tests:fmsync:datafile.tab" replacing yes

end tell

The next step in the Scriptmaker script is"Import Records".

That's it two lines!

The PHP in the "index.php" script returns a tab-separated file with data from a MySQL database.

Good Luck.

Garry

[Garry Claridge]

This has also been tested with FM7.

Garry