Importing Data to QPR ProcessAnalyzer
Jump to navigation
Jump to search
Step 1: Imported File
First choose the file to be imported from the local disk. It's possible to import csv, pacm and xes files. If importing from a csv file, you need to define, whether the data rows are cases or events. Pacm and xes files contain a whole QPR ProcessAnalyzer model, so no further selections are needed.
Step 2: Import Destination
There are following ways to import data:
- 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 name for the new model.
- 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 or model after the import.
- Existing model: You need to select the project and model to which the data will be created. You can click the Open button to check the model that is currently selected.
(Optional) Step 3: CSV File Format
When importing from a csv file, you need to define in what format the data is in the file. If uncertain, open the file and see its structure. Following settings can be adjusted:
- Column delimiter: Column delimiter is the character that separates data cells in 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.