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 Fred Verschueren
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 Verschuerenf...@fremar.bewrote: From: Fred Verschuerenf...@fremar.be Subject: Re: queries on mysql

Re: queries on mysql

2010-11-27 Thread Donald Allen
into Gnucash. David --- On Thu, 11/25/10, Fred Verschuerenf...@fremar.be    wrote: From: Fred Verschuerenf...@fremar.be Subject: Re: queries on mysql To: Derek Atkinswarl...@mit.edu Cc: gnucash-devel@gnucash.org Date: Thursday, November 25, 2010, 1:20 AM I have an assets:bankaccount:bank

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 f...@fremar.be 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
On Sat, Nov 27, 2010 at 11:23 AM, John Ralls jra...@ceridwen.us wrote: On Nov 27, 2010, at 4:40 AM, Donald Allen wrote: On Sat, Nov 27, 2010 at 5:23 AM, Fred Verschueren f...@fremar.be wrote: Don, thanks for your advice and explanation. I've done it the way you described and it took me 50

Re: queries on mysql

2010-11-26 Thread Fred Verschueren
, export to QIF, and then import the QIF into Gnucash. David --- On Thu, 11/25/10, Fred Verschuerenf...@fremar.be wrote: From: Fred Verschuerenf...@fremar.be Subject: Re: queries on mysql To: Derek Atkinswarl...@mit.edu Cc: gnucash-devel@gnucash.org Date: Thursday, November 25, 2010, 1:20 AM I

Re: queries on mysql

2010-11-26 Thread Derek Atkins
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 Verschuerenf...@fremar.be wrote: From: Fred Verschuerenf...@fremar.be Subject: Re: queries on mysql To: Derek Atkinswarl...@mit.edu Cc

Re: queries on mysql

2010-11-26 Thread Donald Allen
: Fred Verschuerenf...@fremar.be Subject: Re: queries on mysql To: Derek Atkinswarl...@mit.edu Cc: gnucash-devel@gnucash.org Date: Thursday, November 25, 2010, 1:20 AM I have an assets:bankaccount:bank with payments for electricity, telecom, gas, aso to expense:XX. I want electricity to go

Re: queries on mysql

2010-11-25 Thread Fred Verschueren
Op 24-11-10 20:28, Derek Atkins schreef: Fred, Fred Verschuerenf...@fremar.be 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

Re: queries on mysql

2010-11-25 Thread David T.
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 Verschueren f...@fremar.be wrote: From: Fred Verschueren f...@fremar.be Subject: Re: queries on mysql To: Derek Atkins warl...@mit.edu Cc: gnucash-devel@gnucash.org

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

Re: queries on mysql

2010-11-24 Thread Derek Atkins
Fred, Fred Verschueren f...@fremar.be 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

Re: queries on mysql

2010-11-23 Thread Derek Atkins
Donald Allen donaldcal...@gmail.com writes: On Mon, Nov 22, 2010 at 10:54 AM, Derek Atkins warl...@mit.edu wrote: Phil, Phil Longstaff plongst...@rogers.com 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

Re: queries on mysql

2010-11-23 Thread Derek Atkins
Frank H. Ellenberger f.ellenber...@online.de 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

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

Re: queries on mysql

2010-11-22 Thread Phil Longstaff
Subject: queries 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

Re: queries on mysql

2010-11-22 Thread Derek Atkins
Phil, Phil Longstaff plongst...@rogers.com 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

Re: queries on mysql

2010-11-22 Thread Donald Allen
On Mon, Nov 22, 2010 at 10:54 AM, Derek Atkins warl...@mit.edu wrote: Phil, Phil Longstaff plongst...@rogers.com 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.  

Re: queries on mysql

2010-11-22 Thread Colin Law
On 22 November 2010 16:18, Donald Allen donaldcal...@gmail.com wrote: On Mon, Nov 22, 2010 at 10:54 AM, Derek Atkins warl...@mit.edu wrote: Phil, Phil Longstaff plongst...@rogers.com writes: I will put some info on the wiki.  Give me a day or so. I would prefer you didn't.  If you supply

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

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