Our membership app resides on a Rackspace server. It's a FoxPro app that uses FoxPro free tables. Our client wants the ability to have members pay dues online. We are looking into http://www.authorize.net/ for the processing center.
Current Membership payment data needs to be available to the payment website to be able to process the correct dues payments, as rates vary and late fees may apply. At the end of the day we will import the transactions into our app through a process within our FoxPro app.
Our idea is that our app creates a table of current membership information which is sent (somehow) to the payment website. Members will use the website to make dues payments. At the end of the day, the website app will send the transaction data to our server on Rackspace (somehow) so we can import the dues transactions. After processing the transactions, our app will refresh the website data with current membership data.
We're not sure how to implement the "somehow" (i.e. send/receive data) to/from the website that submits the payment to the processing center. We're also open to other ideas. Our client's web developer says that there are tools out there to do this, but our initial Google searches have not come up any solutions thus far.
Here's a simple diagram of what we're trying to accomplish http://imgur.com/iKvkfNZ
Thanks in advance.
-Ric
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---