<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7036.0">
<TITLE>Reports from the PostGres Database</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">I'm looking at the gnucash Postgres database defs and plan to get some perl reports out this week.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I have converted Quicken/MsMoney to gnucash and corrected the data, saved it to postgres.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">It looks like the database is flat tables with plenty of fields that could be used for queries.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">From the web site it doesn't look like much report writing is going on (or documentation).</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Not a clue about how database updates are handled (if at all).</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Is the sql server db in sync with the .xac file because it is completely replaced every save?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Any pointers to reports would be appreciated.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">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. </FONT></P>
<P><FONT SIZE=2 FACE="Arial">tedc</FONT>
</P>
<BR>
</BODY>
</HTML>