Skip to main content


Preparing the data

Suggest edit Updated on May 10, 2021

Columns in the comma-separated values (CSV) files that you use to import data to the Pega Sales Automation data model are mapped to fields by using templates. Pega Sales Automation includes default templates as well as specific templates for Salesforce and Siebel data.

Before starting a data import, review the following best practices:

  • Analyze the type of data that you have and how it relates to the fields that Pega Sales Automation entities use.
  • Use the Pega Sales Automation sample data templates as examples when creating your CSV files, to ensure that the CSV file you want to import contains all of the fields and values that Pega Sales Automation requires. If you find that the default templates do not fulfill your requirements, you can extend them. For more information, see Data import scenarios.
  • Ensure that the data types are correct and that date formats are the same across all the CSV files. The data import wizard supports the following ISO 8601 date and time formats:hhmmssZhhmmssffffffhhmmss+|-hhmmhh:mm:ss.ffffffhh:mm:ss.ffffff+|-hh:mmyyyymmddyyyymmddThhmmssZyyyymmddThhmmssffffffyyyymmddThhmmss+|-hhmmyyyy-mm-ddyyyy-mm-ddThh:mm:ss.ffffffyyyy-mm-ddThh:mm:ss.nnnnnn+|-hh:mm
  • Check the relationships between the records, to ensure proper associations between the entities. You can use Vlookup in your Excel files to match parent record IDs with child records in your export CSV files. For example, check whether contacts link to the Accounts that they relate to.
  • The operator IDs in the CSV file must be exactly the same as the created operator IDs. Otherwise, the imported work objects associated with the operator ID, for example, organizations, accounts, leads, contacts, and opportunities will not appear in the application list views.
Note: If you are importing data into Pega Sales Automation for Financial Services, see Importing customer data.
Did you find this content helpful? YesNo

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

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