Admin tools: Import competency framework

tool_lpimportcsv
Maintained by Me! Damyon Wiese
This admin tool allows import/export of competency frameworks using a comma separated value file (CSV). This imports and exports all data contained in the competency framework including related competencies, and any configured competency rules.
164 sites
215 downloads
12 fans
This admin tool allows import/export of competency frameworks using a comma separated value file (CSV). This is useful to move competency frameworks between Moodle sites - or to import new competency frameworks - by first mapping all the fields to match the CSV format used by this plugin.

Screenshots

Screenshot #0
Screenshot #1

Contributors

Me!
Damyon Wiese (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • Picture of David Mudrák
    Thu, 26 May 2016, 5:13 AM

    Thanks Damyon for sharing the plugin with the Moodle community. I was able to successfully test the basic functionality and did not notice any issues with the code that would block the approval here (not that I would expect them wink). I was checking the input data sanitization and it seems to be processed well in the framework_importer class. The raised coding style issues look like easy to fix things and at least replacing var with proper visibility scope identifiers public could make it in the next update (folks tend to see plugins submitted by HQ members as referential ones).

    I am happy to approve this now. You are cleared to land, welcome to the Plugins directory.

  • Picture of Natalie Denmeade
    Sun, 5 Jun 2016, 12:56 PM
    I am trying to import a Competency framework to Moodle Cloud and came across this plugin. Does this mean I can only use the import function on a self-hosted Moodle Site where I can install this plugin? (not Moodle Cloud for Schools)
  • Picture of Xanthe Lawson
    Tue, 27 Sep 2016, 1:20 PM
    Hi Daymo, thanks for your work on this plugin. We are experimenting with it and just wanted to confirm whether you can only import one framework at a time. I've tried importing a CSV file with several frameworks, but it's only creating one of them in Moodle. Is this correct behaviour?
  • Me!
    Fri, 30 Sep 2016, 1:34 PM
    Hi Xanthe, yes this plugin will only import/export one framework at a time.
  • Picture of Helen Foster
    Tue, 11 Oct 2016, 10:40 PM
    Hi Natalie, it is indeed the case that you can currently only use this import tool on a site where you can install plugins. However, the good news is that the Import competency framework admin tool will be included as standard in Moodle 3.2 (MDL-55767), and your MoodleCloud site is likely to be upgraded very soon after release. smile
  • Picture of Chad Frerichs
    Tue, 29 Nov 2016, 12:18 AM
    Is there a description of the required CSV format for this upload?
  • Me!
    Tue, 29 Nov 2016, 4:06 PM
    I describe the format here - but the best thing to do is create a framework in moodle and export it to see the format.

    https://tracker.moodle.org/browse/MDL-56585?focusedCommentId=433693&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-433693
  • Me!
    Fri, 9 Dec 2016, 9:12 AM
    Please don't try and install this plugin on Moodle 3.2 or later because it is already included with Moodle core.
  • Picture of Shawn Bullivant
    Sat, 7 Jan 2017, 4:45 AM
    I have installed the plugin however get an error of "File format error"
    I simply have 3 columns in a spreadsheet and have saved as a CSV file to upload.
    Any help would be appreciated
  • Picture of Boris Malysh
    Sat, 11 Mar 2017, 4:35 PM
    Hello everybody, I have the same issue as Shawn Bullivant. Except that I haven't intalled the plugin since it's already in the core (I'm using moodle 3.2). Below I'll describe the process, hoping it would help identify the root of the problem:

    1 - So, I made this csv file looking like that:
    Parent ID number;ID number;Short name;Description;Description format;Scale values;Scale configuration;Rule type;Rule outcome;Rule config (optional);Cross-referenced competency ID numbers;Exported ID (optional);Is framework;Taxonomy

    Only the first four columns have data. All the others (beginning with "Description format") are empty since I don't know how to fill them.

    2 - Then I drop the file into the box on the "Import competency framework" page;
    I set
    CSV delimiter - ;
    and
    Encoding - UTF-8

    3 - As I hit the "Import button", I see the following:

    Confirm the column mappings
    Parent ID number - Parent ID number
    ID number - ID number
    Short name - Short name
    Description - Description
    Description format - Description format
    Scale values - Scale values
    Scale configuration - Scale configuration
    Rule type (optional) - Rule type (optional)
    Rule outcome (optional) - Rule outcome (optional)
    Rule config (optional) - Rule config (optional)
    Cross-referenced competency ID numbers - Cross-referenced competency ID numbers
    Exported ID (optional) - Exported ID (optional)
    Is framework - Is framework
    Taxonomy - Taxonomy

    4 - When I hit "Confirm", I'm taken back to the "Import competency framework" showing the message "File format is invalid."

    I would add all the competencies manually, but there are over 1000 of them.
    I do really need help with this import. So, any suggestions are apreciated.
Please login to post comments