Stupid Import Question

[presley]

Hi,

Stupid server scripting question from a dummy!

I am "pushing" (cron job) from a MySQL DB into a folder on the puter that houses Filemaker Server Advanced 8.5. I then have written a script step (importing records) from a FM client on a remote machine that accesses FM Server and "updates" a file and adds new records by importing from the MySQL file....and it works!

My trouble is ---

1) I want another user , with an FM client, at a remote location to be able to use the same script step and update records---

2) The "import" script step is not web-compatible

3) Even if the script step was compatible it still opens a dialog box for you to navigate and fing the MySQL(.xls) ...impossible to do because it is located on a remote non-mounted volume....

I guess my larger stupid question is: How do you make script steps within FM Server that become usable/workable on a variety of remote machines with an FM client?.....

This must be EZ ...I don't get it ...it is so different than php and MySQL....

[Keith LaMarre]

First of all - the FileMaker Pro Server should NEVER also be a file server.

Then you have a larger question - i.e. how to get a remote user connected to a FM Server without using the web - unfortunately, this requires either a Terminal Server and the costs associated with that or timuktu/pc anywhere or something else.

Assuming you could do that, then a connected client can import from any available location - and FileMaker can also generally "export" data to any "known" location as well.

Or maybe someone has a solution for the web that DOES allow imports -

[Steven H. Blackwell]

I am "pushing" (cron job) from a MySQL DB into a folder on the puter that houses Filemaker Server Advanced 8.5. I then have written a script step (importing records) from a FM client on a remote machine that accesses FM Server and "updates" a file and adds new records by importing from the MySQL file....and it works!

[color:red]Which must mean that you have a share enabled on the FMS CPU, and that's not a good idea.

Put it somewhere else.

In response to your other question, FMS 8 does not support server side script execution as that term is generally understood. There are some things that can be done to trigger certain scripts via Custom Web Publishing, but that is somewhat different.

OTOH you could simply import the records from the SQL table into FileMaker Pro directly, either with the Perform SQL Scriptmaker step or with a plugin.

Maybe take a look at the Server Admin Guide on the FMI website.

Steven

[Wim Decorte]

Why not use FM's XML interface or even ODBC/JDBC to write directly from your mySQL interface to FM server. There really is no need to try and have FM import it and fight the web compatible script steps. FMS has all the necessary features that let you write data directly to it. That's one of the major improvements in FMS 7/8: no need for robot FMP machines to write data to FMS.