Sample Eventlog Files: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
Sample files contain case and event data that can be used for demo purposes.  
Sample files contain case and event data that can be used for demo purposes.  


== 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 sample files ===
* 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]


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


=== PACM sample files ===
* [http://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]
* [http://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]
* [http://files.qpr.com/releases/PASampleFiles/pacm/LoanApproval.pacm LoanApproval.pacm]
* [http://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]
* [http://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]
* [http://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]
* [http://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]
* [http://files.qpr.com/releases/PASampleFiles/pacm/ServiceTicket.pacm ServiceTicket.pacm]


* CSV sample files:
=== XES sample files ===
** 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]
* 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]
**  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 ==
== Creating Model from Excel Sample Files ==

Revision as of 14:17, 27 May 2020

Sample files contain case and event data that can be used for demo purposes.

Sample Files

CSV sample files

Excel sample files

PACM sample files

XES sample files

Creating Model from Excel Sample Files

  1. To load events to QPR ProcessAnalyzer, select the worksheet that contains Event Data.
  2. On the QPR tab, select Project Workspace.
  3. Click the Import... button.
  4. The Import Wizard opens. Select Events to be imported and click Next.
  5. Select Current Worksheet and click Next.
  6. Select Create New and from the Project drop-down menu, select either "Create New Project" or choose an existing project.
  7. In Model Name, type in a name for the model and click Import.
  8. Next, the case data will be imported to the model. Select the Excel worksheet that contains Case Attribute Data.
  9. On the QPR tab, click Project Workspace.
  10. In the Workspace dialog, click the Import... button.
  11. The Import Wizard opens. Select Case Attributes to be imported and click Next.
  12. Select Current Worksheet and click Next.
  13. Select Add to Existing and select the model for which you gave the name earlier.
  14. Click Import.
  15. 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:

  1. On the QPR tab, select Project Workspace.
  2. Click the Import... button.
  3. The Import Wizard opens. Select QPR PrrocessAnalyzer file to be imported and click Next.
  4. ClickSelect..., locate the pacm file to use and click Open.
  5. Click the Next button.
  6. Select Create New and from the Project drop-down menu, select either "Create New Project" or choose an existing project.
  7. In Model Name, type in a name for the model and click Import.
  8. 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:

  1. On the QPR tab, select Project Workspace.
  2. Click the Import... button.
  3. The Import Wizard opens. Select Events to be imported and click Next.
  4. Select Text File and click Next.
  5. ClickSelect..., locate the CSV file containing event data to use and click Open.
  6. Select the proper delimiter and TimeDate Format, e.g. d.M.yyyy H\:mm.
  7. Select Create New and from the Project drop-down menu, select either "Create New Project" or choose an existing project.
  8. In Model Name, type in a name for the model and click Import.
  9. Next, the case data will be imported to the model.
  10. On the QPR tab, click Project Workspace.
  11. In the Workspace dialog, click the Import... button.
  12. The Import Wizard opens. Select Case Attributes to be imported and click Next.
  13. Select Text File and click Next.
  14. ClickSelect..., locate the CSV file containing event data to use and click Open.
  15. Select the proper delimiter and TimeDate Format, e.g. d.M.yyyy H\:mm.
  16. Select Add to Existing and select the model for which you gave the name earlier.
  17. Click Import.
  18. The resulting model will now have Events and Case Data. In the Project Workspace dialog, select the model and click Open.