search

weltlink / django-quickbooks

Django Integration with Quickbooks
Mozilla Public License 2.0
37 stars 13 forks source link

Is this project still active? #33

Open tobyporter opened 2 years ago

tobyporter commented 2 years ago

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

hassaanalansary commented 2 years ago

If you are using django, then yes. You can use this project data between Quickbooks Desktop and your  database. If you are not using django or dont care about which backend you want to use.You can checkout quickbooks-php, it has more mature codebase.

On Wed, May 11, 2022 at 9:35 PM, Toby @.***> wrote:

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

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you are subscribed to this thread.Message ID: @.***>

bill-ash commented 2 years ago

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.

tobyporter commented 2 years ago

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.

bill-ash commented 2 years ago

@tobyporter

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.

hassaanalansary commented 2 years ago

@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.

bill-ash commented 2 years ago

@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.

https://github.com/bill-ash/django-books