Re: [GNC] find and replace

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

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

Re: [GNC] find and replace

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

Re: [GNC] find and replace

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

[GNC] find and replace

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

Re: [GNC] find AND REPLACE?

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

Re: [GNC] find AND REPLACE?

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

Re: [GNC] find AND REPLACE?

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

Re: [GNC] find AND REPLACE?

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

Re: [GNC] find AND REPLACE?

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

Re: [GNC] find AND REPLACE?

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

Re: [GNC] find AND REPLACE?

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 &

[GNC] find AND REPLACE?

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