Skip to main content
Loading...
Skip to article
  • Qualtrics Platform
    Qualtrics Platform
  • Customer Journey Optimizer
    Customer Journey Optimizer
  • XM Discover
    XM Discover
  • Qualtrics Social Connect
    Qualtrics Social Connect

Load Data into Location Directory Task


Was this helpful?


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

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!


About the Load Data into Location Directory Task

Using Workflows, the Load data into Location Directory task allows you to save imported data to a Qualtrics location directory. For example, you can use an Extract data from SFTP files task to import data from your SFTP server and then map that data to a Qualtrics location directory.

Qtip: This task must be paired with an extractor task that contains the data to be loaded. See Building ETL Workflows for more information.

Creating a Load Data into Location Directory Task

  1. Follow the linked instructions to create a new ETL workflow.
  2. Configure the extractor task for your workflow. This is the source that contains the data you’d like to load into your location directory.setting up an etl extractor task and adding a transformation if needed
    Qtip: Common extractors used with this loader task are Extract data from SFTP files and Extract data from Google Drive.
  3. If needed, you can add a basic transform task to transform incoming data to fit Qualtrics formats.
  4. Click Add a data destination.
  5. Select the Load data into Location Directory task.choosing the "load data into location directory" task
  6. Choose the directory you’d like to load locations into.
    choosing a location directory and extractor data source

    Qtip: If you need to create a new location directory, click the “Visit Location Directory” link displayed in the task.
  7. For the data source, select the extractor task you set up earlier.
  8. Map your data source fields (left) to location fields (right).mapping data fields and saving the task
  9. You can click Add field if you need to map additional fields.
  10. Click the more options menu to view the following options:
    • Delete row: Delete the selected field mapping.
      Attention: The “Location External Reference” field is required and cannot be deleted. This field is used to deduplicate locations. When the workflow runs, Qualtrics will search for the location based on the external reference and either update the existing location if it exists, or create a new location if it doesn’t exist. Do not alter the Location External Reference mapping after the first successful workflow run since this may result in duplicate records in your dataset.
    • Map values: Map individual field values (for example, Y to Yes and N to No). See Mapping Field Values for step by step instructions.
      Qtip: This is particularly useful for mapping values to the “Location Status” field. The values accepted by this field are active, inactive, and closed.
  11. Click Save.
Qtip: If you import data for an existing location and leave an existing field blank, the current value will be kept, not erased.