User talk:Twt

From GnuCash
Jump to: navigation, search

this is my own little playground for trying out stuff

Connecting to LibreOffice (twt scratch)

TWT is collecting some stuff for querying or reporting in GnuCash via Libreoffice. (Based on email discussion "gnucash, sql, and libre office" on gnucash-user starting Feb 18, 2016).

Old Gnucash to LibreOffice macro is available at

Instructions and examples for this old macro are at

(see the navigation links at the top)

Here's a script for going to mysql:

There's also lots of info about converting GnuCash XML using XSLT, and there are some example xslt in

Connecting GnuCash sqlite to LibreOffice via ODBC

Basic info:

Instructions for Ubuntu (based on 14.04 LTS)

1) Install the packages

$ sudo apt-get install unixodbc unixodbc-bin libsqliteodbc

that last libsqliteodbc installs the sqlite to ODBC driver and registers it in the system. The instructions imply you'll also need to install the sqlite3 package but I think you probably don't need it for this.

2) save A COPY OF your gnucash data as a sqlite3 file

3) Create the data source (as a regular user NOT sudo)

$ ODBCManageDataSourcesQ4

Use the tool to create a new sqlite3 data source and connect it to the sqlite3 file you created with gnucash.

4) now you can open LibreOffice Base, create a new Database, connected to an existing ODBC data source, choose the one you created in step 3, and when Base opens you will see the inscrutable tables in GnuCash.

5) [Insert info here about how to make it useful (how to join tables usefully, etc.)]

6) Presumably you close Base and then save a fresh copy of GnuCash to the same file to update your data again and reopen Base to reconnect to updated data, preserving your queries and joins.

Building (twt scratch)

This is a place Twt was using collect some ideas to improve Gnucash#Building page

BY THE WAY ... if you're seeing this before I'm finished (very likely, given my uneven work habits) what I am attempting to do is eliminate the detail problem with the Ubuntu (and Debian and...) section(s) by IMPROVING the detail in the generic section. In other words, the Ubuntu section suffers from too much specificity (examples show totally different scenarios for DIFFERENT Ubuntu releases, whereas the bulk of the examples apply to ALL Ubuntu (and usually Debian) releases. The generic section (for all linux distributions) suffers from too little description.


How about adjusting the Synaptic section to debian's archive or removing it? --Fell (talk) 16:31, 15 August 2019 (UTC)

Hi -- I know that probably wasn't what you were thinking but I restructured the whole section. The lower part of the page needs a similar restructuring but I need to get to something else! Twt (talk) 17:34, 15 August 2019 (UTC)

NP :-) --Fell (talk) 18:24, 15 August 2019 (UTC)