Importing Data to QPR ProcessAnalyzer: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 2: Line 2:
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.
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 ==
== 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:
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.
* '''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.
Line 9: Line 15:
* '''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.
* '''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 ==
[[Category: QPR UI]]
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.

Revision as of 15:09, 21 November 2018

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.