Re: GnuCash SQLite3 to Beancount (was: Conversion from Beancount to SQLite3)

2014-10-19 Thread Wm...
Sun, 19 Oct 2014 16:57:29 <20141019145729.ga15...@upsilon.cc> Stefano Zacchiroli wrote... Wm..., On Sun, Oct 19, 2014 at 03:32:49PM +0100, Wm... wrote: >I don't work for you AFAIK, I built this software to manage my own >finances it shows why are you critical of this comment? Martin agree

Re: GnuCash SQLite3 to Beancount (was: Conversion from Beancount to SQLite3)

2014-10-19 Thread Martin Blais
On Sun, Oct 19, 2014 at 9:32 AM, Wm... wrote: > Sat, 18 Oct 2014 17:23:34 aeg0...@mail.gmail.com> > Martin Blais wrote... > > Again, you're misinterpreting the intent of the constraint. I never >> claimed >> you could not do this in Beancount, just putting a unique >> narration/comment >> on e

Re: GnuCash SQLite3 to Beancount (was: Conversion from Beancount to SQLite3)

2014-10-19 Thread Stefano Zacchiroli
Wm..., On Sun, Oct 19, 2014 at 03:32:49PM +0100, Wm... wrote: > >I don't work for you AFAIK, I built this software to manage my own > >finances > > it shows [...] > >About the precision issue, I've already written a proposal doc to outline > >what the problems are, > > as I and other people have

Re: GnuCash SQLite3 to Beancount (was: Conversion from Beancount to SQLite3)

2014-10-18 Thread Martin Blais
On Sat, Oct 18, 2014 at 4:11 PM, Wm... wrote: > Sat, 18 Oct 2014 13:48:05 b0ferh5dixjoxbi5ohgn76dyjvz...@mail.gmail.com> > Martin Blais wrote... > > 1.1 "Duplicate Entry" drawing 10 cash twice in one day is not an error >>> >>> Hmm, so here's the thing, in the implementation, each tr

Re: GnuCash SQLite3 to Beancount (was: Conversion from Beancount to SQLite3)

2014-10-18 Thread Martin Blais
> 1.1 "Duplicate Entry" drawing 10 cash twice in one day is not an error >> > > Hmm, so here's the thing, in the implementation, each transaction has a > unique signature, a "hash", which allows me to make comparisons between > sets of transactions. The transactions will only be detected as duplica

Re: GnuCash SQLite3 to Beancount (was: Conversion from Beancount to SQLite3)

2014-10-18 Thread Martin Blais
On Sat, Oct 18, 2014 at 12:09 PM, Wm... wrote: > Fri, 17 Oct 2014 18:20:47 > > Martin Blais wrote... > > [GnuCash SQLite3 to Beancount] > > MartinB: > >>> You could adapt this to spit out a Beancount file if you needed to, > >>> with relatively minor changes. > > Wm: > >> I did that just the ot

Re: Conversion from Beancount to SQLite3

2014-10-17 Thread Martin Blais
On Fri, Oct 17, 2014 at 5:14 PM, Wm... wrote: > Wed, 15 Oct 2014 19:16:58 0kfrfyxzjkhrecva_fq7...@mail.gmail.com> > Martin Blais wrote... > > > On Wed, Oct 15, 2014 at 12:15 PM, Gour wrote: >> On Wed, 15 Oct 2014 11:26:15 -0400 >> Martin Blais wrote: >> >> > If you want to help expedite t

Re: Conversion from Beancount to SQLite3

2014-10-17 Thread Wm...
Wed, 15 Oct 2014 19:16:58 Martin Blais wrote... On Wed, Oct 15, 2014 at 12:15 PM, Gour wrote: On Wed, 15 Oct 2014 11:26:15 -0400 Martin Blais wrote: > If you want to help expedite this, you can create a GNUcash ledger > that has at least one of every kind of transaction (especially wi

Re: Conversion from Beancount to SQLite3

2014-10-15 Thread Martin Blais
On Wed, Oct 15, 2014 at 12:15 PM, Gour wrote: > On Wed, 15 Oct 2014 11:26:15 -0400 > Martin Blais wrote: > > > If you want to help expedite this, you can create a GNUcash ledger > > that has at least one of every kind of transaction (especially with > > units held at cost, investments, etc.) tha

Re: Conversion from Beancount to SQLite3

2014-10-15 Thread Martin Blais
On Wed, Oct 15, 2014 at 4:29 AM, Gour wrote: > On Wed, 15 Oct 2014 00:20:23 -0400 > Martin Blais wrote: > > Hello Martin, > > > Tonight I implemented a new command to convert from Beancount to an > > SQL database (SQLite3 implementation). > > I still did not convert from Gnucash to ledger-based

Re: Conversion from Beancount to SQLite3

2014-10-15 Thread Gour
On Wed, 15 Oct 2014 10:29:07 +0200 Gour wrote: > I still did not convert from Gnucash to ledger-based accounting and > wonder what is your priority in regard to some tool to provide ledger > <--> Beancount conversion? Excuse me for making noice...now I'm looking at tutorial and see: "It should

Re: Conversion from Beancount to SQLite3

2014-10-15 Thread Gour
On Wed, 15 Oct 2014 00:20:23 -0400 Martin Blais wrote: Hello Martin, > Tonight I implemented a new command to convert from Beancount to an > SQL database (SQLite3 implementation). I still did not convert from Gnucash to ledger-based accounting and wonder what is your priority in regard to some

Conversion from Beancount to SQLite3

2014-10-14 Thread Martin Blais
Hi, Tonight I implemented a new command to convert from Beancount to an SQL database (SQLite3 implementation). I did this because I'm iterating on an implementation for the native query syntax for generating reports and I want to also play with another SQL client on a similar corpus of transaction