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. > > 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<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 >>>>>> 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@gnucash.org >>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel >>> > > _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
