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