Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Filemaker 6 and the Web

mikemccloskey
in Custom Web Publishing

Featured Replies

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

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

  • Author

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

Mike

No Plugin needed :

Garry

  • Author

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

Thanks

Mike

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

This has also been tested with FM7.

Garry

Create an account or sign in to comment

https://fmforums.com/topic/38199-filemaker-6-and-the-web/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.