Importing Data to QPR ProcessAnalyzer: Difference between revisions
Jump to navigation
Jump to search
(Created page with "== Step 1: Imported File == You can choose whether to import: * '''cases''' or '''case attributes''' * '''events''' or '''event attributes''' * '''.xes''' or '''.pacm''' file....") |
m (Ollvihe moved page Import Data to QPR ProcessAnalyzer to Importing Data to QPR ProcessAnalyzer without leaving a redirect) |
(No difference)
|
Revision as of 15:26, 19 November 2018
Step 1: Imported File
You can choose whether to import:
- 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.
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.