Importing Data to QPR ProcessAnalyzer: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
This page describes how to import data to QPR ProcessAnalyzer using the Data Import view in [[QPR_ProcessAnalyzer_Deployment_Package_for_QPR_UI|QPR ProcessAnalyzer UI]].
This page describes how to import data to QPR ProcessAnalyzer using the Data Import view.


== Step 1: Imported File ==
== Step 1: Imported File ==
Line 9: Line 9:
* '''Create New Model''': Select a project to which the new model will be created, and define a name for the new model.
* '''Create New Model''': Select a project to which the new model will be created, and define a name for the new model.


When importing a data table, the target project and data table name needs to be defined. In the web UI, it's not possible to import to an existing data table.
When importing a data table, the target project and data table name needs to be defined. When importing to an existing datatable, specify the name of the datatable similar to creating a new datatable.
 
When '''Add to existing data''' is checked, the existing data in a datatable is not deleted and the new data is added to the existing data.


== Step 3: CSV File Format ==
== Step 3: CSV File Format ==

Revision as of 13:48, 18 December 2019

This page describes how to import data to QPR ProcessAnalyzer using the Data Import view.

Step 1: Imported File

Choose a file to be imported from your disk drive. It's possible to import .csv, .pacm and .xes files. If importing from a .csv file, define also whether the data contains cases, events or other data to be loaded into a data table. Pacm and xes files contain an entire QPR ProcessAnalyzer model.

Step 2: Import Destination

Cases and/or events can be imported to an existing QPR ProcessAnalyzer model or the import can create a new model:

  • Import to Existing Model: Select a project and model which the data will be import to. You can click the Open button to check the model that is currently selected.
  • Create New Model: Select a project to which the new model will be created, and define a name for the new model.

When importing a data table, the target project and data table name needs to be defined. When importing to an existing datatable, specify the name of the datatable similar to creating a new datatable.

When Add to existing data is checked, the existing data in a datatable is not deleted and the new data is added to the existing data.

Step 3: CSV File Format

When importing from a csv file, you need to define in which format the data is stored in the file. If uncertain, open the file to see its contents. Following settings can be set:

Csv files need to be UTF-8 encoded and size limit is 230mb (tested on Firefox).

When importing cases from a csv file, the first column must contain case ID and the rest of the columns are case attributes. When importing events, the column order in the csv file must be the following:

  • 1. column: case ID's
  • 2. column: event type name
  • 3. column: event timestamp
  • 4. column onwards: event attributes