[GNC] update on piecash, unofficial python bindings for GnuCash

hello everyone, I bring you some news regarding *piecash *(https://piecash.readthedocs.io/), the pure python binding for GnuCash that is easy to install and use, well documented and run seamlessly even on windows. piecash has been updated to support 4.2 GnuCash books (in one of their SQL

Re: [GNC] GC 3.2 Import Price File CSV

Would it be possible you have a blank as first character in your security editor (i.e. " ABF.L")? The screenshot you sent give me this impression... But it may be just a visual artifact. On Sat, Aug 18, 2018, 08:54 Megagrumpy wrote: > Thanks for the response, Deva. I have tried every

Re: [GNC] pros/cons of storage formats

Is the SQLite storage format immune to the issue regarding "very long time to save the XML format" some users are experiencing? On Thu, May 17, 2018, 10:46 David T. via gnucash-user < gnucash-user@gnucash.org> wrote: > And, as I noted in January, the sql format does not get compressed, so the >

Re: [GNC] Automated Reporting

just the SQL backends (sqlite3, postgres and mysql) On Tue, Apr 24, 2018 at 6:56 AM, Justin Phelps <jus...@onitato.com> wrote: > On Mon, Apr 23, 2018 at 9:15 PM Sébastien de Menten <sdemen...@gmail.com> > wrote: > >> With some python skills, you

Re: [GNC] Automated Reporting

With some python skills, you could use piecash ( http://piecash.readthedocs.io/en/master/) to build you own reports and export them in the best format for your needs. We are working to support gnucash 3.0, the current version support gnucash 2.6. On Mon, Apr 23, 2018, 23:26 Justin Phelps

Re: [GNC] Accounts columns currency

The default currency story has always puzzled me a bit in gnucash (a.o. when working on piecash) but with your last emails John, now it makes sense to me! There is a "Book currency" (the ROOT account currency) that is used to display the summary information at the bottom of the gnucash main

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

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: GNUcash setup

Adrien, This thread https://lists.gnucash.org/pipermail/gnucash-user/2016-September/066879.html talks about a similar topic. I have posted some "experimental hacks" on it to have a book with multiple root accounts. But far from guaranteed to work properly in gnucash. Sébastien On Mar 3, 2018

Re: File Format : XML v MySQL / postgres / sqllite

ite a script file (and once written, > would I use some python command to run it? Which command?)? What, exactly, > did I install? > > Clearly, piecash isn’t for the average end user… > > David > > > On Jan 28, 2018, at 4:31 PM, Sébastien de Menten <sdemen...@gmail.

Re: File Format : XML v MySQL / postgres / sqllite

uaranteed by compiling GnuCash with the current version of Python. Short > of shipping GnuCash with a complete Python installation, the only way > around this is for individual users to compile locally. Which, as I noted, > is a painful process for me. But thanks for the information. > >

Re: File Format : XML v MySQL / postgres / sqllite

28, 2018, at 12:55 AM, John Ralls <jra...@ceridwen.us> wrote: > > I suspect David was thinking of CuteCash, Christian Stimming’s > experimental Qt GUI. > > Regards, > John Ralls > > > On Jan 27, 2018, at 10:44 AM, Sébastien de Menten <sdemen...@gmail.com>

Re: File Format : XML v MySQL / postgres / sqllite

Hello David, I saw you were mentioning piecash in your message. If you talk about http://piecash.readthedocs.io/en/latest/, it is not a proof of concept for a frontend but an alternative to the gnucash python bindings to work with gnucash books stored in any of the 3 SQL backends (SQLite,

Re: customizing reports

Hello Richard If you have some programming experience, I can provide you some help to achieve what you want through piecash (for the python programming language). Sebastien On Jan 10, 2018 18:32, "Adrien Monteleone" wrote: > I’ve seen such a report your describe

Re: export general ledger

To export a gnucash book to a ledger-cli output, you may be interested by the piecash python module and the related script https://github.com/sdementen/piecash/blob/master/scripts/piecash_ledger.py On Mon, Dec 18, 2017 at 11:32 AM, Jeff Abrahamson wrote: > On 18/12/17 03:26, Wm

Re: Gnucash 2.7 on Windows

e the most recent build. > It may be a bit hard to find. I personally am not testing it myself. > > David C > > On Fri, Nov 17, 2017 at 5:55 PM, Sébastien de Menten <sdemen...@gmail.com> > wrote: > > Had anyone got some success in running the gnucash 2.7 binaries on W

Gnucash 2.7 on Windows

Had anyone got some success in running the gnucash 2.7 binaries on Windows? My version just crashes at startup time without any meaningful logs. ___ gnucash-user mailing list gnucash-user@gnucash.org

Github projects related to gnucash

Hello, Just to let you know, I have updated the list of github projects with gnucash in their description: http://piecash.readthedocs.io/en/latest/doc/github_links.html Python is the front runner language in terms of # projects followed at some distance by perl and Java. Kind regards,