Blocks: Exabis E-Portfolio

block_exaport
Maintained by Picture of andreas rieplandreas riepl
Start ePortfolio work with Moodle – a compact block with everything needed to collect, select, reflect and share. Exabis ePortfolio establishes a learner driven way of contributing learning products during learning processes course independently. Key features are: - building up ePortfolios with an individual structure - linking ePortfolio-artefacts to competences - publishing of views with a selection of material - export to Europass for CVs - integration of OpenBadges - export to SCORM-format
1137 sites
452 downloads
60 fans
Current versions available: 6
This block can easily be added to a Moodle installation and provides ePortfolio functionality for each student and teacher course independently.
Students can build up their ePortfolios collecting weblinks, files and notes within individually defined categories.  ePortfolio-artefacts can be published to specific target-groups using views to start reflection and assessments.

ePortfolios can be saved as a SCORM-package and can be used cross-platform for further work. Also the CV-functionality allows export to the Europass format.

Exabis ePortfolio is part of a suite of three main modules: Exabis ePortfolio (portfolio work), Exabis Competencies - Competence grids (connecting artefacts to competences and individualization paths using digital competence grids) and Exabis student review (course spanning reporting tool of students’ achievements including assessment of soft skills).

The module can be used standalone or as part of this suite. Advantage of using all three modules together is that learner driven learning paths can be established – these are teacher guided, self-paced, competence-based and individualized.

The free app DAKORA (working with digital competence grids) which was developed together with the Federal Ministry of Education in Baden-Württemberg, Germany, allows work with all three modules with an innovative interface for tablets and smartphones which can be downloaded from all app stores.   

Try out DAKORA at https://exacloud.at/dakora

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

Take a look at the video to see how it works in schools:

Find the transcript in English here: with timeline or without timeline.

More info at gtn-solutions.com

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

Comments

  • Picture of Павел Ломов
    Wed, Sep 14, 2016, 4:21 PM
    My version of moodle is 2.6.6 - It is possible to use version of this plugin for moodle 2.7?
  • Picture of andreas riepl
    Wed, Sep 14, 2016, 6:01 PM
    Hello, you can go to an earlier version of our module, we have one working for 2.7: https://moodle.org/plugins/view.php?plugin=block_exaport&moodle_version=17
  • Picture of advisor advisor
    Wed, Oct 12, 2016, 1:10 PM
    Hello Andreas. Moodle 2.9.1, IIS, PHP 5.6.0, MS SQL 2012, Exabis E-Portfolio 4.3, 4.4, 4.4.1. When open My Portfolio - Error reading from database

    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()
  • Picture of Daniel Gtn
    Wed, Oct 12, 2016, 4:53 PM
    hi, please download the latest version from github:
    https://github.com/gtn/exaport/archive/master.zip
  • Picture of advisor advisor
    Wed, Oct 12, 2016, 6:15 PM
    hi Daniel, I installed the latest version, when open Shared Views - Debug info: SQLState: 42000
    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()
  • Picture of Juan María Palmieri
    Thu, Jan 26, 2017, 5:46 AM
    Hello!
    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
  • Picture of andreas riepl
    Sun, Feb 19, 2017, 3:22 PM
    we will take a look at that,
    best regards Andreas
  • Picture of Tim Quenan
    Wed, Feb 22, 2017, 6:30 AM
    Running into a bunch of errors using the latest 4.5.0 version against Moodle 3.2.1 with an Oracle DB backend. These items worked with our previous 2.7.4 and the 4.3 version of the plug-in. Are there plans to resolve these Oracle related SQL issues?
  • Picture of Daniel Gtn
    Wed, Feb 22, 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, Feb 23, 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, Feb 25, 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, Mar 17, 2017, 1:20 PM
    which version of the block are you using and which moodle-version?
  • Picture of Daniel Gtn
    Fri, Mar 17, 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, Mar 20, 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, Mar 26, 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()
Please login to post comments