Hi everyone, I'm currently trying to export a table from database in Excel format every week.
I have tried to use the Gateway scheduled scripts, and seems it would execute as expected. But I couldn't find the file under the file path.
The script itself works fine when I run it in the Script Console.
Could anyone give me some clue about it?
Script console is a modified client scope (Runs on your/designer computer), gateway scheduled scripts run in a gateway scope(Runs on the gateway machine). Did you check that path on the gateway machine to see if there were files there? Are there any errors in the logs around the time the script runs?
This script is either running into permissions issues on the gateway server, where the ignition service might not have write access to the specified location, or you are running into the problem of the specified folder not existing.
2 Likes
Thank you ryan. How Can I check the path on the gateway machine? I have just started to learn Ignition.
According to the gateway status, the scripts has been executed successfully, so I believe the file might exist under the path of the gateway machine.
And is it possible to run a scheduled scripts under the client scope instead of the gateway scope?
You would have to remotely connect to the server that is running Ignition and browse through the file system there.
Nope, scheduled scripts are gateway scoped only.
Ok I'll try it. Thank you!