Importing Data to QPR ProcessAnalyzer

This page describes how to import data to QPR ProcessAnalyzer using the Data Import view in the QPR ProcessAnalyzer Deployment Package.

Step 1: Imported File

First choose the file to be imported from you local disk drive. It's possible to import csv, pacm and xes files. If importing from a csv file, you need to define, whether the data contains cases or events. Pacm and xes files contain the entire QPR ProcessAnalyzer model, so with those formats no further selections are needed.

Step 2: Import Destination

There are following ways to store data to a model:

• Create a new model to an existing project: You need to select an existing project to which the new model will be created. You also need to define a name for the new model.
• Create a new model to a new project: You need to define the name of the new project and new model. Note that you can't define different names for the new project and the new model, but you can rename the project and model after the import.
• Import to an existing model: You need to select the project and model which the data will be import to. You can click the Open button to check the model that is currently selected.

Step 3: (Optional) CSV File Format

When importing from a csv file, you need to define in what format the data is stored in the file. If uncertain, open the file and see its contents. Following settings can be set:

• Column delimiter: Column delimiter is the character that separates data cells within a row. Usually the column delimiter is a semicolon or tab. It's possible to define any character by selecting the Other option.
• Date format: Date format is used to interpret date values in the csv file. Default format is "yyyy-MM-dd HH:mm:ss,fff". More information about formatting: https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings.
• Text qualifier: Text qualifier is the character used to enclose text (string) values. Sometimes csv files don't contain text qualifiers at all.
• Header row number: The row number (starting from 1) in the file that contains table headers. Usually the first row contains the headers, but the file may start with rows that need to be skipped.

Additional note regarding CSV file columns: When importing cases, the first column must contain case ID's and the rest of the columns are case attributes. When importing events, the column order must be the following:

• 1. column: case ID's
• 2. column: event type names
• 3. column: event timestamps
• starting from 4. column: event attributes