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.
855 sites
620 downloads
30 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 Franck Deroche-Gamonet
    Tue, 31 May 2016, 9:18 PM
    Hello,
    I'd like to report a problem with sharing options. Indeed, for a view, when you select "External Access", the view is defacto visible by all Moodle Members in "shared portfolios". I think this is due to the fact that if you want it to be visible by external users it has to be visible by all. But we can expect that, with the option "External Access", only people with the link containing the hash can access the view. So is it possible to hide portfolios shared with external access in the page "shared portfolios" ? Thanks, regards.
  • Picture of Daniel Gtn
    Thu, 2 Jun 2016, 11:50 AM
    Hi Frank,

    indeed there seems to be a bug with the external sharing. After fixing this issue we will release a new version. Thx for your help!
  • Picture of Kees Koopman
    Fri, 15 Jul 2016, 11:34 PM
    Hi,

    I installed e-Portfolio from github. If I want to read of write a file in a map, I get the following error:

    Tabel "block_exacompitemexample" bestaat niet

    Meer informatie over deze fout

    Debug info:
    Error code: ddltablenotexist
    Stack trace:
    line 590 of /lib/dml/moodle_database.php: dml_exception thrown
    line 1430 of /lib/dml/moodle_database.php: call to moodle_database->where_clause()
    line 79 of /blocks/exaport/shared_item.php: call to moodle_database->get_record()

    Please, can you help me with this?!
    Thanks a lot.
  • Picture of Павел Ломов
    Wed, 14 Sep 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, 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 Master SEO
    Sat, 18 Feb 2017, 9:39 PM
    I have installed the new version of the potfolio but when i choose the the Greek Language my moodle site stops working and i get an error 500 page.
    When i am deleting the el file from https://www.masterseo.id languge from my server the portfolio and my moodle site works https://seo.web.id perfrect.

    I thing there is an error on the greek language pack of the portfolio.
  • 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()
1 2 3 4 5 6 7
Please login to post comments