花粉俱乐部  logo

花粉俱乐部  因为热爱
搜索 |

关于华为系列手机通讯录导入CSV的解决方案,有谁要听的啊

[复制帖子标题和链接]

38985

一个爱唱歌的It工程师  渐入佳境  发表于 2020-2-20 15:39:37 来自:浏览器

最新回复 2021-3-9 11:58:27

关于华为系列手机通讯录导入的解决方案,有谁要听的啊,

1、首先介绍一下华为的通讯录的导入和导出
     这个导入和导出设计的真的是坑,我琢磨了一下午,才把他整明白,说正题了
因为这个导出的CSV通讯录数据是UTF8格式,而当我们导出后再修改后,EXCEL保存会把源格式都去掉不保存,所以再导进去的数据就乱码了,
有图有真向
导出来的源文件是(带引号的,认真看,数一数总共有36个栏位)
Family Name,Given Name,Additional Name,Prefix Name,Suffix Name,Mobile Number,Home Number,Office Number,Home Fax,Bussiness Fax,Pager,Other,customize,Home Email,Work Email,Other Email,customize,Address Home,Address Work,Address Other,customize,Organization Work,Organization Other,customize,AIM,Windows Live,YAHOO,SKYPE-USERNAME,OICQ,GOOGLE-TALK,JABBER,Notes,NickName,WebPage,Ptt/DC1,Ptt/DC2
"","林振宇","","","","189 5004 7784","","","","","","","","","","","","","","","","厦门宏朋工贸有限公司","","","","","","","","","","","","","",""
"","华为客服","","","","4008308300","","","","","","","","mobile@huawei.com","","","住宅","","深圳市龙岗区坂田华为基地","","","","","","","","","","","","","","","","",""


EXCEL修改后保存变成是这样
Family Name,Given Name,Additional Name,Prefix Name,Suffix Name,Mobile Number,Home Number,Office Number,Home Fax,Bussiness Fax,Pager,Other,customize,Home Email,Work Email,Other Email,customize,Address Home,Address Work,Address Other,customize,Organization Work,Organization Other,customize,AIM,Windows Live,YAHOO,SKYPE-USERNAME,OICQ,GOOGLE-TALK,JABBER,Notes,NickName,WebPage,Ptt/DC1,Ptt/DC2
,林振宇,,,,189 5004 7784,,,,,,,,,,,,,,,,厦门宏朋工贸有限公司,,,,,,,,,,,,,,
,华为客服,,,,4008308300,,,,,,,,mobile@huawei.com,,,住宅,,深圳市龙岗区坂田华为基地,,,,,,,,,,,,,,,,,


有发现区别没有就是每个栏位的引号都不见了,华为也很冤,这个是EXCEL保存后会自动的问你说要不要把那些不是字符的数据去掉,当然只有回答【是】

最后就导致我们的数据的格式就由UTF8 变成ANSI  所以我们的格式不对导致我们的数据导入也就乱码了

所以我又摸索出一条路了,想听吗,点个赞,让我有动力继续写吧。哈哈哈哈
1.jpg
2.jpg
3.jpg

评分

参与人数 2人气 +9 威望 +10 收起 理由
花粉149844582 + 1 + 2 好赞~鼓掌~
huafen544269551 + 8 + 8

查看全部评分

花粉162616012  新学乍练  发表于 2020-2-23 13:41:33 来自:OPPO R9s Plus
你丫20号的贴23号又发个一样的?吊胃口呢?
一个爱唱歌的It工程师  渐入佳境  发表于 2020-2-23 16:36:30 来自:HUAWEI Mate 30 5G
呵呵,你怎么知道,你测试看看用手机助手excel导入导出. 通讯录正常吗?
huafen652156147  新学乍练  发表于 2020-2-27 14:15:38 来自:HUAWEI Mate 30 Pro 5G
说方法呀
一个爱唱歌的It工程师  渐入佳境  发表于 2020-2-27 15:06:07 来自:HUAWEI Mate 30 5G
至少得有20人鼓励鼓励,你们也可以开动脑筋研究下,答案其实就在问题里。
liuxiaomingcn  新学乍练  发表于 2021-3-9 11:58:27 来自:浏览器
格式ANSI改UTF8就好啦
微信图片_20210309115748.png
您需要登录后才可以回帖 登录 | 立即注册

用户组申请
版规

花粉俱乐部App下载

  • 花粉客户端官方

    Make it Possible

用户协议| 隐私条款| 网站地图| 客户端| 手机版| 举报邮箱:huaweifans@huawei.com |关注花粉俱乐部:
粤ICP备19015064号-4|备案主体编号:44201919072182| 粤公网安备 44190002003939号

Copyright © 2012-2021 华为终端有限公司 版权所有

快速回复 返回顶部 返回列表