queries on mysql

[Donald Allen]

On Sat, Nov 27, 2010 at 5:23 AM, Fred Verschueren <fvsc at 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.

>
> Nevertheless I think having the layout of the database can help making own
> reports easy.

Absolutely. I've already done my own report-writing outside gnucash,
processing the xml file (with a python program; python has good xml
parsing facilities in its library), which I reverse-engineered. Having
the data in a database and the data-model documented will makes this
sort of thing much easier and the code less messy.

/Don

>
> Fred.
>
>
>
>
> Op 26-11-10 15:21, Donald Allen schreef:
>>
>> I'd like to suggest another possibility. My understanding is that you
>> have a number of years of payments to utilities all charged to one
>> expense account that you now want to separate into more specific
>> accounts. If the descriptions of the payments allow you to distinguish
>> them with 'Find' in gnucash, you can end up with a register displaying
>> just, say, the payments for electricity. You then correct the expense
>> account of the first payment, select the correct account, ctrl-c to
>> copy, and then either use the mouse to select the expense account of
>> the next transaction and paste, or do the navigation from the
>> keyboard, which I find much easier and faster. If you do it from the
>> keyboard, you will use a combination of down-arrow (to move to the
>> correct row), tab (to move to and select the account), ctrl-v (to
>> paste the correct expense account) and enter (to record the change in
>> the transaction) to correct the next transaction. I don't think you
>> will have trouble figuring out the correct sequence. Once you do, and
>> get into the flow, you'll correct a transaction every few seconds. If
>> you have 10 years of data and you've paid your electric bill
>> once/month, that's 120 transactions. A piece of cake. Then repeat the
>> process for the remaining transaction types. If you end up processing,
>> say, 400 or 500 transactions, I think you'll spend less time getting
>> it right this way (if it's 500 transactions and you spend 10
>> seconds/transaction, which is slow, that's 5000 seconds, or less than
>> 1.5 hours; and I think you can do it faster) than trying to learn
>> enough to write the code to mess with a .qif file or the data base,
>> write the code, and debug it. Hacking might be more fun, but I think
>> it will take you hours to get it right. I'd suggest gritting your
>> teeth and doing it the boring, manual way.
>>
>> /Don
>>
>>
>>>> Fred.
>>>
>>> -derek
>>>
>>>> Op 25-11-10 20:53, David T. schreef:
>>>>>
>>>>> Fred--
>>>>>
>>>>> I don't know how you have your accounting set up in Money. When I used
>>>>> Quicken, though, I had categories for Electricity, Gas, and Telecom,
>>>>> and
>>>>> 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
>>>>>
>>>>> --- On Thu, 11/25/10, Fred Verschueren<fvsc at fremar.be>    wrote:
>>>>>
>>>>>> From: Fred Verschueren<fvsc at fremar.be>
>>>>>> Subject: Re: queries on mysql
>>>>>> To: "Derek Atkins"<warlord at MIT.EDU>
>>>>>> Cc: gnucash-devel at 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 to expense:electricity, telecom to
>>>>>>
>>>>>> expense:telecom, gas to expense:gas, aso
>>>>>> This are monthly payments for more than 10 years.
>>>>>> So, a way to automate this would be very welcome.
>>>>>>
>>>>>> Fred.
>>>>>>
>>>>>
>>>>>
>>>>
>>> _______________________________________________
>>> gnucash-devel mailing list
>>> gnucash-devel at gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>>>
>
>