queries on mysql

[Fred Verschueren]

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.

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

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
>>