Sample Eventlog Files: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
Line 4: Line 4:


=== CSV sample files ===
=== 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]
* Epicor_OrderToCash model: [http://files.qpr.com/releases/PASampleFiles/csv/Epicor_OrderToCash_Events.csv Event Data] (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]
*  LoanApproval model: [http://files.qpr.com/releases/PASampleFiles/csv/LoanApproval_Events.csv Event Data] (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 model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_Events.csv Event Data] (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_10K model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_10K_Events.csv Event Data] (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_Extended model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_Extended_Events.csv Event Data] (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_OrderToCash_v2 model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_v2_Events.csv Event Data] (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 model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_Events.csv Event Data] (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]
*  SAP_PurchaseToPay_v2 model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_v2_Events.csv Event Data] (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]
*  ServiceNow_IncidentManagement model: [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 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]
*  ServiceTicket model: [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 ===
=== Excel sample files ===

Revision as of 14:18, 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.