0 Replies Latest reply on Nov 6, 2014 2:05 PM by StefanSaeys

    Export to vCard

    StefanSaeys

      Title

      Export to vCard

      Post

       

      I am trying to export my contact details to vCard format using following script:

      Substitute(
      If( IsEmpty(Contacts::Home Address 1); ""; Contacts::Home Address 1 &";")&
      If( IsEmpty(Contacts::Home Address 2); ""; Contacts::Home Address 2 &";")&
      If( IsEmpty(Contacts::Home City); ""; Contacts::Home City &";")&
      If( IsEmpty(Contacts::Home State); ""; Contacts::Home State &";")&
      If( IsEmpty(Contacts::Home Postal Code); ""; Contacts::Home Postal Code &";")&
      If( IsEmpty(Contacts::Home Country); ""; Contacts::Home Country)
      ;"¶";"")

       

      Everything seems to work except the country information. This results in

      BEGIN:VCARD
      VERSION:3.0
      PRODID:-//Apple Inc.//Mac OS X 10.9.5//EN
      N:Doe;John;;;
      FN:John Doe
      EMAIL;type=INTERNET;type=HOME;type=pref:john.doe@domain.com
      TEL;type=HOME;type=VOICE;type=pref:199999999
      TEL;type=WORK;type=VOICE:299999999
      TEL;type=CELL;type=VOICE:498250744
      ADR;type=HOME;type=pref:;;Church Road 23;Hemiksem;2620;Belgie;
      NOTE:Notes
      UID:6918bd7d-3859-414a-a5e0-41ddfdaf9f8c
      X-ABUID:6918BD7D-3859-414A-A5E0-41DDFDAF9F8C:ABPerson
      LN:Doe
      END:VCARD 

      and it should be:

      ADR;type=HOME;type=pref:;;Church Road 23;Hemiksem;;2620;Belgie

      Any help really appreciated; several attempts result in postcode being in the wrong field or country being in the postcode field.