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

2020-10-25 Thread Sébastien de Menten
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 flavors:

Re: [GNC] GC 3.2 Import Price File CSV

2018-08-18 Thread Sébastien de Menten
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 combination

Re: [GNC] pros/cons of storage formats

2018-05-17 Thread Sébastien de Menten
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 > f

Re: [GNC] Automated Reporting

2018-04-24 Thread Sébastien de Menten
just the SQL backends (sqlite3, postgres and mysql) On Tue, Apr 24, 2018 at 6:56 AM, Justin Phelps wrote: > On Mon, Apr 23, 2018 at 9:15 PM Sébastien de Menten > wrote: > >> With some python skills, you could use piecash ( >> http://piecash.readthedocs.io/en/master/) to

Re: [GNC] Automated Reporting

2018-04-23 Thread Sébastien de Menten
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 wrote:

Re: [GNC] Accounts columns currency

2018-04-16 Thread Sébastien de Menten
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 window

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

2018-04-10 Thread Sébastien de Menten
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: > > > May be fastest and easiest way would

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

2018-04-10 Thread Sébastien de Menten
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 ( https://www.gnu.org/software/guile/ma

Re: GNUcash setup

2018-03-02 Thread Sébastien de Menten
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 02:

Re: Headers for importing accounts from CSV

2018-02-15 Thread Sébastien de Menten
FYI: Commodityn=commodity namespace=CURRENCY for currencies or NASDAQ for commodities on NASDAQ (see https://www.gnucash.org/docs/v2.6/C/gnucash-help/tool-security-edit.html) Commoditym=commodity mnemonic=USD for us dollar or AAPL for Apple stock=the symbol in the page referenced hereabove On Feb

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

2018-01-28 Thread Sébastien de Menten
tten, > 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 > wrote: > > Editing a gnucash book via

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

2018-01-28 Thread Sébastien de Menten
SQL, ...) On Jan 28, 2018 12:03, "D" wrote: > Sébastien, > > I know that users are advised not to edit their Gnucash data directly; is > piecash an approved application to edit Gnucash data directly? > > David > > > On January 28, 2018, at 3:41 PM, Séba

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

2018-01-28 Thread Sébastien de Menten
g 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. > > David > >

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

2018-01-27 Thread Sébastien de Menten
M, John Ralls 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 > wrote: > > > > Hello David, > > > > I saw you were

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

2018-01-27 Thread Sébastien de Menten
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, postgres

Re: customizing reports

2018-01-10 Thread Sébastien de Menten
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 in other software, but only for

Re: export general ledger

2017-12-18 Thread Sébastien de Menten
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 via gnucash-user

Re: Gnucash 2.7 on Windows

2017-11-18 Thread Sébastien de Menten
. I personally am not testing it myself. > > David C > > On Fri, Nov 17, 2017 at 5:55 PM, Sébastien de Menten > wrote: > > 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 2.7 on Windows

2017-11-17 Thread Sébastien de Menten
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 https://lists.gnucash.org/mailman/listinfo/gnucash-user

Github projects related to gnucash

2017-10-11 Thread Sébastien de Menten
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, Sébastien