Is this project still active?
Opened this issue · 6 comments
Hi - I'm looking for a tool to sync Quickbooks desktop data with MySQL. Is this project still active? Can it be used for this use case?
Thanks
Toby
Hi @tobyporter -
You may want to look into qodbc. It comes free if you're running enterprise. Not the best documentation but syncing qb data >> Postgres, MySQL, or any other back end is super easy.
I also made some updates in a private repo that removes the redis dependency and runs on the latest django version. I'll make it public soon.
Hi - thanks all for your prompt responses!
@bill-ash qodbc (https://qodbc.com/) looks promising. What do you mean by "it comes free if you're running enterprise"? Do you mean this is supplied by Intuit? Isn't this a 3rd party product - or did I get the wrong thing?
A bit of background:
We have an old ancient PHP application with a MySQL backend and is synced to QuickBooks Desktop 2022 EE using a really flaky 3rd party tool. (It frequently stops working and the vendor support is poor to non-existent).
The strategic solution is to get off QB desktop onto QB online and use the REST APIs but this will take time and we need a working tactical solution now.
My development background is in databases & python which I why I was interested in django-quickbooks as a potential candidate. I don't want to go down the path of the Microsoft stack to try and implement the QB SDK.
Qodbc is the 'official' odbc connector for quickbooks. But, you are correct it's a third party application and still requires qb to be 'open' when syncing. We went the route of creating a service user that handles all qodbc operations. If readonly access is what you need, you can download it straight from the qb gui. As I mentioned it's free for enterprise. If you want read/write access, they have a paid product that is $250 & $500 for a work station/ server product.
Like everything in this eco system, this too is pretty flaky.
Online is significantly better than working with desktop, but still quite painful compared to any other service I've had to work with.
This library was a monumental help integrating the web connector with django so I could offload some of my responsibilities. IMO was more reliable than scheduling jobs with python and qodbc for inserts/ syncing with other platforms.
If it's just reading from qb and dumping into MySQL, I'd go the qodbc route.
@bill-ash Looking forward to seeing your private repo. As i found redis not very useful for my usecase.
I have implemented QBPoS in my fork.
Lets try to merge these forks into the master repo.
@hassaanalansary Starting from scratch and repurposing as a package. Will be slow but should get some updates over the next few weeks.
Currently ships with a default .qwc file that will authenticate with the WebConnector and that is all.