Course Navigation link tracking

[WillGHampton]

Greetings,

My goal is to track LTI use by using a simple proxy of if the Course Navigation link is enabled. The particular LTI tool I am most interested in tracking(Kaltura LTI 1.1) can be used for assignments, though the vast majority of this LTI use is through the Kaltura LTI 1.1 My Media and Media Gallery course Navigation links.

Are there any tables in CD2 that track what Course Navigation links are active in a course? As in enabled by the instructor in course settings.

Analytics that track Course Navigation links that are active in a course would also be helpful.

Thank you

Will Hampton

[WillGHampton]

The CD2 Entity Relationship Diagram shows several tables related to LTI line items. My investigation of these tables seems to show that I can track LTI assignments with the lti_line_items and lti_resource_links but not course navigation links.

If lti_resource_links.context_type = Assignment  is the row possibly a Course Navigation or Link Selection LTI type?

[dtod · Accepted solution]

I think you're looking for courses.tab_configuration which is JSON. Active tabs are generally either

"hidden": false

or don't have a "hidden" attribute.

The following isn't exact, since it was from parsing a json file that contained the tab_configuration json and the course code, but it's in the ballpark for logic (using jq on linux):

jq  '.[] | .value.course_code as $code | select (.value.tab_configuration != []) | .value.tab_configuration[] | select
(.hidden == null or .hidden==false) | select (.id | tostring | contains("external_tool_2753")) | $code'

 The json I was parsing looked like this. "hidden": true ones are not visible in the course menu.

[
  {
    "value": {
      "course_code": "VW286.OCD.FA23SU24.WRKS",
      "tab_configuration": [
        {
          "id": 0
        },
        {
          "id": 14
        },
        {
          "id": 10
        },
        {
          "id": 8
        },
        {
          "id": 5
        },
        {
          "id": "context_external_tool_9"
        },
        {
          "id": "context_external_tool_41282"
        },
        {
          "id": "context_external_tool_55818"
        },
        {
          "id": "context_external_tool_65483"
        },
        {
          "id": "context_external_tool_92481"
        },
        {
          "id": "context_external_tool_1768"
        },
        {
          "id": "context_external_tool_8537",
          "hidden": true
        },
        {
          "id": "context_external_tool_83014",
          "hidden": true
        },
etc. etc.

[WillGHampton]

Thank you! This is exactly what I was looking for.