Create Polycom directory from FreePBX

#!/bin/bash

xml_head='<?xml version="1.0" charset="utf-8" standalone="yes"?>\n<directory>\n<itemlist>'
xml_tail='</itemlist>\n</directory>'

mysql -N -D asterisk -e 'SELECT name, extension FROM users ORDER BY extension' | \
  awk -F"\t" -v "xh=$xml_head" -v "xt=$xml_tail" '
  BEGIN {print xh}
  {printf ("<item><fn>%s</fn><ln>%s</ln><ct>%d</ct></item>\n", substr($1,0,index($1," ")-1), substr($1,index($1," ")+1), $2)}
  END {print xt}'