[GNC] future of custom reports in 3.x

[David T.]

Or consult https://wiki.gnucash.org/wiki/SQL <https://wiki.gnucash.org/wiki/SQL> and https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png <https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png>

David T.


> On Apr 10, 2018, at 8:45 PM, Amish <anon.amish at gmail.com> wrote:
> 
> 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 <jralls at ceridwen.us <mailto:jralls at 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 at 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.