This one has me stumped.

 

I'm trying to use a web viewer in FileMaker 11 to look up a value from a website. I then use that value to find a record set and email the results. It works when I do it on the client, but when I run it on the server as s scheduled script it does not get the value. I also tried doing it with a startup file to trigger the script from a Windows Schedule and that failed as well.

 

In order to simplify it, I set the script to just lookup the value and email it to me. Current script:

 

Set Error Capture [ On ]
Go to Layout [ “Tasks | processing” (Tasks) ]
Refresh Window
[ Flush cached join results; Flush cached external data ]
Set Variable [ $count ]
Loop
Set Variable [ $count; Value:$count+1 ]
Exit Loop If [ $count = 50000 ]
End Loop
Set Variable [ $GDD; Value:GetLayoutObjectAttribute ( "web"; "content") ]
Send Mail [ Send via SMTP Server; To: "[email protected]"; Subject: "Task " & Tasks::pk_task ID & " for " & Get ( CurrentDate ); Message: "Current Degree Days: " & $GDD

 

The loop is to allow time for the page to render. I've tried upping it to as much as 1 million and still no luck.

 

Again, this works when I run it from the client, both on my computer and on the server, but not when I'm scheduling it.

 

Anybody see what I'm doing wrong or have an alternate suggestion? I really need this to be automated and run overnight.

 

Thanks!

SetWebViewer is not a Server compatible script step. There is no GUI on a server side script...

 

You will need a copy of FileMaker Pro to run that script - I use simple files that are launched by Task Scheduler and call the relevant script.