4 Replies Latest reply on Oct 6, 2015 4:07 PM by nancyhorne@centurytel.net

    Can Filemaker 14 export pictures in containers (to Vcard)

    nancyhorne@centurytel.net

      Filemaker 13 couldn't do this, Can Filemaker 14 export pictures in containers?

       

      TIA,

      Nancy

        • 1. Re: Can Filemaker 14 export pictures in containers (to Vcard)
          steveromig

          Filemaker 13 couldn't do this, Can Filemaker 14 export pictures in containers?

           

          TIA,

          Nancy

           

          Short answer is yes.  13 could likely do this to.

           

          There isn't a direct vCard export type in FileMaker so you will need to get a little creative to make this work. 

           

          We don't have a knowledge base article on how to do this (but we should) but a quick Internet search on "export filemaker to card" provided several different methods that look easy to implement - including one that dealt with pictures.

           

          Here is a good starting point - posted to our old forums.

           

          http://forums.filemaker.com/posts/22293081b3

           

          Steve Romig

          FileMaker, Inc.

          • 2. Re: Can Filemaker 14 export pictures in containers (to Vcard)
            nancyhorne@centurytel.net

            I just tested this solution that I worked on in April.

            The filemaker file I found on the forum: HB-_vCard-Export does indeed import filemaker database fields including picturesfrom a container with the checkbox.

            After matching field names and clicking on import - the 'Import Options' window pops up and has a checkbox 'Preserve external container storage'.
            YAY! This works slick!!!

            • 3. Re: Can Filemaker 14 export pictures in containers (to Vcard)
              ibrahim_bittar

              Hi Nancy, this the calculation I use to create a vCard. Field Names are in Bold.

               

              There is a custom function called ICSEscape ( Text ) = Substitute ( Text ; [ "\"" ; "" ] ; [ "," ; "\," ] ; [ ";" ; "\;"] ; [ "¶" ; "\n" ] )

               

              You create a calculated field with this formula and then in your script, with the BaseElements plugin you can export it to a text file encoded as UTF-8.

               

              BE_WriteTextToFile ( PathToFolder ( "Desktop" ; 0 ) & Contacts::FullName & ".vcf" ; Contacts::vCard )

               

              PathToFolder is a custom function I created to simplify the path calculation:

               

              http://www.briandunning.com/cf/1506

               

              Hope you find this useful.

               

              ------------------------------------------

               

              "BEGIN:VCARD" & "¶" &

              "VERSION:3.0" & "¶" &

              "PRODID:-//Eikonsys SA de CV//Eikonsys One//EN" & "¶" &

              "N:" & ICSEscape ( Name_Last ) & ";" & ICSEscape ( Name_First ) & ";;" & ICSEscape ( Salutation ) & ";" & "¶" &

              "FN:" & ICSEscape ( Name_FullWithSalutation ) & "¶" &

              If ( not IsEmpty ( CompanyName ) ; "ORG:" & ICSEscape ( CompanyName ) & ";" & Division & "¶" ; "" ) &

              If ( not IsEmpty ( Position ) ; "TITLE:" & ICSEscape ( Position ) & "¶" ; "" ) &

              "ADR;type=WORK;type=pref:;;" & ICSEscape ( Contacts_Join_Addresses_Addresses_Ind::Street ) & " " & ICSEscape ( Contacts_Join_Addresses_Addresses_Ind::Number_External ) & If ( not IsEmpty ( Contacts_Join_Addresses_Addresses_Ind::Number_Internal ) ; " - " & ICSEscape ( Contacts_Join_Addresses_Addresses_Ind::Number_Internal ) ; "" ) &  "\, " & Contacts_Join_Addresses_Addresses_Ind::Colony & ";" & Contacts_Join_Addresses_Addresses_Ind::City & ";" & Contacts_Join_Addresses_Addresses_Ind::State & ";" & Contacts_Join_Addresses_Addresses_Ind::Country & "¶" &

              If ( not IsEmpty ( Comm_Email1 ) ; "EMAIL;type=INTERNET;type=pref:" & Comm_Email1 & "¶" ; "" ) &

              If ( not IsEmpty ( Comm_Email2 ) ; "EMAIL;type=INTERNET:" & Comm_Email2 & "¶" ; "" ) &

              If ( not IsEmpty ( Comm_Twitter ) ; "X-SOCIALPROFILE;type=twitter:http://twitter.com/" & Substitute ( Comm_Twitter ; "@" ; "" ) & "¶" ; "" ) &

              If ( not IsEmpty ( Comm_Facebook ) ; "X-SOCIALPROFILE;type=facebook;x-displayname=" & ICSEscape ( FullName ) & ":http://www.facebook.com/" & Comm_Facebook & "¶" ; "" ) &

              If ( not IsEmpty ( Comm_Phone_Office1 ) ; "TEL;TYPE=work:" & ICSEscape ( Comm_Phone_Office1 ) & "¶" ; "" ) &

              If ( not IsEmpty ( Comm_Phone_Office2 ) ; "TEL;TYPE=work:" & ICSEscape ( Comm_Phone_Office2 ) & "¶" ; "" ) &

              If ( not IsEmpty ( Comm_Phone_Mobile ) ; "TEL;TYPE=cell:" & ICSEscape ( Comm_Phone_Mobile ) & "¶" ; "" ) &

              If ( not IsEmpty ( Comm_Phone_Home ) ; "TEL;TYPE=home:" & ICSEscape ( Comm_Phone_Home ) & "¶" ; "" ) &

              If ( not IsEmpty ( Secretary_Phone ) ; "TEL;TYPE=secretary:" & ICSEscape ( Secretary_Phone ) & "¶" ; "" ) &

              If ( not IsEmpty ( DOB_Month ) and not IsEmpty ( DOB_Day ) ; "BDAY;X-APPLE-OMIT-YEAR=1604:1604-" & Right ( "00" & DOB_Month ; 2 ) & "-" & Right ( "00" & DOB_Day ; 2 ) & "¶" ; "" ) &

              "UID:urn:uuid:" & ES_Record_UUID & "¶" &

              If ( not IsEmpty ( Picture ) ; "PHOTO;ENCODING=b;TYPE=JPEG:" & Picture_Base64 & "¶" ; "" ) &

              If ( not IsEmpty ( Comments ) ; "NOTE:" & ICSEscape ( Comments ) & "¶" ; "" ) &

              "LANG:en_US" & "¶" &

              "END:VCARD"

              • 4. Re: Can Filemaker 14 export pictures in containers (to Vcard)
                nancyhorne@centurytel.net

                Thank you - this is fabulous! I'll review this with my current script and see if I can use some of it!