Scorm File Upload problem [V2.6.2]

Scorm File Upload problem [V2.6.2]

Hugh Edwards -
回帖数：2

Hi All, 

I have a problem which I hope someone can help me with. With luck there is a solution!

I created my Scorm 1.2 course in Articulate and all was well. I had 3 PDF's which the users could download in the Resources section of the Scorm Player. Unfortunately, and unbeknown to me, the PDF's were in directories that were greater in length than Microsoft Windows can handle, and so on export the external_files directory was empty. 

This is resulting in 404 errors on the course when the users try and download them, as they aren't on the server, and so I suspect haven't been included in mdl_files. 

I don't want to re-export and re-upload the course again, as I suspect that this will reset all the user's attempt tracking for the course, and it's live to quite a lot of users. 

The path that the document is looking for (in the URL) is:

../pluginfile.php/3001/mod_scorm/content/1/story_content/external_files/Warming%20up%20and%20Microphone%20Technique.pdf

...is there anyway to manually enter this into the mdl_file table so that it will find the right files, and indeed, where will I need to upload that to?

...if not, will updating my Scorm course to the new version reset users scorm attemts and therefore their progress?

Fingers crossed! : )

Hugh. 

平均分： -
回复Hugh Edwards

Re: Scorm File Upload problem [V2.6.2]

Matteo Scaramuccia -

Hi Hugh,
it's quite difficult - not impossible* - to add all the required columns values by hand, it's better to update the package.

If you don't change the identifier of the items in the manifest file, the tracking data will be preserved: parked during the unzipping and then restored. Deletion will happen for those items whose identifier is no more present in the "new" version of the package, to avoid orphan tracking data.
You can test it by your own, by publishing the broken package in a new private course, attend to it to register some known tracking data and then updating that SCORM activity in the private course with the fixed package. Looking at what happened to your tracking data will give you the answer.

Remember to hide/close the Activity/Course during the update to avoid your users to start a tracking session during your update (MDL-40001).

HTH,
Matteo

* You could first look at the mdl_files table to see if they are already recorded in the DB and then lookup/re-create the related physical file through its contenthash: details about the File API internals here, http://docs.moodle.org/dev/File_API_internals#File_storage_on_disk.

平均分： -
回复Matteo Scaramuccia

Re: Scorm File Upload problem [V2.6.2]

Hugh Edwards -

Hi Matteo, 

The solution of creating a test course and trying it out worked well and is now implemented. Thanks for your help. 

Hugh. 

平均分： -