Menu
.qbw file -> CompanyName.qbwsome data out of that file - NOT all , but some.:)Let's say, I want to query only the inventory report.
Within that inventory report, I only want 3 fields.
I've been looking for a tool out there everywhere, I could not find anything that will does exactly what I want.
Can someone get me start on this ? Can anybody at least point me to the right direction ?
I am not exactly sure, if what I am trying to do is possible.
586
When you restore your company backup file (qbb) that contains company data and accounting data, QuickBooks creates a new (qbw) company file based on the last backup saved.
Not a direct answer, but some direction as you requested:
The QOBDC driver available here (http://qodbc.com) should allow you to access your qbw file like a SQL database and perform queries against it. There is a free trial, but it looks like you'll need to pay $150-$500 to buy this driver if you find that it works and you want to use it long term.
As for querying a specific report like inventory, I don't know, but there are plenty of tutorials around in the form of blog posts and YouTube videos that should help you figure out how to use QODBC for your purpose.
132
Intuit (the people that make QuickBooks) offers something called the QuickBooks SDK specifically for situations like yours.
It's free to download. Download, install, and you can connect to QuickBooks and extract any data you want or run any reports you want.
There's about 600 pages of documentation available in PDF format:
And you'll probably also want to look at the QuickBooks OSR, which shows all of the XML messages you can send QuickBooks, along with the XML responses you get back and even some auto-generated sample code:
If you post more details (e.g. what language are you developing in?) we could post sample code for you too.
37
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
