A pythonic interface to GnuCash SQL documents.
Project description
Piecash provides a simple and pythonic interface to GnuCash files stored in SQL (sqlite3, Postgres and MySQL).
- Documentation:
- Google group:
https://groups.google.com/d/forum/piecash (piecash@googlegroups.com)
- Github:
- PyPI:
It is a pure python package, tested on python 2.7 and 3.3/3.4, that can be used as an alternative to:
the official python bindings (as long as no advanced book modifications and/or engine calculations are needed). This is specially useful on Windows where the official python bindings may be tricky to install or if you want to work with python 3.
XML parsing/reading of XML GnuCash files if you prefer python over XML/XLST manipulations.
It allows you to:
open existing GnuCash documents and access all objects within
modify objects or add new objects (accounts, transactions, prices, …)
create new GnuCash documents from scratch
Scripts are also available to:
export to ledger-cli format (http://www.ledger-cli.org/)
export to QIF format
A simple example of a piecash script:
with open_book("example.gnucash") as book:
# get default currency of book
print( book.default_currency ) # ==> Commodity<CURRENCY:EUR>
# iterating over all splits in all books and print the transaction description:
for acc in book.accounts:
for sp in acc.splits:
print(sp.transaction.description)
The project has reached beta stage.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.