Importing data from a file
To add data to your data model more quickly, import data from a .csv file.
If your operator ID has Allow rule checkout enabled, import
performance might be impacted. Use an operator ID that does not have Allow rule
checkout enabled, or disable this option for your operator ID. For more
information, see Defining security information for an operator.
To view a list of operators that have Allow rule checkout enabled,
click View Operators with 'Allow rule checkout' enabled at the bottom
of the Migration settings landing page.
- Access the data object.
- In the navigation pane of App Studio, click Data.
- Click a data object.
- Upload the file.
- Click the Records tab, and then click Import.
- In the Purpose list, select Add only.
- Click Choose File.
- Navigate to your .csv file, and then click Open.
- Click Next.
- Map the columns in your file to the fields in the data object.
- In the Target field column, select the fields in your data
object that correspond to the fields in the .csv file shown in the Source
field column, or click Select to display a dialog
box for searching and filtering fields.
- Optional: If you are importing fields from an external system, you can apply business logic, such as lookups, decision trees, and decision tables to translate the external data into fields that are understood by Pega Platform. In the Mapping options column, click the Mapping options icon to select the type of business logic to use for translation, and click Submit. For more information, see Applying business logic when importing data.
- Optional: Enter a default value. For new records, the default value is used if the source field is blank. For existing records, the default value is used if both the source and target fields are blank. If you use a lookup, decision tree, or decision table, the source value is the value obtained from the lookup, tree, or table. It is not the value in the .csv file.
- Optional: Set defaults for fields that do not have matching source columns in the .csv
file.
- Click View custom defaults.
- Click Add default value.
- In the Target field column, enter the target field or click Select to choose the target field from a list of fields.
- In the Default value column, enter the default value. For new records, the default value is used if it is provided. For existing records, the default value is used if the target value is blank.
- Click Next if you are finished mapping fields, or click Back to mapping to finish mapping fields.
- In the Target field column, select the fields in your data
object that correspond to the fields in the .csv file shown in the Source
field column, or click Select to display a dialog
box for searching and filtering fields.
- Click Next.
- Optional: If you are using a dashboard gadget in your end-user portal that displays in-progress data imports and recently completed data imports, in the Name for this data import field, enter a short description that describes the import.
- To save your import settings for reuse when mapping fields, in the Additional import options section, click Save import settings as a template, and then enter the template name.
- To control validation overhead, in the Skip validation section,
configure how much validation to use on imported data by selecting one of the following
validation options.
- To skip validation, Skip validation step entirely.
- Select Skip running validate rules if you want the system to perform basic validation. Basic validation checks that the property type of the data being imported matches the property type of the field in the data type.
- Clear Skip running validate rules if you want the system to perform advanced validation. Advanced validation performs basic validation, then runs the default validate rule of the data type on each record that is imported. Running the validate rule causes the import to take longer; however, it allows you more control when you need additional validation.
- If you selected Skip running validate rules in step 7, click Start validation.
- Click Continue import. You can close the dialog box for the data import process. The process runs asynchronously and is visible on your worklist.
- If you selected Skip validation step entirely in step 7, click Import.
- Click Finish.
Previous topic Using the Data Import wizard Next topic Applying business logic when importing data