Webmaster Forum / Flash / Data Integration / October 2006

My department is working on setting up a Learning Management System (LMS) but
at this time we are not ready to do so. Unfortunately, other departments are
looking to publish courses with tracking and authentication and, having no LMS
to link them too, we?re having obvious problems imposing standards on the
upcoming courses aside from telling them to keep it SCORM compliant.

In order to create an interim solution this problem, I am hoping to utilize
the Flash quiz templates using the ?Flash with SCORM tracking? publishing
option to send the information from the quizzes to a SCORM compliant MSSQL
database. From what I understand the ?SCORM tracking? publishing option tells
the movie to look for a LMS connection and then pass along its information to
it (more or less). In summary, my goals are to:

1.    Set up a SCORM compliant MSSQL database
2.    Write or integrate an interface that will act like an LMS handshake with
the Flash movie and accept the data from it for storage in the database
3.    Hook the front end of the system up to our HR LDAP for authentication

This would give us in essence a ?lite? LMS that should hold us over until we
purchase an enterprise system and have the added benefit of setting a standard
for other departments to conform too. My current problems are that I?m still
looking for a MSSQL schema that will work for my purposes and I don?t really
know where to start with the Flash ?SCORM tracking? to database interface.
Authentication I don?t foresee as being a problem at this point. We have
primarily a Java based environment here so most of the open source LMS systems
I?ve researched are unusable (Moodle, etc).

If anyone has any suggestion on how I should proceed at this point I?d very
much appreciate it. Also, if anyone is doing freelance/contracting/consulting
in the NYC metro area and has the know-how to solve this problem please let me
know.