server side image export and create folders

[Jonas Löfvenmark]

I need to set up a server scheduled script to export a bunch of images, to a different drive than the filemaker server installation. Also I need to be able to create folders at this location. I have tried creating a shortcut in the data/documents folder and used get(DocumentsPath) & "myfolder" but this does not work. Also tried using "myfolder.lnk" with the same result.

Enviroment is Windows Server 2008, and FMSE 11, also I have the mooplug and CNSImage plug-ins installed. As I am a OS X dude myself I am in desperate help of anyone with windows folder mapping or FMSE experience of this or similar situation. Thanks!

[bcooney]

Take a look at SuperContainer.

[Steven H. Blackwell]

I need to set up a server scheduled script to export a bunch of images, to a different drive than the filemaker server installation. Also I need to be able to create folders at this location. I have tried creating a shortcut in the data/documents folder and used get(DocumentsPath) & "myfolder" but this does not work. Also tried using "myfolder.lnk" with the same result.

FileMaker Server must have permissions to read and write (at a minimum) to the target location. FMS runs under Local Service. be sure the permissions are correct.

Steven

[Wim Decorte]

A couple of issues here I think:

- it's better to export locally and then use OS level features to copy the exports to a mapped drive. FMS by default runs as "local system" under Windows and that does not have any rights to network resources like shares.

- a FMS script sequence schedule can take care of this because you can specify an account with rights to the network share to move the files there. Note that you'll need to use the UNC syntax of the share and not use a mapped drive since this will run in "non-user" space. The UNC syntax will look something like this: serverNameshareName

- I'm pretty sure that you can not use a FMS server-side script to export from a container field. But I could be wrong here. Check the server-compatible script steps to verify this. If it can't you'll need either SuperContainer or use a robot client machine.

[bcooney]

You might find this thread interesting (using ScriptMaster).

[Jonas Löfvenmark]

Thank you all for all your input!

I have this working for one hosted file, but strangely enough not for the other; by setting the filemaker service to "allow desktop access" I can export to a server side local drive by using the CNSImage_Export function on a variable. Exactly what I wanted! Why this only works for one of the files is a mystery. Both file's script run fine from the client, but only one of them from the server. Both files have the same user with full access, and both scripts are run with full user access.

Next I will look into importing images from a network share, and I found out by trail and error that it does not work (@Wim Decorte: thanks for confirming), and will have to look at the ScriptMaster thread (@bcooney: thanks for the tip)!

I did try to set up a different user with full access for the FM service, but then I could not log on to the filemaker server. Any input on that is greatly appreciated.