Re: queries on mysql

2010-12-09 Thread Christoph Holtermann
Hello ! I read this just now. Report generation, moving transactions according to name criteria are all things that can quite easily be done with the python- bindings. They're actually quite a source of joy ;-) Momentarily you just have to fall in love with svn, too and build gnucash from source

Re: queries on mysql

2010-11-27 Thread Donald Allen
On Sat, Nov 27, 2010 at 11:23 AM, John Ralls wrote: > > On Nov 27, 2010, at 4:40 AM, Donald Allen wrote: > >> On Sat, Nov 27, 2010 at 5:23 AM, Fred Verschueren wrote: >>> Don, >>> >>> thanks for your advice and explanation. >>> I've done it the way you described and it took me 50 sec per year for

Re: queries on mysql

2010-11-27 Thread John Ralls
On Nov 27, 2010, at 4:40 AM, Donald Allen wrote: > On Sat, Nov 27, 2010 at 5:23 AM, Fred Verschueren wrote: >> Don, >> >> thanks for your advice and explanation. >> I've done it the way you described and it took me 50 sec per year for one >> account, so in total 25 minutes. > > Good. > >> >>

Re: queries on mysql

2010-11-27 Thread Donald Allen
and Telecom, >>>>> and >>>>> these imported into Gnucash as separate accounts. >>>>> >>>>> Perhaps you could rearrange your accounts in Money to use categories >>>>> (or >>>>> whatever they ar

Re: queries on mysql

2010-11-27 Thread Fred Verschueren
se imported into Gnucash as separate accounts. Perhaps you could rearrange your accounts in Money to use categories (or whatever they are in Money), using a find and replace, export to QIF, and then import the QIF into Gnucash. David --- On Thu, 11/25/10, Fred Verschuerenwrote: From: Fred Verschu

Re: queries on mysql

2010-11-26 Thread Donald Allen
>>> these imported into Gnucash as separate accounts. >>> >>> Perhaps you could rearrange your accounts in Money to use categories (or >>> whatever they are in Money), using a find and replace, export to QIF, >>> and then import the QIF into Gnucash. >>>

Re: queries on mysql

2010-11-26 Thread Derek Atkins
d >> these imported into Gnucash as separate accounts. >> >> Perhaps you could rearrange your accounts in Money to use categories (or >> whatever they are in Money), using a find and replace, export to QIF, >> and then import the QIF into Gnucash. >> >> David >

Re: queries on mysql

2010-11-26 Thread Fred Verschueren
place, export to QIF, and then import the QIF into Gnucash. David --- On Thu, 11/25/10, Fred Verschueren wrote: From: Fred Verschueren Subject: Re: queries on mysql To: "Derek Atkins" Cc: gnucash-devel@gnucash.org Date: Thursday, November 25, 2010, 1:20 AM I have an assets:bankac

Re: queries on mysql

2010-11-25 Thread David T.
y are in Money), using a find and replace, export to QIF, and then import the QIF into Gnucash. David --- On Thu, 11/25/10, Fred Verschueren wrote: > From: Fred Verschueren > Subject: Re: queries on mysql > To: "Derek Atkins" > Cc: gnucash-devel@gnucash.org > Date: Thu

Re: queries on mysql

2010-11-25 Thread Fred Verschueren
Op 24-11-10 20:28, Derek Atkins schreef: Fred, Fred Verschueren writes: Frank et al, I'm coming from MS Money and use gnucash now for a month and I'm happy but I want to totally reorganise my data which I transferred from Money. To avoid I need to do this by hand I want to write a program/

Re: queries on mysql

2010-11-24 Thread Derek Atkins
Fred, Fred Verschueren writes: > Frank et al, > > I'm coming from MS Money and use gnucash now for a month and I'm happy > but I want to totally reorganise my data which I transferred from > Money. > To avoid I need to do this by hand I want to write a program/script > (preferable in python). A

Re: queries on mysql

2010-11-24 Thread Fred Verschueren
Frank et al, I'm coming from MS Money and use gnucash now for a month and I'm happy but I want to totally reorganise my data which I transferred from Money. To avoid I need to do this by hand I want to write a program/script (preferable in python). I had a look at the documentation on the API

Re: queries on mysql

2010-11-23 Thread Derek Atkins
"Frank H. Ellenberger" writes: > Fred, > > Am Montag, 22. November 2010 um 19:15:47 schrieb Fred Verschueren: > : >> 3. You mention an alternative by writing a (python) program using the API. >> Where can I find documentation on this API? > > If you do not have the sources on your machine, where

Re: queries on mysql

2010-11-23 Thread Derek Atkins
Donald Allen writes: > On Mon, Nov 22, 2010 at 10:54 AM, Derek Atkins wrote: >> Phil, >> >> Phil Longstaff writes: >> >>> I will put some info on the wiki.  Give me a day or so. >> >> I would prefer you didn't.  If you supply instructions then that implies >> an implicit acceptance in the pract

Re: queries on mysql

2010-11-22 Thread Frank H. Ellenberger
Fred, Am Montag, 22. November 2010 um 19:15:47 schrieb Fred Verschueren: : > 3. You mention an alternative by writing a (python) program using the API. > Where can I find documentation on this API? If you do not have the sources on your machine, where you could run make doc, you can use http://s

Re: queries on mysql

2010-11-22 Thread Fred Verschueren
Derek et al, 1. I do not want to move *all* data of one account to another one but "spread" the data from that account to several others. 2. I understand the problems and danger of using sql directly on the DB. 3. You mention an alternative by writing a (python) program using the API. Where c

Re: queries on mysql

2010-11-22 Thread Colin Law
On 22 November 2010 16:18, Donald Allen wrote: > On Mon, Nov 22, 2010 at 10:54 AM, Derek Atkins wrote: >> Phil, >> >> Phil Longstaff writes: >> >>> I will put some info on the wiki.  Give me a day or so. >> >> I would prefer you didn't.  If you supply instructions then that implies >> an implici

Re: queries on mysql

2010-11-22 Thread Donald Allen
On Mon, Nov 22, 2010 at 10:54 AM, Derek Atkins wrote: > Phil, > > Phil Longstaff writes: > >> I will put some info on the wiki.  Give me a day or so. > > I would prefer you didn't.  If you supply instructions then that implies > an implicit acceptance in the practice.  I believe we should continu

Re: queries on mysql

2010-11-22 Thread Derek Atkins
Phil, Phil Longstaff writes: > I will put some info on the wiki. Give me a day or so. I would prefer you didn't. If you supply instructions then that implies an implicit acceptance in the practice. I believe we should continue to have a hardline stance that we do not support modification of

Re: queries on mysql

2010-11-22 Thread Phil Longstaff
on mysql Ls, I'm currently working with version 2.3.17 with mysql as database. I need to do a lot of changes in my accounts, moving a lot of entries from one account to another. Now I was wondering if this could be done with some queries (SQL) on the database. I'm wiling to invest

queries on mysql

2010-11-22 Thread Fred Verschueren
Ls, I'm currently working with version 2.3.17 with mysql as database. I need to do a lot of changes in my accounts, moving a lot of entries from one account to another. Now I was wondering if this could be done with some queries (SQL) on the database. I'm wiling to investigate this and if