3 Replies Latest reply on Feb 14, 2014 6:02 PM by beverly

    Export vCard Solution

    ErikWegweiser

      Has anybody come up with a working solution for exporting a vCard format file from FileMaker?

       

      - That will produce a vCard compatible with Mac and Windows applications

      - That does not require a plug-in

      - That does not require a style sheet

      - That works in FileMaker Go

       

      Thanks.

        • 1. Re: Export vCard Solution
          ibrahim_bittar

          Hi Eric

           

          I have something very close from what you want. Let me "fm-13-it" and see if I can get rid of plugins.

           

          I'll get back to you next week.

           

          Regards

           

          Ibrahim

          • 2. Re: Export vCard Solution
            ericjungemann

            We do it in our VetFM product.  Format is like this (and is a standard):

             

            BEGIN:VCARD

            VERSION:3.0

            N:Doe;John;;;

            FN:John Doe

            ORG:Example.com Inc.;

            TITLE:Imaginary test person

            EMAIL;type=INTERNET;type=WORK;type=pref:johnDoe@example.org

            TEL;type=WORK;type=pref:+1 617 555 1212

            TEL;type=CELL:+1 781 555 1212

            TEL;type=HOME:+1 202 555 1212

            TEL;type=WORK:+1 (617) 555-1234

            item1.ADR;type=WORK:;;2 Example Avenue;Anytown;NY;01111;USA

            item1.X-ABADR:us

            item2.ADR;type=HOME;type=pref:;;3 Acacia Avenue;Newtown;MA;02222;USA

            item2.X-ABADR:us

            NOTE:John Doe has a long and varied history\, being documented on more police files that anyone else. Reports of his death are alas numerous.

            item3.URL;type=pref:http\://www.example/com/doe

            item3.X-ABLabel:_$!<HomePage>!$_

            item4.URL:http\://www.example.com/Joe/foaf.df

            item4.X-ABLabel:FOAF

            item5.X-ABRELATEDNAMES;type=pref:Jane Doe

            item5.X-ABLabel:_$!<Friend>!$_

            CATEGORIES:Work,Test group

            X-ABUID:5AD380FD-B2DE-4261-BA99-DE1D1DB52FBE\:ABPerson

            END:VCARD

             

            We use  a calc on the client layout:

             

            "BEGIN:VCARD" &

            "¶VERSION:3.0" &

            "¶N:" & LastName & ";" & FirstName & ";;" & Title & ";" &

            "¶FN:" & c_FirstLast &

            "¶EMAIL;type=INTERNET;type=WORK;type=pref:" & EmailAddress &

            "¶item1.TEL;type=pref:" & c_Phone1 &

            "¶item1.X-ABLabel:" & PhoneType1 &

            "¶item2.TEL;type=pref:" & c_Phone2 &

            "¶item2.X-ABLabel:" & PhoneType2 &

            "¶item3.ADR;type=HOME;type=pref:;;" & AddressLine1 & ";" & City & ";" & State & ";" & Zip & ";" & Country &

            "¶item3.X-ABADR:us" &

            "¶END:VCARD¶"

             

            I hope that helps,

             

            Eric

            • 3. Re: Export vCard Solution
              beverly

              The trick is in the export. Export Field Contents is not supposed to double-byte the text when done on FMGo. Since this is the problem on desktop, plug-in or style sheet are the solution.

               

              Set up your path correctly. Do you want to open automatically? and what do you expect to happen with the vcard? does it become an attachment to email?

               

              Beverly