I'm not sure if the script step is supported, but why don't you use the native FM Go Save/Send command?
When connected to the remote file through FM GO the save/send Database and field contents are greyed out. I cannot choose either.Is there a setting?
I'm sorry, I think I misundestood your original question. So basically they are triggering a remote script step on the solution file which is hosted elsewhere and not on FM Go...
I don't think you will be able to do that through FM Go unless you are using FM server and a scheduled script, or you trigger a remote script that runs on the host machine that will actually take care of the job of saving the file copy and creating and sending the email. I think the reason may be that when you run it through FM Go it dosnt have access to the saved fp7 file in order to attach it to the email...I am assuming the FM Pro 11 machine is the actual host machine?
Thanks for helping out. Yes FMP 11 machine is the host. On the FMP 11 host is a database named AR.fp7. If I open AR.fp7 on the host, run the script "Send it", the email is generated, AR.fp7 is attached. Received in email on ipad, saved as local version. But if I go from the ipad, open AR.fp7 on the FMP 11 host, the script does nothing. I'll try to put some erro codes in and debug the script unless you have any better ideas. Again, thanks!
It's not a debugging issue, it's simply that FM Go does not have access to the specific saved file on the host in order to attach it to the email to be sent. Dont forget that the script is actually being executed on the iPad not the FMP host when you access through FM Go. It works when you access through FMP 11 because you are actually on the same machine as the file. In order to do what you are trying to do, you wither need to host the file on FM Server and use a scheduled script to pick up the Save Copy and send by email request and run it on the server itself, or find a suitable plugin that allows the execution of remote scripts and trigger a script to run on the FMP host machine that will save the copy and email it.
I hope this all makes sense.
There are other ways to get the database or data to FM Go.
If it is only the data that changes, you could make a script that imports the new data from the server to FM Go
If you want a new version of the database, you could run a script every day/hour or so that saves a copy of the
database and imports that copy into a container field.
Then open the server hosted database (you can use a single record file with only the container field for this purpuse)
close the database on FM Go and export field contents the new copy of the file to replace the old copy.
Hope that helps,
Ruben van den Boogaard
Thanks Ruben. I'll have to try this approach. Now the question is which do I mark as the correct answer? Both should work. I have FM Server licenced as well but not installed. That probably is the best production solution. I'll have to give that a try as well. I last did FMP development on version 7 so this is all new to me. I appreciate the assistance.
I was able to setup Ruben's solution above.
1 of 1 people found this helpful
Ruben's answer is a good alternative to delivering the database via email, however it is still essentially the same method of generating the file. If you want to allow users to create and download copies of the file on demand, you will need to create a record in a "trigger" table on the server and then have a scheduled script read the trigger table every 1-2 minutes. If it finds a job then it emails or imports the file into a container...
Thanks again. I really am not up to speed on development. Luckily the external data we are using is only updated daily. Therefore there is no need to update every minute or hour. I don't know if you get docked points or any sort of reward system here like I have seen on other forums, but both you and Ruben provided solutions.