Data hub experts... Help me find a way!
Hello community people,
We have developers here that are using mainly SCORM/xAPI objects to develop content. They have asked for a report that could show when each object in each course has been updated last.
I can find the objects in the ScormObjects dataset. This dataset gives me these columns:
ScormObjects |
|---|
ScormObjectId |
OrgUnitId |
ContentObjectId |
ContentServiceContentId |
ContentServiceRevisionId |
ContentServiceTopicId |
Title |
Description |
LearningStandard |
LastModified |
LastModifiedBy |
With this they can now that ActivityX (Title) has been created in CourseY (OrgUnitId) on Date (LastModified), by Person (LastModifiedBy). The challenge with this is that the same title is often used in multiple courses, so it requires a lot of filtering to get to a result that is still pretty messy. The Dev team has told me that when they upload the objects, they have to use a .zip file and they'd rather have a report that shows when the files have been last uploaded.
I can find that information about the uploads in the MediaObjects dataset, which gives me these columns:
MediaObjects |
|---|
ContentId |
Title |
RevisionCount |
OwnerId |
LastModified |
With that they can know that file12345.zip (Title) has been updated 5 times (RevisionCount), and the last revision was on this date (LastModified). My challenge is that I can't seem to find a way to find a link between both datasets to be able to produce a report that would show when a file was uploaded and which object in which course was created with what file, i.e. file12345.zip created ActivityX. In the ScormObjects dataset, title is the title given to the activity in the course and in MediaObjects it's the name of the file. I initially hoped that ScormObjectId from ScormObjects would be the same as ContentId from MediaObjects but it's not.
I went through a lot of the data hub documentation looking at multiple database schemas, but I can't seem to find away to link those two pieces of information. I am hoping someone here is smarter than I am! 😀 I mean, I know a lot of people are probably smarter than I am, I just hope they will read this post and have an answer! 😉 If you took the time to read this, I thank you!
Have an excellent day.
Mike
Best Answer
-
@Michel.M.597 Hi Mike! Try joining on MediaObjects.ContentId and SCORMObjects.ContentServiceContentId as well as SCORMObjects.ContentObjectId and ContentObjects.ContentObjectId
This will give you all three titles:
- MediaObjects.Title is what the owner of the object can see in their Media Library
- ContentObjects.Title is what is displayed as the Content topic title in the course
- SCORMObjects.Title is the name of the SCORM package when it was created (not sure if you can see this in the Media Library or within a course though)
Answers
-
Dear @Jennifer.W.973 you are a genius!
Well, also I am pretty dumb, because the first thing I did when I downloaded the ScormObjects data last week was remove a few columns, including the ContentServiceContentId one because I thought they wouldn't be useful for the first report (and they weren't).
When I was asked for the second option, I didn't think of redownloading a complete file, so I was working with a file with this missing column, so I couldn't complete that step!
Many thanks! ❤️
Mike