In this chapter we will show you how to import multi-select fields, which means fields where you can enter more than one value, and then also how to translate this content according to your wishes.

 

First follow the steps in Naming the schema and Act! database connection and Source file type and source file directory, schema type.

 

Then you proceed, depending on the instance (e.g. Contacts, Companies) you want to import, like explained in the particular chapter.

 

In Easy Mappings you do not have to consider anything special for the multi-select field.

 

For the translation you go to the Virtual Fields and and create a Custom Expression.

There you enter the following expression:

 

StrReplace(

StrReplace(

StrReplace(

StrReplace(

StrReplace(

StrReplace(

StrReplace(

SourceField( Code ),

" ", false, ""),

"5", false, "five"),

"4", false, "four"),

"3", false, "three"),

"2", false, "two"),

"1", false, "one")

 

​Now adjust this to your source file. For Code enter the name of your multi-select source field, for 5, 4, 3, 2, 1 you enter the values in your source field and for five, four, three, two, one the values you want to import instead. Depending on how many values you want to translate you can either add new rows in the style of

" ", false, " "),

or remove up to four of the five last rows.

 

Once you've created the schema and saved it, you can run the import.