Skip to main content
Participant
April 11, 2006
Question

Outputting quiz results to E-mail / Excel

  • April 11, 2006
  • 3 replies
  • 2640 views
Hi everyone,

I am a multimedia computing student currently on placement at an organisation. I am designing an e-learning package at the moment and am fairly new to Captivate. I have designed a package which consists of 6 question slides. I have set the project to send the results of the quiz to my work's e-mail address. I'm trying to find out if there is a way of getting Captivate to directly output the results to an Excel document. I have read numerous articles on this site regarding outputting the results to an Access database and would use this method, although my workplace unfortunately does not have ColdFusion. I have also read the article regarding manually importing the results from the e-mail into Excel, but have been asked by my supervisor to see if there is way for Captivate to automate this process. If you guys can help in any way, it would be greatly appreciated.

The organisation does not currently have a LMS either, so I can't even output the results to that. On top of that, they want me to find a way of identifying when somebody has been through the appication, but without a LMS I guess Captivate is unable to do that. If you can let me know whether this is true too, that would be brilliant!

Many thanks in advance for your help guys.
This topic has been closed for replies.

3 replies

Known Participant
April 26, 2006
If you are looking for a low cost LMS Breeze is actually not too bad. We have recently started using a hosted version of the LMS for about £10,000 - 12,000 (roughly coverted from AUD) with an ongoing yearly fee of about half that.

It worked for us, and at least gives you another option to consider.
Inspiring
April 12, 2006
Would your office, department, and/or township be willing to look at an
LMS? There are a few free and low-cost LMS products out there...

Gaftop's solution is decent but shouldn't be limited to ASP.
Since Captivate can run javascript functions that are present in the
parent HTML page, just make calls to that JS, which then posts to
whatever backend page you have setup to receive that POST (ASP, PHP,
etc). Then have the backend page update the database.

This does, of course, require some sort of web server.
Erik




jostler wrote:
> Hi everyone,
>
> I am a multimedia computing student currently on placement with the police. I
> am designing an e-learning package at the moment and am fairly new to
> Captivate. I have designed a package which consists of 6 question slides. I
> have set the project to send the results of the quiz to my work's e-mail
> address. I'm trying to find out if there is a way of getting Captivate to
> directly output the results to an Excel document. I have read numerous
> articles on this site regarding outputting the results to an Access database
> and would use this method, although my workplace unfortunately does not have
> ColdFusion. I have also read the article regarding manually importing the
> results from the e-mail into Excel, but have been asked by my supervisor to see
> if there is way for Captivate to automate this process. If you guys can help
> in any way, it would be greatly appreciated.
>
> The police don't currently have a LMS either, so I can't even output the
> results to that. On top of that, they want me to find a way of identifying
> when somebody has been through the appication, but without a LMS I guess
> Captivate is unable to do that. If you can let me know whether this is true
> too, that would be brilliant!
>
> Many thanks in advance for your help guys.
>
> It's really good to find other people whom are experiencing similar problems
> to talk to. The head multimedia designers at work are absolutely useless!
>
> :-)
>

--
Erik Lord
http://www.capemedia.net
Adobe Community Expert - Authorware
http://www.macromedia.com/support/forums/team_macromedia/
------------------------------------------------------------------------
http://www.awaretips.net - samples, tips, products, faqs, and links!
*Search the A'ware newsgroup archives*
http://groups.google.com/groups?q=macromedia.authorware
Participant
April 12, 2006
Thanks for all the help!

My department are looking into something called 'OnDemand' - not heard too much about it though. We would love to have Macromedia Breeze - it would solve a whole lot of problems, but I hear it costs about £40,000 and unfortunately the organisation does not have that much money to spend on an LMS.
April 11, 2006
Is the Captivate movie on a server?

If so and the server supports ASP, then you can write to a text file using the FileSystemObject commands.

Gaftop
Participant
April 11, 2006
The file does not currently sit on the server, but it will do in due course. I know how to program in XHTML and CSS but I have yet to learn ASP. It is quite a straight forward ASP command to create, or is there any alternate way around it?

Thanks for your help so far by the way gaftop.