Bulk transaction move
Wm
wm+gnc at tarrcity.demon.co.uk
Sat Dec 27 10:28:57 EST 2014
Mon, 22 Dec 2014 18:07:07 <5498CE4B.3020800 at polywatt.com> Thomas Young
<thomas at polywatt.com>
>I have an account named Miscellaneous with about 1400 transactions and
>I would like to move about 600 of them to a different account. Is there
>any way of doing this in a bulk move instead of one by one? I have
>tried saving my Gnucash file as Sqlite3 and editing account name
>records with openoffice but the results have been essentially gibberish
>back in Gnucash. My attempts with exporting and importing CSV have not
>been much better since it seems CSV exporting does not include all data
>like memos for instance.
I have used keystroke macros [1] to do similar tasks before.
basically you sort / filter your register so all the transactions you
want to change are next to each.
start recording, change one, stop recording. then run the keystroke
macro n many times and watch it trundle through your transactions
[1] I use TinyTask from http://www.vtaskstudio.com/support.php which is
free, I have no connection to them, others available, etc.
--
Wm...
More information about the gnucash-user
mailing list