Totara Learn Open Discussions

SCORM time reporting

 
Rebecca Fraser
SCORM time reporting
על ידי Rebecca Fraser בתאריך 13/05/2021, 18:00
 

Hi all, 

We are running the SCORM time report but the time is coming through in a very weird way. As an example, for someone that probably spent 38 minutes in a course, it is reporting as 38:00:00:00.

When this is exported as an excel or CSV it changes the data format to date and when I change this back to numerical, it is a different time because of the fact excel and CSV were seeing it as a date. 

Is this what anyone else is seeing in this report or is the field format in our tables possible incorrect?

Craig Eves
Re: SCORM time reporting
על ידי Craig Eves (Totara Support) בתאריך 13/05/2021, 21:09
קבוצה Totara

Hi Rebecca

When I export the SCORM report from the report builder as Excel the time is recognised as time format - using the latest Excel version.

Are you able to change the format of the column to this format?




Regards


Andrew Metcalfe
Re: SCORM time reporting
על ידי Andrew Metcalfe בתאריך 15/09/2022, 17:41
קבוצה Most Helpful Contributor 2022

SCO Total time appears to report (in text form) whatever the SCO returned to the LMS. 

I have an interesting issue here with a mixture of SCORM1.2 and SCORM2004 SCO's built with Articulate, and Articulate appear to have botched the time reporting for SCORM2004 format, making it unnecessarily difficult to parse. For non-standard formats, fixed-width is simple to parse with conventional tools such as Excel.

Eg these are all scorm total time straight from Totara (SCORM2004 from Articulate Storyline)
PT34.93S (in my opinion should read PT00H00M34.93S)

PT6.78S (in my opinion should read PT00H00M06.78S)

PT8M (in my opinion should read PT00H08M00.00S)

PT1H30.92S (in my opinion should read PT01H00M30.92S)

(EDIT: Alternatively, as the quantity of this field is known (elapsed time), Articulate - why not just report in hh:mm:ss.0, making it compatible with other versions, particularly in mixed reports?)

If anyone has excel formula/VBA/other code to reliably decode SCORM2004 time formats, I'd really appreciate a copy! Thanks

Regards, Andrew