Sample Eventlog Files: Difference between revisions

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




* CVS sample files:  
* CSV sample files:  
** Dynamics_OrderToCash_Events.csv: http://files.qpr.com/releases/PASampleFiles/csv/Dynamics_OrderToCash_Events.csv  
** Dynamics_OrderToCash_Events.csv: http://files.qpr.com/releases/PASampleFiles/csv/Dynamics_OrderToCash_Events.csv  
** Dynamics_OrderToCash_CaseAttributes.csv: http://files.qpr.com/releases/PASampleFiles/csv/Dynamics_OrderToCash_CaseAttributes.csv
** Dynamics_OrderToCash_CaseAttributes.csv: http://files.qpr.com/releases/PASampleFiles/csv/Dynamics_OrderToCash_CaseAttributes.csv

Revision as of 12:24, 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.

Creating Model from CVS Sample Files

  1. To load events to QPR ProcessAnalyzer, select the worksheet that contains Event Data.
  2. On the QPR tab, select Project Workspace and create then an empty model.
  3. Click the Properties... button and add the following code in the Configuration section:
 {
    "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"
        }
     }
    }
}
Retrieved from "https://wiki.onqpr.com/pa/index.php?title=Sample_Eventlog_Files&oldid=14415"