Announcement: Evaluation of GnuCash Data in OpenOffice.org

[Donald Allen]

On Sun, Dec 21, 2008 at 10:31 AM, Don H <don.harville at att.net> wrote:

>
> Excellent macro, makes it much easier to see where my money is going.
>
> I do have a question.  In Gnucash there are parent accounts and child
> accounts.  The parent account shows the total of all of the child accounts
> under it.  Is there a way to show the parent account totals in OpenOffice
> vs. just seeing all of the accounts?


What version of Openoffice are you using? I have had absolutely no luck with
3.0, as has been reported by others, despite the fact that there are
instructions for manually installing the macro, which I've done. Unlike
others, in my case, the macros are present when you click 'Run Macro', but
SetGnucashFilePaths does not behave as the documentation says it will (the
first dialog does not have a heading on it explaining what file it's
attempting to find), but if you assume that it wants to be told where your
Gnucash file is and you do so, you get an error: "Error! TypeError encode()
argument(1) must be a string, not None". I guess I'll have to wait for OO
3.0.1 to appear in the Gentoo repository, unless someone has a bright idea.

/Don


>
> Thx Don H.
>
>
> regunk wrote:
> >
> >    I have been writing an OpenOffice.org macro that will read GnuCash
> >    output data and import it into OpenOffice.org's embedded database, so
> >    that thereafter you can evaluate them e.g. in Ooo-Calc. I wrote this
> at
> >    first for myself only, but now I have made it more presentable and fit
> >    for general application.
> >    Downloading instructions and a detailed step-by-step description on
> its
> >    use can be found on my website
> >    [1]http://www.alice-dsl.net/gnuc2ooo/gnuc2ooo_en/intro.html
> >    Feedback is appreciated!
> >    Kind regards
> >    Knut
> >    Unbegrenzter Speicher, Top-Spamschutz, 120 SMS und eigene E-MailDomain
> >    inkl.
> >    [2]
> http://office.freenet.de/dienste/emailoffice/produktuebersicht/power
> >    /mail/index.html
> >    Ist Ihr wunschname at freenet.de noch frei?
> >    Jetzt prüfen und kostenlose E-Mail-Adresse sichern!
> >    [3]
> http://email.freenet.de/dienste/emailoffice/produktuebersicht/basic/
> >    mail/index.html?pid=6829
> >    --
> >
>  [4][site=fn&prod=chetools&kat=inhalte&tbl=webmail&ppos=14&TransactionID
> >    =1223142456657725&rgtg=256]
> >
> > References
> >
> >    1. %27http://www.alice-dsl.net/gnuc2ooo/gnuc2ooo_en/intro.html%27
> >    2.
> > %27
> http://office.freenet.de/dienste/emailoffice/produktuebersicht/power/mail/index.html%27
> >    3.
> > %27
> http://email.freenet.de/dienste/emailoffice/produktuebersicht/basic/mail/index.html?pid=6829%27
> >    4.
> >
> http://adserver.freenet.de/click.ng/site=fn&prod=chetools&kat=inhalte&tbl=webmail&ppos=14&TransactionID=1223142456657725&rgtg=256
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Announcement%3A-Evaluation-of-GnuCash-Data-in-OpenOffice.org-tp19814980p21115997.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>