Skip to main content
B
Brock22
Known Participant
June 1, 2006
Question

Quiz email

  • June 1, 2006
  • 6 replies
  • 508 views
Is there a way for the email that you receive when people answer your quiz questions to be more legible. It is a pain to have to look through something like this to find a few simple answers:

Results=
Core Data
"Status","Location","Raw Score","Max Score","Min Score","Time"
"passed","40","0","0","0","00:01:24"

Interaction Data
"Date","Time","Interaction ID","Objective ID","Interaction Type","Correct Response","Student Response","Result","Weight","Latency"
"06/01/2006","14:00:14","Interaction13587_4","Quiz10022","likert","Poor","Poor","C","0","00:00:06"
"06/01/2006","14:00:14","Interaction13587_3","Quiz10022","likert","Adequate","Adequate","C","0","00:00:06"
"06/01/2006","14:00:14","Interaction13587_2","Quiz10022","likert","Good","Good","C","0","00:00:06"
"06/01/2006","14:00:14","Interaction13587_1","Quiz10022","likert","Very_Good","Very_Good","C","0","00:00:06"
"06/01/2006","14:00:14","Interaction13587_0","Quiz10022","likert","Excellent","Excellent","C","0","00:00:06"
"06/01/2006","14:00:21","Interaction13645_2","Quiz10022","likert","Adequate","Adequate","C","0","00:00:06"
"06/01/2006","14:00:21","Interaction13645_1","Quiz10022","likert","Very_Good","Very_Good","C","0","00:00:06"
"06/01/2006","14:00:21","Interaction13645_0","Quiz10022","likert","Good","Good","C","0","00:00:06"
"06/01/2006","14:00:31","Interaction13688","Quiz10022","long-fill-in","","Thank you for this training. It was great.","W","0","00:00:10"
"06/01/2006","14:00:56","Interaction13720","Quiz10022","long-fill-in","","Being able to take it when I want to take it.","W","0","00:00:24"
"06/01/2006","14:01:06","Interaction13752","Quiz10022","long-fill-in","","No interaction is disappointing.","W","0","00:00:10"

    This topic has been closed for replies.

    6 replies

    C
    Czajka
    Known Participant
    August 2, 2006
    When I try to use e-mail reporting, I get no content in the body of the e-mail, even when trying the samples from Adobe's site. Is there an issue with Flash 8 or running the tests locally?
    B
    Brock22Author
    Known Participant
    June 2, 2006
    When you say remove any surplus paragraph marks, you mean just manually deleting all of the excess stuff that isn't the actual quiz results? I can do that for sure if there aren't any fast options. I will be getting a LOT of quiz results back so a manual process like that would probably waste too much time. I may not have understood you though. I followed you on the MS word and Convert text to table part.
    A
    Anonymous
    June 3, 2006
    Hi Brock22,

    I would agree that this would be a time consuming method with LOTS of emails to process. I'm afraid I don't have a simple solution for you.

    If you have Ms Office Professional with Ms Access you could use Office Automation to open your emails in Ms Access, extract the Quiz Data using VBA code and then save it to an Ms Access table or an Excel spreadsheet.

    Here is a link to an article by Helen Feddena that may help you get started http://www.helenfeddema.com/Files/accarch15.zip

    hope this helps

    kind regards

    Malcolm
    A
    Anonymous
    June 2, 2006
    Hi Brock22,

    The Quiz Data seems to be in Comma Seperated Vale (CSV) format.

    You could copy the data set into Ms Word, remove any surplus paragraph marks, then use the menu option Convert Text to Table.

    That should give you a clean formatted table with your quiz results.

    hope this helps

    kind regards

    Malcolm
    B
    Brock22Author
    Known Participant
    June 1, 2006
    hmmmmmmm...okay...unfortunately, I don't know Javascript
    B
    Brock22Author
    Known Participant
    June 1, 2006
    hmmmmmmm...okay...unfortunately, I don't know Javascript
    A
    Anonymous
    June 1, 2006
    I used Javascript in the HTML page to parse the content of the body of the message into an array. Then I reconstructed the body of the message using only selected elements from the array.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices