csv转vCard格式,用于通讯录批量导入手机。
csv字段如下:
[root@repo csv2vcf]# cat list.csv 姓,名,QQ,手机号,邮箱,职位,生日,公司,部门
csv2vcf.sh代码:
#!/bin/bash
############################
# Usage:
# File Name: csv2vcf.sh
# Author: annhe
# Mail: i@annhe.net
# Created Time: 2015-09-10 11:32:50
############################
while read id;do
FIRSTNAME=`echo $id | awk -F "," '{print $1}'`
LASTNAME=`echo $id | awk -F "," '{print $2}'`
CORP=`echo $id | awk -F "," '{print $8}'`
DEPART=`echo $id | awk -F "," '{print $9}'`
TITLE=`echo $id | awk -F "," '{print $6}'`
TEL=`echo $id | awk -F "," '{print $4}'`
EMAIL=`echo $id | awk -F "," '{print $5}'`
IMADDRESS=`echo $id | awk -F "," '{print $3}'`
cat >> list.vcf <<EOF
BEGIN:VCARD
VERSION:2.1
N;LANGUAGE=zh-cn;CHARSET=utf8:$FIRSTNAME;$LASTNAME
FN;CHARSET=utf8:$FIRSTNAME$LASTNAME
ORG;CHARSET=utf8:$CORP;$DEPART
TITLE;CHARSET=utf8:$TITLE
TEL;CELL;VOICE:$TEL
X-MS-OL-DEFAULT-POSTAL-ADDRESS:0
EMAIL;PREF;INTERNET:$EMAIL
X-QQ:$IMADDRESS
END:VCARD
EOF
done <list.csv
发表回复