gnucash, sql, and libre office

[Kai Truempler]

Thanks. On the macro, it is still available here:

https://github.com/cstim/gnucash/blob/master/contrib/gnuc2ooo.py

However, I don't think it works with newer versions of OO/LO.

On the sql connection:

I got a connection to a gnucash sqlite database with LO 4.4 on MacOS 10.11,
following the instructions included in the readme files in this installer
"sqliteodbc-0.9993.dmg" on this page:

http://www.ch-werner.de/sqliteodbc/

(Though since I originally tried to get a connection to Excel, I did some
random things in the process, btw: Excel never got a connection).

And now comes the embarrassing part: I'm stuck at "now what"?

Knut's gnuc2ooo macro was nicely designed to get a database that makes
answering certain questions easy and those were the same questions I have
(e.g. doing monthly reports).

The sql database in gnucash uses a different schema. I really don't know
much sql and certainly not enough to get a nice data view that I could use
to work with in calc. For example gnuc2ooo came up with a database that you
were able to filter by account level. I have no idea how to extract that
information from the gnucash sqlite file.

At the moment I'm wondering if it would be easier to strip the OO parts
from the original gnuc2ooo macro and just run it as a python script
directly. Any thoughts on that?


On Sat, Feb 20, 2016 at 2:34 AM, Tommy Trussell <tommy.trussell at gmail.com>
wrote:

>
> On Thu, Feb 18, 2016 at 2:25 PM, Kai Truempler <truempler at gmail.com>
> wrote:
>
>> a couple of years ago I was using gnucash with the gnuc2ooo macro (
>> http://www.alice-dsl.net/gnuc2ooo/save/).
>>
>> After a break from Gnucash, I was wondering now where I can find some
>> hints
>> how to use the now functioning sql backend in a similar way. Is there a
>> tutorial how to set Libre Office (Base and Calc) up with the actual
>> gnucash
>> sqlite file in a way that was possible with the database created by the
>> gnuc2ooo macro (like in this
>> http://www.alice-dsl.net/gnuc2ooo/save/gnuc2ooo_en/Example1.html example?
>>
>> Many apologies if that question has been solved before, but I had a hard
>> time finding an answer.
>>
>>
> As you probably know, the macro described at that link is no longer
> available, and its documentation stated it would no longer function for
> GnuCash after 2.4.x versions. The macro's author felt it would be
> superfluous since GnuCash 2.6.x can use Sqlite3 databases.
>
> With a small amount of searching, I found some documentation here:
>
>
> https://wiki.openoffice.org/wiki/Documentation/How_Tos/Using_SQLite_With_OpenOffice.org
>
> I have made it partway through the setup (not yet successfully) but I
> thought I would report back here with a big hint. Using that page's
> examples on my Ubuntu 14.04 LTS installation, it turns out the ODBCConfig
> utllity in unixodbc-bin is now  ODBCManageDataSourcesQ4
>
> There's also an ODBCCreateDataSourceQ4 which launches a wizard.
>
> However I haven't yet successfully created a working link from LibreOffice
> to a GnuCash sqlite3 database file I created.
>
> If you do develop a procedure that works, let's plan to put the
> information on the GnuCash wiki.
>
>
>
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>