Python list all invoices

Christoph Holtermann c.holtermann at gmx.de
Tue Nov 11 11:06:13 EST 2014


Hi Tom,

just what you have already put into gnucash has been sufficient, Thanks !
My script now lists all invoices:
https://github.com/c-holtermann/gnucash/commit/765d73f9037adb69fd4bfa7ae229d8e2fb876336

kind regards,

Christoph

Am 10.11.2014 um 20:57 schrieb Tom Lofts:
> Hi Christoph,
>
> While the query api isn’t available in Python yet, I’ve made some steps towards this for the REST API I’ve been working on. Some of this code is already available in the latest version of Gnucash, mostly in the Python examples directory at https://github.com/Gnucash/gnucash/blob/master/src/optional/python-bindings/example_scripts/rest-api/gnucash_rest.py
>
> The code you’ll want is getInvoices which creates a query which then adds a condition to check for paid/unpaid and active/inactive invoices.
>
> I’ve done a little more work which I haven’t made available publicly yet, but a work in progress version of this function is also attached.
>
> If you have any queries please let me know.
>
> Kind regards,
>
> Tom
>
>
> On 10/11/14 15:10, Christoph Holtermann wrote:
>> Dear developers,
>>
>> to get my invoices to LaTeX I went to jinja2 templating engine
>> which works quite fine.
>> src/optional/python-bindings/example_scripts/gncinvoice_jinja.py
>> https://github.com/c-holtermann/gnucash/commit/15a69f120569a174837b467d54a22fb1b4345777
>>
>> I want to be able to show a list of all invoices to select which one to extract.
>> This leads to my question:
>>
>> What ways are there to list all invoices (with python) ?
>>
>> I first went through all lots to get corresponding invoices - which leaves all
>> invoices without transactions. Did this in latex_invoices.py.
>> Then I realized that in the python business bindings there is
>> InvoiceLookupByID which is a good way to access invoices.
>> But it's not possible by this way to know all IDs.
>>
>> When I use the way similar to the search dialogue like "all invoices
>> after 1970 january" I would probably get all invoices. But as far as I
>> know the query api is not yet open to python, is it ?
>>
>> Is there another way to get all invoices ?
>>
>> regards,
>>
>> Christoph Holtermann
>>


-- 
--- Nachricht gesendet von C. Holtermann ---
-                                          -
-  Verschlüsselte Nachrichten können über  -
- den öffentlichen Schlüssel auf folgendem -
- Keyserver an mich gesendet werden:       -
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x4DD9CF0482B0620B



More information about the gnucash-devel mailing list