#!/bin/bash

# Quick and dirty script to parse a CSV file and output XML for Illustrator
# Header and footer can be grabbed from sample 
# CC Attribution-ShareAlike 3.0 http://creativecommons.org/licenses/by-sa/3.0/legalcode

# Usage: make_ai_xml <input csv filename> <output xml filename>

if [ -z $1 ]; then
  printf "We need an input CSV file and an output XML file:\n\n"
  printf ". make_ai_xml <input csv filename> <output XML filename>\n"
  return
elif [ -z $2 ]; then
  printf "We need an output XML file:\n\n"
  printf ". :wq
make_ai_xml <input csv filename> <output XML filename>\n"
  return
fi

printf "\t\t<v:sampleDataSets\txmlns=\"&ns_custom;\"\txmlns:v=\"&ns_vars;\">\n" > body.xml

while read csvLine; do
  Surname=`echo $csvLine | cut -d"," -f1`
  Name=`echo $csvLine | cut -d"," -f2`
  Address=`echo $csvLine | cut -d"," -f3`
  Phone=`echo $csvLine | cut -d"," -f4`
  Webpage=`echo $csvLine | cut -d"," -f5`
  printf "\t\t\t<v:sampleDataSet\tdataSetName=\"$Surname\">\n"
  printf "\t\t\t\t<Name>\n\t\t\t\t\t<p>$Name</p>\n\t\t\t\t</Name>\n"
  printf "\t\t\t\t<Address>\n\t\t\t\t\t<p>$Address</p>\n\t\t\t\t</Address>\n"
  printf "\t\t\t\t<Phone>\n\t\t\t\t\t<p>$Phone</p>\n\t\t\t\t</Phone>\n"
  printf "\t\t\t\t<Web_page>\n\t\t\t\t\t<p>$Webpage</p>\n\t\t\t\t</Web_page>\n"
  printf "\t\t\t</v:sampleDataSet>\n"
done < $1 >> body.xml
cat header.xml body.xml footer.xml > $2

