Re: [GNC] future of custom reports in 3.x

Thanks very much to William, David, and Sébastien for those links. That's all the documentation I could want. Cheers! Matt ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] future of custom reports in 3.x

You can also look at http://piecash.readthedocs.io/en/latest/object_model.html Piecash is in fact a python ORM (sqlalchemy) on top of the gnucash dql tables. On Tue, Apr 10, 2018, 18:14 Matthew Pounsett wrote: > On 10 April 2018 at 11:45, Amish wrote:

Re: [GNC] future of custom reports in 3.x

Or consult https://wiki.gnucash.org/wiki/SQL and https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png David T. > On Apr 10, 2018, at 8:45 PM, Amish wrote: > > May be

Re: [GNC] future of custom reports in 3.x

> Is there some clear documentation of the SQL schema somewhere? https://wiki.gnucash.org/wiki/SQL https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences

Re: [GNC] future of custom reports in 3.x

On 10 April 2018 at 11:45, Amish 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. > > That's an approach, for sure. However... there are 24

Re: [GNC] future of custom reports in 3.x

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

Re: [GNC] future of custom reports in 3.x

On 8 April 2018 at 13:13, John Ralls 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

Re: [GNC] future of custom reports in 3.x

Re running reports within gnucash, I have toyed with the idea to be able to call from gnucash a local web server to run a report and return the HTML to gnucash (or even other mimetype like an excel, csv or word file). It needed the Web Client module for guile (

Re: [GNC] future of custom reports in 3.x

Op maandag 9 april 2018 07:12:29 CEST schreef Saša Janiška: > John Ralls writes: > > 3. Learn Python and use either the python bindings or PieCash (also > > requires the SQL backend) to query the database and write custom > > reports. > > I'll take a closer look at this

Re: [GNC] future of custom reports in 3.x

John Ralls writes: > While we would like to replace the reporting system with something > more flexible and user friendly we’re a very long way from being in a > position to even start on it. OK - that's nice to know. ;) > In the meantime there are four alternatives for

Re: [GNC] future of custom reports in 3.x

While we would like to replace the reporting system with something more flexible and user friendly we’re a very long way from being in a position to even start on it. In the meantime there are four alternatives for custom reports: 1. Learn Scheme and qof-query to make custom reports for use

Re: [GNC] future of custom reports in 3.x

I wonder the same too. Although new reports are enough for me now. But I had to delete lots of old custom reports because they no more worked (or compiled) But in future I may want to have my own custom reports. I wish there was GnuCash library with we could simply call Gnc_LoadFile("path")