Re: Quickbooks functions

On Thu, 15 May 2008 13:10:48 -0500, "ARC" <PCESoft@xxxxxxxxxxxxxxx> wrote:

Hello all,

Does anyone have any access functions for quickbooks integration, or have a
link with access examples for some basic importing / exporting?

Many Thanks,

I have done a lot of work recently integrating one of my applications with
QuickBooks using the QB SDK.

Once you get your head around the way their files need to be formatted it was
surprisingly simple to get working.

Each specific (allowed) operation in QB can be automated by generating an XML
string containing the required data for the specific request. You use a
recordset to seed the XML string with data from your database.
The XML string must be in exactly the right configuration for the request (add
customer, modify order, adjust inventory etc) and the version of QB you are
using.

You can use whatever method you are comfortable with to create the XML as long
as the end result is in the correct format. The SDK includes a utility to paste
the XML string into and test that the format is correct. It will give the
starting character number of any error found in the string. The utility makes
debugging the XML very easy.

Once the XML string is created you pass it to QB for processing. If the request
is successful QB will return a response also in XML containing an EditSequence
code and an error report. You parse this response to check the error code. The
response will return 0 if the request was completed successfully or a specific
error code for any failure. You include an error handler in your code to handle
any errors and resubmit the response.

If you email me I have some documentation that might help you.


Wayne Gillespie
Gosford NSW Australia
.

Relevant Pages

  • Re: Quickbooks functions
    ... Maybe I'll have another look at the SDK in the near future. ... The XML string must be in exactly the right configuration for the request (add ... You parse this response to check the error code. ...
    (comp.databases.ms-access)
  • Re: Quickbooks functions
    ... All in all, some developer should post the access functions one of these days to the accessweb.net, or something similar. ... The XML string must be in exactly the right configuration for the request (add ... You parse this response to check the error code. ...
    (comp.databases.ms-access)
  • Re: Reading XML Stream in C++
    ... My code below sending request to web server and getting response as XML string. ... char* response; ... where outout of above function returns xml string which is stored in response variable. ...
    (microsoft.public.dotnet.languages.vc)
  • Reading XML Stream in C++
    ... My code below sending request to web server and getting response as XML ... where outout of above function returns xml string which is stored in ...
    (microsoft.public.dotnet.languages.vc)
  • Reading XML stream using unmanaged c++
    ... My code below sending request to web server and getting response as XML ... where outout of above function returns xml string which is stored in ...
    (microsoft.public.vc.mfc)