General plugins

Hi,

This module had errors while loading into the databse. basically for the last 5 database Insert Into lines I had to add a '0',  right after the first ( on each line. Then the module installed properly.

Hope it works ok.

Thanks.

Hi,

The link to download "registration" seems to be broken.

Thanks!

Hi, Miroslav, I just installed the registration mod. However, when I tried to install the registration tables, the following program errors appear on the computer screen:

(mysql): INSERT INTO mdl_log_display VALUES ('registration', 'view', 'registration', 'name')  

---

1136: Column count doesn't match value count at row 1

Error

---

(mysql): INSERT INTO mdl_log_display VALUES ('registration', 'add', 'registration', 'name')  

---

1136: Column count doesn't match value count at row 1

Error

---

(mysql): INSERT INTO mdl_log_display VALUES ('registration', 'update', 'registration', 'name')  

---

1136: Column count doesn't match value count at row 1

Error

---

(mysql): INSERT INTO mdl_log_display VALUES ('registration', 'view submission', 'registration', 'name')  

---

1136: Column count doesn't match value count at row 1

Error

---

(mysql): INSERT INTO mdl_log_display VALUES ('registration', 'upload', 'registration', 'name')  

---

1136: Column count doesn't match value count at row 1

Error

registration tables could NOT be set up successfully!

Any ideas ?

TIA

Mónico

Has anyone tried using this module with Moodle 1.5?

We have upgraded module Registration for Moodle 1.7 so it works with roles. Download is possible from the Modules and Plugins database. Currently it is in beta state, please do not use it in production environment without some testing.
Known bug: list of possible persons to be registered includes course teachers.

Hi,

i wanted to try your registration module out, but it doesn't seem to work for me.
We have moodle 1.6.4+ we postgresql...
It tries to install but it says:
"Module registration: /var/www/localhost/htdocs/moodle/mod/registration/db/postgres7.php was not readable"
Don't know what this means, is it because we're using postgresql? Does it only work with mysql?

Thanks...

Mr. Fikar,

I am having trouble with the registration module in Moodle 1.7, can you assist me? 

When I run "admin/cron.php" from my browser, I get the following output:

Server Time: Mon, 26 Feb 2007 20:36:57 -0800 Starting activity modules

Processing module function assignment _cron ...done.
Processing module function chat _cron ...done.
Processing module function forum _cron ...done.
Processing module function journal _cron ...done.
Processing module function wiki _cron ...done.
Processing module function workshop _cron ...done.
Processing module function netpublish _cron ...done.
Processing module function registration _cron ...This SQL relies on obsolete tables! Your code must be fixed by a developer.

The cron report says that processing for the assignment and forum modules is "done" but only forum e-mails are going out.

The registration module seems to be coming from "lib/dmllib.php" and indicates I am  using Moodle 1.7 (which I am). It occurs when there is a reference to one of the following tables:

• user_students
• user_teachers
• user_coursecreators
• user_admins

These tables have been replaced by the "roles" tables from Moodle 1.7. It looks like the registration module needs to be updated to be compatible with Moodle 1.7.  Will your new module do the trick for me to remedy this situation?

Please advise.

Sincerely,

Cindy Koeppel
The Dirksen Congressional Center

Hi. is it possible to permanently delete the grading from registration? I would like to use it for registration for other activities than exams, like fieldtrips etc. or if that is not doable is is possible to change the "maximun points" to no grade as standard?

Question number 2, is it possible to increse the maximun number of students beoind 100?

/ Daniel Håkansson

I have tried to install Registration module for Moodle 1.7.2 and I have 5 errors. Do you have any idea what is wrong?


This script generated 5 warnings - Scroll to the first warning
registration
(mysql): CREATE TABLE mdl_registration ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', description TEXT NOT NULL, number TINYINT(2) unsigned NOT NULL DEFAULT 0, room VARCHAR(30) NOT NULL DEFAULT '', timedue BIGINT(10) unsigned NOT NULL DEFAULT 0, timeavailable BIGINT(10) unsigned NOT NULL DEFAULT 0, grade BIGINT(10) NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )
Gotowe

(mysql): ALTER TABLE mdl_registration COMMENT='Defines registrations'
Gotowe

(mysql): CREATE INDEX mdl_regi_cou_ix ON mdl_registration (course)
Gotowe

(mysql): CREATE TABLE mdl_registration_submissions ( id BIGINT(10) unsigned NOT NULL auto_increment, registration BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, grade BIGINT(11) NOT NULL DEFAULT 0, teacher BIGINT(10) unsigned NOT NULL DEFAULT 0, timemarked BIGINT(10) unsigned NOT NULL DEFAULT 0, mailed TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )
Gotowe

(mysql): ALTER TABLE mdl_registration_submissions COMMENT='Info about submitted registrations'
Gotowe

(mysql): CREATE INDEX mdl_regisubm_use_ix ON mdl_registration_submissions (userid)
Gotowe

(mysql): CREATE INDEX mdl_regisubm_mai_ix ON mdl_registration_submissions (mailed)
Gotowe

(mysql): CREATE INDEX mdl_regisubm_tim_ix ON mdl_registration_submissions (timemarked)
Gotowe

(mysql): CREATE INDEX mdl_regisubm_reg_ix ON mdl_registration_submissions (registration)
Gotowe

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'view', 'registration', 'name')
1062: Powt�rzone wyst?pienie 'registration-view' dla klucza 2
ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'view', 'registration', 'name'), false) % line 889, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'view', 'registration', 'name')) % line 71, file: dmllib.php
execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'view', 'registration', 'name'), true) % line 1886, file: dmllib.php
execute_sql_arr(Array[14]) % line 548, file: ddllib.php
install_from_xmldb_file(/home/markras/public_html/student/mod/registration/db/install.xml) % line 332, file: adminlib.php
BłądScroll to next warning

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'add', 'registration', 'name')
1062: Powt�rzone wyst?pienie 'registration-add' dla klucza 2
ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'add', 'registration', 'name'), false) % line 889, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'add', 'registration', 'name')) % line 71, file: dmllib.php
execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'add', 'registration', 'name'), true) % line 1886, file: dmllib.php
execute_sql_arr(Array[14]) % line 548, file: ddllib.php
install_from_xmldb_file(/home/markras/public_html/student/mod/registration/db/install.xml) % line 332, file: adminlib.php
Scroll to previous warningBłądScroll to next warning

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'update', 'registration', 'name')
1062: Powt�rzone wyst?pienie 'registration-update' dla klucza 2
ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'update', 'registration', 'name'), false) % line 889, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'update', 'registration', 'name')) % line 71, file: dmllib.php
execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'update', 'registration', 'name'), true) % line 1886, file: dmllib.php
execute_sql_arr(Array[14]) % line 548, file: ddllib.php
install_from_xmldb_file(/home/markras/public_html/student/mod/registration/db/install.xml) % line 332, file: adminlib.php
Scroll to previous warningBłądScroll to next warning

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'view submission', 'registration', 'name')
1062: Powt�rzone wyst?pienie 'registration-view submission' dla klucza 2
ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'view submission', 'registration', 'name'), false) % line 889, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'view submission', 'registration', 'name')) % line 71, file: dmllib.php
execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'view submission', 'registration', 'name'), true) % line 1886, file: dmllib.php
execute_sql_arr(Array[14]) % line 548, file: ddllib.php
install_from_xmldb_file(/home/markras/public_html/student/mod/registration/db/install.xml) % line 332, file: adminlib.php
Scroll to previous warningBłądScroll to next warning

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'upload', 'registration', 'name')
1062: Powt�rzone wyst?pienie 'registration-upload' dla klucza 2
ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'upload', 'registration', 'name'), false) % line 889, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'upload', 'registration', 'name')) % line 71, file: dmllib.php
execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('registration', 'upload', 'registration', 'name'), true) % line 1886, file: dmllib.php
execute_sql_arr(Array[14]) % line 548, file: ddllib.php
install_from_xmldb_file(/home/markras/public_html/student/mod/registration/db/install.xml) % line 332, file: adminlib.php
Scroll to previous warningBłądScroll to continue button

I would like to announce that the new maintainer of the Registration module is Richard Haywood (see this post for reasons).

Is it possible to modify this great module to allow signing in many students at once? Now, if my teacher wants to add 5 students to an exam, the teacher has to press the "sign in" -radiobutton and submit the action and search the student list over and over again. This could be easily solved if the list where you sign in students would use checkboxes instead of radiobuttons..

We have succesfully used the registration module in a case where 500 students needed to register for 4 workshops from a list of 35 workshops, with a total of 2000 registrations. Below some additional functional requests from the teachers:

1. Teachers may remove a registration from the list. The teachers would also like to be able to add students;
2. Teachers would like to be able to export the entire list of registrations for further analysis and resorting, for example sorted on class first and then last name.

I solved request 2 by exporting 3 MySQL tables to Excel (you find this in Moodle under Server - Database):

1. mdl_user
2. mdl_registration
3. mdl_registration_submissions 

With the function VERT.SEARCH in Excel (the function name varies with language) we combined the information in the above mentioned tables to a single table with all the neccessary information. Key fields for the function were NumberID, User_id and Registration_id. For example (Ci = user_id in a specific registration):

     = VERT.SEARCH(Ci, user!$A$1:user!$F$500, 7)

This function searches the spreadsheet containing the users for the same user_id and takes the last name from column 7 in that row.

Make sure the key field that is searched for is in the first column of the spreadsheet and that it is a numerical value. We could not get it working otherwise.

We used the same method to compare the registration database with the official student database to find out which students did not register:

     = VERT.SEARCH(Ci, user!$A$1:user!$F$500, 7, untrue)

When you add the registration mod to a web page it says "Examination Date" then there is the clickable link (I can use the the clickable link to convey any information).

Does anyone know how to change the words "Examination Date" to something else or completely remove it? I do not know too much about php and a little about MySQL.
Thanks

Tim