If a quiz contains a double-quote (“) character in the quiz question text, any of the answers, or the fill-in-the-blank answers, it breaks LMS reporting.
Has anyone else solved this problem?
If a quiz contains a double-quote (“) character in the quiz question text, any of the answers, or the fill-in-the-blank answers, it breaks LMS reporting.
We are using SuccessFactors and Adobe Captivate 2019. But this has been a problem for as long as I remember. Our only solution has so far been to tell people not to use double-quotes, but instead use single-quotes which don’t cause the same problem.
How I understand the problem is, the LMS outputs exam details using quote-delimited CSV. But there are so many transforms and escaping of characters between systesm (Captivate to SuccessFactors to Tableau) that somewhere along the line it just can’t handle it, and it shifts the field over one–which results in a broken report for no apparent reason that takes days to figure out what happened.
Painful. It would be nice if there was a way to sanitize the inputs so that we can prevent special characters from being input (including double-quotes).
I had this problem in Moodle, I couldn’t find a solution either. I had to remove the double quotes (“) and replace them with the single ones (‘).
You must be logged in to post a comment.
