# -*- coding: utf-8 -*-
#python 3.x

import csv
import sys

#convert a "comma separated values" file to vcf contact cards. I used this to convert a list of student
#names and phone numbers into a vcf and save the trouble of adding one by one through phone

#USAGE:
#CSV_to_Vcards.py CSV_filename


def convert(somefile):
    #assuming file format : lastname,firstname,phonenumber,mail
    with open( somefile, 'r' ) as source:
        reader = csv.reader( source ) #reader now holds the whole data like ['lastname', 'firstname', 'phonenumber', 'mail']
        allvcf = open('ALL.vcf', 'w') 
        i = 0
        for row in reader:
            #write in the "ALL.vcf" file.
            allvcf.write( 'BEGIN:VCARD' + "\n")
            allvcf.write( 'VERSION:2.1' + "\n")
            allvcf.write( 'N:' + row[0] + ';' + row[1] + "\n")
            allvcf.write( 'FN:' + "Bootcamp " + row[1] + ' ' + row[0] + "\n") #remember that lastname first
            allvcf.write( 'ORG:' + 'Bootcamp' + "\n")
            allvcf.write( 'TEL;CELL:' + row[2] + "\n")
            allvcf.write( 'EMAIL:' + row[3] + "\n")
            allvcf.write( 'END:VCARD' + "\n")
            allvcf.write( "\n")

            i += 1#counts

        allvcf.close()
        print (str(i) + " vcf cards generated")


def main(args):
    if len(args) != 2:
        print ( "Usage:")
        print ( args[0] + " filename")
        return

    convert(args[1])

if __name__ == '__main__':
    main(sys.argv)

import csv
import vobject

# org,department,name,title,office,phone,email,cell
# 研究院,院领导,xxx,党委书记,主616,xxxxxxx,,186xxxxxxx

def csv2vcf(csv_file, vcf_file):
    with open(csv_file, 'r', encoding='utf-8-sig') as f:
        reader = csv.DictReader(f)
        for row in reader:
            v = vobject.vCard()
            v.add('n')
            v.n.value = vobject.vcard.Name(family=row['name'])
            v.add('fn')
            v.fn.value = row['name']
            v.add('org')
            v.org.value = [row['org']]
            v.add('title')
            v.title.value = row['title'] + ' ' + row['department']
            tel1 = v.add('tel')
            tel1.value = row['cell']
            tel1.type_param = 'cell'
            tel2 = v.add('tel')
            tel2.value = row['phone']
            tel2.type_param = 'work'
            v.add('email')
            v.email.value = row['email']
            v.email.type_param = 'INTERNET'
            v.add('adr')
            v.adr.value = vobject.vcard.Address(street=row['office'])
            v.adr.type_param = 'WORK'
            with open(vcf_file, 'a', encoding='utf-8') as f:
                f.write(v.serialize())

if __name__ == '__main__':
    csv_file = 'input.csv'
    vcf_file = 'output.vcf'
    csv2vcf(csv_file, vcf_file)