I am in desparate need of help in trying to solve the following problem. For my manufacturing business, I have developed a rather large solution. We run FileMaker Server v11 / some desktops (Mac's) and iPad's out in our factory. And for those involved in admin or out on the road, we all have iPhone's.
On the iPhone we all use Prowl. Prowl (a la Growl) we use because it is the only way I have found to get notifications onto the screen of the iPhone. Sending ordinary email gets missed and so we need a notification process on the iPhone that is in your face!
FileMaker Server is scheuled to run scripts that uses the Prowl email facility to send notifications to employee's iPhone's. An email is sent to Prowl instead of their ordinary email account to convey important messages.
Prowl has an http protocol that allows messages to be sent instead of using email.
The Prowl API --- I do not understand! BUT - I know how to construct the HTTP string. If I copy and paste the string into a web browser, I get the desired results.
Equally, I know how to write a script in FileMaker that uses the OpenURL function. I construct a $url variable into the required format from data inside of our database.
But, here are my issues:
1. The Open URL function opens a web browser page. I don't want this.
2. The Open URL function does not run from FileMaker Server - which is where I need it to run.
3. I am aware of plug-ins e.g. 360Works, that allow the Open URL function to work server side; I am also aware that 360Works have a Prowl API custom function. But, I do not want to install any plug-ins.
4. The email to Prowl feature works ok --- providing there are no SMTP issues. And we do get these from time to time.
So, where am I going with this.....I know on FileMaker Server on our MacMini that it is possible to run system scripts at pre-determined times.
Given I am an idiot, I really just want to construct the URL string in FileMaker and have the system script literally send the HTTP request as http://<my string from FileMaker>
But I have no clue how to do this. I have reserched for many hours on the Internet but I am totally lost. PHP; Pearl etc mean nothing to me.
Can anyone spare a few minutes to explain (a) if this is possible and (b) how this may be done?
I hope this makes sense.
Thanks in advance