Add Contacts and Transactions to XMD Task

Suite
Customer Experience Strategy & Research
Product
Qualtrics
What's on this page

About the Add Contacts and Transactions to XMD Task

The Add Contacts and Transactions to XMD task allows you to map data imported into Qualtrics to your XM Directory. For example, you can use an Extract data from SFTP files task to import data into Qualtrics and then map that data to your directory.

Qtip: For more information on using data loading and extracting tasks, see using Workflows tasks to build ETL workflows.
Qtip: This task is compatible with both XM Directory and XM Directory Lite. However, this task is not available in all licenses, and may not include certain features when used with XM Directory Lite, such as transaction data. If you’d like to upgrade to XM Directory, reach out to your Account Executive.
Qtip: For information on general limits that apply to ETL workflows, see Workflow Limits. For any task-specific limits, refer to the information on this page.

Setting Up an Add Contacts and Transactions to XMD Task

Create an ETL workflow.
Select Data source (ETL extractor). In this step, you’ll extract data that you can load to another destination. See using Building ETL Workflows for more information.
adding an extractor task to the etl workflow
adding an extractor task to the etl workflow
Qtip: Files must be less than 1 GB and 750,000 rows to be compatible with the add contacts and transactions to XMD task.
Click Add a data destination.
adding a loader task to the workflow
adding a loader task to the workflow
Choose the Add contacts and transactions to XMD task.
selecting task from the workflows menu
selecting task from the workflows menu
Choose the directory to map data to.
choosing a directory, list, and data source
choosing a directory, list, and data source
Qtip: Most licenses only have a default directory, but some may have multiple directories.
Select a mailing list to map data to. You can also choose to create a new mailing list for this directory each time this workflow runs.
Select a data source. This should be the data extractor task you set up earlier.
Use the menus to map fields from your data extracting task to your XM Directory. Fields can be mapped to contact data, existing embedded data, and transaction data in the selected directory. Review the mappings and make changes as needed:
mapping fields in the task
mapping fields in the task
  • Source field: The field from your extractor task.
    Qtip: Source fields can only be mapped to one destination field within the task.
  • Data project field: The destination field in XM Directory.

    Qtip: The following XM Directory contact fields are added by default:

    • ContactID
    • FirstName
    • LastName
    • Email
    • Language
    • Phone
    • Unsubscribed
    • ExternalReference (also known as ExternalDataReference)
  • Field type: The field type the imported data should be saved as:
    • Contact data: Standard contact fields.
    • Embedded data: Custom embedded data fields for extra contact data.
    • Transaction data: Data imported as a transaction field.

      Qtip: The TransactionDate field is useful for recording when the transaction occurred. Dates are assumed to be in UTC unless the time zone is explicitly included in the date value. More information on these formats can be found on the Date Format Syntax support page. Here is a list of compatible time formats:

      • ISO-8601 (2006-01-02T15:04:05+07:00)
      • ANSIC (Mon Jan _2 15:04:05 2006)
      • UnixDate (Mon Jan _2 15:04:05 MST 2006)
      • RFC822 (02 Jan 06 15:04 MST)
      • RFC850 (Monday, 02-Jan-06 15:04:05 MST)
      • RFC1123 (Mon, 02 Jan 2006 15:04:05 MST)

      You can map TransactionDate to whatever field you want; for example, you can choose a survey’s end date to reflect when a response was submitted, or a custom date field you have created. If your task contains transaction data but you do not map a TransactionDate field, then the date and time of the workflow run will be recorded as the TransactionDate.

      Qtip: The TransactionExternalReference field is a reference ID for each transaction. When a transaction is imported with a TransactionExternalReference, if an existing transaction is found with a matching TransactionExternalReference, that matching transaction will be updated. If no matching transaction exists, a new one will be created with the TransactionExternalReference.

When mapping fields, there are additional options available:
  • Delete: Remove the mapping.
  • Map Value: Map individual field values (for example, Y to Yes and N to No). See Mapping Field Values for more information.
To add custom fields to your mapping, click Add Field and then use the menus to map the field.
adding custom fields and saving
adding custom fields and saving
When finished mapping fields, click Save.
Qtip: This task obeys your directory’s contact deduplication rules.
Qtip: If desired, you can upload a file that contains your field mapping. Click Download a sample mapping to download an example CSV to your computer. Open this file in a spreadsheet editor and add your mappings using the file as a guide. Save the file as a CSV on your computer. Then, click Choose File and select your file. Make sure to double check your mappings before saving the task.
uploading a file in the task
uploading a file in the task

Troubleshooting Tips

  • When investigating what went wrong with a workflow task, check out Workflows reporting for any errors and correct them before retrying your task.
  • Contact deduplication allows you to retry your task without creating duplicate contacts. Make sure to set up contact deduplication rules when testing and retrying this task.
  • When mapping field values, keep the following in mind:
    • You may have up to 500 mapping pairs. If your file contains more than 500 mappings, then you will receive an error message and only the first 500 rows will be uploaded.
    • Make sure your file contains the “from” and “to” headers. If these headers are not detected, then Qualtrics will assume the first column is “from” and the second column is “to.

FAQs

Do I have access to all extensions available through the Workflows templates?

Is there a link to all Workflows events and tasks?

What are Workflows templates?

What are workflows? / Where are actions?

When you import updates to existing contacts, how are empty / blank fields treated?

Was this helpful?

The feedback you submit here is used only to help improve this page.

That's great! Thank you for your feedback!

Thank you for your feedback!