Simple GnuCash web interface

[Wm Tarr]

On 2012-03-07 01:30, James Nylen wrote:
> 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, I'm relatively new to python and have just installed django and 
have got further than I think you might have expected on Win XP

Some quick Q's

your python version (I'm using ActivePython 2.7 as that is the most 
obvious one for Win users, I could use a standard 2.7 too but that may 
seem unnatural to other Win users, django doesn't do Python 3.x as I 
expect you know)

your django version (I'm using django 1.3.1 -- latest from ActiveState's 
repository and I guess you are too looking at the dir structure for 
gnucash-django; i.e. you don't have a "mysite within mysite" which seems 
to be the structure for django 1.4)

any extra modules from a vanilla installation that I might need (I'm new 
to how python dependencies work if that seems like a silly q) and have 
found I needed python-dateutil (I know how it is when you have a mature 
installation, I forget to tell people all the bits and pieces I have in 
my perl for e.g.), anything else obvious?

I'm also using sqlite3 rather than mysql (I do have a mysql copy of 
gnucash and may go try with that later this w/e if I am still stuck) so 
I may be picking up some oddities there but I thought I'd check on 
obvious missing stuff like modules, etc. first.  I may be wrong but I 
wasn't expecting to pick up sqlite3 specific issues as it is native to 
both python and django, have you done anything unusual on the date 
conversions specific to mysql?

P.S. have you seen http://pypi.python.org/pypi/django-openbudget ?  I'm 
going to have a play with that too.





-- 
William Tarr
Addr: 391E Southwark Park Road; London; SE16 2JH; UK
Home: +44 (0)20 7252 0218      Mobile: 07544 583 073