Forum .LRN Q&A: LORS Management available on CVS

Collapse
Posted by Ernie Ghiglione on
Everyone,

Thanks to Jeff Davis, I have added all LORS Management packages to CVS.

You will need the four packages to install it in .LRN. In addition, make sure that you have file-storage version *5.1*, as otherwise you'll get a bunch of errors.

LORS

    cvs -z3 -d :pserver:mailto:anonymous@openacs.org:/cvsroot co openacs-4/packages/lors

LORS Management

    cvs -z3 -d :pserver:mailto:anonymous@openacs.org:/cvsroot co openacs-4/packages/lorsm

LORS Management Portlet

    cvs -z3 -d :pserver:mailto:anonymous@openacs.org:/cvsroot \
    co openacs-4/packages/lorsm-portlet

LORS Management Applet

    cvs -z3 -d :pserver:mailto:anonymous@openacs.org:/cvsroot \
    co openacs-4/packages/dotlrn-lorsm

Once you got the packages, from the package management page, install the LORS Management Applet (dotlrn-lorsm) and that should take care of installing all the dependent packages in their correspondent places.

Reinitiate your site, go to you class admin page, add the Applet, and voila.. it's all there 😉

Hopefully, very shortly we will have a bug tracker set up to report bugs and potential features.

Thanks,

Ernie

Collapse
Posted by Orzenil Silva Junior on
Olá Ernie,

Great work! I was very anxious for this news.

I followed your instructions here and update file-storage to 5.1 on my 2.0.3 dotlrn installation. All packages for LORS management installs ok. No problem, no pain.

But I fall into trouble when I activated applet for a dotlrn class. I had the following error:
------------

You have found a bug in our code.

Please notify the webmaster and include the following text. Thank You.

*** portal::evaluate_element callback Error! ***

Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  No such attribute cp.course_name

SQL:
    select
          cp.man_id,
          cp.course_name,
          cp.identifier,
          cp.version,
    text '[view]' as course_structure,
          case
              when hasmetadata = 't' then 'Yes'
              else 'No'
          end as hasmetadata,
          case
              when isscorm = 't' then 'Yes'
              else 'No'
          end as isscorm,
          cp.fs_package_id,
          cp.folder_id,
      acs.creation_user,
      acs.creation_date,
      acs.context_id
    from
          ims_cp_manifests cp, acs_objects acs
    where
          cp.man_id = acs.object_id
    and
          acs.context_id = '2472'

-------

I see at database schema and ims_cp_manifest table is there but there is not a course_name atribute in it.

Thanks

Orzenil

Collapse
Posted by Ernie Ghiglione on
Bom dia Orzenil,

Como vai?

the ims_cp_manifest table must have a course_name column. Can you do the following for me?

$ psql your-database-name

your-database-name# \d ims_cp_manifests

that should give you a list of all the columns on this table. If for some reason it doesn't look like this:
          Table "public.ims_cp_manifests"
    Column    |          Type          | Modifiers
---------------+-------------------------+-----------
man_id        | integer                | not null
course_name  | character varying(1000) |
identifier    | character varying(1000) |
version      | character varying(100)  |
orgs_default  | character varying(100)  |
hasmetadata  | boolean                |
parent_man_id | integer                |
isscorm      | boolean                |
folder_id    | integer                |
fs_package_id | integer                |

Then, I think we might have had a problem while installing. What version of postgres are you using?

Thanks,

Ernie