May be fastest and easiest way would be to first save sample data (say
only 1 transaction) to say PostgreSQL database and then use pg_dump to
dump it to text file.
Amish.
On Tuesday 10 April 2018 08:57 PM, Matthew Pounsett wrote:
On 8 April 2018 at 13:13, John Ralls <jra...@ceridwen.us
<mailto: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.
