Moodle plugins directory: Learning plan | Moodle.org
Learning plan
Blocks ::: block_learning_plan
Maintained by 
3i Logic LMS
3i Logic LMSPopular plugin "Learning Plan" has now been upgraded & is compatible with Moodle version 3.3.
This plugin serves as a database and plan for all learning activities in the organization for a structured learning program, including management reports.
Latest release:
383 sites
45 downloads
91 fans
Current versions available: 1
This plugin can be used as a database for entering and saving details about the organization's learning inititaives, and it can also be used as a platform for making, organizing and implementing structured learning throughout the organization. Each Learning Plan includes reports highlighting the trainings needed to complete the plan, the start and end date of the training, the learners and the status of the training. All in all, it is a great plugin to manage organizational learning.
Screenshots
Contributors
3i Logic LMS (Lead maintainer)
Please login to view contributors details and/or to contact them
Awards
Comments 
Comments
Please login to post comments
Would it be possible to allow students to change the status of their learning plans?
Thank you for using learning plan plugin. It can be possible by customization as per the requirement but it comes under our customization service. If you wants to avail our customization service I can forward your query to our marketing department.Please send me your detail requirements at lms@3ilogic.com.
Regards,
3i Logic LMS Team
looking forward to using this resource, however I just installed and hit the same error that Stefan hit above. Now, it appears im kind of stuck in limbo. It keeps taking me back to the plugins "plugins check" page and under the "Learning_Plan" block, it notes "to be installed" however if i click "upgrade database, it just keeps getting the same error.
I noted what Stefan did above to fix, but Im not as confident or skilled in this as he and im afraid of doing more damage. Could you please advise? Thank you!
Moodle version 2.9
block_learning_plan
DDL sql execution error
More information about this error
Debug info: Table 'mdl_block_learning_plan' already exists
CREATE TABLE mdl_block_learning_plan (
id BIGINT(10) NOT NULL auto_increment,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Default comment for block_learning_plan, please edit me'
;
CREATE TABLE mdl_learning_learningplan (
id BIGINT(10) NOT NULL auto_increment,
learning_plan VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
description LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Learning Plan'
;
CREATE TABLE mdl_learning_training (
id BIGINT(10) NOT NULL auto_increment,
training_name VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
type_id BIGINT(10) NOT NULL,
file VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
url VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
start_date BIGINT(10),
end_date BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Default comment for the table, please edit me'
;
CREATE TABLE mdl_learning_plan_training (
id BIGINT(10) NOT NULL auto_increment,
lp_id BIGINT(10) NOT NULL,
t_id BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_learplantrai_lp__ix (lp_id)
, KEY mdl_learplantrai_t_i_ix (t_id)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Default comment for the table, please edit me'
;
CREATE TABLE mdl_learning_traningtype (
id BIGINT(10) NOT NULL auto_increment,
training_type VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
description LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Default comment for the table, please edit me'
;
CREATE TABLE mdl_learning_user_learningplan (
id BIGINT(10) NOT NULL auto_increment,
u_id BIGINT(10) NOT NULL,
lp_id BIGINT(10) NOT NULL,
assignee_id BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_learuserlear_lp_2_ix (lp_id)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Default comment for the table, please edit me'
;
CREATE TABLE mdl_learning_user_trainingplan (
id BIGINT(10) NOT NULL auto_increment,
lpt_id BIGINT(10) NOT NULL,
u_id BIGINT(10) NOT NULL,
status VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'Not Yet Started',
remarks VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_learusertrai_lpt2_ix (lpt_id)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Default comment for the table, please edit me'
Error code: ddlexecuteerror
Stack trace:
line 449 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
line 905 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 76 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
line 412 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
line 364 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()
line 867 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
line 426 of /lib/upgradelib.php: call to upgrade_plugins_blocks()
line 1630 of /lib/upgradelib.php: call to upgrade_plugins()
line 433 of /admin/index.php: call to upgrade_noncore()
Thank you for using learning plan plugin. we'll get back to you after diagnose this issue.
Regards,
3i Logic LMS Team
Thank you for using Learning Plan plugin. Moodle default role of teacher/manager will work with Learning Plan.
Regards,
3i Logic LMS Team
Can you provide plugin version so we can diagnose the problem?
Regards,
3i Logic LMS Team
There is no need to assigned manager to manage Learning Plan activities, by default manager can manage all learning plan activities. You need to create user and assign manager role, when the user having manager role access the learning plan than they have rights to do management activities in the Learning Plan.
Thanks,
3i Logic LMS Team
example: Peter has 10 students, Peter dont have any role on the site. I want him to be the manager of the training block to manage the 10 students. how do I do that?
Thanks
Can you provide your email address? so we can send you a detail process of assigning a manager. You can also reach us directly too at lms@3ilogic.com
Regards,
3i Logic LMS Team
When i try to assign a plan to students i get back this error:
Debug info: ERROR: column " " does not exist
LINE 1: SELECT id, CONCAT(firstname," ", lastname)FROM mdl_user wher...
^
SELECT id, CONCAT(firstname," ", lastname)FROM mdl_user where username!="guest"
[array (
)]
Error code: dmlreadexception
Stack trace:
line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 244 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
line 785 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
line 1404 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
line 310 of /blocks/learning_plan/learning_plan_form.php: call to moodle_database->get_records_sql_menu()
line 192 of /lib/formslib.php: call to assignlerningplan_user_form->definition()
line 183 of /blocks/learning_plan/view.php: call to moodleform->__construct()
I installed this plugin on moodle 3.0, plugin version: 2.9 (2016021201)
Any suggestions??
Thank you for using leanring plan plugin. Give us some time to investigate the issue, we'll get back to you soon.
Thanks,
3i Logic LMS Team
Does this plugin have a function export or convert learning plan to excel ?