Shared file can never find temp file?

[Justin P.]

Not much FMP Server experience, so am running into the following problem, and cannot seem to get around it.

I have a solution with the following files:

(A) "SOLUTION.FP7". It is a multi-user solution hosted by FMPServer.

( "TEMP.FP7". Used solely by an import/export script from file (A). Not viewable by open remote file dialogs, and is not even a shared file (am I reasoning this correctly?)

The script in (A) is supposed to just Export a set of records to TEMP.FP7, then call TEMP.FP7 to import them back (into an separate table) and clear all records in TEMP. All without user interaction (file names are set).

Works fine on a standalone machine, but when I move the solution to the Server, TEMP.FP7 can never be found by the script. (File references look correct?)

The script always throws up a dialog box for where to find the TEMP file (which is useless, because the TEMP file cannot be found by an average user as he/she who cannot mount the server, and it is not shared in the open remote dialog).

Is there something I am missing here re: location of TEMP file at the server level? Or more likely, a vastly more efficient way to do this? I just feel like I am not properly understanding the settings required for multi-file solutions between "Sharing", "Dispay in open remote menu", and File References.

Thanks for you help.

[Ender]

(A) "SOLUTION.FP7". It is a multi-user solution hosted by FMPServer.

( "TEMP.FP7". Used solely by an import/export script from file (A). Not viewable by open remote file dialogs, and is not even a shared file

All files that are part of the user's process must be accessible to the user's workstation. You should try turning on Sharing for that TEMP file, and see what happens (you should still be able to hide it from "Open Remote...")

If you are worried about users tinkering about in it after it has done its job, close the file after the import. you can also change the privileges on that file so users don't have access to layouts.

[Vaughan]

Make sure FMS is updated to 7.0v2 and the clients are using FMP 7.0v3. All earlier versions have problems with import.

[DykstrL]

All file references for files hosted on a FM server are based on the client/user - NOT the server. If you can't access/open the file using a client machine and user logon/ID your setup won't work.

At least, you would have to host the file on the server as shared(hidden).