Re: [GNC] find and replace

[D. via gnucash-user]

This message from 2014 covers the same problem: 
https://lists.gnucash.org/pipermail/gnucash-user/2014-February/052767.html


 Original Message 
From: Doug 
Sent: Sat Jan 30 17:19:33 EST 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] find and replace

Just a quick idea:
Perhaps you can do a sort on the known string of memo text. Next, as you edit & 
change categories, also edit the text (perhaps add a star or something in the 
middle) The search should drop that item then

You can also look in the unassigned category. As you change fields from 
unassigned to another category, they will drop out of unassigned.

regards, Doug (nb: I am no expert! but there is always a way)


On Sat, 30 Jan 2021 11:13:33 -0800
gnu Gord  wrote:

> Is it possible to find a specific split transaction based on the memo field
> and assign the account to transfer for that split item?
> 
> Let me explain. I'm new to GnuCash and have just imported my Quicken data
> QIF file but it appears that some transactions within splits have no
> transfer account assigned. It appears that I did not have a category
> assigned to them in Quicken. However, most seem to have the same memo text.
> There are really too many to do manually so some sort of find/replace would
> be helpful. If it's not possible within GnuCash, can the XML file be edited
> directly?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


-- 
Doug 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] find and replace

[Doug]

Just a quick idea:
Perhaps you can do a sort on the known string of memo text. Next, as you edit & 
change categories, also edit the text (perhaps add a star or something in the 
middle) The search should drop that item then

You can also look in the unassigned category. As you change fields from 
unassigned to another category, they will drop out of unassigned.

regards, Doug (nb: I am no expert! but there is always a way)


On Sat, 30 Jan 2021 11:13:33 -0800
gnu Gord  wrote:

> Is it possible to find a specific split transaction based on the memo field
> and assign the account to transfer for that split item?
> 
> Let me explain. I'm new to GnuCash and have just imported my Quicken data
> QIF file but it appears that some transactions within splits have no
> transfer account assigned. It appears that I did not have a category
> assigned to them in Quicken. However, most seem to have the same memo text.
> There are really too many to do manually so some sort of find/replace would
> be helpful. If it's not possible within GnuCash, can the XML file be edited
> directly?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


-- 
Doug 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] find and replace

[Geoff]

Hi Gord

You could also try exporting all the transactions from GnuCash to CSV, 
correcting the CSV file, and importing to a new GnuCash database.


I did a similar exercise recently to split an enterprise into two - a 
38,000 line CSV file imported without any problems (once I remembered to 
tick the "Multi-split" option, see attached).


Good luck.

Geoff
=

On 31/01/2021 7:40 am, Derek Atkins wrote:

Hi,

On Sat, January 30, 2021 2:13 pm, gnu Gord wrote:

Is it possible to find a specific split transaction based on the memo
field
and assign the account to transfer for that split item?


No, there is no way to en-masse manipulate multiple transactions.  The
ONLY en-masse thing you can do is reassign all transaction from one
account to another account.  For example, you could move ALL transactions
from "Imbalance-USD" into, e.g. Expenses:Groceries, by deleting the
Imbalance-USD account and telling GnuCash to target.  But if you're
looking to reassign a subset of transactions, then no, there is no way to
do that.


Let me explain. I'm new to GnuCash and have just imported my Quicken data
QIF file but it appears that some transactions within splits have no
transfer account assigned. It appears that I did not have a category
assigned to them in Quicken. However, most seem to have the same memo
text.
There are really too many to do manually so some sort of find/replace
would
be helpful. If it's not possible within GnuCash, can the XML file be
edited
directly?


Sounds like you might be better off starting over and re-importing the
QIF.  Fix the QIF file to assign a proper account target (or better yet,
map the Memo to the correct account during the QIF import).


Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


-derek

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] find and replace

[Derek Atkins]

Hi,

On Sat, January 30, 2021 2:13 pm, gnu Gord wrote:
> Is it possible to find a specific split transaction based on the memo
> field
> and assign the account to transfer for that split item?

No, there is no way to en-masse manipulate multiple transactions.  The
ONLY en-masse thing you can do is reassign all transaction from one
account to another account.  For example, you could move ALL transactions
from "Imbalance-USD" into, e.g. Expenses:Groceries, by deleting the
Imbalance-USD account and telling GnuCash to target.  But if you're
looking to reassign a subset of transactions, then no, there is no way to
do that.

> Let me explain. I'm new to GnuCash and have just imported my Quicken data
> QIF file but it appears that some transactions within splits have no
> transfer account assigned. It appears that I did not have a category
> assigned to them in Quicken. However, most seem to have the same memo
> text.
> There are really too many to do manually so some sort of find/replace
> would
> be helpful. If it's not possible within GnuCash, can the XML file be
> edited
> directly?

Sounds like you might be better off starting over and re-importing the
QIF.  Fix the QIF file to assign a proper account target (or better yet,
map the Memo to the correct account during the QIF import).

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] find and replace

[gnu Gord]

Is it possible to find a specific split transaction based on the memo field
and assign the account to transfer for that split item?

Let me explain. I'm new to GnuCash and have just imported my Quicken data
QIF file but it appears that some transactions within splits have no
transfer account assigned. It appears that I did not have a category
assigned to them in Quicken. However, most seem to have the same memo text.
There are really too many to do manually so some sort of find/replace would
be helpful. If it's not possible within GnuCash, can the XML file be edited
directly?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] find AND REPLACE?

[Glenn Bordonada via gnucash-user]

 
David,Thanks. I was able to get a readable (but quite big) text file.Glenn
On Saturday, April 14, 2018, 11:00:57 AM GMT+8, David Carlson 
 wrote:  
 
 Glenn,
Please address your messages to gnucash-user @gnucash.orgby using reply All.

As David T mentioned earlier the .gnucash file is compressed and it has to be 
saved in uncompressed XML format first.  To do that click on Edit > Preferences 
>General and uncheck Compress File then File > Save As... whatever filename and 
location you are using for your experiment.  

Remember when you go back to your original filename and location to again click 
on Edit > Preferences >General and check Compress Fileto resume saving in 
compressed format.

David C

On Fri, Apr 13, 2018 at 8:47 PM, Glenn Bordonada  
wrote:

 David,When I saved the .gnucash file as .xml, I found that the .xml file is 
not text but binary or encrypted code. I was hoping, I could extract the text 
data. Regards,Glenn
On Friday, April 13, 2018, 2:10:41 AM GMT+8, David Carlson 
 wrote:  
 
 The simplest answer is:  

1.  it is incredibly easy to break the file so that GnuCash cannot read it.

2.  A large part of the file is obfuscated by using tokens instead clear text 
so cross references are really difficult to follow.

David C

On Thu, Apr 12, 2018 at 12:47 PM, Glenn Bordonada via gnucash-user 
 wrote:

 Pardon a naive question from a newbie.
I noted that I can save my .gnucash file into .xml file which I can edit with a 
text editor or write text processing programs to extract the data in various 
ways.
Can anybody tell me what are the pros and cons for such a change?
Regards,Glenn

    On Friday, April 13, 2018, 1:15:14 AM GMT+8, C M Reinehr  
wrote:

 I'm still a novice at GnuCash but from previous discussions I do not
believe that there is a global find and replace utility. But two ideas
come to mind. If your file format is XML, isn't that a text file? If it
is, you could use a text editor ('vi' if you're on Linux) to do a global
search & replace. Or, if you are using SQLite, you could use the dump
utility to create a text SQL file and, likewise, use a text editor. Then
rebuild your GnuCash file from the edited SQL dump file.

HTH!

CMR


On 04/09/2018 11:11 PM, Paul Costan wrote:
> I am looking for the command(s) or work-around to accomplish what I
> used to use in Quicken as Find and Replace.  Specifically, after
> downloading multiple months of transactions from my credit union into
> a simple checkbook ledger, I could use the Quicken "find" to select
> all transactions with description "Safeway" and then select from them
> to "replace" the category to "Groceries". I'm good in Gnucash up
> through the Find part, can't figure out how to easily set the Account
> without a lot of keystrokes. Didn't see anything in the
> manual/help/faq.  Suggestions? Thanks.
>
> __ _
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/ mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/ Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

--
Linux distribution Debian 8 "Jessie"

"We contend that for a nation to tax itself into prosperity is like a man 
standing in a bucket and trying to lift himself up by the handle." --Winston 
Churchill
--

__ _
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/ mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/ 
Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
__ _
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/ mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/ 
Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

  

  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] find AND REPLACE?

[David Carlson]

Glenn,
Please address your messages to gnucash-user@gnucash.org by using reply All.

As David T mentioned earlier the .gnucash file is compressed and it has to
be saved in uncompressed XML format first.  To do that click on Edit >
Preferences >General and uncheck Compress File then File > Save As...
whatever filename and location you are using for your experiment.

Remember when you go back to your original filename and location to again
click on Edit > Preferences >General and check Compress File to resume
saving in compressed format.

David C

On Fri, Apr 13, 2018 at 8:47 PM, Glenn Bordonada 
wrote:

> David,
> When I saved the .gnucash file as .xml, I found that the .xml file is not
> text but binary or encrypted code.
> I was hoping, I could extract the text data.
> Regards,
> Glenn
>
> On Friday, April 13, 2018, 2:10:41 AM GMT+8, David Carlson <
> david.carlson@gmail.com> wrote:
>
>
> The simplest answer is:
>
> 1.  it is incredibly easy to break the file so that GnuCash cannot read it.
>
> 2.  A large part of the file is obfuscated by using tokens instead clear
> text so cross references are really difficult to follow.
>
> David C
>
> On Thu, Apr 12, 2018 at 12:47 PM, Glenn Bordonada via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>  Pardon a naive question from a newbie.
> I noted that I can save my .gnucash file into .xml file which I can edit
> with a text editor or write text processing programs to extract the data in
> various ways.
> Can anybody tell me what are the pros and cons for such a change?
> Regards,Glenn
>
> On Friday, April 13, 2018, 1:15:14 AM GMT+8, C M Reinehr <
> c...@reinehr.net> wrote:
>
>  I'm still a novice at GnuCash but from previous discussions I do not
> believe that there is a global find and replace utility. But two ideas
> come to mind. If your file format is XML, isn't that a text file? If it
> is, you could use a text editor ('vi' if you're on Linux) to do a global
> search & replace. Or, if you are using SQLite, you could use the dump
> utility to create a text SQL file and, likewise, use a text editor. Then
> rebuild your GnuCash file from the edited SQL dump file.
>
> HTH!
>
> CMR
>
>
> On 04/09/2018 11:11 PM, Paul Costan wrote:
> > I am looking for the command(s) or work-around to accomplish what I
> > used to use in Quicken as Find and Replace.  Specifically, after
> > downloading multiple months of transactions from my credit union into
> > a simple checkbook ledger, I could use the Quicken "find" to select
> > all transactions with description "Safeway" and then select from them
> > to "replace" the category to "Groceries". I'm good in Gnucash up
> > through the Find part, can't figure out how to easily set the Account
> > without a lot of keystrokes. Didn't see anything in the
> > manual/help/faq.  Suggestions? Thanks.
> >
> > __ _
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/ mailman/listinfo/gnucash-user
> 
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/ Mailing_Lists
>  for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> --
> Linux distribution Debian 8 "Jessie"
> 
> "We contend that for a nation to tax itself into prosperity is like a man
> standing in a bucket and trying to lift himself up by the handle."
> --Winston Churchill
> --
>
> __ _
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/ mailman/listinfo/gnucash-user
> 
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/
> Mailing_Lists  for more
> information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> __ _
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/ mailman/listinfo/gnucash-user
> 
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/
> Mailing_Lists  for more
> information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:

Re: [GNC] find AND REPLACE?

[cicko]

If you do decide to go down that route, it would probably be much easier to
save the file as an SQLite database (or a few other SQL options) and then
modify the data using SQL.
Note the disclaimer about making backups, being responsible for any damaga,
yada, yada.
However, if you are comfortable with SQL, modifying destination account Ids
in splits should not be such a big deal unless they also include different
currencies and you're using trading accounts, etc. It can get complex fairly
quickly.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] find AND REPLACE?

[D]

To be more specific about item 2, Gnucash uses a random 32 character string to 
store account information in transactions, rather than an account name. This, 
of course, means that you can rename an account without breaking all the 
transactions that have used that account previously. The downside is that you 
can't simply read a transaction in the stored XML and ascertain which 
transactions are using a given account. 

That being said, if you were to determine the proper codes involved, a simple 
find and replace of the codes in the text file will change the references. As 
David C noted, though, if you break it somehow, you're on your own. Note that 
by default, Gnucash compressed your XML file, and that you have to expand it 
before it is readable in a text editor. There are explanations about this on 
the wiki, I believe. 

Oh, and should you choose to go this route, a backup taken before you mess with 
the file might be prudent.

David T

On April 12, 2018, at 11:11 PM, David Carlson  
wrote:

The simplest answer is:

1.  it is incredibly easy to break the file so that GnuCash cannot read it.

2.  A large part of the file is obfuscated by using tokens instead clear
text so cross references are really difficult to follow.

David C

On Thu, Apr 12, 2018 at 12:47 PM, Glenn Bordonada via gnucash-user <
gnucash-user@gnucash.org> wrote:

>  Pardon a naive question from a newbie.
> I noted that I can save my .gnucash file into .xml file which I can edit
> with a text editor or write text processing programs to extract the data in
> various ways.
> Can anybody tell me what are the pros and cons for such a change?
> Regards,Glenn
>
> On Friday, April 13, 2018, 1:15:14 AM GMT+8, C M Reinehr <
> c...@reinehr.net> wrote:
>
>  I'm still a novice at GnuCash but from previous discussions I do not
> believe that there is a global find and replace utility. But two ideas
> come to mind. If your file format is XML, isn't that a text file? If it
> is, you could use a text editor ('vi' if you're on Linux) to do a global
> search & replace. Or, if you are using SQLite, you could use the dump
> utility to create a text SQL file and, likewise, use a text editor. Then
> rebuild your GnuCash file from the edited SQL dump file.
>
> HTH!
>
> CMR
>
>
> On 04/09/2018 11:11 PM, Paul Costan wrote:
> > I am looking for the command(s) or work-around to accomplish what I
> > used to use in Quicken as Find and Replace.  Specifically, after
> > downloading multiple months of transactions from my credit union into
> > a simple checkbook ledger, I could use the Quicken "find" to select
> > all transactions with description "Safeway" and then select from them
> > to "replace" the category to "Groceries". I'm good in Gnucash up
> > through the Find part, can't figure out how to easily set the Account
> > without a lot of keystrokes. Didn't see anything in the
> > manual/help/faq.  Suggestions? Thanks.
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> --
> Linux distribution Debian 8 "Jessie"
> 
> "We contend that for a nation to tax itself into prosperity is like a man
> standing in a bucket and trying to lift himself up by the handle."
> --Winston Churchill
> --
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using 

Re: [GNC] find AND REPLACE?

[David Carlson]

The simplest answer is:

1.  it is incredibly easy to break the file so that GnuCash cannot read it.

2.  A large part of the file is obfuscated by using tokens instead clear
text so cross references are really difficult to follow.

David C

On Thu, Apr 12, 2018 at 12:47 PM, Glenn Bordonada via gnucash-user <
gnucash-user@gnucash.org> wrote:

>  Pardon a naive question from a newbie.
> I noted that I can save my .gnucash file into .xml file which I can edit
> with a text editor or write text processing programs to extract the data in
> various ways.
> Can anybody tell me what are the pros and cons for such a change?
> Regards,Glenn
>
> On Friday, April 13, 2018, 1:15:14 AM GMT+8, C M Reinehr <
> c...@reinehr.net> wrote:
>
>  I'm still a novice at GnuCash but from previous discussions I do not
> believe that there is a global find and replace utility. But two ideas
> come to mind. If your file format is XML, isn't that a text file? If it
> is, you could use a text editor ('vi' if you're on Linux) to do a global
> search & replace. Or, if you are using SQLite, you could use the dump
> utility to create a text SQL file and, likewise, use a text editor. Then
> rebuild your GnuCash file from the edited SQL dump file.
>
> HTH!
>
> CMR
>
>
> On 04/09/2018 11:11 PM, Paul Costan wrote:
> > I am looking for the command(s) or work-around to accomplish what I
> > used to use in Quicken as Find and Replace.  Specifically, after
> > downloading multiple months of transactions from my credit union into
> > a simple checkbook ledger, I could use the Quicken "find" to select
> > all transactions with description "Safeway" and then select from them
> > to "replace" the category to "Groceries". I'm good in Gnucash up
> > through the Find part, can't figure out how to easily set the Account
> > without a lot of keystrokes. Didn't see anything in the
> > manual/help/faq.  Suggestions? Thanks.
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> --
> Linux distribution Debian 8 "Jessie"
> 
> "We contend that for a nation to tax itself into prosperity is like a man
> standing in a bucket and trying to lift himself up by the handle."
> --Winston Churchill
> --
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] find AND REPLACE?

[Glenn Bordonada via gnucash-user]

 Pardon a naive question from a newbie.
I noted that I can save my .gnucash file into .xml file which I can edit with a 
text editor or write text processing programs to extract the data in various 
ways.
Can anybody tell me what are the pros and cons for such a change?
Regards,Glenn

On Friday, April 13, 2018, 1:15:14 AM GMT+8, C M Reinehr  
wrote:  
 
 I'm still a novice at GnuCash but from previous discussions I do not 
believe that there is a global find and replace utility. But two ideas 
come to mind. If your file format is XML, isn't that a text file? If it 
is, you could use a text editor ('vi' if you're on Linux) to do a global 
search & replace. Or, if you are using SQLite, you could use the dump 
utility to create a text SQL file and, likewise, use a text editor. Then 
rebuild your GnuCash file from the edited SQL dump file.

HTH!

CMR


On 04/09/2018 11:11 PM, Paul Costan wrote:
> I am looking for the command(s) or work-around to accomplish what I 
> used to use in Quicken as Find and Replace.  Specifically, after 
> downloading multiple months of transactions from my credit union into 
> a simple checkbook ledger, I could use the Quicken "find" to select 
> all transactions with description "Safeway" and then select from them 
> to "replace" the category to "Groceries". I'm good in Gnucash up 
> through the Find part, can't figure out how to easily set the Account 
> without a lot of keystrokes. Didn't see anything in the 
> manual/help/faq.  Suggestions? Thanks.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-- 
Linux distribution Debian 8 "Jessie"

"We contend that for a nation to tax itself into prosperity is like a man 
standing in a bucket and trying to lift himself up by the handle." --Winston 
Churchill
--

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] find AND REPLACE?

[C M Reinehr]

I'm still a novice at GnuCash but from previous discussions I do not 
believe that there is a global find and replace utility. But two ideas 
come to mind. If your file format is XML, isn't that a text file? If it 
is, you could use a text editor ('vi' if you're on Linux) to do a global 
search & replace. Or, if you are using SQLite, you could use the dump 
utility to create a text SQL file and, likewise, use a text editor. Then 
rebuild your GnuCash file from the edited SQL dump file.


HTH!

CMR


On 04/09/2018 11:11 PM, Paul Costan wrote:
I am looking for the command(s) or work-around to accomplish what I 
used to use in Quicken as Find and Replace.  Specifically, after 
downloading multiple months of transactions from my credit union into 
a simple checkbook ledger, I could use the Quicken "find" to select 
all transactions with description "Safeway" and then select from them 
to "replace" the category to "Groceries". I'm good in Gnucash up 
through the Find part, can't figure out how to easily set the Account 
without a lot of keystrokes. Didn't see anything in the 
manual/help/faq.  Suggestions? Thanks.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
Linux distribution Debian 8 "Jessie"

"We contend that for a nation to tax itself into prosperity is like a man standing 
in a bucket and trying to lift himself up by the handle." --Winston Churchill
--

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] find AND REPLACE?

[Paul Costan]

I am looking for the command(s) or work-around to accomplish what I used 
to use in Quicken as Find and Replace.  Specifically, after downloading 
multiple months of transactions from my credit union into a simple 
checkbook ledger, I could use the Quicken "find" to select all 
transactions with description "Safeway" and then select from them to 
"replace" the category to "Groceries". I'm good in Gnucash up through 
the Find part, can't figure out how to easily set the Account without a 
lot of keystrokes. Didn't see anything in the manual/help/faq.  
Suggestions? Thanks.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.