Importing Data to QPR ProcessAnalyzer

From QPR ProcessAnalyzer Wiki
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: 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", where dd = zero-padded day of the month, from 01 through 31; MM = zero-padded month, from 01 through 12; yyyy = year as a four-digit number; HH = zero padded hour, using a 24-hour clock from 00 to 23; mm = zero-padded minute, from 00 through 59; ss = second, from 00 through 59; fff = millisecond. 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.

Step 3: 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 is to 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.
  • Existing model: You need to select the project and model to which the data is to be created. You can click the Open button to check the model that is currently selected.