#!/bin/bash if [ ! -f Persons.csv ]; then
echo Please run in data-directory! exit
fi
cp Persons.csv Persons.csv.backup.$( date +%Y%m%d-%M%H )
# First we read everything in slapcat | egrep “(^MaN-Internet-Cash|^cn|^uidNumber)” | grep -B 2 MaN | grep -v – “–” > cash
# Then we clean up Persons.csv perl -pi -e “s/.credit_due*,//” Persons.csv
# Finally we set every cash while read one; do
read two read three echo -e "$one\n$two\n$three" | sort | sed -e "s/.* //" > cash.tmp while read cn; do read cash read uid echo cn is $cn with uid=$uid and $cash CFAs; perl -pi -e "s/(.person_id..$uid[^0-9])/\"credit\":$cash,\1/" Persons.csv done < cash.tmp
done < cash