Announcement: Evaluation of GnuCash Data in OpenOffice.org
Donald Allen
donaldcallen at gmail.com
Sat Dec 27 12:37:11 EST 2008
On Mon, Dec 22, 2008 at 9:36 AM, Don H <don.harville at att.net> wrote:
>
> Hello Donald,
> I am using OpenOffice 2.4, that is the latest version in Ubuntu.
>
> Now I did see an error like you mentioned but that is because I was
> selecting the wrong file. So to make it work I did the following:
>
> * My Gnucash file is called Home Finances. It is a Gzip file. It is
> located in a folder called Gnucash and it contains all of my Gnucash files
> (e.g., main file, .log, .xac).
> * I loaded the macros into Openoffice.
> * I opened up Calc and ran the SetGnuCashFilePaths macro.
> * On the Pick Output Data File screen I selected the Gnucash file 'Home
> Finances' and hit Open.
> * Next on the Enter Database Filename screen I entered the name of the
> spreadsheet I would use in OpenOffice (I called it 'Where did my money go)
> and hit Save.
> * At that point it created the database, and has worked every time I do
> a refresh.
>
> So if you doing the above and it isn't working I can only imagine that it
> would be version related in OpenOffice.
>
Thanks very much for trying to help, but I've been in touch privately with
Knut, the author of the macros, who has been extremely helpful. The issue is
the state of the locale settings on my system. I need to do one more test,
but I'm quite certain he's identified the problem.
Thanks again --
/Don
>
> Don H
>
>
> Donald Allen wrote:
> >
> > 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.
> >>
> > _______________________________________________
> > 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-tp19814980p21128854.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.
>
More information about the gnucash-user
mailing list