Home

Macro

Paths

Insert Data

Example 1

Example 2

Blog

Evaluation of GnuCash Data in OpenOffice.org

Configuring paths for input and output and inserting a new database into OpenOffice.org

Please open the Macro-Selector (Tools → Macros → Run Macro) and then „My Macros“ and „gnuc2ooo“.

Now select "SetGnuCashFilePaths“ and press "Run".

The called macro will ask for the the locations of input (GnuCash-file) and output (= new OpenOffice.org Base document). It will store this information into file GnuCashFilePaths.txt. Subsequently, an empty Base-Databse <databasename>.odb will be created.

After the macro SetGnuCashFilePaths has been started the following window will be displayed:

So here you will have to navigate to the GnuCash file with the data you want to process, select it and press "Open". If you don't know how to find it there is some helpful information here at GnuCash's FAQ-list.

Next the program wants to know where to store your new OpenOffice database:

The program will suggest the working directory of the user in OpenOffice and, as filename, the same name as the name of your GnuCash file (but it will automatically add the appropiate fileextension .odb). In many cases this will be just fine, it is however perfectly all right, for example, to pick instead the same directory as the one in which GnuCash stores its data or to edit a different filename. Note that in the above example, the directory that was initially selected would be /home/knut but I changed to a subdirectory of mine, /home/knut/openoffice. In any case, the selection has to be confirmed with "Save".
Now the aforementioned Configuration File and a - still empty - Base database will be created.

Review of results:

The empty database can be opened in OpenOffice.org - Base, after you doubleclicked on the name of the datafile (2008.odb in our example).

Explanatory note for regular operation:

The steps described on this page only have to be performed when you want to create another database or change the location of files. When just updating the GnuCash data it is sufficient to start with the next step: "Insert data".

Please close this database before performing the next step.

Next Step: Fill data from GnuCash into the Ooo-database