Sending runtime solution data to main server via php

[Adrian McManus]

I'm trying to find the best solution to send data to our main server from our runtime solution. I have a runtime solution that each user creates bids with. The users are not always connected to the internet so that's why they are using the runtime solution.

I want them to be able to send the bid data to our main server once they are connected to the internet. I thought I would just use PHP to interact with our Filemaker server which is hosting the file. It also has web publishing (PHP) enabled.

Could someone point me in the right direction on how to get the runtime solution to send the data via php to my main server? I'm not sure if I could just script a loop with the web viewer, or use the troi url plugin etc...

Thanks in advance,

Adrian

[TheTominator]

If your bid data is very small, you could simply send each one to a web server using URL encoding of the parameters. For example...

http: www.example.com/submit_bid.php?user_id=5000&bid_amt=179.80&item_id=2423

This can be sent using the runtime via the Open URL script step.

[Baloo]

How much data are we talking about?

I don't have too much experience with runtime solutions and as such don't have a handle on their limitations, but the first thing that comes to mind is a Open URL script step that passes the data to a custom php script on your server.

[Adrian McManus]

I was trying to stay away from Open URL script because I may need to send several bids at a time and I don't want the runtime solution having to interact with their web browser.

Here is what I was hoping to create:

Bid table has 3 records

Bid1

Bid2

Bid3

Loop...

Send Bid data to PHP page linked to my filemaker server and create the record.

Return the record id from the hosted filemaker file.

Upon successful return of the record id mark this bid as uploaded.

Repeat for each Bid.

If I want a seemless integration for the end user I'm going to need the troi URL plugin or are there other plugins that would achieve this result?

Thanks,

Adrian

[TheTominator]

If you don't want to use Open URL, you can use Set Web Viewer to achieve the same result.

You can scrape the web viewer contents to get the result.

As to plug-ins, a specialized plug-in to interact with a URL is an option or you can program the code yourself with the more general ScriptMaster or SmartPill PHP plug-ins.

Edited July 14, 2010 by Guest