{"id":340,"date":"2012-01-02T12:20:00","date_gmt":"2012-01-02T12:20:00","guid":{"rendered":"http:\/\/thomas.w-p.me.uk\/blog\/2012\/01\/google-contacts-importing-nightmares\/"},"modified":"2012-01-02T12:20:00","modified_gmt":"2012-01-02T12:20:00","slug":"google-contacts-importing-nightmares","status":"publish","type":"post","link":"https:\/\/thomas.w-p.me.uk\/blog\/2012\/01\/google-contacts-importing-nightmares\/","title":{"rendered":"Google Contacts importing nightmares."},"content":{"rendered":"<p>Years ago I wrote the ultimate address book that has people and addresses as separate tables in a database where people can have more than one address.\u00a0 It worked well.\u00a0 Now I want to use something in the cloud, and can&#8217;t find anything that works as elegantly.\u00a0 To keep things simple I plan to use Google contacts.<\/p>\n<p>Easy.\u00a0 Export my contacts, patch them together in Excel and import them as a google CSV.<\/p>\n<p>Except that google exports in one format but is unable to import back again!?\u00a0 Very frustrating, and their help files are dreadful giving<a href=\"http:\/\/support.google.com\/mail\/bin\/answer.py?hl=en&#038;answer=12119\"> no help at all on field headings<\/a>.<\/p>\n<p>At least they allow you to roll back your contacts, so my mistakes were able to be fixed.\u00a0 <\/p>\n<p>Later:\u00a0 I eventually sorted it out, but it took a lot of pain to do so.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Years ago I wrote the ultimate address book that has people and addresses as separate tables in a database where people can have more than one address.\u00a0 It worked well.\u00a0 Now I want to use something in the cloud, and can&#8217;t find anything that works as elegantly.\u00a0 To keep things simple I plan to use &hellip; <a href=\"https:\/\/thomas.w-p.me.uk\/blog\/2012\/01\/google-contacts-importing-nightmares\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Google Contacts importing nightmares.<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-340","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"https:\/\/thomas.w-p.me.uk\/blog\/wp-json\/wp\/v2\/posts\/340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thomas.w-p.me.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thomas.w-p.me.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thomas.w-p.me.uk\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thomas.w-p.me.uk\/blog\/wp-json\/wp\/v2\/comments?post=340"}],"version-history":[{"count":0,"href":"https:\/\/thomas.w-p.me.uk\/blog\/wp-json\/wp\/v2\/posts\/340\/revisions"}],"wp:attachment":[{"href":"https:\/\/thomas.w-p.me.uk\/blog\/wp-json\/wp\/v2\/media?parent=340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thomas.w-p.me.uk\/blog\/wp-json\/wp\/v2\/categories?post=340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thomas.w-p.me.uk\/blog\/wp-json\/wp\/v2\/tags?post=340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}