Hello Christopher
I am the dev of piecash. Regarding the second resolution of datetime, I
think I got it by reverse engineering the SQL database format for gnucash
books (you can check by introspecting the DB or the XML). Why do you need
this very high resolution? I think most of the datetime
Hello Chris,
I am definitely interested into such gnucash data set of books/accounts/etc
for testing piecash (reports, performance,.. ). With the transition to
gnucash 3 coming to maturity, I planned to convert/rework the existing set
of sample books (
.us>
> > To: "Julian Wollrath" <jwollr...@web.de>
> > Cc: gnucash-devel@gnucash.org
> > Subject: Re: [PATCH] Switch to python 3
> >
> > For further discussion here, though, particularly for Sébastien de
> Menten and Ale
t of price data (direct SQL, XML, piecash, ...) is
complex to use.
On Feb 13, 2018 15:47, "Wm" <wm_o_...@yahoo.co.uk> wrote:
> On 13/02/2018 12:47, Sébastien de Menten wrote:
>
>> On Tue, Feb 13, 2018 at 6:32 AM, Wm via gnucash-devel <
>> gnucash-devel@gnucash.o
On Tue, Feb 13, 2018 at 6:32 AM, Wm via gnucash-devel <
gnucash-devel@gnucash.org> wrote:
> On 12/02/2018 21:00, Sébastien de Menten wrote:
>
>> When I enter a new price for a given day for a security on the NASDAQ via
>> the price editor, it is stored in the
evel@gnucash.org>
wrote:
On 11/02/2018 12:33, Sébastien de Menten wrote:
> When exporting data from SQL backends, I see some inconsistencies in the
> handling of some date & datetime columns.
>
> In the prices table, when adding price via the price editor, I see in the
> date col
Ralls" <jra...@ceridwen.us> wrote:
>
>
> > On Feb 11, 2018, at 4:33 AM, Sébastien de Menten <sdemen...@gmail.com>
> wrote:
> >
> > When exporting data from SQL backends, I see some inconsistencies in the
> > handling of some date & datetime
When exporting data from SQL backends, I see some inconsistencies in the
handling of some date & datetime columns.
In the prices table, when adding price via the price editor, I see in the
date column a datetime with the UTC of the /MM/DD 00:00:00 of my local
timezone (CET).
For instance, for
=791848, let's
move the discussion there.
Regards,
John Ralls
> On Dec 21, 2017, at 10:49 AM, Sébastien de Menten <sdemen...@gmail.com>
wrote:
>
> Ok but then it will be semi-backward incompatible as it will be only
compatible with 2.6.20 which can make it very tricky for users to t
Hello,
In books created in gnucash 2.7, the size of the field for date has been
increased from 14 to 19 characters to move from a custom format to an ISO
format if I understand properly.
This is a backward incompatible change, correct ?
ie GC 2.7 will read previous books and "migrate" them to
r 2017 19:48:41 CET schreef Geert Janssens:
> > Op maandag 20 november 2017 06:02:20 CET schreef John Ralls:
> > > > On Nov 19, 2017, at 8:28 PM, Sébastien de Menten <
> sdemen...@gmail.com>
> > > > wrote:
> > > >
> > > > btw, how c
yes, the same can be done in scheme but the question is "will scheme
reports/scripts need to be rewritten for Gnucash 2.7/2.8?" (i.e. no back
compatibility guaranteed)
On Mon, Nov 20, 2017 at 5:50 PM, John Ralls <jra...@ceridwen.us> wrote:
>
>
> On Nov 20, 2017, at 1:3
Indeed. But in gnucash guile world, how will scm scripts using the old API
still work tomorrow ? Or do they need a migration/versioning per gnucash
version ?
On Nov 20, 2017 06:04, "John Ralls" <jra...@ceridwen.us> wrote:
>
>
> On Nov 19, 2017, at 8:28 PM, Sé
Ok, thanks for the clarification.
On Nov 19, 2017 16:05, "John Ralls" <jra...@ceridwen.us> wrote:
>
>
> > On Nov 19, 2017, at 6:20 AM, Sébastien de Menten <sdemen...@gmail.com>
> wrote:
> >
> > Not sure if it is a bug with gnucash 2.7.1,
Not sure if it is a bug with gnucash 2.7.1, but I can't use
the gnc-build-dotgnucash-path in the config.user as I get an unbound
variable.
any clue?
is this the right list for questions re gnucash 2.7.1 or should I use the
gnucash-user ML ?
___
Great!
I have installed gnucash 2.7 on windows (downloaded the binaries) but can't
make it work.
Anyone using the 2.7 binaries for windows successfully?
On Nov 14, 2017 11:00 AM, "Geert Janssens" <geert.gnuc...@kobaltwit.be>
wrote:
Op dinsdag 14 november 2017 09:01:01 CET schr
hello,
What version of guile is packaged with the windows build of gnucash ?
I have the impression it is the 1.8.8 released in 2010 but am not sure...
if so, would it be possible to upgrade it to 2.0 or 2.2 ?
sebastien
___
gnucash-devel mailing list
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,
xisting wrappers for e.g. gnc_get_current_book().
>
> -derek
>
> On Fri, February 17, 2017 4:23 pm, Sébastien de Menten wrote:
> > If only I knew how to do this ! I can't find the proper documentation ...
> > help much appreciated !
> >
> > On Feb 17, 2017 22:14, "Dere
ent-book). So all you need to do is
> find (or add) an API to get the current session from the current book.
>
> -derek
>
> On Fri, February 17, 2017 4:01 pm, Sébastien de Menten wrote:
> > I can access a function named qof-session-get-url which expects a
> session.
>
.
On Fri, Feb 17, 2017 at 4:56 PM, Derek Atkins <warl...@mit.edu> wrote:
> Hard to say. I don't know what other dependencies would need to be brought
> in.
> You'd certainly need to rebuild GnuCash!
>
> -derek
>
> Sébastien de Menten <sdemen...@gmail.com> w
Is it complex to add it ?
On Feb 16, 2017 16:11, "Derek Atkins" <warl...@mit.edu> wrote:
> OOPS. You are correct.
> There is no scheme binding for this API.
> Sorry.
>
> -derek
>
> Sébastien de Menten <sdemen...@gmail.com> writes:
>
> >
On Nov 16, 2016 12:30 AM, "John Ralls" <jra...@ceridwen.us> wrote:
>
>
> > On Nov 15, 2016, at 12:58 PM, Sébastien de Menten <sdemen...@gmail.com>
wrote:
> >
> >
> > On Tue, Nov 15, 2016 at 6:41 PM, John Ralls <jra...@ceridwen.us> wrote:
On Tue, Nov 15, 2016 at 6:41 PM, John Ralls <jra...@ceridwen.us> wrote:
>
> > On Nov 15, 2016, at 9:24 AM, Sébastien de Menten <sdemen...@gmail.com>
> wrote:
> >
> > On Tue, Nov 15, 2016 at 4:17 PM, John Ralls <jra...@ceridwen.us> wrote:
> >
&g
On Tue, Nov 15, 2016 at 4:17 PM, John Ralls <jra...@ceridwen.us> wrote:
>
> On Nov 14, 2016, at 10:43 PM, Sébastien de Menten <sdemen...@gmail.com>
> wrote:
>
>
> On Tue, Nov 15, 2016 at 5:37 AM, John Ralls <jra...@ceridwen.us> wrote:
>
>>
>&g
On Tue, Nov 15, 2016 at 5:37 AM, John Ralls <jra...@ceridwen.us> wrote:
>
> On Nov 14, 2016, at 7:05 PM, Sébastien de Menten <sdemen...@gmail.com>
> wrote:
>
> On Nov 15, 2016 1:27 AM, "John Ralls" <jra...@ceridwen.us> wrote:
> >
> >
> &g
On Nov 15, 2016 1:27 AM, "John Ralls" <jra...@ceridwen.us> wrote:
>
>
> > On Nov 14, 2016, at 1:31 PM, Sébastien de Menten <sdemen...@gmail.com>
wrote:
> >
> > Hello,
> >
> > I have finished a first version of a mechanism to use python
Hello,
I have finished a first version of a mechanism to use python for reporting
in gnucash.
It uses a scheme script to start a python process that does the heavy
lifthing.
Should you be interested, you can find documentation/instructions here:
Cross posting to gnucash-devel as probably more a dev question.
Essentially: is there any way to get some documentation (even just the list
of modules with symbols exported) on the guile gnucash bindings ?
Sébastien
-- Forwarded message --
From: "Sébastien de Menten&quo
There is no constraint in gnucash to avoid creating two top-level accounts
with the same name while there is such a constraint for two sub-accounts.
Should the first be allowed ? Is there some reason to allow this ?
regards
sebastien
___
gnucash-devel
Seen the recent emails on the gnucash mailing lists about several topics
for which the project I am working on could be deemed interesting, I
announce you that version 0.62 of piecash, an alternative python interface
to GnuCash, is released.
I made two simple screencasts to show its use (to be
Anyone attending FOSDEM next weekend ?
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
I noticed in the log /tmp/gnucash.trace that whenever I rename a gnucash
sqlite file and I open it in gnucash, Gnucash leaves a CRITical warning in
it:
* 21:02:56 CRIT GLib g_key_file_free: assertion 'key_file != NULL' failed
* 21:02:56 INFO gnc.app-utils [gnc_state_get_current] No pre-existing
For each scheduled transaction, I can see that a BANK account is created
as a child of the root_template, with as name the guid of the scheduled
transaction. This account does not have a lot of valuable information
(field or slots) at first sight.
What would be the role of this account ?
kr
piecash ;-) )
sebastien
On Sun, Dec 28, 2014 at 3:59 PM, John Ralls jra...@ceridwen.us wrote:
On Dec 27, 2014, at 11:54 PM, Sébastien de Menten sdemen...@gmail.com
wrote:
Just a thought regarding the need for a python distribution for the
python
binding on Windows/OS X, would
hello,
I have some questions on gnucash behavior regarding some limit changes:
- a placeholder account: an account can be converted to a placeholder
account even if there are splits related to it. Is it expected behavior ?
or should the placeholder flag be selectable only if there are no split in
On Mon, Dec 29, 2014 at 6:36 PM, John Ralls jra...@ceridwen.us wrote:
On Dec 29, 2014, at 7:17 AM, Sébastien de Menten sdemen...@gmail.com
wrote:
hello,
I have some questions on gnucash behavior regarding some limit changes:
- a placeholder account: an account can be converted
Just a thought regarding the need for a python distribution for the python
binding on Windows/OS X, would it be an option to build a single executable
with the gnucash bindings (see http://www.orbitals.com/programs/pyexe.html
or http://www.decalage.info/en/python/py2exe) ?
This would give a
Hello,
There is no currency explicitly linked to a given stock (is this correct?).
As a result, one can attach to a given stock multiple prices in multiple
commodities.
For instance, YHOO (which is traded in USD) could have a price in CAD if
entered manually (in the price editor or through a
:
On Dec 17, 2014, at 1:28 PM, Sébastien de Menten sdemen...@gmail.com
javascript:; wrote:
Hello,
There is no currency explicitly linked to a given stock (is this
correct?).
As a result, one can attach to a given stock multiple prices in multiple
commodities.
For instance, YHOO
Hello,
I was wondering why there was a need for a KvpFrame type when the key was
nevertheless holding the full path to the value, for example a Book may
have the slot:
options : a frame holding
options/Accounts : a frame holding
options/Accounts/Use Trading Accounts : a boolean
If
at 8:36 PM, Sébastien de Menten sdemen...@gmail.com
wrote:
Hello,
I was wondering why there was a need for a KvpFrame type when the key was
nevertheless holding the full path to the value, for example a Book may
have the slot:
options : a frame holding
options/Accounts : a frame
On Monday, November 17, 2014, Derek Atkins warl...@mit.edu wrote:
I think most of our beef against your project is that you're making it
read-write. If it was read-only then nobody here would care.
Yes indeed. Me first needs are a) to read a GnuCash boom from python and b)
to create some
On Saturday, November 15, 2014, Christian Stimming christ...@cstimming.de
wrote:
Dear Sébastien,
I really try not to be rude, but a little bit it seems to me as if you
don't
accept no as an answer here. You asked whether the gnucash developers
support an alternative SQL access layer written
Hello John,
I have put at this address
https://github.com/sdementen/piecash/blob/master/docs/source/object_model.rst
what I understood from the object model of GnuCash
(schema/fields/invariants).
I have also added some questions regarding the objects for which you may
have the answer... (or these
First of all, thank you John for taking the time to answer to this thread !
If you see GnuCash from the (limited) perspective of an editor for a
Book document (as LibreOffice Writer is an editor for a ODT document),
object persistence is central. And luckily we have both a very clean and
On Fri, Nov 14, 2014 at 3:33 AM, Derek Atkins warl...@mit.edu wrote:
John Ralls jra...@ceridwen.us writes:
What’s your goal here? I don’t think that reimplementing GnuCash in
Python with GnuCash’s SQL schema is a particularly good approach: It’s
not exactly the most efficient design.
On Fri, Nov 14, 2014 at 3:31 AM, Derek Atkins warl...@mit.edu wrote:
Sébastien de Menten sdemen...@gmail.com writes:
Where could I find detailed documentation on the GnuCash engine (and the
constrains/invariants GnuCash enforces) ? Or would there be some
code/program to check a GnuCash
On Friday, November 14, 2014, John Ralls jra...@ceridwen.us wrote:
On Nov 14, 2014, at 4:28 AM, Sébastien de Menten sdemen...@gmail.com
javascript:_e(%7B%7D,'cvml','sdemen...@gmail.com'); wrote:
In terms of the implementation itself of the object model, the main things
I see not that clean
On Wednesday, November 12, 2014, John Ralls jra...@ceridwen.us wrote:
On Nov 11, 2014, at 1:10 PM, Sébastien de Menten sdemen...@gmail.com
javascript:; wrote:
I would be genuinely interested to have more specific documentation on
the
risks of going the SQL way.
There's nothing
On Thursday, November 13, 2014, John Ralls jra...@ceridwen.us wrote:
On Nov 12, 2014, at 12:08 PM, Sébastien de Menten sdemen...@gmail.com
javascript:_e(%7B%7D,'cvml','sdemen...@gmail.com'); wrote:
On Wednesday, November 12, 2014, John Ralls jra...@ceridwen.us
javascript:_e(%7B%7D,'cvml
On 2014-11-13 19:25, John Ralls wrote:
On Nov 13, 2014, at 9:31 AM, Sébastien de Menten sdemen...@gmail.com wrote:
Indeed, it may be worth to explain what are the goals (and the limits).
I have tried to use the official python bindings and had the following issues:
- need swig + compilations
Hello,
After trying multiple times to work with GnuCash from python (via xml, via
the python bindings, via sql), I finally had a try to use SQLAlchemy to
handle the GnuCash Books saved through the SQL backend (sqlite3 and
postgres).
I have a release on PyPI the package pyscash installable
53 matches
Mail list logo
