Forum LAMS for Tech-Heads - General Forum: Migrating to moodle 2.0 and LAMS 2.3.5

Unfortunately we don't have an upgrade path for this. The new module you installed in Moodle 2 is a complete new re-write so it won't import your old stuff.

Also, the old LAMS module (for Moodle 1.8.x+) won't be able to be installed in Moodle 2.

So as of now you are better of creating new sequences in Moodle 2 again.

I haven't looked into this carefully, but there might be a chance to move the lessons manually on the database. But I'm really not sure.

We've been doing a lot of client work lately, so I haven't had much chance to look into this. As soon as some time, I'll look into upgrade options.

Thanks,

ernie

Posted by Ernie Ghiglione

Hi Amy, 

If you have a look at the data model in Moodle 1.x:

mysql> desc mdl_lamstwo_lesson;
+--------------+---------------------+------+-----+---------+----------------+
| Field        | Type                | Null | Key | Default | Extra          |
+--------------+---------------------+------+-----+---------+----------------+
| id           | bigint(10) unsigned | NO   | PRI | NULL    | auto_increment | 
| course       | bigint(10) unsigned | NO   | MUL | 0       |                | 
| lamstwo      | bigint(10) unsigned | NO   |     | 0       |                | 
| name         | varchar(255)        | NO   |     |         |                | 
| intro        | text                | NO   |     |         |                | 
| groupid      | bigint(20)          | YES  |     | 0       |                | 
| sequence_id  | bigint(20) unsigned | YES  |     | 0       |                | 
| lesson_id    | bigint(20) unsigned | YES  |     | 0       |                | 
| timemodified | bigint(10) unsigned | NO   |     | 0       |                | 
+--------------+---------------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)

and then in Moodle2:

+------------------+----------------------+------+-----+---------+----------------+
| Field            | Type                 | Null | Key | Default | Extra          |
+------------------+----------------------+------+-----+---------+----------------+
| id               | bigint(10) unsigned  | NO   | PRI | NULL    | auto_increment | 
| course           | bigint(10) unsigned  | NO   | MUL | 0       |                | 
| name             | varchar(255)         | NO   |     |         |                | 
| intro            | text                 | NO   |     |         |                | 
| introformat      | smallint(4) unsigned | NO   |     | 0       |                | 
| groupid          | bigint(20)           | YES  |     | 0       |                | 
| grade            | smallint(3)          | YES  |     | 0       |                | 
| sequence_id      | bigint(20) unsigned  | YES  |     | 0       |                | 
| lesson_id        | bigint(20) unsigned  | YES  |     | 0       |                | 
| timemodified     | bigint(10) unsigned  | NO   |     | 0       |                | 
| completionfinish | tinyint(1)           | NO   |     | 0       |                | 
| displaydesign    | tinyint(1)           | NO   |     | 0       |                | 
+------------------+----------------------+------+-----+---------+----------------+
12 rows in set (0.00 sec)

I think you could easily create a script that moves the data from one table to do the upgrade. 

Please email me if you need further help. 

Thanks,

Ernie

Posted by Ernie Ghiglione