Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Need to get data into Quickbooks [closed]

I'm looking for an existing Java (or JVM'able language) library that will create IIF files for import into Quickbooks. Free or Commercial. Anyone know of something?

UPDATE:

After reading a comment on this question, I looked at the IPP and SDK options that Intuit provides and they could not have made this more difficult. So here is what I need to do. I need to take data from my database and export it into some sort of format that I can then import into Quickbooks. This doesn't really even need to be an automatic process as the Quickbooks application/database won't be on the server (linux) that the web applications runs on.

like image 286
Gregg Avatar asked Jan 25 '11 19:01

Gregg


2 Answers

There are a number of free options as well if you're comfy rolling your own (or using Intuit test apps).

If you download the QuickBooks SDK, it includes examples of sending QuickBooks XML documents which instruct QuickBooks to add customers, add transactions, etc. etc. etc. The examples could easily be extended to allow you to copy/paste in an XML document or load an XML document from disk.

You could then build the actual XML files in Java. If you wanted to get really fancy, use JAXB (or an equivalent XSD to Class generator) to generate Java classes from the included .XSD documents, and be able to do things like: InvoiceAdd inv = new InvoiceAdd();

There's documentation about the XML format included in the QuickBooks SDK. You can also find some QuickBooks XML examples on our QuickBooks integration wiki.

like image 176
Keith Palmer Jr. Avatar answered Oct 12 '22 02:10

Keith Palmer Jr.


You should be able to use QODBC for this. According to the QODBC newsgroup, some people are using this QuickBooks database driver with JDBC.

like image 23
Paul Keister Avatar answered Oct 12 '22 03:10

Paul Keister