Register

Database acces in vq

Questions regarding the authoring of Viewlets, installation or possible bugs with our products. For urgent issues, please use our support form on our website: http://www.qarbon.com/help/helpme.php
User
Posts: 5
Joined: Wed Sep 03, 2008 8:43 am

Database acces in vq

Postby jimmy » Wed Sep 03, 2008 8:48 am

Hi,

is it possible to access a database in viewletquiz which for example contains
the questions and answers?
Or can I direct the xml-output created by viewlet quiz into a database, for example
to log the responses the user gives?

kind regards, jimmy

Site Admin
User avatar
Posts: 1071
Joined: Fri May 26, 2006 3:15 pm
Location: San Jose, CA

Re: Database acces in vq

Postby James » Wed Sep 03, 2008 10:15 am

Jimmy,

You can redirect the XML data that is created by the Viewlet to your own server for processing.

Here is an existing forum posting on this

viewtopic.php?f=7&t=295

James

User
Posts: 5
Joined: Wed Sep 03, 2008 8:43 am

Re: Database acces in vq

Postby jimmy » Thu Sep 04, 2008 5:22 am

thanks a lot,

this seems to be a complicated task. is it possible to get support from qarbon in realizing it?
And do you maybe also have some information on how to redirect the xml-data into a database?

Or is there any way of a direct database access from within a viewlet without having to parse xml-data?

kind regards, jimmy

Site Admin
User avatar
Posts: 223
Joined: Fri May 26, 2006 1:51 pm
Location: Rochester, NY

Re: Database acces in vq

Postby Andrew » Thu Sep 04, 2008 8:01 am

Hi Jimmy,

There isn't really a way for the Viewlet to directly access a database. It must send XML to a back end process that then takes the XML and writes it to your database. Part of the reason its complicated is because the Viewlet will send XML after every question is answered, so that you can capture partial results.

The easiest solution is to sign up for a ViewletCentral account which will process all the reporting results for you. http://www.qarbon.com/presentation-soft ... etcentral/

A second alternative is to use email reporting. This will send the results of the tests to you via email.

The most flexible and complicated is the last approach of catching the XML sent from the Viewlet directly and processing it. For this you will need to a mini web application to process the XML and write it to your database. The example Java code in in this topic http://forum.qarbon.com/viewtopic.php?f=7&t=295 will help you there.

If you need custom programming work we could assign a developer to help you at an hourly rate.

Andrew Branch
Andrew Branch

User
Posts: 5
Joined: Wed Sep 03, 2008 8:43 am

Re: Database acces in vq

Postby jimmy » Wed Sep 10, 2008 4:01 am

thank you very much for your reply. we need to evaluate ths possibility and would certainly need
some support with this.

How would you assess the possibility to use reporting via the SCORM-interface?
Is it possible to plug a SCORM-Interface into a website and then to redirect the reporting results
form viewletquiz into a database?

Site Admin
User avatar
Posts: 223
Joined: Fri May 26, 2006 1:51 pm
Location: Rochester, NY

Re: Database acces in vq

Postby Andrew » Wed Sep 10, 2008 9:50 am

Yes you could publish to SCORM format and then write your own back end to fetch the SCORM results and then place in a database. This would basically be the same approach as catching the XML results as I mentioned above in this post: viewtopic.php?f=7&t=295, but they would now conform to the SCORM format.

You could also purchase or get an open source SCORM system (such as Moodle) to process the SCORM results. And avoid having to write any back end code at all.
Andrew Branch

Return to Discussions

Who is online

Users browsing this forum: No registered users and 1 guest