Simple GnuCash web interface
jnylen+gnucash at gmail.com
Mon Mar 19 23:03:00 EDT 2012
I don't have a demo set up. I will let you know if I can get something
working, but there are a lot more features I'd like to implement (graphs,
budgeting, etc.) so it would probably be after I can get some of those
I currently use the GnuCash API for importing QIF files via a cronjob, and
that's the only place. It certainly takes longer than would be acceptable
for a web request, but that's partly because I'm doing some things to
eliminate duplicate transactions.
The only modifications I make from Django are to change the opposing
account of a transaction. How bad is that, or how likely is it that I'm
not modifying important data stored in the key/value table?
Also, I noticed that GnuCash deletes tables it doesn't recognize. This
means I'm using a separate database for the Django stuff, which is less
convenient because Django doesn't support cross-database foreign keys. Any
idea why GnuCash deletes tables like that?
Thanks for your input,
On Mon, Mar 19, 2012 at 4:58 PM, Christian Stimming
<christian at cstimming.de>wrote:
> Hi James,
> thanks for sharing your interesting project here! I think this is a great
> idea. I guess you've already heard our word of caution when accessing
> gnucash's SQL database directly, but on the other hand this is probably
> currently the most effective way to access the data through some other
> as you demonstrated here.
> Do you have an example web page where one can see this web application
> live in
> action? That would be very interesting... well, at least I personally
> would be
> interested to have a look at it, but I don't think I'll install django and
> gnucash SQL database on my own.
> Do you use the gnucash python API for any parts of the data access? I'm
> curious whether this works well enough for a webserver.
> Am Dienstag, 6. März 2012, 20:30:54 schrieb James Nylen:
> > Hi all,
> > I migrated my financial data to GnuCash several months ago. One of the
> > things I wanted for my financial management software of choice is a web
> > interface. So, I have been working on creating a simple mobile-friendly
> > web frontend for GnuCash, and I think it is ready to share now.
> > The application is written in Python using the Django framework. It also
> > accesses the GnuCash Python API for some features, but this is probably
> > required. The application currently has the following features, with
> > planned (graphs, budgeting, etc.):
> > - View transactions in a GnuCash account, along with their "opposing
> > account"
> > - Filter by opposing account, transaction description, or transaction
> > date
> > - Change the opposing account of any transaction and create rules for
> > categorizing future transactions
> > - Import QIF files and automatically categorize transactions according
> > the saved rules
> > You'll have to be using one of the GnuCash database backends so that the
> > Django code can access your stored data. The project is in a very early
> > stage, so if you want to use it, you should probably be familiar with the
> > command line and with setting up an SQL database. I would be very
> > surprised if it worked on Windows, but if you're familiar with Python and
> > Django, feel free to try it and share your experiences.
> > Find the code and installation instructions here:
> > https://github.com/nylen/gnucash-django
> > Let me know if you can get any use out of this!
> > James
> > _______________________________________________
> > gnucash-devel mailing list
> > gnucash-devel at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-devel
More information about the gnucash-devel