#!/bin/sh
green="\033[0;32m"
lgreen="\033[0;36m"
nocol="\033[0m"
[ -z "$1" ] || [ -z "$2" ] && {
  printf "Usage:$green xlsx-to-vcards.sh file.xlsx output-dir\n"
  printf "$lgreen  output-dir$nocol will be filled with .vcf files\n"
  exit 1
}
printf "Converting to csv..\n"
#libreoffice --headless --convert-to csv "$1" --outdir /tmp/
[ -d "$2" ] || {
  printf "Dir %s doesn't exit, creating..\n"
  mkdir -pv "$2" || exit 1
}
OUTD="$2"
bname="${1##*/}"
csvfname="/tmp/${bname%.*}.csv"
echo "$(file "$csvfname")"
create_vcf() {
  [ -z "$1" ] || [ -z "$2" ] || [ -z "$3" ] && {
    printf "Invocation (no spaces in names/p.numbers):\n"
    printf "create_vcard last_name first_name phone\n"
    exit 1
  }
  uid=$(uuidgen -s -n @oid -N $1_$2)
  ofname="${OUTD}/${uid}.vcf"
  printf "BEGIN:VCARD\nVERSION:3.0\n" > $ofname
  printf "UID:%s\n" $uid >> $ofname
  printf "FN:%s %s\n" $2 $1 >> $ofname
  printf "TEL;TYPE=cell:+%s\n" $3 >> $ofname
  printf "END:VCARD" >> $ofname
  unix2dos $ofname
}
for trip in $(strings "$csvfname"|sed -E 's/[",]/ /g;s/7-9/79/g'|
  awk 'NR>1 {printf "%s_%s_%s\n", $2, $3, $NF}')
do
  fname=${trip%_*}
  fname=${fname#*_}
  create_vcf ${trip%%_*} $fname ${trip##*_}
done