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.
857 sites
572 downloads
31 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 epop - www.epop.at - where associated competencies and examples are rolled out to mobile devices.

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 andreas riepl
    Wed, 14 Sep 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, 12 Oct 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, 12 Oct 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, 12 Oct 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, 26 Jan 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, 19 Feb 2017, 3:22 PM
    we will take a look at that,
    best regards Andreas
  • Picture of Tim Quenan
    Wed, 22 Feb 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, 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()
1 2 3 4 5 6 7 8
Please login to post comments