Sample Eventlog Files: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
(20 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Sample files contain case and event data that can be used for demo purposes.  
Sample files contain event data (eventlogs) and case attribute data can be used for learning and demo purposes. See how to [[Exporting_and_Importing_Data_in_QPR_ProcessAnalyzer|import CSV, PACM and XES files]] to QPR ProcessAnalyzer.


== Accessing Sample Files ==
== Sample Files ==
* Excel sample files:
** [http://files.qpr.com/releases/PASampleFiles/excel/Dynamics_OrderToCash.xlsx Dynamics_OrderToCash.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/Dynamics_ProcureToPay.xlsx Dynamics_ProcureToPay.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/Epicor_OrderToCash.xlsx Epicor_OrderToCash.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/Healthcare_Patient_Journey.xlsx Healthcare_Patient_Journey.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/LoanApproval.xlsx LoanApproval.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/O2C_Manufacturing.xlsx O2C_Manufacturing.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_OrderToCash.xlsx SAP_OrderToCash.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_OrderToCash_10K.xlsx SAP_OrderToCash_10K.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_OrderToCash_Extended.xlsx SAP_OrderToCash_Extended.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_OrderToCash_v2.xlsx SAP_OrderToCash_v2.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_PurchaseToPay.xlsx SAP_PurchaseToPay.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_PurchaseToPay_v2.xlsx SAP_PurchaseToPay_v2.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/ServiceNow_IncidentManagement.xlsx ServiceNow_IncidentManagement.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/ServiceTicket.xlsx ServiceTicket.xlsx]


=== CSV Files ===
*  SAP Order-to-cash: [https://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_10K_Events.csv Event Data] and [https://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_10K_CaseAttributes.csv Case Attributes]
*  SAP Order-to-cash (more data): [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]


* PACM sample files:
=== PACM Files ===
** [http://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]
** [http://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]
** [http://files.qpr.com/releases/PASampleFiles/pacm/Epicor_OrderToCash.pacm Epicor_OrderToCash.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/Epicor_OrderToCash.pacm Epicor_OrderToCash.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/Healthcare_Patient_Journey.pacm Healthcare_Patient_Journey.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/Healthcare_Patient_Journey.pacm Healthcare_Patient_Journey.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/LoanApproval.pacm LoanApproval.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/LoanApproval.pacm LoanApproval.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/O2C_Manufacturing.pacm O2C_Manufacturing.pacm]  
* [https://files.qpr.com/releases/PASampleFiles/pacm/O2C_Manufacturing.pacm O2C_Manufacturing.pacm]  
** [http://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash.pacm SAP_OrderToCash.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash.pacm SAP_OrderToCash.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash_10K.pacm SAP_OrderToCash_10K.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash_10K.pacm SAP_OrderToCash_10K.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash_Extended.pacm SAP_OrderToCash_Extended.pacm]  
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash_Extended.pacm SAP_OrderToCash_Extended.pacm]  
** [http://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash_v2.pacm SAP_OrderToCash_v2.pacm]  
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash_v2.pacm SAP_OrderToCash_v2.pacm]  
** [http://files.qpr.com/releases/PASampleFiles/pacm/SAP_PurchaseToPay.pacm SAP_PurchaseToPay.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_PurchaseToPay.pacm SAP_PurchaseToPay.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/SAP_PurchaseToPay_v2.pacm SAP_PurchaseToPay_v2.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_PurchaseToPay_v2.pacm SAP_PurchaseToPay_v2.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/ServiceNow_IncidentManagement.pacm ServiceNow_IncidentManagement.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/ServiceNow_IncidentManagement.pacm ServiceNow_IncidentManagement.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/ServiceTicket.pacm ServiceTicket.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/ServiceTicket.pacm ServiceTicket.pacm]


=== XES Files ===
* Real-life XES event log files can be found from [https://www.tf-pm.org/resources/xes-standard/about-xes/event-logs IEEE Task Force on Process Mining repository].


* CSV sample files:
[[Category: QPR ProcessAnalyzer]]
** Epicor_OrderToCash model: [http://files.qpr.com/releases/PASampleFiles/csv/Epicor_OrderToCash_Events.csv Event Data] (event date format: d.M.yyyy H\:mm) and [http://files.qpr.com/releases/PASampleFiles/csv/Epicor_OrderToCash_CaseAttributes.csv Case Attributes]
**  LoanApproval model: [http://files.qpr.com/releases/PASampleFiles/csv/LoanApproval_Events.csv Event Data] (event date format: d.M.yyyy H\:mm) and [http://files.qpr.com/releases/PASampleFiles/csv/LoanApproval_CaseAttributes.csv Case Attributes]
**  SAP_OrderToCash model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_Events.csv Event Data] (event date format: d.M.yyyy H:mm) and  [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_CaseAttributes.csv Case Attributes]
**  SAP_OrderToCash_10K model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_10K_Events.csv Event Data] (event date format: d.M.yyyy H\:mm\:ss) and [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_10K_CaseAttributes.csv Case Attributes]
**  SAP_OrderToCash_Extended model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_Extended_Events.csv Event Data] (event date format: d.M.yyyy H\:mm\:ss) and [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_Extended_CaseAttributes.csv Case Attributes]
**  SAP_OrderToCash_v2 model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_v2_Events.csv Event Data] (event date format: d.M.yyyy H\:mm) and [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_v2_CaseAttributes.csv Case Attributes]
**  SAP_PurchaseToPay model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_Events.csv Event Data] (event date format: d.M.yyyy H\:mm\:ss) and [http://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_CaseAttributes.csv Case Attributes]
**  SAP_PurchaseToPay_v2 model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_v2_Events.csv Event Data] (event date format: d.M.yyyy H\:mm) and [http://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_v2_CaseAttributes.csv Case Attributes]
**  ServiceNow_IncidentManagement model: [http://files.qpr.com/releases/PASampleFiles/csv/ServiceNow_IncidentManagement_Events.csv Event Data] (event date format: d.M.yyyy H\:mm) and [http://files.qpr.com/releases/PASampleFiles/csv/ServiceNow_IncidentManagement_CaseAttributes.csv Case Attributes]
**  ServiceTicket model: [http://files.qpr.com/releases/PASampleFiles/csv/ServiceTicket_Events.csv Event Data] (event date format: d.M.yyyy H\:mm) and [http://files.qpr.com/releases/PASampleFiles/csv/ServiceTicket_CaseAttributes.csv Case Attributes]
 
 
* XES sample files:
** Some real-life XES event log files can be found from IEEE Task Force on Process Mining repository at [https://data.4tu.nl/repository/collection:event_logs_real 4TU.Centre for Research Data]
 
== Creating Model from Excel Sample Files ==
#To load events to QPR ProcessAnalyzer, select the worksheet that contains Event Data.
#On the QPR tab, select '''Project Workspace'''.
#Click the '''Import...''' button.
#The Import Wizard opens. Select '''Events''' to be imported and click '''Next'''.
#Select '''Current Worksheet''' and click '''Next'''.
#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. Select the Excel worksheet that contains Case Attribute Data.
#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 '''Current Worksheet''' and click '''Next'''.
#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 PrrocessAnalyzer 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'''.
 
== 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'''.

Revision as of 09:08, 31 August 2021

Sample files contain event data (eventlogs) and case attribute data can be used for learning and demo purposes. See how to import CSV, PACM and XES files to QPR ProcessAnalyzer.

Sample Files

CSV Files

PACM Files

XES Files