Please open the Macro-Selector (Tools → Macros → Run Macro...) from within any OpenOffice.org-window - except from the very database you are just going to update - and then "My Macros" and "gnuc2ooo".
|
|
Now choose "fillGnuCashDB" and press "Run".
You will be asked to confirm if you really want to update the database:
|
|
Press "Yes" and the data will
be imported - this may take a minute or two.
If - at this stage of
the game - the import fails completely with a
com.sun.star.lang.WrappedTargetException, it is probably because the
Base component of OpenOffice.org is not installed on your system.
Open the Base-database and press "Tables" in the left frame:
|
|
If you doubleclick on a tablename the data will be displayed. "ACCOUNT", "SPLIT" and "TRN" map the basic tables pretty much structured like they are stored in GnuCash's xml-outputfile. "ACCTTREE" maps the account hierarchy and "ALL_TRANSACTIONS" is a view that puts it all together. The rows of "ALL_TRANSACTIONS" look quite similar to the way transactions are displayed in GnuCash and this is the table we will mainly use for our evaluations.
This step has to be performed each time you want to update the data.
Next step: Example 1: Summary of Monthly Expenses per Account
