Announcement: Evaluation of GnuCash Data in OpenOffice.org

danilo lujambio lujambiodanilo at gmail.com
Mon Dec 29 16:15:50 EST 2008 

hi,

I am using openoffice 2.4 in ubuntu 8.04 I selected the main file of my
gnucash , I verified the paths on /home/.../.openoffice/....paths  and are
OK , but when I execute the fill database macro I only obtain an error which
says:

com.sun.star.lang.WrappedTargetException xxxxx (the name of my main file)
and then for further information look into file .... (the path to the config
file about paths ) but there the paths are OK

can you help me ?

On Sat, Dec 27, 2008 at 3:37 PM, Donald Allen <donaldcallen at gmail.com>wrote:

> 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. %27
> http://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.
> >
> _______________________________________________
> 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