Forum Discussion
Totara SCO total time
Hi all,
We are using Totara v12, and we have a report that shows SCO total time which is super helpful. Most of the records are displaying correctly like 00:08:36.12 meaning the user spent 8 mins ...
Alyssa, thank you very much, I'll try the excel method asap.
I ended up exporting the mixed report (SCORM1.2 and SCORM2004 format) and processed it with a Python script using regex. If anyone's interested in the regex I used, here they are, one for each SCORM type in my report. The SCORM2004 definition allows for crazy data however the regex is simplified due to Articulate's good sense in using it.
SCORM2004 format issued by articulate
r'P(?:(?P<days>(?:\d+D))?T(?P<hrs>(?:\d+H))?(?P<mins>(?:\d+M))?(?P<secs>(?:\d+(?:\.\d{1,2})?S)?))?'
scorm1.2 format issued by articulate
r'(?:(?P<hrs>(?:\d{2})):(?P<mins>(?:\d{2})):(?P<secs>(?:\d{2}\.\d{2})))'
hrs/mins/secs can then be processed into total seconds or whatever.
Thank you Alyssa!
