[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
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gnc_csv_import.jpg
Type: image/jpeg
Size: 84712 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210131/cdc2bebb/attachment-0001.jpg>