Forums / Developer / Creating and using custom tables to store and retrieve data

Creating and using custom tables to store and retrieve data

Author Message

Trond Åge Kvalø

Monday 16 February 2004 2:36:21 am

We're creating a Learning Management Server based on eZpublish 3.2-4.

The LMS will follow the SCORM standard as found on http://www.adlnet.org/

According to this standard we need to store variables with predefined variable names.

Would it be better/simpler to create our own tables to store the SCORM data, or could we just set up different classes in eZp to store these data? How would we go about if we were to store and retrieve data from custom database tables in eZpublish?

Trond Kvalo

trondåge

Trond Åge Kvalø

Tuesday 17 February 2004 3:22:16 am

Hi again!

I forgot to mention that the variables will be POSTed to eZpublish using macromedia Flash.

trondåge

trondåge

Eirik Alfstad Johansen

Tuesday 17 February 2004 7:00:12 am

Hi Trond,

I'll be happy to answer your question if you could tell me a little bit about the SCORM standard and its purpose. I had trouble locating any useful information for answering your question at the site you provided.

Sincerely,

Eirik Johansen

Sincerely,

Eirik Alfstad Johansen
http://www.netmaking.no/

Trond Åge Kvalø

Tuesday 17 February 2004 8:47:26 am

Hi Erik!

The Sharable Content Object Reference Model (SCORM) is a standard describing in detail how to build and deploy computer based training on a large scale.

The SCORM standard gives a detailed set of rules like variable naming, how the learning module shall communicate with the learning management server, what types of data should be stored etc. It consists of three rather heavy books: The Content Aggregation Model that tells how to build learning modules; The Run-Time Environment that lays out the communication between learning modules and the LMS, and tracking of user results; And Sequencing and Navigation that deals with how to navigate through the learning modules and in which order.

One of the purposes is to make buyers of e-learning independent of proprietary LMS-implementations. A SCORM conformant e-learning application should be able to run under any SCORM conformant LMS and vice versa.

We create our learning applications using Macromedia Flash, and most of the data will probably be transferred between frameworks, content and LMS using XML. SCORM dictates the data and variable names that we have to handle, but for instance we have the following data about a user:

cmi.learner_id string (4096)
cmi.learner_name string (255)
cmi.learner_preference.audio float(10,7)
cmi.learner_preference.language string (255)
cmi.learner_preference.speed float(10,7)
cmi.learner_preference.text (-1,0,1)

There are of course several other variables being registered but you get the picture I guess.

As I mentioned when we get to the real stuff we'll probably use XML to pass data around, but for now we would be incredibly happy if someone could guide us in how to store these variables if they were posted as plain text to a node in eZpublish.

Thanks in advance
trondåge

trondåge

Trond Åge Kvalø

Tuesday 17 February 2004 8:48:32 am

whoops, sorry I misspelled your name, Eirik!

trondåge

trondåge

Olivier GAUDE

Friday 28 January 2005 5:47:21 am

Hi Trond

i'm also looking to developp a scorm adaptation of ez publish. Can you tell me the progress you have done with this implementation ?

Bye

Olivier

Tore Jørgensen

Monday 31 January 2005 1:55:21 am

Hi! We did make a basic LMS about a year ago, and are now in the process of making an improved version. We chose to create our own tables and let a eZ module access them. Most of the SCORM stuff is done on the client side with a flash framework.
--
Tore
http://www.atlantia.no