Sunday, November 7, 2010
End of Maintenance
Sorry, but I took the whole thing (software plus documentation) off the web. I would have had to put a lot of work into some necessary adaptations and since with the next release of gnucash there will be the possibilty to save all your data into sql-databases (which can then be read in openoffice) I decided it would not be worth the effort.
Friday, April 16, 2010
This blog has moved
This blog is now located at http://gnuc2ooo.blogspot.com/.
You will be automatically redirected in 30 seconds, or you may click here.
For feed subscribers, please update your feed subscriptions to
http://gnuc2ooo.blogspot.com/feeds/posts/default.
Friday, October 3, 2008
Evaluating GnuCash in Ooo
This blog is dedicated to the discussion of my macro "gnuc2ooo".
If you haven't done so already please read at least the introduction before posting.
Aside from general comments you can leave feature requests, examples for application you want to share and bug reports.
If possible leave some detail on your Operating System, e.g. "Windows XP" or even something like "Linux ubuntu 8.04, GnuCash 2.24, OpenOffice.org 2.4.1", but this is optional.
If you haven't done so already please read at least the introduction before posting.
Aside from general comments you can leave feature requests, examples for application you want to share and bug reports.
If possible leave some detail on your Operating System, e.g. "Windows XP" or even something like "Linux ubuntu 8.04, GnuCash 2.24, OpenOffice.org 2.4.1", but this is optional.
Labels: General discussion
Thursday, October 2, 2008
Variants of reports
One of my helpful testers (thank you, Michael!) with a big GnuCash file over several years accomplished good results with the following query in Ooo-Base which he then evaluated by the DataPilot in Calc:
SELECT "ACCOUNT-TYPE", "LEVEL2", SUBSTRING ( "DATE_YM" FROM 1 FOR 4 ) AS "DATE_Y", SUM( "VALUE" ) AS "VALUE"
FROM "ALL_TRANSACTIONS"
GROUP BY "ACCOUNT-TYPE", "LEVEL2", "DATE_Y"
With "LEVEL2" instead of "ACCOUNT-NAME" he condenses somewhat the accounts and by isolating the first 4 characters from "DATE_YM" he will have the years instead of the months as columns, altogether a wonderful general overview over the whole file.
SELECT "ACCOUNT-TYPE", "LEVEL2", SUBSTRING ( "DATE_YM" FROM 1 FOR 4 ) AS "DATE_Y", SUM( "VALUE" ) AS "VALUE"
FROM "ALL_TRANSACTIONS"
GROUP BY "ACCOUNT-TYPE", "LEVEL2", "DATE_Y"
With "LEVEL2" instead of "ACCOUNT-NAME" he condenses somewhat the accounts and by isolating the first 4 characters from "DATE_YM" he will have the years instead of the months as columns, altogether a wonderful general overview over the whole file.
Labels: Variants of reports
