Sample Eventlog Files: Difference between revisions

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


== Sample Files ==
== Sample Files ==
Line 13: Line 13:
*  ServiceNow_IncidentManagement: [http://files.qpr.com/releases/PASampleFiles/csv/ServiceNow_IncidentManagement_Events.csv Event Data] (date format: d.M.yyyy H:mm) and [http://files.qpr.com/releases/PASampleFiles/csv/ServiceNow_IncidentManagement_CaseAttributes.csv Case Attributes]
*  ServiceNow_IncidentManagement: [http://files.qpr.com/releases/PASampleFiles/csv/ServiceNow_IncidentManagement_Events.csv Event Data] (date format: d.M.yyyy H:mm) and [http://files.qpr.com/releases/PASampleFiles/csv/ServiceNow_IncidentManagement_CaseAttributes.csv Case Attributes]
*  ServiceTicket: [http://files.qpr.com/releases/PASampleFiles/csv/ServiceTicket_Events.csv Event Data] (date format: d.M.yyyy H:mm) and [http://files.qpr.com/releases/PASampleFiles/csv/ServiceTicket_CaseAttributes.csv Case Attributes]
*  ServiceTicket: [http://files.qpr.com/releases/PASampleFiles/csv/ServiceTicket_Events.csv Event Data] (date format: d.M.yyyy H:mm) and [http://files.qpr.com/releases/PASampleFiles/csv/ServiceTicket_CaseAttributes.csv Case Attributes]
=== 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]


=== PACM sample files ===  
=== PACM sample files ===  
Line 49: Line 33:
* 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]
* 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 CSV Sample Files ==
#To load events to QPR ProcessAnalyzer, select the worksheet that contains Event Data.
To create a model to QPR ProcessAnalyzer using CSV files:
#On the QPR tab, select '''Project Workspace'''.
#On the QPR tab, select '''Project Workspace'''.
#Click the '''Import...''' button.
#Click the '''Import...''' button.
#The Import Wizard opens. Select '''Events''' to be imported and click '''Next'''.
#The Import Wizard opens. Select '''Events''' to be imported and click '''Next'''.
#Select '''Current Worksheet''' 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.
#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'''.
#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.
#Next, the case data will be imported to the model.  
#On the QPR tab, click '''Project Workspace'''.
#On the QPR tab, click '''Project Workspace'''.
#In the Workspace dialog, click the '''Import...''' button.
#In the Workspace dialog, click the '''Import...''' button.
#The Import Wizard opens. Select '''Case Attributes''' to be imported and click '''Next'''.
#The Import Wizard opens. Select '''Case Attributes''' to be imported and click '''Next'''.
#Select '''Current Worksheet''' 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.
#Select '''Add to Existing''' and select the model for which you gave the name earlier.
#Click '''Import'''.
#Click '''Import'''.
Line 75: Line 63:
#Select '''Create New''' and from the '''Project''' drop-down menu, select either "Create New Project" or choose an existing project.
#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'''.
#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'''.
#The resulting model will now have Events and Case Data. In the '''Project Workspace''' dialog, select the model and click '''Open'''.


[[Category: QPR ProcessAnalyzer]]
[[Category: QPR ProcessAnalyzer]]

Revision as of 12:03, 23 September 2020

Sample files contain event data (event logs) and case attribute data can be used for learning and demo purposes.

Sample Files

CSV sample files

PACM sample files

XES sample files

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.

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.