When we are trying to import a SCORM content, the import might fail and give us the error message, "An error was detected: getzipFile(filename,uploadID,addXMLFilesOnly) error occured while retrieving the file from db".
LMS with iContent
Reproducing the Issue
LMS->Admin->Content->Tools->Import Content->Add New Content->Any SCORM content
The issue might be with with the "imsmanifest.xml" file present inside the zip(content) file. There is a parameter call "lom" in the manifest file and if we remove all the occurrence of the lom data, zip the content, and try to upload, it should work fine.
Steps to follow:
1) Extract the zip file, open the imsmanifest.xml and find "<lom" and remove all the values till "</lom>" and save the file.
2) Zip the content again(not the folder but the contents in it, ie., if you open the zip file it should contain all the files in it and not just a folder which contains the files and folders inside of it, it should have the folder and file structure just like your original content file, please refer that structure). Also, this solution is not for all the contents that you upload to the LMS system but only with the ones with which you are facing the issues and this will not affect the behaviour of the content in any way.
getzipFile, getzipFile(filename,uploadID,addXMLFilesOnly), SCORM import failed, Content import failed, SCORM , KBA , LOD-SF-LMS-CNT , Content , Problem