Hi there,

We are looking into tracking SCORM results back to a users courses records (In the admin view) to be included as the course total score when only an elearning piece is involved in the training.

So far I have this in relation to figuring out where the SCORM data is store and how it is used in the DB:

They are stored in a blob field as a whole lot of XML. I can see it via the database but it
looks as though docebo isn't reading it.. it basically has to parse the XML
in the page to return the interactions in a table format.

it looks like the docebo code is looking for data type tags of 

description/text
type/text
result/text
id/text

but ive checked the code for two courses (Cad & CommInsure) and the
interaction data is being logged as

<interactions index="7" item="no">
<id item="yes" LMSMandatory="no" DataType="CMIIdentifier"
SCOAccessibility="writeonly" isset="1">Q10/42</id>
<type item="yes" LMSMandatory="no" DataType="CMIVocabulary"
DataSubtype="Interaction" SCOAccessibility="writeonly"
isset="1">choice</type>
<student_response item="yes" LMSMandatory="no" DataType="CMIFeedback"
SCOAccessibility="writeonly" isset="1">2</student_response>
<result item="yes" LMSMandatory="no" DataType="CMIVocabulary"
DataSubtype="Result" SCOAccessibility="writeonly" isset="1">wrong</result>
</interactions>


I've found that if I change the code to replace "description" with
"student_response" it displays the interactions within the page... 

Not sure if this would be a bug in the Docebo code?, just a SCORM Thing? Or
something our content is doing? 


Are you able to HELP????? 

Hi, i am having the same problem.
I know that they are stored in a blob field as a whole lot of XML. I can see it via the database but it
looks as though docebo isn't reading it...
I add a echo $doc->saveXML(); to the docebo\doceboLms\modules\organization\orgresults.php

 Then i can see the information. 

This is one interactions in at the xmldata in learning_scorm_tracking database:

<interactions index="0" item="no">
<type item="yes" LMSMandatory="yes" DataType="state" DataSubtype="interaction_type" SCOAccessibility="readwrite" isset="1">choice</type>
<objectives index="0" item="no"/><correct_responses index="0" item="no"><pattern item="yes" LMSMandatory="yes" DataType="long_identifier_type" SCOAccessibility="readwrite" isset="1">c</pattern></correct_responses><weighting item="yes" LMSMandatory="yes" DataType="real10_7" SCOAccessibility="readwrite" isset="1">1</weighting><learner_response item="yes" LMSMandatory="yes" DataType="characterstring" SCOAccessibility="readwrite" isset="1">c</learner_response><result item="yes" LMSMandatory="yes" DataType="real10_7,state" DataSubtype="interaction_result" SCOAccessibility="readwrite" isset="1">correct</result><latency item="yes" LMSMandatory="yes" DataType="timeinterval" DataSubtype="second,10,2" SCOAccessibility="readwrite" isset="1">PT00H00M07S</latency><description item="yes" LMSMandatory="yes" DataType="localized_string_type" SCOAccessibility="readwrite" DataSubtype="4000" isset="1">undefined</description></interactions>

any help would be nice!!!

Regards,
Madeleine

Hi!
I don´t know if it will be helpful, but I´ve developed a simple Php Script that tracks the Scorm interactions and Polls from the DB and  then shows the results on a table format, as you can see in the attached image. From it, you can analyze your user results.

If you´re interested on it, write me your e-mail and I´ll send it to you.

Regards
Rubén García