Simple GnuCash web interface

[James Nylen]

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

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,
James


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
> means,
> 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
> a
> 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.
>
> Regards,
>
> Christian
>
> 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
> not
> > required.  The application currently has the following features, with
> more
> > planned (graphs, budgeting, etc.):
> >
> >  - View transactions in a GnuCash account, along with their "opposing
> > account"
> >  - Filter by opposing account, transaction description, or transaction
> post
> > date
> >  - Change the opposing account of any transaction and create rules for
> > categorizing future transactions
> >  - Import QIF files and automatically categorize transactions according
> to
> > 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
>