Reports from the PostGres Database

[ted creedon]

DTD's in XSLT Transform for Gnucash XML.
http://www.gnucash.org/pipermail/gnucash-user/2003-September/008366.html,
etc.

Gnucash looks like a handy program.

Clarify, does the logging stop too after saving to postgres? Do the xac
files restart if you resave to a  file after saving to postgres?

Thanks.
Tedc

-----Original Message-----
From: Derek Atkins [mailto:warlord at MIT.EDU] 
Sent: Thursday, February 24, 2005 11:02 AM
To: ted creedon
Cc: gnucash-user at gnucash.org
Subject: Re: Reports from the PostGres Database

Hi, Ted,

"ted creedon" <tcreedon at easystreet.com> writes:

> I'm looking at the gnucash Postgres database defs and plan to get some 
> perl reports out this week.

oooh, brave soul...

> I have converted Quicken/MsMoney to gnucash and corrected the data, 
> saved it to postgres.

Oooh, even BRAVER soul!

> It looks like the database is flat tables with plenty of fields that 
> could be used for queries.

I doubt the original creators tried to obfuscate the database too much...

> From the web site it doesn't look like much report writing is going on 
> (or documentation).

There hasn't been a large call for additional reports.  We've certainly
added a few reports over time, and there are a handful of new reports in CVS
that haven't been released.  But generally when someone writes a new report
we add it to the source tree.

> Not a clue about how database updates are handled (if at all).

When you make a change to your data, gnucash updates the database.
Or is that not what you're asking?

> Is the sql server db in sync with the .xac file because it is 
> completely replaced every save?

No, once you save into PG it stops saving into .xac.  The backend is the
backend.

> Any pointers to reports would be appreciated.

src/reports/...

> One bug I found is in the .dtd when a xml->excel conversion was done. 
> The tax number is not in its s own separate field, its in with the text
description.

What dtd?  There aren't any dtds for the xml format; or at least there are
no dtds that are guaranteed accurate.

> tedc

-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