I created a database that has a script that exports the records to an HTML using a XSLT file. The problem is when I run the database locally on my machine and run the script, everything works fine, the file is created fine. However when I open the database remote from the server and run the script, the file is not created for some reason.

The setup on my machine and the server is exactly the same way....

Is there a difference in terms of running scripts particularly exporting the records to a file.

Thanks.

Are you expecting the file to end up on the server? Cause that's not gonna happen.

If you have suppressed the save dialog box it's probably going to end up in a similar location on the client computer as it does on the host computer when you run it there... try searching by filename if you can't find it.

Well i don't expect it to exist on the server but on the local computer itself that opened the database remotely. When I click the script. It didn't create anything. But when i go to the server directly and run the script, the file is created on the server as expected.

I do think it has something to do with running the script with no dialog. It may be something with attempting to reference the XSLT that though it exist in both the server and the local machine running the script the script was initially setup to reference the XSLT in the server (which is in the memory of the script) but this doesn't really work when accessing remotely since cause then the reference is different.....

I'm not sure but I could be totally off base here.....

One of the problems that I fixed was that it was attempting to use a stylesheet that did not exist on the computer opening the databases remotely. However the problem now is that when I run the script, the files are created in the FileMaker Pro folder and not where I was expecting to, which is a folder that I created the same way as in the server.

I have feeling that filemaker pro is attempting to save it based on the relative path to database and since the database is opened remotely, then the relative path would not work.

Is there a way to specify exactly where to export the file without having to open a dialog.

Thanks.

You'll need to use some plug-in like DialogMagic or oAziumFileTools.

Dj