Importing Data to QPR ProcessAnalyzer: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
m (Ollvihe moved page Import Data to QPR ProcessAnalyzer to Importing Data to QPR ProcessAnalyzer without leaving a redirect)
Line 1: Line 1:
== Step 1: Imported File ==
== Step 1: Imported File ==
You can choose whether to import:
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.
* '''cases''' or '''case attributes'''
* '''events''' or '''event attributes'''
* '''.xes''' or '''.pacm''' file.
With cases or case attributes and events or event attributes, the data needs to be imported from .csv files. A .xes or a .pacm file will contain both case and event data.<br>


== Step 2: CSV File Format ==
== Step 2: CSV File Format ==

Revision as of 12:05, 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: CSV File Format

When importing from a csv file, here you can define in what format the data is in the file:

  • 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 (staring from 1) in the file that contains the headers of the data. 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.