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 ---
You might look to Square to design your payment portal as they have one of the best systems for handling money for small organizations as other web developers have said.
Interacting with VFP data files is probably the biggest hurdle to overcome unless you set up a west wing service to do all the work for your web site with respect to data and payment amounts.
On Tue, Apr 5, 2016 at 8:24 AM, Richard Caruso rcaruso@acutedesigns.com wrote:
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
[excessive quoting removed by server]
OK, we'll take a look at Square. And you are correct, we're looking for solutions to transfer data to / from web server....that's the hurdle we're wrestling with.
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen Russell Sent: Tuesday, April 05, 2016 9:34 AM To: ProFox Email List profox@leafe.com Subject: Re: Online Dues Payments
You might look to Square to design your payment portal as they have one of the best systems for handling money for small organizations as other web developers have said.
Interacting with VFP data files is probably the biggest hurdle to overcome unless you set up a west wing service to do all the work for your web site with respect to data and payment amounts.
On Tue, Apr 5, 2016 at 8:24 AM, Richard Caruso rcaruso@acutedesigns.com wrote:
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
[excessive quoting removed by server]
On Tue, Apr 5, 2016 at 11:19 AM, Richard Caruso rcaruso@acutedesigns.com wrote:
OK, we'll take a look at Square. And you are correct, we're looking for solutions to transfer data to / from web server....that's the hurdle we're wrestling with.
From Square you can take the payment, give them the confirmation # post the
transaction to your VFP environment somehow. Putting up a web service may be required to pass the data from your VFP to square and for square to send you back for your insert into VFP.
On Tue, Apr 5, 2016 at 9:24 AM, Richard Caruso rcaruso@acutedesigns.com wrote:
Our membership app resides on a Rackspace server. It's a FoxPro app that uses FoxPro free tables.
Is this:
an APP or an EXE or something else?
(a) a web app, running a web framework like FoxWeb, Web Connection, the VFP sample code? (b) a VFP desktop app, accessed via RDP? (c) a FoxPro for DOS 2.6a app?
The membership application is a compiled FoxPro 2.6 windows EXE. The client's office staff access the application via an RDP session. The membership do not have access.
The website will be hosted on a web server separate from our Rackspace server.
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Ted Roche Sent: Tuesday, April 05, 2016 10:17 AM To: profox@leafe.com Subject: Re: Online Dues Payments
On Tue, Apr 5, 2016 at 9:24 AM, Richard Caruso rcaruso@acutedesigns.com wrote:
Our membership app resides on a Rackspace server. It's a FoxPro app that uses FoxPro free tables.
Is this:
an APP or an EXE or something else?
(a) a web app, running a web framework like FoxWeb, Web Connection, the VFP sample code? (b) a VFP desktop app, accessed via RDP? (c) a FoxPro for DOS 2.6a app?
You shouldn't have to send or retrieve full tables to or from Authorize.net; you can do individual transactions instead. Furthermore, you can even process the transaction within your own app with a simple API call to Authorize.net. Make sure you visit their developers' pages at https://developer.authorize.net/.
Mike
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Richard Caruso Sent: Tuesday, April 05, 2016 7:24 AM To: profoxtech@leafe.com Subject: Online Dues Payments
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
I was browsing through the AVFP** discussion site and came across this link re. Foxpro speed: http://stackoverflow.com/questions/34667084/c-sqlite-performance-vs-foxpro-f...
** anyone using it? I've got a test setup running fine locally and on GoDaddy / BigRock
AVFP, no, but I'd like to learn more.
SQLite, yes. Whil Hentzen wrote a book about using SQLite for data import when data sources exceed 2 Gb, to pare down the data for final import into DBFs. I edited that book, and found that SQLite was a pretty nifty little database engine.
On Sat, Apr 9, 2016 at 11:34 PM, AndyHC andy@hawthorncottage.com wrote:
I was browsing through the AVFP** discussion site and came across this link re. Foxpro speed: http://stackoverflow.com/questions/34667084/c-sqlite-performance-vs-foxpro-f...
** anyone using it? I've got a test setup running fine locally and on GoDaddy / BigRock
[excessive quoting removed by server]
On 10 April 2016 at 13:07, Ted Roche tedroche@gmail.com wrote:
SQLite, yes. Whil Hentzen wrote a book about using SQLite for data import when data sources exceed 2 Gb, to pare down the data for final import into DBFs. I edited that book, and found that SQLite was a pretty nifty little database engine.
SQLite is a great but it's not designed for multiple users. It's perfect for a single user app, or for storing local configuration etc.
I wrote a small app in C# for my own use and it works really well.
On Sun, Apr 10, 2016 at 2:22 PM, Paul Hill paulroberthill@gmail.com wrote:
SQLite is a great but it's not designed for multiple users. It's perfect for a single user app, or for storing local configuration etc.
Yep. Works great as a small, light database when I'm doing development, then I can ship staging/testing/production code to another platform for multi-user stuff.
It's also handy to learn how to use, as many products come with it as their data store.
On 2016-04-09 23:34, AndyHC wrote:
I was browsing through the AVFP** discussion site and came across this link re. Foxpro speed: http://stackoverflow.com/questions/34667084/c-sqlite-performance-vs-foxpro-f...
** anyone using it? I've got a test setup running fine locally and on GoDaddy / BigRock
From the article: "If you needed to parse the lines, then VFP is quite slow on string operations, compared to C#."
Really?!??
I've read a lot time ago that this is true because C# string optimizations where made by part of the Fox Team :)
So yes, I believe that the same people that made VFP Great can enhance some parts and implement them on another language.
Edit: Found some old articles: http:// http://www.codemag.com/article/030054www.codemag.com http://www.codemag.com/article/030054/ http://www.codemag.com/article/030054article http://www.codemag.com/article/030054/030054 http://www.codemag.com/article/030054 https://blogs.msdn.microsoft.com/vsdata/2005/02/10/exploring-vb-net-from-a-v...
Regards
On 2016-04-09 23:34, AndyHC wrote:
I was browsing through the AVFP** discussion site and came across this link re. Foxpro speed:
http://stackoverflow.com/questions/34667084/c-sqlite-performance-vs-foxpro-f... http://stackoverflow.com/questions/34667084/c-sqlite-performance-vs-foxpro-for-importing-files
** anyone using it? I've got a test setup running fine locally and on GoDaddy / BigRock
From the article: "If you needed to parse the lines, then VFP is quite
slow on string operations, compared to C#."
Really?!??
[excessive quoting removed by server]
No. There's lies, damned lies, and then there's benchmarks.
I've seen benchmarks showing VFP really slow parsing text files, because the coder had never seen _MLINE nor knew how to use it. VFP can be wickedly fast if properly tuned. As George Goley pointed out, all you need to do is take out the slow parts.
Also, the OP's article has VFP using raw APPEND, a single command, while C# is using ODBC and transactions on every single insert. Totally unfair. If you were bulk-loading a SQLite database, you'd use the built in import tools, and not a scripting language through an ODBC driver.
https://cs.stanford.edu/people/widom/cs145/sqlite/SQLiteLoad.html
But if the original post is saying that bulk data load is faster than passing individual transactions through ODBC, well, yeah. But not a fair apples-to-apples comparison.
On Mon, Apr 11, 2016 at 10:30 AM, Fernando D. Bozzo fdbozzo@gmail.com wrote:
I've read a lot time ago that this is true because C# string optimizations where made by part of the Fox Team :)
So yes, I believe that the same people that made VFP Great can enhance some parts and implement them on another language.
Edit: Found some old articles: http:// http://www.codemag.com/article/030054www.codemag.com http://www.codemag.com/article/030054/ http://www.codemag.com/article/030054article http://www.codemag.com/article/030054/030054 http://www.codemag.com/article/030054 https://blogs.msdn.microsoft.com/vsdata/2005/02/10/exploring-vb-net-from-a-v...
Regards
On 2016-04-09 23:34, AndyHC wrote:
I was browsing through the AVFP** discussion site and came across this link re. Foxpro speed:
http://stackoverflow.com/questions/34667084/c-sqlite-performance-vs-foxpro-f... http://stackoverflow.com/questions/34667084/c-sqlite-performance-vs-foxpro-for-importing-files
** anyone using it? I've got a test setup running fine locally and on GoDaddy / BigRock
From the article: "If you needed to parse the lines, then VFP is quite
slow on string operations, compared to C#."
Really?!??
[excessive quoting removed by server]