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
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
