filemaker server load script

Posted on 2012-03-14
Last Modified: 2012-03-22
On my computer, I have filemaker client. I can open the database and manually execute scriptmaker script.

Now, I need to execute the script on the filemaker server. I have the admin console open. How do I open the database and execute the script? I tried to click on the database, and I selected the database, selected open, clicked on "perform action", nothing happens.

Also I created a schedule, I run the schedule, I know the script does not run successfully since the data I needed didn't come in. Is there any log file or something to let me know which step is wrong or tell me the script execute status etc? Thanks.
Question by:xiaoyunwu
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
LVL 25

Expert Comment

by:Will Loving
ID: 37721088
I only have a moment right now, but take a look at this knowledgebase article and see if it helps along with the additional links at the bottom.

Author Comment

ID: 37721604
I was able to figure out on the server machine, there're filemaker server and filemaker pro. Filemaker server is where I schedule script etc. Filemaker pro is where to open all the database and make the scriptmaker script. And now I see in the schedule after I run the script, there's a status tell me "scriptmaker script aborted", if I run the script via filemaker pro under that database and execute directly, it works. But if I schedule with server, it does not work, status is aborted. I make the script as simple as open a database, still get the same error, not sure what's the problem.
LVL 25

Expert Comment

by:Will Loving
ID: 37722028
Well, part of the problem is with your test script using "Open File". That script step is not supported for Server-side scripting. To see which script steps are supported, open Scriptmaker and then your test script. Go to the lower left corner of the Edit Script window and change the "Select Compatibility" option to Server. Only the script steps that are NOT grayed out are available for server side scripts.

I would suggest using the Set Field script set. Select a field that is easy to see the change in or create a new field for test purposes and add it to a layout out. You'll also probably want to use a Go To Record step before Set Field to make sure you're either on the first or last record.

Show script step compatibility
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 37722196
Now my problem becomes: how to schedule a script in filemaker pro instead of filemaker server. Or is this possible? Since the script is there already and can run perfectly in filemaker pro manually. I do not know how to and do not have time to rewrite the script. I only want the script to run daily by itself.

Author Comment

ID: 37722238
my version: FileMaker Pro 9
LVL 25

Expert Comment

by:Will Loving
ID: 37722297
Using Server-side scripting is the only simple way I'm aware of to have something run automatically in the background on a daily basis. There are other ways to do it but all require more involved scripting and setup. If the server-side script was working previously then it should be possible to get it working again.

You may get a clearer picture of what the error is by checking the FM Server Events log. See this FileMaker Knowledgebase article for more info on where to find it:

In addition, the fact that the script runs fine in FileMaker Pro probably means that there is something Server specific that is not right. I can think of two things that might cause that:

The use of an Import File location that is NOT allowed for FM Server - FM Server has a more restrictive set of allowed locations.
A script step that is not Server compatible.

Of those two options, I consider the first one to be the most likely since it doesn't appear that the script has been edited to include a step that is not server compatible.

If the script worked previously, then what has changed? Is the file to be imported being saved in the EXACT same location with the EXACT same name? Is that location one of the allowed location for FM Server? (it might be allowed for FM Pro but NOT server)  When you run it with FM Pro is the file being imported without a dialog or are you getting a dialog popping up indicating that the saved location for the file is not proving to be valid?
LVL 25

Expert Comment

by:Will Loving
ID: 37722320
> my version: FileMaker Pro 9

Another possible problem. If you are also using FileMaker Server 9, I'm pretty sure that server-side support of Import and Export was not introduced until FM Server 10. I recommend that you:


Check to see what version of FM Server you are running


Open the script with the SAME version number of FM Pro


Check to make sure that all script steps used in the script are compatible with the version of Filemaker Server.
If you moved this database "in-house" did you possibly switch from FileMaker Server 10 to FMS 9, for which Import and Export are not supported?

Author Comment

ID: 37722365
server version: FileMaker Server 9
All the server didn't change, since we used to have someone comes in or remote access our server to make things happen. Since I can't see anything in the scheduled list of server. And there're a lot of open, import steps in the script. I'm guess they somehow run the script somewhere else.

I found this one even though I'm not totally understand it yet.
LVL 25

Accepted Solution

Will Loving earned 500 total points
ID: 37722444
There are a number of options there though probably the best one is to have the script triggered by the last user closing out of the program. You use the option to run a script on File Close  (under File -> File Options) and it checks to see if Get( UserCount ) = 1  - meaning that person is the last person accessing the db - and then triggers the script.

However, that may not work if your Import file is not local on the machine that is running script. There is also a plug in called "ScriptFire" which may let you do what you are talking about with FM Server 9 but you'll need to figure out the programming.

I think that simplest and probably least expensive option in terms of both time and money (your time presumably being worth money)  to do at this point is to consult with former developer and find out how they did it and why it may not be working.

I would again say I can't understand how the script could have been run automatically using server-side script scheduling using FileMaker Server 9. It is my understanding that that function simply wasn't supported by FMS 9. If they were using 9 and doing importing, then they must have been triggering the script another way.

Author Closing Comment

ID: 37753897
Hi willmcn,
Thank you so much for all the help.
I eventually used scriptfire plugin as you mentioned in the link: It works great.
I did see "Run script daily.fp7" on the server that might have been what former developer used.
Thanks again!

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question