auto_scoring
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
auto_scoring [2022/01/25 14:46] yves |
auto_scoring [2022/01/25 14:52] (current) yves |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== Retrieving scoring results (automation) ===== | ===== Retrieving scoring results (automation) ===== | ||
| - | For data wrangling purposes, it is useful to automate the retrieve of a training session's scoring result. | + | For [[https://en.wikipedia.org/wiki/Data_wrangling|data wrangling purposes]], it is useful to automate the retrieve of a training session's scoring result. |
| + | {{ :ctrl2_auto_scoring10.png?nolink&600 |}} | ||
| The formal syntax is: | The formal syntax is: | ||
| - | ''https://server/pma.control/Training/UserScoreReportExcel/{TRAINING_SESSION_ID}/type={REPORT_TYPE}'' | + | ''https://server/pma.control/Training/UserScoreReportExcel/{TRAINING_SESSION_ID}/type={REPORT_TYPE}&sessionID={PMA_CORE_SESSION_ID}'' |
| For convenient parsing, we recommend setting REPORT_TYPE to 2 (CSV, computer-readable, de-normalized). | For convenient parsing, we recommend setting REPORT_TYPE to 2 (CSV, computer-readable, de-normalized). | ||
| - | Note that the above URL cannot be invoked automatically from within any programming environment. PHP's ''get_file_contents()'' method e.g. does not work. | + | Note that the above URL cannot be invoked automatically from within any programming environment. [[https://www.php.net/manual/en/function.file-get-contents|PHP's file_get_contents() method]] e.g. does not work. |
| - | The call requires cookie to authenticate properly, because it is a view controller. The php function ''file_get_contents'' does not use cookies as the server requests so the call fails. It only works if you have cookies set correctly in the browser via another tab or previous login to the pma.control. | + | The call requires cookie to authenticate properly, because it is a view controller. The php function ''file_get_contents()'' does not use cookies as the server requests so the call fails. It only works if you have cookies set correctly in the browser via another tab or previous login to the pma.control. |
| For this to work properly via php you have to use cUrl with cookies enabled: | For this to work properly via php you have to use cUrl with cookies enabled: | ||
| - | ''<?php | + | <code php> |
| + | <?php | ||
| function file_get_contents_curl($url) { | function file_get_contents_curl($url) { | ||
| $ckfile = tempnam ("/tmp", "CURLCOOKIE"); | $ckfile = tempnam ("/tmp", "CURLCOOKIE"); | ||
| Line 41: | Line 43: | ||
| $trainingsession = 66 | $trainingsession = 66 | ||
| - | $url = "https://host.pathomation.com/pma.control.2/Training/UserScoreReportExcel/".$trainingsession."?type=2&delimiter=%2C&decimalSeperator=.&sessionId=".$sessionID; | + | $url = "https://server/pma.control/Training/UserScoreReportExcel/".$trainingsession."?type=2&delimiter=%2C&decimalSeperator=.&sessionId=".$sessionID; |
| // retrieve data | // retrieve data | ||
| $tsData = file_get_contents_curl($url); | $tsData = file_get_contents_curl($url); | ||
| } | } | ||
| - | ?>'' | + | ?> |
| + | </code> | ||
auto_scoring.1643111204.txt.gz · Last modified: 2022/01/25 14:46 by yves
Page Tools
