This article describes features available to Enterprise users only.

User Group Mapping

When importing data, you can combine field and field value specifications to automatically assign a row to a user group.

For example, if the Division column contains the value 'retail', assign the row to the User Group with ID 1, if the Division column contains the value 'commercial', assign the row to the User Group with ID 2.

Under Tools > Import Mapping, the following screen lists any existing mappings. To create a new mapping, click New.

The first example above would require a mapping as shown:

If the Existing Mapping Type is empty, enter UserGroupId as a New Mapping Type.

Category Mapping

In some cases, users would like rows to be added to a category if field contains a certain value. This is mapping type is Category.

For example, if the FavoriteColor column contains the value 'red', assign the row to the category with ID 25, if the FavoriteColor column contains the value 'blue', assign the row to the category with ID 26.

Transformation Mapping

If a value should be modified on the fly during the bulk import, a Twig template can be applied to the data. The only fields that apply to Transformation-type mappings are the Field Name, Mapping Type and the Transformation as shown below. The mapping type must be set to Transformation.

The template is a Twig template, which can perform simple (and not-so-simple) transformations of the incoming data.

A few examples:

Replace any dashes found in the field value with dots:

{{ template_item.value|replace({'-':'.'}) }}

Remove any values greater than 5 characters in length:

{% if template_item.value|length <= 5 %}{{template_item.value}}{% endif %}

Remove any email fields without an @ sign.

{% if '@' in template_item.value %}{{template_item.value}}{% endif %}

Did this answer your question?