| June 2004 | ||
| Quickbooks RDS Client for PHP/Apache/Linux | ||
| Transactional Web, Inc. has released the first public open source client for integrating PHP/Apache/Linux web applications with Quickbooks desktop RDS (Remote Data Sharing, RDS) interworking. | ||
The source code is here: class.qbrds.inc Thanks to many of the folks on the Inutit deveoper's web site for making this possible. Based on a few comments, we've added a bit more wrapper around it so "out-of-the-box" you can pull the whole chart of accounts out of QB RDS Server. Those modifications are here: rdsclient.php Using this version, you know something is working, when it works.
|
||
| This code extends the NuSOAP class published by Dietrich Ayala and Scott Nichol and is documented here: http://dietrich.ganx4.com/nusoap/ (By Dietrich) and here: http://www.scottnichol.com/soap.htm (By Scott Nichol) The particular version tested with Quickbooks RDS Server 3.0 was downloaded from Sourceforge. | ||
| Included with this class is a small driver to instantiate the class and make a default call to a specific RDS Server. You can modify the parameters to suit your specific situation. Written in PHP, it relies on CURL and SSL. | ||
This code instantiates a PHP/Linux client that finds and exchanges messages with the Quickbooks RDS server. It helps if the PC running your Quickbooks RDS Server is behind a firewall that allows the specific traffic through. In addition, it is required that the PC host name be listed either as a FQDN DNS entry and/or listed in the client's (i.e. web server's /etc/hosts file. SSL traffic requires the DNS entry to match the host name of the target machine. You have to build your own QBXML messages to hand off to this object, which returns a response QBXML message from the RDS Server it targets. This has been tested across the Internet from a public web server to private PCs. |
||
| Suggestions
for improvement are welcome. We have offered this code to several public
sites for ongoing maintenance and discussion, but offer it here as a timely
response to Quickbooks developer's needs.
Earle West CTO, Transactional Web, Inc. Marlboro, NJ earle.west@transactionalweb.com 732-420-8456 |