GPCats to GPX

gpcats-to-gpx.sh

#!/usr/bin/env bash

collar=myCollarId # replace this!
days=1
charging=no

if [[ $1 = "gsm" ]]; then
  script="db_output_gsm.php"
else
  script="db_output.php"
fi

curl -s "http://h2572785.stratoserver.net/~jklose/${script}?did=${collar}&setting24=${days}&displaycharging=${charging}" > /tmp/gpcats

header=$(head -1 /tmp/gpcats)

columns=""
for column in ${header//,/ }; do
  let colnum=${colnum:-0}+1
  case $column in
    latitude|longitude|altitude|sec|min|hour|day|month|year|numSats)
       columns+="$colnum,"
       ;;
   esac
done

grep -v -e EOF -e '^0,0,' /tmp/gpcats \
  | cut -d, -f${columns::-1} \
  | perl -pe 's|(\d{2}),(\d{2}),(\d{2}),(\d{2}),(\d{2}),(\d{4})|\6-\5-\4,\3:\2:\1|g; s/sec,min,hour,day,month,year/date,time/;' \
  | gpsbabel -i unicsv -f - \
      -x transform,trk=wpt \
      -x nuketypes,waypoints \
      -x track,speed \
      -x track,course \
      -x validate,checkempty \
      -o gpx -F -