Blocks: Exabis E-Portfolio

block_exaport
Maintained by Picture of andreas riepl andreas riepl
Start ePortfolio-work within Moodle - a compact block with everything needed to build up competency-profiles. Establish a student-centered way of contributing within Moodle. Key-features are course-independant eportfolio-work througout Moodle, publishing of views, association of artefacts with competencies, integration of OpenBadges.
931 sites
779 downloads
36 fans
Moodle 2.0, 2.1, 2.2, 2.3, 2.4, 2.5

This block can easily be added to a Moodle installation and provides ePortfolio functionality for each student and teacher.

Students can build up their ePortfolios collecting weblinks, files and notes within individually defined categories, publish ePortfolio-artefacts to specific target-groups using views to get reflections and comments submitted by other persons as well as import uploaded assignments from within the Moodle-installation.

In addition the ePortfolio can be saved as a SCORM-package which is a standardized scheme and file format for the transportation of learning-based data and can be used cross-platform for further work.

Also a connection with the newest module "exabis competencies” which enables users to associate ePortfolio artefacts with competencies can be made. The current version also connects to the SmartPhone-app eLOVE (electronial lifelong outcomeoriented vocational education) and Dakora-App. More info at gtn-solutions.com

With the exabis-series consisting of exabis ePortfolio, exabis competencies and exabis student review teachers can work on individualization scenarios. Students can contribute portfolio artefacts, teachers can roll out materials to students selectively and reports can be generated documenting this work.

For a detailed documentation refer to Admins' manual or the Teachers' manual.


Screenshots

Screenshot #0
Screenshot #1
Screenshot #2

Contributors

Picture of andreas riepl
andreas riepl (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • Picture of Daniel Gtn
    Wed, 22 Feb 2017, 1:50 PM
    hi tim,
    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.
  • Picture of Tim Quenan
    Thu, 23 Feb 2017, 3:02 AM
    Daniel,

    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()
  • Picture of Ella S.
    Sat, 25 Feb 2017, 5:20 PM
    Moodle 3.2.1 (on MS SQL Server 2014 + Windows Server 2016R2 + IIS)
    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()
  • Picture of andreas riepl
    Fri, 17 Mar 2017, 1:20 PM
    which version of the block are you using and which moodle-version?
  • Picture of Daniel Gtn
    Fri, 17 Mar 2017, 1:48 PM
    sorry all for keeping you waiting, we just saw your replies today (didn't get any notification mails).
    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.
  • Picture of Daniel Gtn
    Mon, 20 Mar 2017, 4:38 PM
    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
  • Picture of Ella S.
    Sun, 26 Mar 2017, 2:03 PM
    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()
  • Picture of Ella S.
    Sun, 26 Mar 2017, 2:16 PM
    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()
  • Picture of Daniel Gtn
    Tue, 4 Apr 2017, 8:13 PM
    hi ella, i sent you a pm.
  • Picture of Blair F.
    Wed, 14 Jun 2017, 2:21 AM
    The Teacher's Manual link, in the description area of this page, is broken.
  • Picture of andreas riepl
    Wed, 14 Jun 2017, 10:07 PM
    Thanks for the hint, I just corrected it. Best regards, Andreas
  • Picture of Blair F.
    Thu, 15 Jun 2017, 4:27 AM
    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.
  • Picture of Blair F.
    Sat, 17 Jun 2017, 2:53 AM
    I'm wondering if the CV is meant to be shared? I cannot find any way of doing that, other than through europass.
  • Picture of andreas riepl
    Sun, 18 Jun 2017, 1:55 PM
    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
  • Picture of Kees Koopman
    Fri, 23 Jun 2017, 6:49 AM
    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.
1 2 3 4 5 6 7 8
Please login to post comments