Moodle plugins directory: Exabis E-Portfolio | Moodle.org
Exabis E-Portfolio
About Exabis ePortfolio:
Start ePortfolio work with Moodle – a compact block with everything needed to collect, select, reflect, and share.
Exabis ePortfolio redefines the learning experience by placing learners at the centre of their educational journey. This Moodle plugin empowers students to create, collect, and share their learning artefacts in the form of digital portfolios. It offers a learner-driven approach to acquiring new competencies by enabling learners to create and share their artefacts as part of the learning process.
Key Features:
Individualized Portfolio Structure
Build ePortfolios with a structure tailored to your individual preferences and learning objectives.
Competence Mapping
Link your ePortfolio artefacts to specific competencies, facilitating a comprehensive understanding of your learning journey.
Selective Publishing
Publish views of your portfolio with a selection of materials, allowing you to curate and share your work with precision. Collect materials and artefacts created as part of collaboration and co-creation with others.
Export to Europass
Export your ePortfolio content to Europass format, making it easy to showcase your accomplishments and skills on your CV.
Integration of OpenBadges
Seamlessly integrate OpenBadges to recognize and showcase your achievements within your ePortfolios.
Cross-Platform Use
Save ePortfolios as SCORM packages for cross-platform compatibility, extending the reach and usability of your learning materials.
Exabis ePortfolio can be effortlessly integrated into your existing Moodle installation, allowing for course-independent operation.
How it Works:
Students can easily collect web links, files, and notes, organizing them into self-defined categories. They have the flexibility to choose whether to publish all or select parts of their collected learning materials, making it possible to share their work with the entire community or a specific group of users. This sharing feature enables peer and teacher assessment, fostering collaboration and reflection.
ePortfolios can be saved as SCORM packages, ensuring compatibility across different platforms. The built-in CV functionality streamlines the process of exporting to Europass format, enhancing your professional profile.
Exabis ePortfolio is a pivotal component of the Exabis Suite, a 100% open-source suite that seamlessly combines Exabis Competencies, ePortfolio, and Student Review modules. This suite offers adaptive learning scenarios that can be guided by trainers, self-paced, reflective, and personalized, enhancing the learning experience for all users. The modules can be used independently or as part of the suite, providing maximum flexibility and customization options for educators and learners.
Read more at: www.exabis.at
Screenshots
Debug info: SQLState: 42000
Error Code: 8120
Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Column "mdl_block_exaportcate.shareall" in the selection list is invalid because it is not contained in an aggregate function, any proposal GROUP BY.
SELECT c.id, c.name, c.pid, c.shareall, c.internshare, c.structure_shareall, c.structure_share, COUNT(i.id) AS item_cnt
FROM mdl_block_exaportcate c
LEFT JOIN mdl_block_exaportitem i ON i.categoryid=c.id AND (i.isoez=0 OR (i.isoez=1 AND (i.intro<>'' OR i.url<>'' OR i.attachment<>'')))
WHERE c.userid = '11'
GROUP BY c.id, c.name, c.pid
ORDER BY c.name ASC
[array (
0 => '11',
)]
Error code: dmlreadexception
Stack trace:
line 443 of \lib\dml\moodle_database.php: dml_read_exception thrown
line 250 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
line 357 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
line 792 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
line 840 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
line 89 of \blocks\exaport\view_items.php: call to sqlsrv_native_moodle_database->get_records_sql()
https://github.com/gtn/exaport/archive/master.zip
Error Code: 8120
Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Column "mdl_block_exaportview.sharedemails" in the selection list is invalid because it is not contained in an aggregate function, any proposal GROUP BY.
SELECT v.*, u.firstname, u.lastname, u.picture, COUNT(DISTINCT vshar_total.userid) AS cnt_shared_users, COUNT(DISTINCT vgshar.groupid) AS cnt_shared_groups
FROM mdl_user u
JOIN mdl_block_exaportview v ON u.id=v.userid
LEFT JOIN mdl_block_exaportviewshar vshar ON v.id=vshar.viewid AND vshar.userid='11'
LEFT JOIN mdl_block_exaportviewgroupshar vgshar ON v.id=vgshar.viewid
LEFT JOIN mdl_block_exaportviewshar vshar_total ON v.id=vshar_total.viewid
WHERE
(
vshar.userid IS NOT NULL -- shared to me
OR v.shareall=1 -- shared to all, if enabled
OR v.id IN (0) -- Add group shareing views
)
AND v.userid!='11' -- don't show my own views
-- user filter
GROUP BY v.id, v.userid, v.name, v.description, v.timemodified, v.shareall, v.externaccess, v.externcomment, v.hash, v.langid, v.layout, u.firstname, u.lastname, u.picture
ORDER BY u.lastname, u.firstname, cast(v.name AS varchar(max))
[array (
0 => '11',
1 => '11',
)]
Error code: dmlreadexception
Stack trace: •line 443 of \lib\dml\moodle_database.php: dml_read_exception thrown
•line 250 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
•line 357 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
•line 792 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
•line 840 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
•line 80 of \blocks\exaport\shared_views.php: call to sqlsrv_native_moodle_database->get_records_sql()
when open Shared Categories - Debug info: SQLState: 42000
Error Code: 8120
Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server] Column "mdl_block_exaportcate.pid" in the selection list is invalid because it is not contained in an aggregate function, any proposal GROUP BY.
SELECT c.*, u.firstname, u.lastname, u.picture, COUNT(DISTINCT cshar_total.userid) AS cnt_shared_users, COUNT(DISTINCT cgshar.groupid) AS cnt_shared_groups FROM mdl_user u JOIN mdl_block_exaportcate c ON (u.id=c.userid AND c.userid!='11') LEFT JOIN mdl_block_exaportcatshar cshar ON c.id=cshar.catid AND cshar.userid='11' LEFT JOIN mdl_block_exaportviewgroupshar cgshar ON c.id=cgshar.groupid LEFT JOIN mdl_block_exaportcatshar cshar_total ON c.id=cshar_total.catid WHERE ((c.shareall=1 OR cshar.userid IS NOT NULL) ) AND internshare = 1 GROUP BY c.id, c.userid, c.name, c.description, c.timemodified, u.firstname, u.lastname, u.picture ORDER BY u.lastname, u.firstname, cast(c.name AS varchar(max))
[array (
0 => '11',
1 => '11',
)]
Error code: dmlreadexception
Stack trace: •line 443 of \lib\dml\moodle_database.php: dml_read_exception thrown
•line 250 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
•line 357 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
•line 792 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
•line 840 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
•line 65 of \blocks\exaport\shared_categories.php: call to sqlsrv_native_moodle_database->get_records_sql()
I´m running Exabis Portfolio 4.5 on a Moodle 3.2.1. When students and teachers try to access other user shared category the get an error "Error code: Invalid user". As Admin user I have no problem with those shared categories.
Can you gave me some advice about this issue.
Thanks! Regards, Juan María Palmieri
best regards Andreas
unfortunatly we don't have an oracle installation in house. but we test our plugin under mysql and postgres.
maybe you can give us more details about the problems you are experiencing.
your help on improving this plugin is much appreciated.
Here's an example. Got this after adding Exabis ePortfolio block to my home page and then click on the My Portfolio artifacts. I'm willing to help go through and resolve these Oracle based issues and submit the changes/patches. Just let me know what the process is for doing that.
Debug info: ORA-00979: not a GROUP BY expression
SELECT c.id, c.userid, c.name, c.pid, c.shareall, c.internshare, c.structure_shareall, c.structure_share, COUNT(i.id) AS item_cnt
FROM m_block_exaportcate c
LEFT JOIN m_block_exaportitem i ON i.categoryid=c.id AND (i.isoez=0 OR (i.isoez=1 AND (i.intro<>'' OR i.url<>'' OR i.attachment<>'')))
WHERE c.userid = :o_param1
GROUP BY c.id, c.name, c.pid
ORDER BY c.name ASC
[array (
'o_param1' => '2',
)]
Error code: dmlreadexception
Stack trace:
line 479 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 277 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()
line 1179 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
line 175 of /blocks/exaport/view_items.php: call to oci_native_moodle_database->get_records_sql()
I’ve installed the latest version from GIT (last commit was on 11 Nov 2016).
I have the same error like user “advisor” wrote.
----------
On page “shared_views.php” this error:
----------
Debug info: SQLState: 42000
Error Code: 8120
Message: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Column 'tblblock_exaportview.sharedemails' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT v.*, u.firstname, u.lastname, u.picture, COUNT(DISTINCT vshar_total.userid) AS cnt_shared_users, COUNT(DISTINCT vgshar.groupid) AS cnt_shared_groups
FROM tbluser u
JOIN tblblock_exaportview v ON u.id=v.userid
LEFT JOIN tblblock_exaportviewshar vshar ON v.id=vshar.viewid AND vshar.userid='2'
LEFT JOIN tblblock_exaportviewgroupshar vgshar ON v.id=vgshar.viewid
LEFT JOIN tblblock_exaportviewshar vshar_total ON v.id=vshar_total.viewid
WHERE
(
vshar.userid IS NOT NULL -- shared to me
OR v.shareall=1 -- shared to all, if enabled
OR v.id IN (0) -- Add group shareing views
)
AND v.userid!='2' -- don't show my own views
-- user filter
GROUP BY v.id, v.userid, v.name, v.description, v.timemodified, v.shareall, v.externaccess, v.externcomment, v.hash, v.langid, v.layout, u.firstname, u.lastname, u.picture
ORDER BY u.lastname, u.firstname, cast(v.name AS varchar(max))
[array (
0 => '2',
1 => '2',
)]
Error code: dmlreadexception
--------------
On page “shared_categories.php” this error:
--------------
Debug info: SQLState: 42000
Error Code: 8120
Message: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Column 'tblblock_exaportcate.pid' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT c.*, u.firstname, u.lastname, u.picture, COUNT(DISTINCT cshar_total.userid) AS cnt_shared_users, COUNT(DISTINCT cgshar.groupid) AS cnt_shared_groups FROM tbluser u JOIN tblblock_exaportcate c ON (u.id=c.userid AND c.userid!='2') LEFT JOIN tblblock_exaportcatshar cshar ON c.id=cshar.catid AND cshar.userid='2' LEFT JOIN tblblock_exaportviewgroupshar cgshar ON c.id=cgshar.groupid LEFT JOIN tblblock_exaportcatshar cshar_total ON c.id=cshar_total.catid WHERE ((c.shareall=1 OR cshar.userid IS NOT NULL) ) AND internshare = 1 GROUP BY c.id, c.userid, c.name, c.description, c.timemodified, u.firstname, u.lastname, u.picture ORDER BY u.lastname, u.firstname, cast(c.name AS varchar(max))
[array (
0 => '2',
1 => '2',
)]
Error code: dmlreadexception
Stack trace:
•line 479 of \lib\dml\moodle_database.php: dml_read_exception thrown
•line 297 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
•line 404 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
•line 865 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
•line 913 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
•line 65 of \blocks\exaport\shared_categories.php: call to sqlsrv_native_moodle_database->get_records_sql()
thank you all for your help and quick replys.
@tim: your problem is already fixed in the latest 4.5.1 https://github.com/gtn/exaport/archive/v4.5.1.zip
@nadia: can you check your webserver / php error log for any more details on this? the greek language seems to work fine for me. maybe you also try to install the version from githup.
your problems with mssql should also be fixed.
please download the new version from github: https://github.com/gtn/exaport/archive/v4.5.1.zip
I installed new version by your link. Now I got new error. When I try to create new view (click "Add View" button on page Views /exaport/views_mod.php) I got this exception:
Debug info: SQLState: 42000
Error Code: 8120
Message: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Column 'tblblock_exaportcate.pid' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT c.*, u.firstname, u.lastname, u.picture, COUNT(DISTINCT cshar_total.userid) AS cnt_shared_users, COUNT(DISTINCT cgshar.groupid) AS cnt_shared_groups FROM tbluser u JOIN tblblock_exaportcate c ON u.id=c.userid LEFT JOIN tblblock_exaportcatshar cshar ON c.id=cshar.catid AND cshar.userid='4788' LEFT JOIN tblblock_exaportviewgroupshar cgshar ON c.id=cgshar.groupid LEFT JOIN tblblock_exaportcatshar cshar_total ON c.id=cshar_total.catid WHERE ((c.shareall=1 OR cshar.userid IS NOT NULL) ) AND c.userid!='4788' AND internshare = 1 GROUP BY c.id, c.userid, c.name, c.timemodified, c.shareall, u.firstname, u.lastname, u.picture ORDER BY u.lastname, u.firstname, c.name
[array (
0 => '4788',
1 => '4788',
)]
Error code: dmlreadexception
× Stack trace: •line 479 of \lib\dml\moodle_database.php: dml_read_exception thrown
•line 297 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
•line 404 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
•line 865 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
•line 913 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
•line 617 of \blocks\exaport\lib\sharelib.php: call to sqlsrv_native_moodle_database->get_records_sql()
•line 1091 of \blocks\exaport\lib\lib.php: call to block_exaport_get_items_shared_to_user()
•line 163 of \blocks\exaport\views_mod.php: call to block_exaport_get_portfolio_items()
•line 204 of \lib\formslib.php: call to block_exaport_view_edit_form->definition()
•line 266 of \blocks\exaport\views_mod.php: call to moodleform->__construct()