If you need to make changes to settings for all your eLearning currently loaded in UniversitySite and you have access to SQL query analyzer you can make use of scripts, after dutifully backing up your database first, to adjust them very quickly.
– If you just want to update all your eLearning to playback at fullscreen run the following
UPDATE [ScormPackageProperties] SET [desired_fullscreen]= 1
–To Disable all your eLearning run the following:
update trainingcourses set disabled = 1 where ELearningContent = 0
–To adjust the maximum retakes allowed setting for eLearning run the following:
update trainingcourses set maxattempts = -1
– Options below (save New Window options) have a value that represents
–the order they appear in the drop down so if you want a different option check
– its order in the drop down field in eLearning settings
– SCO Launch Type = Frameset
UPDATE [ScormPackageProperties] SET [sco_launch_type]=1
– Player Launch Type = New window without browser toolbar
update [ScormPackageProperties] SET [player_launch_type]=4
– New Window Options = Specify New Window Dimensions
– When you need to specify new window dimensions you will want to update all of the following
update [ScormPackageProperties] SET [desired_fullscreen]= 0
update [ScormPackageProperties] SET [required_fullscreen] = 0
update [ScormPackageProperties] SET [desired_width] = 1024 –or whatever you need for the width
update [ScormPackageProperties] SET [desired_height] = 768 –or whatever you need for the height
–There are also required_width and required_height. Those are used if the content absolutely must have a
–window of at least those dimensions to work. These will cause a warning to pop up if your screen is not big enough.
– Width for display stage = 1024 pixels
update [ScormPackageProperties] SET [desired_width] = 1024
– Height for display stage = 768 pixels
update [ScormPackageProperties] SET [desired_height] = 768
– Course Structure Width = ###
update [ScormPackageProperties] SET [course_structure_width] =
– Structure Status Display = Completion Only
UPDATE [ScormPackageProperties] SET [status_display]=2
