aheinecke@6866: #!/bin/sh
aheinecke@6866: 
aheinecke@6866: # Use this on an exported query from roundup
aheinecke@6866: # Known issue: Tiles with more then three , in them fail.
aheinecke@6866: # Yes (ah) I do not know how to correctly handle the csv quoting...
aheinecke@6866: 
aheinecke@6866: echo "-------------"
aheinecke@6866: echo "Unter anderem wurden folgende issues bearbeitet und können getestet werden:"
aheinecke@6866: 
aheinecke@6866: sed 's/"\(.*\),\(.*\)"/"\1§\2"/g' "$1" | \
aheinecke@6866: sed 's/"\(.*\),\(.*\)"/"\1§\2"/g' | \
aheinecke@6866: sed 's/"\(.*\),\(.*\)"/\1§\2/g' | \
aheinecke@6866: gawk -F, '$5 > 5 {
aheinecke@6866: print "- flys/issue"$2 " ("$1")"
aheinecke@6866: print "[https://roundup-intern.intevation.de/flys/issue"$2"]"
aheinecke@6866: print ""
aheinecke@6866: }' | sed 's/§/,/g'
aheinecke@6866: 
aheinecke@6866: 
aheinecke@6866: echo "-------------"
aheinecke@6866: echo "Desweiteren gab es fortschritte in folgenden Issues:"
aheinecke@6866: echo ""
aheinecke@6866: sed 's/"\(.*\),\(.*\)"/"\1§\2"/g' "$1" | \
aheinecke@6866: sed 's/"\(.*\),\(.*\)"/"\1§\2"/g' | \
aheinecke@6866: sed 's/"\(.*\),\(.*\)"/\1§\2/g' | \
aheinecke@6866: gawk -F, '$5 <= 5 && $5 > 0 {
aheinecke@6866: print "- flys/issue"$2 " ("$1")"
aheinecke@6866: print "[https://roundup-intern.intevation.de/flys/issue"$2"]"
aheinecke@6866: print ""
aheinecke@6866: }' | sed 's/§/,/g'
aheinecke@6866: