Skip to main content

         This documentation site is for previous versions. Visit our new documentation site for current releases.      

Running a data import using the Data import wizard

Updated on May 10, 2021

Import data into your application using the Data Import wizard to upload comma-separated values (.csv) files containing data records.

Pega Sales Automation Implementation Guide

To import your data by using the Data import wizard, perform the following steps:

  1. Open the Data Import wizard:
    1. Log in to Pega Sales Automation as a Sales Ops.
    2. In the User portal navigation pane, click ToolsData import wizard.
    3. In the Import Data wizard step, select the data type that you want to import.

    Caution: Because the data types have dependencies, the data types need to be imported in the order that they display in the drop-down menu.

  2. Select the purpose of the data import:
    • To add only new records, click Add only. Updates to existing records are ignored.
    • To add and update records, click Add or update.
  3. Click Choose File, select the .csv file that you want to import, and then click Next.
  4. In the Map Fields wizard step, map the data fields in your source data to the fields in Pega Sales Automation by selecting the template that you want to use:
    1. In the Template field, select the import template.
    • If you have not created configuration templates, see Improving data import performance by using configuration templates.
    • When you select the out-of-the-box template the system populates the Target field fields. If your CSV file has any additional fields, map the fields manually. For more information, see Preparing the data.
    • If the purpose is set to Add or update, you can use the Update type to control how the data import process handles empty fields.
    • If the purpose is set to Add or update, the Match existing records by option allows you to choose the field name by which existing records in the system will be identified for updating.
  5. In the Import Options wizard step, select the import options:
    • To save the mappings that you configure in the Map fields wizard step to a new or existing template for future use, select Save import settings as a template check box.
    • If this is the first time that you are loading data from a data source, clear the Skip running validate rules check box.

      Note: Before loading a full record set, try loading only a few rows of data as a test. After you are confident about the quality of your data, select the Skip running validate rules check box to reduce the throughput by skipping only the validate rules but still checking the required fields.

    • To skip all the validation, including validating the required fields, select the Skip validation step entirely check box
    1. Click Start validation.
      The validation process is split into two parts to ensure that the data import succeeds. After the initial validation succeeds, continue the import process by moving into the next step.
    2. Click Continue import.
  6. In the Validate and review wizard step, review the uploaded data:
    1. Review the list of processed, added, and failed records.
    2. If an entity has a parent, open a few instances in the context of the entity's parent. If files are imported in the incorrect order, associations between entities might be broken. For example, activities would not show up in the associated contact if they were imported before the contact data in the import order.
    3. Click Finish.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us