Ok, so we have a way to get the awards *out* of ucoz, what about a way to get them *into* ldap?
Code
cat exportedAwards050815.csv | grep Gigglesmirk | while read award ; do curl "http://autoroster.the-confederation.net/rosters_arg.php?mode=appendAward&uid=$(echo $award | cut -d'|' -f1)&password=REDACTED&type=$(echo $award | cut -d'|' -f2 | sed 's/\ /\+/g')&date=$(echo $award | cut -d'|' -f3 | sed 's/\ /\+/g' | sed 's/\:/\%3A/g')&reason=$(echo $award | cut -d'|' -f4 | sed 's/\ /\+/g' | tr -d '<>#%{}[]|\/^~`;?:@=&$')" ; done
And here you can see the results:
http://autoroster.the-confederation.net/rosters....lesmirk
There are a couple of rough spots here. I'm not sure I like the date formatting. It does not agree with the default dates filled by the add award form and it is probably not the easiest to parse in the future. It is a fairly simple matter to change this date format in the export script, we just need to pick a standard format and stick with it.
Likewise, I need to be careful about funky characters in the reason field. As such I'm simply stripping out all of these:
<>#%{}[]|\/^~`;?:@=&$
I can go to the effort to carefully escape and preserve these but it doesn't seem like a good use of time.
Also there are currently two different forms of combat pin and service cross. We need to decide to merge them or formalize the difference in the lore.
