Integrating Servoy with Quickbooks

Classic Servoy
1

Does anybody know if it is possible to push data from Servoy into Quickbooks either directly or through a 3rd party application?

TIA

2

Michael,

Sure - use XML. (controller.printXML to a variable or to disk and then pass it to QuickBooks with executeProgram or import from QuickBooks).

I haven’t worked with that integration in many years - but I know that some people in the FM world built a FM plug-in that uses XML to do the transfer.

That’s a GREAT IDEA for a plug-in or product!

Bob Cusick

3

Intuit now provides the ability to update dynamically bidirectional via the QuickBooks SDK.

Look here for more information: http://developer.intuit.com/QuickBooksSDK/

Utilize XML :slight_smile: instead of the importing the iif files :cry: .

We plan to integrate QuickBooks with one of our Servoy based products. If someone wants to share or work together on it let me know.

Jody Weaver
WeaverWorld, Inc.

4

It can also be done using the correct api and using triggers from your back-end data source. I have been talking with a local company that will built the fuctionality to puch from SQL to QB.

That will be the last part of my build, but if you are still interested in about 6-9 months, I will let you know what all was involved.

5

Thanks for all the replies. Much appreciatede.

6

This is on my to-do list as well; I have found a java to COM bridge from Intuit that will simplify this significantly; check out http://developer.intuit.com/QuickBooksS … es/?id=121
for more details and a simple sample app..

Some things I am trying to figure out:

  • Do I have to have QB running on my server, or can I talk to a client QB via Java or COM across the LAN (I am leaning towards running a copy of QB on server so that I am able to better control the config).
  • The QBProcessor (or more precisely the DOMParser component) seems to require an actual file to process (although a pipe might suffice), so handling multiple simultaneous requests could be complex.
  • I will need to figure out how to best do this on the server side (stand-alone app, servlet, web service, plugin) and then figure out how to write it :P (since I have written very little java…)
    I would love to team up on this, if the project can be defined in a way to allow for multiple developers.. Anyone interested?
7

As for the Servoy side, especially if webservices are involved: check out:

http://forum.servoy.com/viewtopic.php?t=2166&highlight=

Paul