Sample Eventlog Files: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
Line 3: Line 3:
== Accessing Sample Files ==
== Accessing Sample Files ==
* Excel sample files:  
* Excel sample files:  
** Dynamics_OrderToCash.xlsx: http://files.qpr.com/releases/PASampleFiles/excel/Dynamics_OrderToCash.xlsx
** [http://files.qpr.com/releases/PASampleFiles/excel/Dynamics_OrderToCash.xlsx Dynamics_OrderToCash.xlsx]
** Dynamics_ProcureToPay.xlsx: http://files.qpr.com/releases/PASampleFiles/excel/Dynamics_ProcureToPay.xlsx
** [http://files.qpr.com/releases/PASampleFiles/excel/Dynamics_ProcureToPay.xlsx Dynamics_ProcureToPay.xlsx]
** Epicor_OrderToCash.xlsx: http://files.qpr.com/releases/PASampleFiles/excel/Epicor_OrderToCash.xlsx
** [http://files.qpr.com/releases/PASampleFiles/excel/Epicor_OrderToCash.xlsx Epicor_OrderToCash.xlsx]
** Healthcare_Patient_Journey.xlsx: http://files.qpr.com/releases/PASampleFiles/excel/Healthcare_Patient_Journey.xlsx
** [http://files.qpr.com/releases/PASampleFiles/excel/Healthcare_Patient_Journey.xlsx Healthcare_Patient_Journey.xlsx]
** LoanApproval.xlsx: http://files.qpr.com/releases/PASampleFiles/excel/LoanApproval.xlsx
** [http://files.qpr.com/releases/PASampleFiles/excel/LoanApproval.xlsx LoanApproval.xlsx]
** O2C_Manufacturing.xlsx: http://files.qpr.com/releases/PASampleFiles/excel/O2C_Manufacturing.xlsx
** [http://files.qpr.com/releases/PASampleFiles/excel/O2C_Manufacturing.xlsx O2C_Manufacturing.xlsx]
** SAP_OrderToCash.xlsx: http://files.qpr.com/releases/PASampleFiles/excel/SAP_OrderToCash.xlsx
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_OrderToCash.xlsx SAP_OrderToCash.xlsx]
** SAP_OrderToCash_10K.xlsx: http://files.qpr.com/releases/PASampleFiles/excel/SAP_OrderToCash_10K.xlsx
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_OrderToCash_10K.xlsx SAP_OrderToCash_10K.xlsx]
** SAP_OrderToCash_Extended.xlsx: http://files.qpr.com/releases/PASampleFiles/excel/SAP_OrderToCash_Extended.xlsx
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_OrderToCash_Extended.xlsx SAP_OrderToCash_Extended.xlsx]
** SAP_OrderToCash_v2.xlsx: http://files.qpr.com/releases/PASampleFiles/excel/SAP_OrderToCash_v2.xlsx
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_OrderToCash_v2.xlsx SAP_OrderToCash_v2.xlsx]
** SAP_PurchaseToPay.xlsx: http://files.qpr.com/releases/PASampleFiles/excel/SAP_PurchaseToPay.xlsx
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_PurchaseToPay.xlsx SAP_PurchaseToPay.xlsx]
** SAP_PurchaseToPay_v2.xlsx: http://files.qpr.com/releases/PASampleFiles/excel/SAP_PurchaseToPay_v2.xlsx
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_PurchaseToPay_v2.xlsx SAP_PurchaseToPay_v2.xlsx]
** ServiceNow_IncidentManagement.xlsx: http://files.qpr.com/releases/PASampleFiles/excel/ServiceNow_IncidentManagement.xlsx
** [http://files.qpr.com/releases/PASampleFiles/excel/ServiceNow_IncidentManagement.xlsx ServiceNow_IncidentManagement.xlsx]
** ServiceTicket.xlsx: http://files.qpr.com/releases/PASampleFiles/excel/ServiceTicket.xlsx
** [http://files.qpr.com/releases/PASampleFiles/excel/ServiceTicket.xlsx ServiceTicket.xlsx]




Line 82: Line 82:
#Click '''Import'''.
#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'''.
== Creating Model from CVS Sample Files ==
#To load events to QPR ProcessAnalyzer, select the worksheet that contains Event Data.
#On the QPR tab, select '''Project Workspace''' and create then an empty model.
#Click the '''Properties...''' button and add the following code in the '''Configuration''' section:
<pre>
{
    "DataSource": {
        "Cases":
{   
    "DataSourceType": "odbc",
    "OdbcConnectionString": "Driver={Microsoft Access Text Driver (*.txt, *.csv)};DefaultDir=C:\\TestDataSampleFiles\\;Extensions=asc,csv,tab,txt",
    "OdbcQuery": "SELECT * FROM [ServiceTicket_CaseAttributes.csv]",
    "Columns": {
    "CaseId": "Name"
}
            }
,
        "Events":
    {
    "DataSourceType": "odbc",
    "OdbcConnectionString": "Driver={Microsoft Access Text Driver (*.txt, *.csv)};DefaultDir=C:\\TestDataSampleFiles\\;Extensions=asc,csv,tab,txt",
    "OdbcQuery": "SELECT * FROM [ServiceTicket_Events.csv]",
    "Columns":  {
    "CaseId": "CaseId",
    "EventType": "Activity",
    "Timestamp": "Time"
        }
    }
    }
}
</pre>

Revision as of 13:09, 30 October 2019

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

Accessing 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.