If those transactions appeared in the imbalance account because you imported them without correctly assigning them during the import process, just re-import them. Note that if they were imported from OFX files the bad transactions would have to be deleted before they can be re-imported.
On Sun, Jan 31, 2021 at 2:06 PM Stephen M. Butler < stephen.m.butle...@gmail.com> wrote: > I have not had to do this at a large enough level to warrant the below: > > 1. Make a backup copy of your file (I presume you are using XML instead > of a database back-end). > 2. Export all the transactions from the Imbalance Account (getting the > other splits also). > 3. Delete the entire Imbalance Account and all associated transactions > (why you needed to export the other splits). > 4. Pull the export from #2 into a spreadsheet or other editing tool and > make the assignments. > 5. Import the multi-split edited file from #4 into GnC. > 6. Do reports and other sanity checks to ensure everything is right. > > That's the safe and logical way. The other way is not safe and could > really mess things up so you still need a backup: > 1. Make that backup. > 2. Un-Compress the XML file so you can humanly read the contents. > 3. Figure out which fields you need to edit on which transactions (note > -- I've not used an XML editor so don't know how easy this might be. > I'd probably use vi or sed myself and groan inwardly.) > 4. Make those edits. > 5 Do the reports and other sanity checks to ensure everything is right. > 6. Go back to the backup copy and try again since #5 wasn't right. > Note: Loop through these steps as many times as needed until #5 looks > good. > > --Steve > > PS If using a database back-end and you have experience as a database > admin or programmer then use the database tools to effect the changes. > Again, make that backup first and loop around as needed until GnC looks > good. > > PPS Backups are mandatory. > > On 1/31/21 11:35 AM, Jeff Rizzo wrote: > > Hi- > > > > > > I'm currently trying to get my financial house back in order after > > some years, and have been pleasantly surprised with how much progress > > GNUCash has made since last I tried to use it (8 or 9 years ago). It > > seems to fit my need almost perfectly at this point, with one gaping > > hole - not being able to edit multiple transactions at the same time. > > :-( (I have read the "Register Tip" that says "There is no direct way > > to move a large number of transactions from one account to another in > > GnuCash.") > > > > > > As I'm trying to deal with several years' (two, at this point) worth > > of data, having to make three clicks to change each transaction is > > really a drag - and it's quickly sapping my enthusiasm for this > > project. Is there some workaround that some clever soul out there is > > using that would speed this up? To clarify, I'm trying to move large > > numbers of similar transactions from the "Imbalance" account to where > > they actually belong, so I don't see how I could easily do this by > > deleting an account. > > > > > > Thanks, > > > > +j > > > > > > > > _______________________________________________ > > 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. > > > -- > Stephen M Butler, PMP, PSM > stephen.m.butle...@gmail.com > kg...@arrl.net > 253-350-0166 > ------------------------------------------- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > > _______________________________________________ > 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. > -- David Carlson _______________________________________________ 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.
