#!/bin/bash
# url: http://pank.org/scripts/
# description: convert Nokia PC Suite csv file to Google contacts csv file
# comment: bash
# platform: all

if [ -f nokia.csv ] ; then
    echo "Name,Given Name,Additional Name,Family Name,Yomi Name,Given Name Yomi,Additional Name Yomi,Family Name Yomi,Name Prefix,Name Suffix,Initials,Nickname,Short Name,Maiden Name,Birthday,Gender,Location,Billing Information,Directory Server,Mileage,Occupation,Hobby,Sensitivity,Priority,Subject,Notes,Group Membership,E-mail 1 - Type,E-mail 1 - Value,Phone 1 - Type,Phone 1 - Value,Website 1 - Type,Website 1 - Value" > google.csv
    sed -n '2,$p' nokia.csv | iconv -funicode -tutf-8 | tr -d \" | awk -F, '{if (substr($15,0,2)=="09") type="Mobile"; else type="Home"; print $2$3$4",,,,,,,,,,,,,,,,,,,,,,,,,,Nokia,,,"type","$15}' >> google.csv
fi