Register for our next webinar, 5 Keys to Unlock Storytelling in Your eLearning, where you'll learn how to unlock the magic of storytelling in your eLearning development to increase learner engagement and retention! Join Andrew Townsend, our Campaign Marketing Manager, on Thursday, December 3, 2020 at 11:00 AM MDT.

Be The First On Your Block to Rock Lectora® 21!


Apply for exclusive early access to the latest version of Lectora® Desktop v21. Seating is limited so make sure you apply now!

Exporting Lectora test results to Access

adm-developeradm-developer Community Member Posts: 2
There have been some postings about this topic, but I haven't seen any recent post. Maybe there are some new interventions!



I'm currently using a Moss 2007 SharePoint team site to conduct "end of training" surveys, using the SharePoint survey feature, which doesn't provide the level of test analysis I need. I've created 6 tests in Lectora to replace the SharePoint survey. I would like to be able to export the Lectora test results to a database that I can query to provide reports with the following information for each test:

-Employee ID

-Location

-Incorrect/correct responses

-Comparison of one location to another

-Question trend analysis

-Pass/Fail

The majority of the questions are closed-ended, but there are a few open-ended questions as well.



My current audience is less than 50 people in six locations spread across North America. The next phase of the rollout will involve hundreds of people in more than 50 locations. We are installing a delivery center application that will allow us to deliver almost any content to any location without being concerned about speed or bandwidth.



I will ultimately being looking at using a SQL Server for this, but for now I need to build a proof of concept before I can get funding and resources to create an SQL server site. I've also looked at some of the SharePoint LMS plug-in options, but the company is in the middle of heavy conversations with an LMS vendor. I'm hoping to preview this process in Access on a small scale and then replicate the process in an SQL server. If anyone has an example of sample AccessDB connections strings they could share, it would be great.



Thanks,

Dennis

Comments

  • rvjrvj Community Member Posts: 27
    Hello. I am new to lectora and even programming. I have the same problem and the same issue. I too want to integrate my lectora values to sql server 2008. I want to store values of test question id, answer, and results. I guess you must have solved it. Can you please help me too/?

    Thank you.
Sign In or Register to comment.

So You Wanna Be An eLearning ROCKSTAR?

We're all fans of eLearning here! Want to become an eLearning ROCKSTAR? Just click on one of the buttons below to start your rocking journey!

Be The First On Your Block to Rock Lectora® 21!


Apply for exclusive early access to the latest version of Lectora® Desktop v21. Seating is limited so make sure you apply now!