Moodle plugins directory: Exabis E-Portfolio

hi, ella.

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

Thank you, Daniel.
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()

Also I got error, when try to click on some link, or file, or notes (page /exaport/shared_item.php?courseid=1&access=portfolio/id/4788&itemid=2):

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 686 of \blocks\exaport\lib\sharelib.php: call to block_exaport_get_items_shared_to_user()
•line 309 of \blocks\exaport\lib\sharelib.php: call to block_exaport_can_user_access_shared_item()
•line 37 of \blocks\exaport\shared_item.php: call to block_exaport_get_item()

hi ella, i sent you a pm.

The Teacher's Manual link, in the description area of this page, is broken.

Thanks for the hint, I just corrected it. Best regards, Andreas

I'm just learning to use this plugin. I've tried in Moodle 3.0 as well as 3.2. In both environments, I find that I cannot enter spaces between words in the Headertext areas, when building a view. Is it just me? What could the problem be. I've tried two different browsers.

I'm wondering if the CV is meant to be shared? I cannot find any way of doing that, other than through europass.

Hello, can you please tell me which browsers you use? CV so far only has an export to the Europass because a pdf is generated there but this can then be made available within the portfolio again, best regards Andreas

Hi Andreas,

There are some troubles with Exabis portfolio ans Moodle.
I have made a document with screenshots: https://docs.google.com/document/d/1V74kTMvaUZP8NfkOybgxYTAAS1CHnZpsyJbbLsQ3bMQ/edit?usp=sharing

Please, would you look after this? Thank you!

Sincerely,
Kees Koopman.

Hello Kees, thank you, is it possible that you are still using version 4.5.1, I think some of those issues are already fixed. Can you get our modules from git?

Hi Andreas,

Thank you for your answer.

We use (downloaded from Moodle.org)
Moodle version 3.3+ (Build: 20170519)
Exabis e-Portfolio version 4.5.1.experimental 2016092101

Is the version on git more recent?
Is this the URL: https://github.com/gtn/exaport

Sincerely,
Kees.

Hello Kees, we just published, we are now going by version-numbers in the branches, so we will update changes on https://github.com/gtn/exaport/tree/v4.6.0
best regards
Andreas

Sorry I took so long to reply to your question of June 17. This problem occurs in all browsers that I use. I just now tested it on MS Edge, as well, with the latest version of Exabis on Moodle 3.2. I try to enter Header text in a view and I cannot have any spaces between words.

hi blair, i wrote you a pm.