Reports from the PostGres Database

[Derek Atkins]

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

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

Ahh, those aren't ours.  And I still maintain that they are not
guaranteed, either.

> Gnucash looks like a handy program.

It is. :)

> 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?

I dont know if logging continues, but it's really not needed.  When
you use Postgres, your data is saved at every commit operation.

The .xac backup files are part of the XML File backend, so if you
revert back to using the XML File backend then yes, you'll get your
.xac backup files at every save operation.

> Thanks.
> Tedc

-derek

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

-- 
       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