Skip to main content

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

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Importing the data

Updated on September 10, 2021

To upload comma-separated values (.csv) files into your application, you can use the Data Import wizard or the data import File Listener (large data volumes only).

Note: This article explains how to use the Data Import wizard. If you are using the data import File Listener, skip this article. For more information, see Using the data import File Listener.
Note: To import your data with increased performance, see Improving data import performance by using configuration templates.

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 Operator.
    2. In the navigation pane, click Tools > Data Import wizard.
    3. Select the data type that you want to import.
      The types need to be imported in the order that they display in the drop-down menu due to their dependencies.

      Selecting upoad type

  2. Import data.
    1. Select an import purpose:
      1. To add only new records, click Add only. Updates to existing records are ignored.
      2. To add and update records, click Add or update.
    2. Click Choose File and select the CSV file that you want to import.
  3. Map fields.
    1. Select the template that you want to use.
      • If the purpose is set to Add or update, you can use the Update type to control how empty fields are handled.
      • If the purpose is set to Add or update, the Match existing records by option allows you to choose the field name with which existing records in the system will be identified for update.

        Selecting import purpose

  4. Select import options.
    1. Optional: To save mappings configured on the Map fields page in the wizard to a new or existing template for future use, select Save import settings.
    2. If this is the first time you are loading data from a data source, clear the Skip running validate rules check box.
      Note: Load only a few rows of data as a test before loading a full record set. Once you are confident about the quality of your data, select the Skip running validate rules check box to reduce the throughput.

      Additional import options

  5. Validate and review.
    1. Review the list of processed, added, and failed records before continuing the import.
    2. If the entity has a parent, open a few instances in the context of their parent with which they are associated. If files are imported in an 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.

      Data import validation

  • Previous topic Improving data import performance by using configuration templates
  • Next topic Importing large amounts of data by using the data import File Listener

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