####A very messy implementation of Quickbooks desktop mirroring. #####You get everything without magic. ####Two-way communication between Quickbooks and Django/Python.

Requirements:

• python 3.4 (Tested on 3.4.2)
• pip

git clone https://github.com/royendgel/django-quickbooks.git

pip install -r requirements.txt

python manage.py migrate

python initialize.py

python manage.py runserver

Note : Remember if you are using mac/linux and you are trying this with virualbox or remote. Change your server to 0.0.0.0:8000

Open your browser and go to http://localhost:8000/quickbooks/get-company-file open that file in your text editor and edit your server url. or better edit in views : get_company_file

def get_company_file(request):
    response = HttpResponse(generate_qbc_file(), content_type='text/xml')
    response['Content-Disposition'] = 'attachment; filename="quickbooksconnector.qwc"'
    return response

change generate_qbc_file() to something like this generate_qbc_file(app_url="http://192.168.1.20/quickbooks/") remember the trailing slash at quickbooks/.

run that file on the computer that have quickbooks & webconnector installed.

Then finally enter the password for the company file. as password enter kickstart

###Tested with 9500 entries. it is working ! Work in progress.

Currently if you start as described above with intialize.py it will read and store data as xml in your db. This are the tested queries read:

• Customer
• Bill
• Account
• Check
• Account
• Estimate
• Invoice
• ReceivePayment
• Vendor
• ToDo

Need to be done (Write new and/or modified records back to quickbooks) :

• Customer
• Bill
• Account
• Check
• Account
• Estimate
• Invoice
• ReceivePayment
• Vendor
• ToDo

More things:

• Time stamped so I can ask for only changed or added records
• Irritation for big company files
• Advanced queries(Not really I don't see why for now)

#####Any Question or help contact me: royendgel@techprocur.com