Medallia Experience Cloud reusable field mapping

Use Medallia Experience Cloud reusable field mapping to add fields already built in Medallia Experience Cloud to Digital’s reusable field library, making it available for selection in Digital Feedback configuration. Add fields individually through the Command Center user interface or through a bulk operation using the Import and Export functionality. Open the reusable field mapping as an XLSX file showing all of the fields in the library. Make bulk changes using your favorite spreadsheet editor.

Once a field is added to the library, it is part of the Digital Integration to Experience Cloud. Fields that are added into the reusable field library are highly sensitive to changes made in Experience Cloud. Modifying the field in Experience Cloud after this point could break the mapping. For example, suppose a field has been added as text to the reusable field library. Changing that field in Experience Cloud to autoindexed text causes a synchronization error for the Digital integration.

The Experience Cloud Mapping page is only visible for users with Admin-level role or user permissions in Experience Cloud.

The Experience Cloud Mapping page relies on the latest version of the Command Center UI. The migration of properties to the UI is ongoing, and currently some parts of the UI are not migrated. As such, the navigation menu only shows the link to the Experience Cloud mapping page when you are on a Command Center page that has been migrated to the new UI. For example Forms is currently on the legacy UI so the EC Mapping link does not appear from that page. Pages currently using the new UI include, Rule Engine, Custom Parameters, User Behavior Triggers, Advanced Settings (if enabled), and Approved Domains (if enabled).

The EC Mapping menu option available from a Command Center page using the new UI.
Important: If the link to EC Mapping is not visible in the Command Center, ensure you are currently on a page that has been migrated to the new UI.

When you open the EC Mapping page it displays a list of the current mapping between Experience Cloud and Digital.

The list of EC Field mappings.

Filter the list of mappings to see them across your properties and forms. Select one option in each category: EC Type, Usage, Share Level, Property. If you select "Account" share level then the Property filter is not visible.

For example to find a list of all text fields available for use in survey forms, choose to filter by "Text" (EC Type), "Form Field" (Usage), and "Share Level" (Account). You cannot select multiple options within a single category. For example, you cannot select "Email" and "Text" under EC Type to find a list of all email and text fields

Filtering the list by EC type.

See fields by the selected type. This list also defines the types of fields that are currently supported in the integration to Experience Cloud. If a field type is not listed, it means that it cannot currently be used in Digital Feedback.

Filtering the list by usage.

See fields available for use in surveys with Form Fields, fields available for custom parameters Custom Parameter, or both.

Filtering the list by share level.

See fields available for the entire account, fields available to specific properties, or both.

Filtering the list by property.

List all properties in the Digital account..

Select an individual property or any of the available properties..

The columns show the different mapping's values.

  • EC Key: The field name in Experience Cloud
  • EC Type: The field’s ContentKind in Experience Cloud
  • EC Friendly Name: This name appears on your field mapping drop-down
  • Usage: The usage of the field in Experience Cloud
  • Share Level
  • Property Names: The properties that use this field
    • If share level is Account, no property names are displayed

Actions

Hover the cursor over a row and these icons are visible.

The icons used to edit a row.
  • Pencil: Open the Edit Mapping to MEC options. Use this menu to update the EC Friendly Name or the Share Level. You cannot edit the EC Key or the EC Type. The Edit Mapping to MEC dialog.
  • Trash Can: Initiate deletion of the field from the Reusable Field Library The Delete Field Mapping dialog.

Adding fields

To make minor additions to the reusable field mappings, use the Command Center interface. Alternatively, to make larger changes to the reusable field mapping use the bulk operations.

  1. Add fields individually by clicking New Mapping.

    The New Mapping button.

  2. "New Mapping to MEC" opens in a side panel. Provide this information:

    • EC Key
      • Full field keyname - with e_ or q_ prefix
    • EC Type
      • Must match the ContentKind of the field in Experience Cloud and is validated upon upload
      • Incorrect Content
    • EC Friendly Name
    • Usage
    • Share Level

    The New Mapping options.

  3. After providing all required details, click the Create button.

    You cannot click Create if any of the required details are missing.

    Example of EC Field dialog.

    Failure adding EC field dialog.

  4. If the selected EC Type is correct, a success message appears and the field appears in the Experience Cloud Mapping table.

    The field is now available for use in survey or custom parameter configuration.

    Successfully added EX Field dialog.

  5. If the selected EC Type is incorrect, an error message appears after clicking Create. You need to identify the correct EC Type by referencing Experience Cloud, and then repeat the process of adding the mapping.

    Failure to add EC Field dialog.

Bulk edits

To make a lot of changes to the reusable field mapping, it can be more convenient to work with the data in an external tool such a spreadsheet. Use the import and export to save the reusable field mapping as an XLSX format file. Then make the changes to the fields using your spreadsheet editor and import the modified reusable field mapping.

Export reusable field mapping

Use the Export function to fetch an XLSX file with the reusable field mapping, showing the required column headers.

  1. Export a table of all reusable field mappings in the library by clicking the Export button.

    The Export button.

    The mappings are exported to an XLSX file that is downloaded to your local machine.

  2. To make bulk changes to the reusable field mapping load the XLSX file in a spreadsheet editor.

    Example of the reusable field mapping exported.

  3. The exported file has these columns:

    • EC Key
    • EC Type
    • EC Friendly Name
    • Usage
    • Share Level
    • Properties (populated only if Share Level is set to "Properties")

Import (Bulk Mapping)

Use the Import function to add fields to the reusable field library by uploading an .xlsx file. You should export the existing library to fetch the correct format (.xlsx) and column headers.

The required column headers are (in order, from left to right):

  1. EC Key
  2. EC Type
  3. EC Friendly Name
  4. Usage
  5. Share Level
  6. Properties (only required if Share Level is ‘Properties’)

The uploaded file must also have the sheet title labeled as ‘Reusable fields’. This is already set by default in the export file.

Import: Allowed Values

Column

Allowed Values (Case Sensitive)

Can be modified after Import

# of Allowed Values, per field

Description

EC Key

MEC Field Keyname - must have e_ or q_ prefix

No

1

The Experience Cloud field that you are making available for use in Digital Feedback configuration

EC Type

autoindex_text comment date datetime ecGrading0to10 ecGrading1to10 ecGrading1to5 ecGrading1to7 email enumeration

enumerationMultiValues firstname

hyperlink lastname phone text translatable_comment

No

1

The ContentKind of the field, which determines what questions the field can be used in.

Note that rating scale fields have the "enumeration" ContentKind, but must be imported with the appropriate ecGrading EC Type to be available for rating scale questions.

EC Friendly Name

Freeform text

Yes

1

The display name to use in the Report Field Mapping dropdown in Form Builder

Example field mapping dropdown in the form editor.

Usage

FormField

CustomParameter

No

1

Define if the field should be used as a question mapping or as a custom parameter mapping.

A field can only have 1 usage type.

Share Level

Account

Properties

Yes

1

Define if the field should be available for usage in configuration across the entire Digital account or only for specific properties. If only for specific properties, you need to populate a comma-separated list of Property ID numbers that the field is available in.

Properties

Property ID numbers, comma-separated if multiple

Yes

Multiple

A comma-separated list of property IDs to make the field available to.

A list of all properties (and IDs) you have access to is listed in the Switch Property menu, accessible in the right hand corner.

The switch property dialog.

This column should only be populated if the "Share Level" of the field is set to "Properties". Leave this column blank if "Share Level" is "Account"

Import: Adding new fields

  1. Export the current list of fields to fetch the correct file format and required column headers.

    The export button.

  2. For each new field you would like to add, provide the requested details in a new row.

    Example row for a field mapping.

  3. Add new fields by adding to the end of the existing list.

    Extending the list of new fields.

  4. You can also add new fields by removing the existing fields in the list (rows with the gray shaded cell) and keeping the column headers. If you have no updates to make to the existing list of fields, Medallia recommends removing them from the Import file and only including the new fields you would like to add.

    Example of stripped file with only new fields.

  5. When populating the file with new fields, you must fill out all required details:

    • EC Key
    • EC Type (Reference this table for the values to use - they are slightly different from the values in the Command Center picklist)
    • EC Friendly Name
    • Usage
    • Share Level
    • Properties (populated only if Share Level is set to "Properties")

    Deleting empty rows.

  6. Delete all empty rows.

    Uploading empty rows can result in extra error messaging, indicating that the empty row was not processed. This has no impact on rows successfully processed, but can be confusing to see.

    Deleting empty rows.

  7. Save the Import file after adding all desired fields and verifying that all entered values are correct. Note the case sensitivity of some values.

  8. To import the file, click Import button on the Experience Cloud Mapping screen, and select your updated import file

    The import button.

  9. A success message is displayed if all required values pass validation with Experience Cloud. New fields added become visible in the Experience Cloud Mapping table, and are now available for use in configuration

    Result of successfully importing a mapping file.

Import: Error Messages and Troubleshooting

During the import process you could encounter these errors.

  • If you have been logged out due to timeout in the Experience Cloud instance and attempted to add a field, this error message is displayed.

    Example of the logged out user error.

    To proceed, you need to re-authenticate to the Experience Cloud instance.

  • If there are rows that fail the Import validation, you are provided with an error message and link to download an error log file

    Example of the error shown when a file is incompatible.

    The error log file can be downloaded as a plain text (.txt) file.

    The file identifies the sheet and row where the error took place for you to troubleshoot further.

    Example of the import errors file.

Error Log Text

What this means

Processing EC Fields failed, Failed to add ecFields, some of the fields are invalid

The "EC Type" in the Import file does not match the ContentKind value of the field in Experience Cloud. Update the Import file with the correct EC Type value, and reupload to resolve.

Sheet name is supposed to be: Reusable fields

The Import file does not have the correct sheet title.

Update the sheet title to ‘Reusable fields’ and reupload to resolve.

Processing EC Fields failed, No enum constant com.kampyle.kampylepersistence.entities.experienceCloud \\ .ReusableField.Usage.customparameter

The value for "Usage" in the Import file does not match the case-sensitivity rules. In this example, the value in the file is "customparameter" instead of "CustomParameter"

Processing EC Fields failed, No enum constant com.kampyle.kampylepersistence.entities.experienceCloud. \\ ReusableField.Usage.formfield

The value for "Usage" in the Import file does not match the case-sensitivity rules.

In this example, the value in the file is "formfield" instead of "FormField"

Processing reusable fields failed, ecKey is empty, skip to next reusable field

The Import file has empty rows. This does not impact rows where you have correctly populated new fields to be added. No action needs to be taken if the new fields added to the sheet are successfully processed.

Import FAQ

  • Can I use the Import function to create new fields?
    • No. The Import functionality is to make existing Experience Cloud fields available for usage in Digital Feedback survey form and custom parameter configuration.
      • Create new fields in Experience Cloud
  • Can I use the Import function to remove fields from the library?

Removing a field from the library

When a field is removed from the library, it is no longer available for selection in the Form Builder or Custom Parameter configuration.

Existing usages of the removed field in Form Builder or Custom Parameter configuration are not affected, and the linked components remain mapped to the selected field.

  1. Remove fields from the library by clicking on the trash can icon in the Action columns.

    Icons used to modify fields.

  2. You are prompted to confirm that they want to delete the field mapping.

    The delete field dialog that confirms a deletion.

  3. After clicking Delete, the field is removed and a success message is displayed

    Result of successful deletion.

Reference

Medallia recommends mapping questions to the field types listed below:

Question Type in Form Builder

EC Type (In-Product Dropdown)

EC Type (Import)

Field can be used as a filter in Reporting?

Text Input

Text

text

Autoindex Text

autoindex_text

Yes

First Name

firstname

Last Name

lastname

Phone

phone

Text Area

Comment

comment

Translatable Comment

translatable_comment

Drop Down Radio Buttons

Enumeration

enumeration

Yes

Checkboxes

Multi-Value Enumeration

enumerationMultiValues

Yes

Rating: 1 - 5 Scale

Grading (1 - 5)

ecGrading1to5

Rating: 1 - 7 Scale

Grading (1 - 7)

ecGrading1to7

Rating: 1 - 10 Scale

Grading (1 - 10)

ecGrading1to10

Rating: 0 - 10 Scale

Grading (0 - 10)

ecGrading0to10

NPS

Grading (0 - 10)

ecGrading0to10

Date

Date

date

Email

Email

email

Field Types by Parameter Type

Medallia recommends mapping custom parameters to the fields listed below:

Parameter Type (Custom Parameter Configuration)

EC Type (In-Product Dropdown)

EC Type (Import)

Field can be used as a filter in Reporting?

Property Type Availability

Text

Text

text

All

Autoindex Text

autoindex_text

Yes

All

Hyperlink

hyperlink

All

Email

email

All

Number

Text

text

All

Boolean

Autoindex Text

autoindex_text

Yes

All

Datetime

Date/Time

datetime

Digital Web only