DataPlus

Activities ::: mod_dataplus
Maintained by Anthony Forth
Part of set Open University.
DataPlus is a Moodle module that enables the production of customisable, portable, standalone SQLite3 databases for teaching and learning. It's features are similar to the Data module, but it allows easier export and search as well as improved performance for larger databases.
Latest release:
27 sites
5 downloads
4 fans
Current versions available: 4

DataPlus is a Moodle module conceived and developed at The Open University.  It enables the production of customisable, portable, standalone SQLite3 databases for teaching and learning.

The module is designed to build upon many of the strengths of the existing Moodle Database module, but with increased performance, improved search and the ability to create a standalone database that can be exported easily and imported into other Moodle / DataPlus instances easily.  Version 1.0 of DataPlus is designed to feel familiar to users of the Data module with a familiar interface and much familiar functionality (DataPlus owes a significant debt to the Data module).

Another advantage of creating a standalone database is that its customisation and use do not touch the Moodle database, avoiding any possible performance or security implications of this and providing the potential for greater flexibility in future versions.  The easiest way to use the module is with the SQLite3 support in PHP 5.3, however earlier PHP 5 versions can be configured to enable SQLite3.

The module was developed in the Autumn of 2009 and first released to The Open University community for use, with the intention of deprecating the Data module in the local Moodle build, in December 2009.  A second version was produced in January 2010, when this site was launched.  Further development will be documented here.

The module is available for free use and distribution under GPL.

Contributors

Anthony Forth (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Comments

  • Germán and Temudgin
    Sun, 2 Dec 2012, 5:15 AM
    Hi,
    I was translating the dataplus plugin and I found a strange-looking English string:

    2.1 [cleardatadone,dataplus] "All has been data cleared from the database."

    which I think might be better understood as "All data has been cleared from the database."

    But I am not a native English speaker.
    Thanks in advance for your help.
  • Germán and Temudgin
    Sun, 2 Dec 2012, 7:38 AM
    Hi,
    The following English string looks strange:2.1 [listperpage_help,dataplus] "Set the number of records to display in a list template and disable the menu to enable the use to do this."

    Perhaps "use" should be "user" ( I think).
    Thanks in advance for your help.
  • Germán and Temudgin
    Sun, 2 Dec 2012, 7:56 AM
    Hi,The following string looks strange:
    2.1 [useroutline_templatesaved,dataplus] "Number of time a template has been updated:"
    Perhaps "time" should be "times".
    Thanks in advance for your help.
  • Germán and Temudgin
    Mon, 3 Dec 2012, 9:33 PM
    Hi Anthony,
    I translated the dataplus plugin for Moodle 2.0 and 2.1 branches into Spanish for Mexico (es_mx). I found it very strange that AMOS (http://lang.moodle.org/) does not have the English language strings for Moodle branches 2.2 , 2.3 and 2.4dev. I wrote David Mudrak about it and I am looking forward to reading his expert diagnosis of the problem and suggested fix.
    By the way, is the dataplus plugin compatible with Moodle 2.2 and 2.4 branches ? If it is, it would be great to have it marked accordingly, or if it is not, to have the explanation for it.

    Thank you very much for your promp answer.
  • Anthony Forth
    Mon, 3 Dec 2012, 9:56 PM
    I never tested it with an out-of-the-box 2.2 installation, although my belief is the 2.1 version will work. I will test against 2.4 in the new year.
  • Michael Deane
    Tue, 4 Dec 2012, 12:12 PM
    I have tested the 2.2 version of Dataplus in a couple of installations and whilst it generally behaves as expected, I was hoping for uploaded files (images) to be exported. Whilst the exported file structure has a files directory none of my test exports had any exported files. My hope was that I would be able to recreate the export file structure from data I have in another DB and use it to import to Moodle. I don't want to get stuck with data in a database that I cannot export should I need to move at some point in the future.
  • Anthony Forth
    Tue, 4 Dec 2012, 5:34 PM
    Thanks for that Michael. I will have a look at whether the export is behaving correctly with images and get back to you.
  • David Mudrák
    Wed, 12 Dec 2012, 7:16 PM
    Please note that the heredoc syntax (EOF) is not supported by AMOS. Also, the whole templates_hookstext string should better go into a docs imho.
  • Pavel Krejci
    Thu, 28 Mar 2013, 12:26 AM
    The language file contains 2 definitions of "alt tag" that are causing dmlwriteexception error when editing custom language strings in Moodle:
    Debug info: Duplicate entry 'cs-407-Alttag' for key 'mdl_toolcust_lancomstr_uix'
    INSERT INTO mdl_tool_customlang (lang,componentid,stringid,original,master,timemodified,outdated,local,timecustomized) VALUES(?,?,?,?,?,?,?,?,?)
  • Marie AFA
    Sat, 27 Apr 2013, 1:48 PM
    Is there a way to know where the sqlite3 DB file is actually located ?
    For example could I from a non moodle script located on the same server open the sqlite3 and make whatever necessary updates ?
    I was thinking about a batch which would generate thumbs periodicaly for Image field.
  • Ziyad Muslat
    Fri, 30 Sept 2016, 3:44 AM
    Hi Installed the plugin on my moodle 3.1.2. When I try to create the activity, I get this error message:

    Exception - could not find driver

    More information about this error

    Debug info:
    Error code: generalexceptionmessage
    Stack trace:
    line 72 of /mod/dataplus/sqlite3_db.php: PDOException thrown
    line 72 of /mod/dataplus/sqlite3_db.php: call to PDO->__construct()
    line 37 of /mod/dataplus/sqlite3_db_dataplus.php: call to sqlite3_db->__construct()
    line 102 of /mod/dataplus/locallib.php: call to sqlite3_db_dataplus->__construct()
    line 1098 of /mod/dataplus/view.php: call to dataplus_base_setup()

    When I click on more info link, it does not show anything.
    Can please help?
  • Jean-Christophe Taboada
    Thu, 20 Apr 2017, 7:51 PM
    Hello,
    I have exactly the same error, with the latest version of the plugin, and a the 3.1.1 version of Moodle (nginx)
    Unfortunately, it seems development is stalled.
    Is there any way to get help on this ?
Please login to post comments