Year to date budgeting report

[Klaus Dahlke]

That's the way I am following as well. A couple of month ago I posted here two perl-scripts to 
a) setup a database according to the old gnucash-1.8 structure (at that time postgresql backend was supported)
b) to read the .xac-file (gzipped xml) and parse the content into the database
As far as I know the scripts have made it into the 'contribute' section of gnucash.

In meanwhile I discovered some oddities with the second script. Using the gzipped file doesn't work properly, so today I unzip the xac-file by hand and have then the script works on the plain xml-file.

I do my reporting in the moment via command line for postgresql (I prefer postgresql but the the scripts will work for mysql or similar also). Actually, I am working on  developing some reporting  with ruby on rails. Hopefully, that will ease the reporting (just clicking through a web app). Unfortunately, the manual step to update the database still remains.

And what I heard, there is a new database backend in planning (sqlite). Such a database backend would integrate the transactional activities (recording actual data via manual entry, Finance::Quote, HBCI etc) and the reporting activities via ruby on rails.

Cheers,
Klaus


On Tue, 10 Jun 2008 15:12:34 -0700
"Pelton, Brian" <bpelton at jgboswell.com> wrote:

> One alternative to writing reports using the gnucash reporting language
> is to export the data.
> 
> For instance, I wrote a utility to take a gnucash file and export it to
> MSAccess.  (Yes, not the most impressive choice, but it works).  Doing
> that lets me write reports as I need them in MSAccess.
> 
> I believe there are some export utilities available for gnucash, but as
> far as I know, nothing from within GnuCash itself.  If there is
> interest, I could try to polish up my utility for use by the general
> public.  (It is written in C#, so Windows users primarily although mono
> might allow Linux users)  
> 
> --Brian
> 
> 
> -----Original Message-----
> From: gnucash-user-bounces at gnucash.org
> [mailto:gnucash-user-bounces at gnucash.org] On Behalf Of Derek Atkins
> Sent: Tuesday, June 10, 2008 6:52 AM
> To: Thomas Peterson
> Cc: gnucash-user at gnucash.org
> Subject: Re: Year to date budgeting report
> 
> "Thomas Peterson" <thomas.tap.peterson at gmail.com> writes:
> 
> > Now that I have been using gnucash for the last 5 months, I have come
> to
> > really miss the year to date budget report that I created in Quicken.
> Does
> > the ability to create such a report exist in gnucash?
> >
> > I have attached an example of the report which is very simple but
> extremely
> > valuable to me.
> 
> Define "create"
> 
> It's just a Simple Matter of Programming to create any report.
> The reporting language is Turing Complete so you could make it
> do anything you want.  See http://wiki.gnucash.org/wiki/Custom_Reports
> 
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> 
> -- 
>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>        Member, MIT Student Information Processing Board  (SIPB)
>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>        warlord at MIT.EDU                        PGP key available
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.