With IMPORT|IT you have the possibility to import the full name with all of the name components (title of nobility etc) of your contacts. In this example we will show you how to import a field "Contact" with the prefix, the first name, the second first name, the last name prefix, the last name and the suffix as well as a field "FULLLONGNAME" that contains the title of the contact, too.
1. Before the import you create two new fields in Act! for the contacts (FULLLONGNAME and LASTNAMEPREFIX) or if you use the addon ADDRESS|IT with the control element for splitting up names you will already have those fields.
2. Proceed with creating a contact import schema as usual, like explained in the chapter How to: Import Contacts.
3. Now you create the two virtual fields "Contact" and "FULLLONGNAME". For both fields you use the option Custom Expression. Type in this expression for the field Contact:
If(StrLength(SourceField(Prefix)) > 0 , SourceField(Prefix) & " ", "") & If(StrLength(SourceField(First name)) > 0 , SourceField(First name) & " ", "") & If(StrLength(SourceField(Second first name)) > 0 , SourceField(Second first name) & " ", "") & If(StrLength(SourceField(Last name prefix)) > 0 , SourceField(Last name prefix) & " ", "") & If(StrLength(SourceField(Last name)) > 0 , SourceField(Last name) & " ", "") & If(StrLength(SourceField(Suffix)) > 0 , SourceField(Suffix) & " ", "")
For the FULLLONGNAME field you enter this expression:
If(StrLength(SourceField(Prefix)) > 0 , SourceField(Prefix) & " ", "") & If(StrLength(SourceField(Title)) > 0 , SourceField(Title) & " ", "") & If(StrLength(SourceField(First name)) > 0 , SourceField(First name) & " ", "") & If(StrLength(SourceField(Second first name)) > 0 , SourceField(Second first name) & " ", "") & If(StrLength(SourceField(Last name prefix)) > 0 , SourceField(Last name prefix) & " ", "") & If(StrLength(SourceField(Last name)) > 0 , SourceField(Last name) & " ", "") & If(StrLength(SourceField(Suffix)) > 0 , SourceField(Suffix) & " ", "")
This is what your virtual fields will look like:
4. Next you set the Easy Mapping:
5. In the end you run the schema. The result in Act! should look similar to this one:
|
