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
John Ralls" wrote:
>
>
> > On Feb 11, 2018, at 4:33 AM, 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
"
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 column a dateti
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 date colu
any extract of price data (direct SQL, XML, piecash, ...) is
complex to use.
On Feb 13, 2018 15:47, "Wm" 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.org> wrote
th"
> > Cc: gnucash-devel@gnucash.org
> > Subject: Re: [PATCH] Switch to python 3
> >
> > For further discussion here, though, particularly for Sébastien de
> Menten and Alen Siljak: Is it OK to convert to Python-3 only or should the
> bindings support both Python-2.7
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 (
https://github.com/sdementen/piecash/tree/mas
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 elem
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 throu
On Wednesday, November 12, 2014, John Ralls wrote:
>
> > On Nov 11, 2014, at 1:10 PM, Sébastien de Menten > wrote:
> >
> >
> > I would be genuinely interested to have more specific documentation on
> the
> > risks of going the SQL way.
>
> There
On Thursday, November 13, 2014, John Ralls wrote:
>
> On Nov 12, 2014, at 12:08 PM, Sébastien de Menten > wrote:
>
> On Wednesday, November 12, 2014, John Ralls > wrote:
>
>>
>> > On Nov 11, 2014, at 1:10 PM, Sébastien de Menten
>> wrote:
>> >
On 2014-11-13 19:25, John Ralls wrote:
On Nov 13, 2014, at 9:31 AM, Sébastien de Menten 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 to make them work
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 wrote:
> John Ralls 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. Rather, it’s designed to mirro
On Fri, Nov 14, 2014 at 3:31 AM, Derek Atkins wrote:
> Sébastien de Menten 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 wrote:
>
> On Nov 14, 2014, at 4:28 AM, Sébastien de Menten > wrote:
>
>
> In terms of the implementation itself of the object model, the main things
> I see not that clean are:
> - KVP vs field representation
> - XXX_denom
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
On Saturday, November 15, 2014, Christian Stimming
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 in python from
On Monday, November 17, 2014, Derek Atkins 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 new objects (
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
representation, one could ponder the use of the KVP
Frame object as the name includes the hierarchical relation.
On Tue, Dec 16, 2014 at 8:36 PM, Sébastien de Menten
wrote:
>
> Hello,
>
> I was wondering why there was a need for a KvpFrame type when the key was
> nevertheless holding the f
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 tran
2014, John Ralls wrote:
>
> > On Dec 17, 2014, at 1:28 PM, Sébastien de Menten > 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 multi
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 complet
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 i
On Mon, Dec 29, 2014 at 6:36 PM, John Ralls wrote:
>
> > On Dec 29, 2014, at 7:17 AM, Sébastien de Menten
> wrote:
> >
> > hello,
> >
> > I have some questions on gnucash behavior regarding some "limit" changes:
> > - a placeholder a
piecash ;-) )
sebastien
On Sun, Dec 28, 2014 at 3:59 PM, John Ralls wrote:
>
> > On Dec 27, 2014, at 11:54 PM, Sébastien de Menten
> wrote:
> >
> > Just a thought regarding the need for a python distribution for the
> python
> > binding on Windows/OS X, would
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
seb
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 g_key_file_free: assertion 'key_file != NULL' failed
* 21:02:56 INFO [gnc_state_get_current] No pre-existing
state found, crea
Anyone attending FOSDEM next weekend ?
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/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 wat
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 mai
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"
D
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:
http://gnucash-utilities.readthedocs.io/en/master/d
On Nov 15, 2016 1:27 AM, "John Ralls" wrote:
>
>
> > On Nov 14, 2016, at 1:31 PM, Sébastien de Menten
wrote:
> >
> > Hello,
> >
> > I have finished a first version of a mechanism to use python for
reporting
> > in gnucash.
> > It uses a s
On Tue, Nov 15, 2016 at 5:37 AM, John Ralls wrote:
>
> On Nov 14, 2016, at 7:05 PM, Sébastien de Menten
> wrote:
>
> On Nov 15, 2016 1:27 AM, "John Ralls" wrote:
> >
> >
> > > On Nov 14, 2016, at 1:31 PM, Sébastien de Menten
> wrote:
>
On Tue, Nov 15, 2016 at 4:17 PM, John Ralls wrote:
>
> On Nov 14, 2016, at 10:43 PM, Sébastien de Menten
> wrote:
>
>
> On Tue, Nov 15, 2016 at 5:37 AM, John Ralls wrote:
>
>>
>> On Nov 14, 2016, at 7:05 PM, Sébastien de Menten
>> wrote:
>>
&g
On Tue, Nov 15, 2016 at 6:41 PM, John Ralls wrote:
>
> > On Nov 15, 2016, at 9:24 AM, Sébastien de Menten
> wrote:
> >
> > On Tue, Nov 15, 2016 at 4:17 PM, John Ralls wrote:
> >
> > Sébastien,
> >
> > That's a bit more "external&quo
On Nov 16, 2016 12:30 AM, "John Ralls" wrote:
>
>
> > On Nov 15, 2016, at 12:58 PM, Sébastien de Menten
wrote:
> >
> >
> > On Tue, Nov 15, 2016 at 6:41 PM, John Ralls wrote:
> >
> > > On Nov 15, 2016, at 9:24 AM, Sébastien de Menten
w
Is it complex to add it ?
On Feb 16, 2017 16:11, "Derek Atkins" wrote:
> OOPS. You are correct.
> There is no scheme binding for this API.
> Sorry.
>
> -derek
>
> Sébastien de Menten writes:
>
> > I went to look for the file you mentioned and I see
swig.
On Fri, Feb 17, 2017 at 4:56 PM, Derek Atkins 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 writes:
>
> > Is it complex to a
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.
> > However, to g
c_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, "Derek Atkins" wr
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
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
gnu
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"
wrote:
Op dinsdag 14 november 2017 09:01:01 CET schreef Sébastien de Menten:
&g
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 ?
___
gnucash-de
Ok, thanks for the clarification.
On Nov 19, 2017 16:05, "John Ralls" wrote:
>
>
> > On Nov 19, 2017, at 6:20 AM, Sébastien de Menten
> wrote:
> >
> > Not sure if it is a bug with gnucash 2.7.1, but I can't use
> > the gnc-build-dotgnu
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" wrote:
>
>
> On Nov 19, 2017, at 8:28 PM, Sébastien de Menten
> wrote:
&
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 wrote:
>
>
> On Nov 20, 2017, at 1:37 AM, Sébastien de Menten
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 can I keep backward compati
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 the
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 test 2.8
and then go back to an old gnucash (if needed) < 2.6.20 the user has using
before, no ?
On piecash side, both formats can be supported so it is more for gn
91848, let's
move the discussion there.
Regards,
John Ralls
> On Dec 21, 2017, at 10:49 AM, Sébastien de Menten
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 test 2.8
and then go back
54 matches
Mail list logo
