Sample Eventlog Files: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
 
(15 intermediate revisions by the same user not shown)
Line 1: Line 1:
Sample files contain event data (event logs) and case attribute data can be used for learning and demo purposes.  
These files contain sample datasets that can be directly imported to QPR ProcessAnalyzer, and they can be used for learning and demo purposes. There are two tabular datasets needed to create a process mining model: event data (eventlog) and case attributes. When using CSV files, these two datasets need to be imported from separate files. When using PACM or XES formats, the single file contains both the events and case attributes data. See how to [[Exporting_and_Importing_Data_in_QPR_ProcessAnalyzer|import CSV, PACM and XES files]] to QPR ProcessAnalyzer.


== Sample Files ==
== CSV Files ==
*  SAP Order-to-cash: [https://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_Extended_Events.csv Event Data] and [https://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_Extended_CaseAttributes.csv Case Attributes]
*  SAP purchase-to-pay: [https://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_v2_Events.csv Event Data] and [https://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_v2_CaseAttributes.csv Case Attributes]
*  Loan approval: [https://files.qpr.com/releases/PASampleFiles/csv/LoanApproval_Events.csv Event Data] and [https://files.qpr.com/releases/PASampleFiles/csv/LoanApproval_CaseAttributes.csv Case Attributes]
*  ServiceNow incident management: [https://files.qpr.com/releases/PASampleFiles/csv/ServiceNow_IncidentManagement_Events.csv Event Data] and [https://files.qpr.com/releases/PASampleFiles/csv/ServiceNow_IncidentManagement_CaseAttributes.csv Case Attributes]
*  Service tickets: [https://files.qpr.com/releases/PASampleFiles/csv/ServiceTicket_Events.csv Event Data] and [https://files.qpr.com/releases/PASampleFiles/csv/ServiceTicket_CaseAttributes.csv Case Attributes]
*  Order-to-cash (900k cases / 92k events): [https://files.qpr.com/releases/PASampleFiles/csv/OTC_Events_900k.csv Event Data] and [https://files.qpr.com/releases/PASampleFiles/csv/OTC_Cases_92k.csv Case Attributes]


=== CSV sample files ===
== PACM Files ==  
*  LoanApproval: [https://files.qpr.com/releases/PASampleFiles/csv/LoanApproval_Events.csv Event Data] (date format: d.M.yyyy H:mm) and [https://files.qpr.com/releases/PASampleFiles/csv/LoanApproval_CaseAttributes.csv Case Attributes]
*  SAP_OrderToCash: [https://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_Events.csv Event Data] (date format: d.M.yyyy H:mm) and  [https://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_CaseAttributes.csv Case Attributes]
*  SAP_OrderToCash_10K: [https://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_10K_Events.csv Event Data] (date format: d.M.yyyy H:mm:ss) and [https://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_10K_CaseAttributes.csv Case Attributes]
*  SAP_OrderToCash_Extended: [https://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_Extended_Events.csv Event Data] (date format: d.M.yyyy H:mm:ss) and [https://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_Extended_CaseAttributes.csv Case Attributes]
*  SAP_OrderToCash_v2: [https://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_v2_Events.csv Event Data] (date format: d.M.yyyy H:mm) and [https://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_v2_CaseAttributes.csv Case Attributes]
*  SAP_PurchaseToPay: [https://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_Events.csv Event Data] (date format: d.M.yyyy H:mm:ss) and [https://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_CaseAttributes.csv Case Attributes]
*  SAP_PurchaseToPay_v2: [https://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_v2_Events.csv Event Data] (date format: d.M.yyyy H:mm) and [https://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_v2_CaseAttributes.csv Case Attributes]
*  ServiceNow_IncidentManagement: [https://files.qpr.com/releases/PASampleFiles/csv/ServiceNow_IncidentManagement_Events.csv Event Data] (date format: d.M.yyyy H:mm) and [https://files.qpr.com/releases/PASampleFiles/csv/ServiceNow_IncidentManagement_CaseAttributes.csv Case Attributes]
*  ServiceTicket: [https://files.qpr.com/releases/PASampleFiles/csv/ServiceTicket_Events.csv Event Data] (date format: d.M.yyyy H:mm) and [https://files.qpr.com/releases/PASampleFiles/csv/ServiceTicket_CaseAttributes.csv Case Attributes]
 
=== PACM sample files ===  
* [https://files.qpr.com/releases/PASampleFiles/pacm/Dynamics_OrderToCash.pacm Dynamics_OrderToCash.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/Dynamics_OrderToCash.pacm Dynamics_OrderToCash.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/Dynamics_ProcureToPay.pacm Dynamics_ProcureToPay.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/Dynamics_ProcureToPay.pacm Dynamics_ProcureToPay.pacm]
Line 30: Line 25:
* [https://files.qpr.com/releases/PASampleFiles/pacm/ServiceTicket.pacm ServiceTicket.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/ServiceTicket.pacm ServiceTicket.pacm]


=== XES sample files ===
== XES Files ==
* Real-life XES event log files can be found from [https://data.4tu.nl/repository/collection:event_logs_real IEEE Task Force on Process Mining repository].
* Real-life eventlogs in XES format can be found in [https://www.tf-pm.org/resources/xes-standard/about-xes/event-logs IEEE Task Force on Process Mining repository].
 
== Creating Model from CSV Sample Files ==
To create a model to QPR ProcessAnalyzer using CSV files:
#On the QPR tab, select '''Project Workspace'''.
#Click the '''Import...''' button.
#The Import Wizard opens. Select '''Events''' to be imported and click '''Next'''.
#Select '''Text File''' and click '''Next'''.
#Click'''Select...''', locate the CSV file containing event data to use and click '''Open'''.
#Select the proper delimiter and TimeDate Format, e.g. d.M.yyyy H\:mm.
#Select '''Create New''' and from the '''Project''' drop-down menu, select either "Create New Project" or choose an existing project.
#In '''Model Name''', type in a name for the model and click '''Import'''.
#Next, the case data will be imported to the model.
#On the QPR tab, click '''Project Workspace'''.
#In the Workspace dialog, click the '''Import...''' button.
#The Import Wizard opens. Select '''Case Attributes''' to be imported and click '''Next'''.
#Select '''Text File''' and click '''Next'''.
#Click'''Select...''', locate the CSV file containing event data to use and click '''Open'''.
#Select the proper delimiter and TimeDate Format, e.g. d.M.yyyy H\:mm.
#Select '''Add to Existing''' and select the model for which you gave the name earlier.
#Click '''Import'''.
#The resulting model will now have Events and Case Data. In the '''Project Workspace''' dialog, select the model and click '''Open'''.
 
== Creating Model from PACM Sample Files ==
To load a model to QPR ProcessAnalyzer using PACM file:
#On the QPR tab, select '''Project Workspace'''.
#Click the '''Import...''' button.
#The Import Wizard opens. Select '''QPR ProcessAnalyzer file''' to be imported and click '''Next'''.
#Click'''Select...''', locate the pacm file to use and click '''Open'''.
#Click the '''Next''' button.
#Select '''Create New''' and from the '''Project''' drop-down menu, select either "Create New Project" or choose an existing project.
#In '''Model Name''', type in a name for the model and click '''Import'''.
#The resulting model will now have Events and Case Data. In the '''Project Workspace''' dialog, select the model and click '''Open'''.


[[Category: QPR ProcessAnalyzer]]
== OCEL 2.0 Files ==
Example OCEL 2.0 eventlogs: https://www.ocel-standard.org/event-logs/overview/ (download the json format supported by QPR ProcessAnalyzer)

Latest revision as of 09:09, 14 October 2024

These files contain sample datasets that can be directly imported to QPR ProcessAnalyzer, and they can be used for learning and demo purposes. There are two tabular datasets needed to create a process mining model: event data (eventlog) and case attributes. When using CSV files, these two datasets need to be imported from separate files. When using PACM or XES formats, the single file contains both the events and case attributes data. See how to import CSV, PACM and XES files to QPR ProcessAnalyzer.

CSV Files

PACM Files

XES Files

OCEL 2.0 Files

Example OCEL 2.0 eventlogs: https://www.ocel-standard.org/event-logs/overview/ (download the json format supported by QPR ProcessAnalyzer)

Retrieved from "https://wiki.onqpr.com/pa/index.php?title=Sample_Eventlog_Files&oldid=25283"