I'll second what David T. mentioned below. Cut-&-Paste using CTRL-X combo seems to go much faster than exporting-modifying-importing cycles. Just note that you will have to highlight the transfer account name before pressing CTRL-C to capture it to the clipboard in order to paste it.
If you are on Windoze, you may want to look at nifty little open-source utility called Hotkeys from https://www.autohotkey.com/ ... and specifically the "How to Send Keystrokes" with a single hotkey ... -----Original Message----- From: sunfis...@yahoo.com <sunfis...@yahoo.com> Sent: Tuesday, February 11, 2025 4:21 AM To: Geoff <cleanoutmys...@gmail.com> Cc: Adrian Holbrook <megagru...@hotmail.com>; gnucash-user@gnucash.org Subject: Re: [GNC] Batch transfer from one expense category to another. I'd go a different route. In your register window sorted by description so the following: 1) Edit one transaction with the new account, and before leaving, CTRL-C the complete transfer account name. Save the transaction. It will disappear from the register. 2) I'm the next transaction, highlight the transfer field, press CTRL-V to paste the new account name, and press enter several times to commit the transaction. Repeat step 2 until all phone transactions are gone from the register. Although it sounds odious, this process can go pretty quickly. David T. On Feb 11, 2025, 11:18 AM, at 11:18 AM, Geoff <cleanoutmys...@gmail.com> wrote: >Hi Adrian > >Unless you are comfortable saving your data into an SQL database (eg >SQLite) and doing manipulation using SQL queries, your suggestion of >exporting, manipulating, and reimporting is the best solution. > >I suggest you: >(a) Take a backup >(b) Export all transactions in your Utilities Account >(c) Rename the Account to Utilities-OLD >(d) Import your modified transactions >(e) Check that Utilities + Phone = Utilities-OLD >(f) Delete the Utilities-OLD Account. > >Regards > >Geoff >===== > >On 11/02/2025 6:47 pm, Adrian Holbrook wrote: >> I have a number of entries that I have classified under the expense >category "Utilities". I now wish to remove all my phone payments from >that category and have a new category for "Phone". The description for >all these entries is the same so I have sorted by description and am >laboriously going through 20 years of records to transfer each one >individually. Is there a way of doing this as a batch process? I have >thought of exporting the transactions as a CSV file, importing into >Excel, filtering them and editing the transactions and importing back >into Gnucash. >> _______________________________________________ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> ----- >> 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 >----- >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 ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
