[grisbi-user] Bulk edit transactions?

Barrie Treloar baerrach at gmail.com
Sat Oct 27 15:29:32 CEST 2012


I often find that I change my mind over time about how best to
categorise something.
Or perhaps I forget which category something is in and so need to
change them later.

I'm not enough of an expert with the Grisbi code base to make this enhancement.
(or whether there are enough people that would find this feature useful)

However, I do have a workaround.

Using the documentation of the file format
http://wiki.grisbi.org/doku.php?id=docs:dev:format_gsb#list_of_the_transactions
The fields I need to modify are usually:
* Pa=Party
* Ca=Category
* Sca=Subcategory

To list all the Category details:
grep \<Category Grisbi.gsb

To list all the Subcategory details:
grep \<Sub_category Grisbi.gsb

You have to manually match up the Sub_Category to its Category via the
Nbc field.

Then you can use see to transform your data on bulk.

e.g. Find all Party=60 and rewrite them so they have Category=5 and
Subcategory=5
sed 's/Pa="60" Ca="[0-9]" Sca="[0-9][0-9]*"/Pa="60" Ca="5" Sca="5"/' <
Grisbi.gsb > tmp.gsb

Obviously this would be easier within Grisbi.
Hopefully this will be helpful to someone else.


More information about the user mailing list