Skip to main content

Changing mapping delimiters

Abstract

How to change mapping delimiters for fields with multiple values in Sitecore.

When Sitecore stores multiple values in a field, by default it uses a comma (,) to separate the individual values. You can change the delimiter to another character.

If you use special characters as a separator, you must allow those characters on the Sitecore level. You do this by using a patch file to change the ItemNameValidation setting. For example:

<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/"> 
    <sitecore> 
        <settings> 
            <setting name="ItemNameValidation"> 
                <patch:attribute name="value">^.*$</patch:attribute> 
            </setting> 
        </settings> 
    </sitecore> 
</configuration> 

Important

This example allows all characters to be used. It is best practice to only allow the characters you need.

You can change the delimiter for the following fields:

  • Relation field mapping - the delimiter for taxonomy values.

  • Tag field mapping - the delimiter for values in a tag.

You can change the delimiter Sitecore uses to separate values when it stores multiple taxonomy values.

To change the delimiter:

  1. On your Sitecore instance, open the App_Config\Modules\Sitecore.Connector.CMP.config file.

  2. In the configuration/sitecore/settings node, set the value of Sitecore.RelationFieldMappingSeparator to the delimiter you want to use. For example, <setting name="Sitecore.RelationFieldMappingSeparator" value=", " />.

  3. Save the file.

You can change the delimiter Sitecore uses to separate values when it stores multiple values in a tag.

To change the tag field mapping delimiter:

  1. On your Sitecore instance, open the App_Config\Modules\Sitecore.Connector.CMP.config file.

  2. In the configuration/sitecore/settings node, change the setting Sitecore.NodeNameSeparator to the delimiter you want to use. For example, <setting name="Sitecore.NodeNameSeparator" value="." \>.

  3. Save the file.