Server Blues

[hexxabubba]

I'm confused...Have a box with Windows XP and FMP 9 client version with File Sharing turned off as server. There are approximately 4 users.

I’ve been trying to set up a script for 1 of the users to import from an XLS.

I have not been able to automate the script; as I think it should work. I simply want the user to import an XLS from the same folder on a desktop that has the same name. Works great in a non-server environment. It should work…

When the database opens the “set path” script runs:

Set variable [$$path;If( PatternCount ( Get ( SystemPlatform ) ; 1 ) ; "filemac:" ; "filewin:" )"]

Set variable $$desktop; Get ( DesktopPath )]

and then when the user is ready to import it calls the Import_from_Excel Script

Set variable [$filename; "/XLS/" &"Test"&".xls"]

Set variable [$fullpath; $$path & $$desktop & $filename]

Import Records [no dialogue: Source: $fullpath; update matching]

I am also trying to implement a simple backup script to the file. Works great in non server environment, but fails when using server.

Upon closing:

If [ get ( usercount ) = 1 ]

Set variable [$pth ; "Filewin:/C:/Backups/" & "Filename" & substitute ( getastext ( get ( currentdate ) ) ; "/" ; "_" ) & ".fp7" ]

Save a Copy As [ $pth ]

I tried to do the save as from Menu but was grayed out. I did get Filepath at one point of file:../../../Backups/test.fp7. And it worked when I had file non networked. What does the ../../../ mean?

I switched out a logo and when the file would reboot; the logo had switched back to the original. Yes it was the same file; being accessed through remote access. It's a global container field. To fix it, I ran tskmnger, and ended all Filemaker proccesses, dragged a copy to desktop, fixed logo. and replaced...

I didn't set the server up; but the folders look like how you would expect Filemaker server; but it is using Client.

And Finally. I tried to create a simple launcher, and I couldn't figure out how to close the launcher. Everything seemed to work except the last step...

Set Error Capture [On]

Open File [< pick your file from the list. Since you only made one file reference you'll only have one file in the list >]

If [PatternCount(DatabaseNames, "YourIntendedFileName")=0]

.. Show Custom Dialog ["Unable to open file at this time. Call IT Dept if you keep getting this message." / "OK"]

End If

Close File [Current File]

I even tried to have the main file open script close it; and that didn't work.

HELP!

[IdealData]

The "Save As" command is disabled for clients in all networked/hosted environments. It's an obvious security issue - anyone could steal the file!

As for the IMPORT, please post the script. A PDF print or image capture should suffice.