使用Python处理手机通讯录导入与导出文件

最新推荐文章于 2023-04-28 15:57:37 发布

邓旭东HIT

最新推荐文章于 2023-04-28 15:57:37 发布

阅读量1.9k

点赞数 2

本文链接：https://blog.csdn.net/weixin_38008864/article/details/104871764

版权

最近遇到一个问题

如何将通讯录信息导出到csv
如何将csv导入到通讯录

网上大多都是在说使用Vcard文件，这种文件是手机自带通讯录app能识别的文件格式。

但是试了网上各种服务，废了很大的劲头儿也没将csv转为vcf格式（Vcard文件）。后来github一搜csv2vcf，还真让我找到代码。直接封装成函数，各位回去直接调用即可。

import os
import re
import quopri
def csv2vcf(csv_filename, encoding='utf-8'):
    """csv格式文件转换为vcf格式文件"""
    # 1.读取csv文件
    with open(csv_filename, 'r', encoding='utf-8') as f:
        ftext_list = f.readlines()
        f.close()
    # 2.将cvs转换为vcf格式
    vcards = ''
    for line in ftext_list[1:]:
        tel_numbers = ''
        name_tel_list = line.strip().split(',')
        if name_tel_list[0]:
            tel_name = name_tel_list[0]  # 姓名
            for tel in name_tel_list[1:]:  # 电话
                tel_numbers += f'TEL;CELL:{tel}\n'
            vcard = f'BEGIN:VCARD\nN:{tel_name}\n{tel_numbers}END:VCARD\n'
            vcards += vcard
    # 3.保存转换后的vcf格式文件
    (fpath, temp_fname) = os.path.split(csv_filename)
    (fname, fextension) = os.path.splitext(temp_fname)
    with open(f'{fpath}{fname}.vcf', "w", encoding=encoding) as f:
        try:
            f.write(vcards)
        finally:
            f.close()
def vcf2csv(vcf_filename, encoding="gbk"):
    """vcf格式文件转换为csv格式文件"""
    # 1.读取vcf文件
    with open(vcf_filename, 'r', encoding='utf-8') as f:
        try:
            ftext = f.read()
        finally:
            f.close()
    # 2.正则替换清洗数据
    re_dic = {
        r"(EMAIL;)(.*)(\n)": "",
        r"(ADR;)(.*)(\n)": "",
        r"(ORG;)(.*)(\n)": "",
        r"(NOTE:)(.*)(\n)": "",
        r"(\n)(VERSION:2.1)": "",
        r"\nEND:VCARD\nBEGIN:VCARD": "",
        r"\nEND:VCARD": "",
        r"BEGIN:VCARD\n": "",
        r"(;;;)([\s\S]*?)(TEL;CELL:)": ",",
        r"N;CHARSET=UTF-8;ENCODING=QUOTED-PRINTABLE:": "",
        r"(\nTEL;)(.*?)(:)": ",",
        r"N:;": "",
        r";": "",
        r" ": "",
        r"=\n": ""
    }
    for re_rule, replace_str in re_dic.items():
        p1 = re.compile(re_rule)
        ftext = p1.sub(replace_str, ftext)
    # 3.解码quopri编码
    #ftext = quopri.decodestring(ftext).replace(" ", "")
    ftext = "".join([s for s in ftext.splitlines(True) if s.strip()])
    # 4.保存cvs文件
    csv_str = f'姓名,手机\n{ftext}'
    (fpath, temp_fname) = os.path.split(vcf_filename)
    (fname, fextension) = os.path.splitext(temp_fname)
    with open(f'{fpath}{fname}.csv', "w", encoding=encoding) as f:
        try:
            f.write(csv_str)
        finally:
            f.close()