{"id":27,"date":"2018-07-02T17:11:37","date_gmt":"2018-07-02T22:11:37","guid":{"rendered":"http:\/\/www.diadian.com\/?p=27"},"modified":"2018-07-02T17:11:37","modified_gmt":"2018-07-02T22:11:37","slug":"a-quick-thank-you-to-greg-hadlock-of-vcf-import","status":"publish","type":"post","link":"https:\/\/www.diadian.com\/index.php\/2018\/07\/02\/a-quick-thank-you-to-greg-hadlock-of-vcf-import\/","title":{"rendered":"A quick Thank You to Greg Hadlock of VCF Import"},"content":{"rendered":"

https:\/\/sourceforge.net\/projects\/bulkvcftocsv<\/a><\/p>\n

Last week I had to combine 3 sources of contact data into one address book. \u00a0The sources were: A google account, an iPhone’s local address book and an email account on Office 365. \u00a0The Google account had 300+ contacts, the iPhone had 3,000+ contacts and the exchange account had 700+. \u00a0The Exchange account was the desired destination of the combined data. \u00a0Exporting the data from gmail’s web interface and iCloud’s web interface was easy but when I imported the exported data into Outlook, I was only getting one contact from a file that should have had 3000+ contacts. \u00a0I remembered that some programs have issues with VCF files that have multiple entries and assumed that this was the issue here. \u00a0Google brought me to Greg’s excellent converter.<\/p>\n

On gmail, I exported to “vCard format”. \u00a0On iCloud, there was no option, it just downloaded a file in VCF format. \u00a0Each of these files had multiple contacts in it and did not import correctly into Outlook. \u00a0After enabling Macros in Excel, I opened the VCF IMPORT macro file. \u00a0It prompted me for a source VCF, did its magic and created a .CSV with a name that matched the source VCF except for its extension, in the right format for Outlook to import. \u00a0I was able to import both of the new CSV files without issue into Outlook.<\/p>\n

I did try directly importing google’s “Outlook CSV” but there was an error, which I don’t remember right now.<\/p>\n

For safety’s sake, I made all of these changes into a separate Outlook PST file and imported each sources data into a separate folder. \u00a0I then copied and combined the data from all three sources into a new folder on the same PST. \u00a0Once this was done, I transferred the PST to the user’s computer, deleted his contacts and copied only the combined contacts folder into his Outlook. \u00a0After the copy was complete, I closed the new PST to avoid user confusion. \u00a0Keeping the original data in three different folders in a separate PST gives me the ability to quickly retrieve data that might have been overwritten or erroneously merged.<\/p>\n

The macro is free and the author just asks for a review. \u00a0I signed up on SourceForge just to leave the review and decided to also put this up in hope that his macro gets a bit better known.<\/p>\n","protected":false},"excerpt":{"rendered":"

https:\/\/sourceforge.net\/projects\/bulkvcftocsv Last week I had to combine 3 sources of contact data into one address book. \u00a0The sources were: A google account, an iPhone’s local address book and an email account on Office 365. \u00a0The Google account had 300+ contacts, the iPhone had 3,000+ contacts and the exchange account had 700+. \u00a0The Exchange account was […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-27","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.diadian.com\/index.php\/wp-json\/wp\/v2\/posts\/27"}],"collection":[{"href":"https:\/\/www.diadian.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.diadian.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.diadian.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.diadian.com\/index.php\/wp-json\/wp\/v2\/comments?post=27"}],"version-history":[{"count":2,"href":"https:\/\/www.diadian.com\/index.php\/wp-json\/wp\/v2\/posts\/27\/revisions"}],"predecessor-version":[{"id":29,"href":"https:\/\/www.diadian.com\/index.php\/wp-json\/wp\/v2\/posts\/27\/revisions\/29"}],"wp:attachment":[{"href":"https:\/\/www.diadian.com\/index.php\/wp-json\/wp\/v2\/media?parent=27"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.diadian.com\/index.php\/wp-json\/wp\/v2\/categories?post=27"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.diadian.com\/index.php\/wp-json\/wp\/v2\/tags?post=27"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}