queries on mysql

[Derek Atkins]

Hi,

On Fri, November 26, 2010 3:26 am, Fred Verschueren wrote:
> David,
>
> sounds easy but the drawback would be that all the work that I have
> already done in GnuCash I need to do again.

Yes, but it's only 1 month of work, vs. 10 years of data.  It's your choice.

> Second, if it is that easy in Quicken and Money why can it not be also
> that easy in GnuCash.

I don't know if it IS that easy in Quicken, but GnuCash does not have the
ability to act on multiple transactions at once.  It's possible that
Quicken does (I don't know -- I've never used it).

HOWEVER, during the import you might be able to re-assign the accounts.. 
Or you may be able to massage the QIF itself with a perl script or text
editor to get the changes that you want.

My point is that if the import didn't put things where you want them to be
then perhaps you should re-run the import.  Yes, I realize that means
re-doing a month of work, but that's what?  50 transactions?  Just print
out a report of those transactions so you can re-enter them after you
re-import.

Seriously, taking the time to get the import done right will save you much
more time of angst and disappointment down the road.

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