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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 18 2025 19:23:17
Script start
Timing: Jan 18 2025 19:23:17
Module start 'layout'
Timing: Jan 18 2025 19:23:17
Module start 'content'
Timing: Jan 18 2025 19:23:18
Module end 'content'
Timing: Jan 18 2025 19:23:18
Script end

Main resources:

Total runtime0.8726 sec
Peak memory usage4,096.0000 KB
Database Queries73

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0059 589.6172152.6563
Module start 'layout' 0.00590.0027 742.273439.5078
Module start 'content' 0.00860.8623 781.7813655.4453
Module end 'content' 0.87090.0017 1,437.226616.0938
Script end 0.8726  1,453.3203 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00320.3632160.0002
Check MTime0.00130.1510160.0001
Mysql Total
Database connection0.00110.130510.0011
Mysqli_queries0.802891.9940730.0110
Looping result0.00080.0876710.0000
Template Total0.834595.620.4173
Template load0.00210.237320.0010
Template processing0.832495.392620.4162
Template load and register function0.00030.033210.0003
states
state_id_array0.00150.177510.0015
state_identifier_array0.00170.189720.0008
Override
Cache load0.00180.2046480.0000
Sytem overhead
Fetch class attribute can translate value0.00100.113640.0002
Fetch class attribute name0.00110.122690.0001
XML
Image XML parsing0.00130.151040.0003
class_abstraction
Instantiating content class attribute0.00000.001690.0000
General
dbfile0.00120.1414220.0001
String conversion0.00000.000840.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
7content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
9content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
3content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 23
 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs