Your Moodle version

Activities: DataPlus

mod_dataplus
Maintained by Picture of Anthony Forth Anthony Forth
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.

Sets

This plugin is part of set Open University. Plugins from the set work the best when installed together.

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

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

Comments RSS

Show comments
  • Picture of German Valero
    Sun, Dec 2, 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.
  • Picture of German Valero
    Sun, Dec 2, 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.
  • Picture of German Valero
    Sun, Dec 2, 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.
  • Picture of German Valero
    Mon, Dec 3, 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.
  • Picture of Anthony Forth
    Mon, Dec 3, 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.
  • Picture of Michael Deane
    Tue, Dec 4, 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.
  • Picture of Anthony Forth
    Tue, Dec 4, 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.
  • Picture of David Mudrák
    Wed, Dec 12, 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.
  • Picture of Pavel Krejci
    Thu, Mar 28, 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(?,?,?,?,?,?,?,?,?)
  • Picture of Marie AFA
    Sat, Apr 27, 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.
Please login to post comments