On 8 April 2018 at 13:13, John Ralls <jra...@ceridwen.us> wrote: > > In the meantime there are four alternatives for custom reports: > 2. Learn SQL and use a SQL backend to extract the data you want. The > results are generally amenable to import into a spreadsheet for further > processing; you could also install the appropriate ODBC module for your SQL > engine of choice and connect to it with Libre/OpenOffice, Microsoft Access, > or some similar tool with a custom report writer or your favorite > programming language’s SQL interface (e.g. DBAPI for Python).
Is there some clear documentation of the SQL schema somewhere? I had a look through the gnc-*-sql.cpp files, but it's not the most transparent description of a database that I've ever read. :) I was considering putting together a set of Python/SQLAlchemy classes that implement the object-data mapping, and would be happy to contribute it back to the project, if people thought that'd be useful. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
