Moodle
  1. Moodle
  2. MDL-13114

Include bulk course create and remove with Moodle through the use of CSV files

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: 1.8.4, 1.9.10, 2.0.1, 2.3.2, 2.4, 2.5
    • Fix Version/s: 2.6
    • Component/s: Administration
    • Environment:
      Redhat Enterprise 4AS running Apache 2.2.x, MySQL 5, and Moodle 1.8.x and Moodle 1.9.xbeta
    • Database:
      MySQL
    • Testing Instructions:
      Hide
      1. Create a CSV to import data from
      2. Navigate to Home / Site administration / Courses / Upload courses
      3. TEST: Different combinations of settings
      4. TEST: Different combinations of CSV data (https://tracker.moodle.org/browse/MDL-13114?focusedCommentId=231131&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-231131)
      5. Make sure
        • Expected errors occurred
        • Update/Create/Delete/Rename, etc... worked when no errors occurred

      Repeat using the command line tool.

      Show
      Create a CSV to import data from Navigate to Home / Site administration / Courses / Upload courses TEST : Different combinations of settings TEST : Different combinations of CSV data ( https://tracker.moodle.org/browse/MDL-13114?focusedCommentId=231131&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-231131 ) Make sure Expected errors occurred Update/Create/Delete/Rename, etc... worked when no errors occurred Repeat using the command line tool.
    • Affected Branches:
      MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE, MOODLE_25_STABLE
    • Fixed Branches:
      MOODLE_26_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      MDL-13114-master
    • Story Points (Obsolete):
      100
    • Sprint:
      BACKEND Sprint 2

      Description

      We're looking to Moodle for a replacement to Blackboard Enterprise. In order for Moodle to be a viable replacement we need a way to bulk create and delete courses based on CSV files. The bulk create courses is handled by use of a 3rd party module (uploadcourse.php created by Rory Allford). However once we import say 700+ courses there's no way to them bulk remove them at the end of a semester (removing 1 by 1 would be too time consuming). We would really prefer that this functionality be included within Moodle, as relying on 3rd party modules (no matter how good they are), inherits a risk if the module stops getting updated.

        Gliffy Diagrams

          Issue Links

            Activity

            Greg Rodenhiser created issue -
            Marc Grober made changes -
            Field Original Value New Value
            Link This issue has been marked as being related by CONTRIB-605 [ CONTRIB-605 ]
            Anthony Borrow made changes -
            Link This issue will be resolved by MDL-17017 [ MDL-17017 ]
            Caroline Moore made changes -
            Link This issue is duplicated by MDL-14341 [ MDL-14341 ]
            Jason Hollowell made changes -
            Attachment uploadcourse.php [ 20298 ]
            Martin Dougiamas made changes -
            Workflow jira [ 24496 ] MDL Workflow [ 42951 ]
            Anthony Borrow made changes -
            Fix Version/s DEV backlog [ 10464 ]
            Affects Version/s 2.0.1 [ 10420 ]
            Affects Version/s 1.9.10 [ 10407 ]
            Martin Dougiamas made changes -
            Workflow MDL Workflow [ 42951 ] MDL Full Workflow [ 71356 ]
            Paul Fynn made changes -
            Link This issue is duplicated by MDL-24881 [ MDL-24881 ]
            Michael de Raadt made changes -
            Priority Minor [ 4 ] Critical [ 2 ]
            David Mudrak made changes -
            Assignee Martin Dougiamas [ dougiamas ] David Mudrak [ mudrd8mz ]
            Michael Spall made changes -
            Affects Version/s 2.3.2 [ 12353 ]
            Affects Version/s 2.3.3 [ 12373 ]
            Affects Version/s 2.4 [ 12255 ]
            Michael de Raadt made changes -
            Issue Type New Feature [ 2 ] Improvement [ 4 ]
            Labels patch triaged
            Affects Version/s 2.4 [ 12255 ]
            Affects Version/s 2.3.3 [ 12373 ]
            Dan Marsden made changes -
            Assignee David Mudrak [ mudrd8mz ] Dan Marsden [ danmarsden ]
            Martin Dougiamas made changes -
            Fix Version/s DEV Current [ 12256 ]
            Martin Dougiamas made changes -
            Status Open [ 1 ] Waiting for peer review [ 10012 ]
            Dan Marsden made changes -
            Pull Master Diff URL https://github.com/piersharding/moodle-tool_uploadcourse
            Pull Master Branch master
            Séverin Terrier made changes -
            Link This issue has a non-specific relationship to MDL-38501 [ MDL-38501 ]
            Martin Dougiamas made changes -
            Fix Version/s BACKEND [ 12582 ]
            Fix Version/s DEV Current [ 12256 ]
            Derek Chirnside made changes -
            Affects Version/s 2.5 [ 12452 ]
            Affects Version/s 2.4 [ 12255 ]
            moodle.com made changes -
            Story Points 40
            moodle.com made changes -
            Rank Ranked higher
            Michael de Raadt made changes -
            Sprint BACKEND Sprint 1 [ 2 ]
            Frédéric Massart made changes -
            Original Estimate 0 minutes [ 0 ]
            Remaining Estimate 0 minutes [ 0 ]
            Status Waiting for peer review [ 10012 ] Peer review in progress [ 10013 ]
            Peer reviewer fred
            Frédéric Massart made changes -
            Status Peer review in progress [ 10013 ] Development in progress [ 3 ]
            Dan Marsden made changes -
            Assignee Dan Marsden [ danmarsden ] Frédéric Massart [ fred ]
            Michael de Raadt made changes -
            Rank Ranked lower
            Michael de Raadt made changes -
            Sprint BACKEND Sprint 1 [ 2 ]
            Michael de Raadt made changes -
            Rank Ranked higher
            moodle.com made changes -
            Story Points 40 100
            Michael de Raadt made changes -
            Sprint BACKEND Sprint 2 [ 4 ]
            Frédéric Massart made changes -
            Labels patch triaged docs_required patch qa_test_required triaged
            Frédéric Massart made changes -
            Testing Instructions # Create a CSV to import data from
            # Navigate to Home / Site administration / Courses / Upload courses
            # *TEST*: Different combinations of settings
            # *TEST*: Different combinations of CSV data
            # *Make sure*
            #- Expected errors occurred
            #- Update/Create/Delete/Rename, etc... worked when no errors occurred
            Frédéric Massart made changes -
            Status Development in progress [ 3 ] Waiting for peer review [ 10012 ]
            Dan Poltawski made changes -
            Status Waiting for peer review [ 10012 ] Peer review in progress [ 10013 ]
            Peer reviewer fred poltawski
            Dan Poltawski made changes -
            Status Peer review in progress [ 10013 ] Development in progress [ 3 ]
            Dan Poltawski made changes -
            Labels docs_required patch qa_test_required triaged docs_required patch qa_test_required triaged ui_change
            Frédéric Massart made changes -
            Status Development in progress [ 3 ] Waiting for peer review [ 10012 ]
            Frédéric Massart made changes -
            Status Waiting for peer review [ 10012 ] Waiting for integration review [ 10010 ]
            Sam Hemelryk made changes -
            Currently in integration Yes [ 10041 ]
            Marina Glancy made changes -
            Status Waiting for integration review [ 10010 ] Integration review in progress [ 10004 ]
            Integrator marina
            Frédéric Massart made changes -
            Testing Instructions # Create a CSV to import data from
            # Navigate to Home / Site administration / Courses / Upload courses
            # *TEST*: Different combinations of settings
            # *TEST*: Different combinations of CSV data
            # *Make sure*
            #- Expected errors occurred
            #- Update/Create/Delete/Rename, etc... worked when no errors occurred
            # Create a CSV to import data from
            # Navigate to Home / Site administration / Courses / Upload courses
            # *TEST*: Different combinations of settings
            # *TEST*: Different combinations of CSV data
            # *Make sure*
            #- Expected errors occurred
            #- Update/Create/Delete/Rename, etc... worked when no errors occurred

            Repeat using the command line tool.
            Marina Glancy made changes -
            Status Integration review in progress [ 10004 ] Waiting for testing [ 10005 ]
            Fix Version/s 2.6 [ 12579 ]
            Fix Version/s DEV backlog [ 10464 ]
            Fix Version/s BACKEND [ 12582 ]
            Frédéric Massart made changes -
            Testing Instructions # Create a CSV to import data from
            # Navigate to Home / Site administration / Courses / Upload courses
            # *TEST*: Different combinations of settings
            # *TEST*: Different combinations of CSV data
            # *Make sure*
            #- Expected errors occurred
            #- Update/Create/Delete/Rename, etc... worked when no errors occurred

            Repeat using the command line tool.
            # Create a CSV to import data from
            # Navigate to Home / Site administration / Courses / Upload courses
            # *TEST*: Different combinations of settings
            # *TEST*: Different combinations of CSV data (https://tracker.moodle.org/browse/MDL-13114?focusedCommentId=231131&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-231131)
            # *Make sure*
            #- Expected errors occurred
            #- Update/Create/Delete/Rename, etc... worked when no errors occurred

            Repeat using the command line tool.
            David Monllaó made changes -
            Tester skodak
            Petr Skoda made changes -
            Status Waiting for testing [ 10005 ] Testing in progress [ 10011 ]
            Petr Skoda made changes -
            Status Testing in progress [ 10011 ] Problem during testing [ 10007 ]
            Frédéric Massart made changes -
            Link This issue has a non-specific relationship to MDL-40728 [ MDL-40728 ]
            Marina Glancy made changes -
            Status Problem during testing [ 10007 ] Waiting for testing [ 10005 ]
            Petr Skoda made changes -
            Status Waiting for testing [ 10005 ] Testing in progress [ 10011 ]
            Petr Skoda made changes -
            Status Testing in progress [ 10011 ] Tested [ 10006 ]
            Frédéric Massart made changes -
            Link This issue blocks MDL-40737 [ MDL-40737 ]
            Frédéric Massart made changes -
            Link This issue has a non-specific relationship to MDL-40737 [ MDL-40737 ]
            Frédéric Massart made changes -
            Link This issue blocks MDL-40737 [ MDL-40737 ]
            Damyon Wiese made changes -
            Status Tested [ 10006 ] Closed [ 6 ]
            Resolution Fixed [ 1 ]
            Currently in integration Yes [ 10041 ]
            Integration date 19/Jul/13
            Petr Skoda made changes -
            Link This issue caused a regression MDL-40898 [ MDL-40898 ]
            Sam Hemelryk made changes -
            Link This issue has been marked as being related by MDL-40903 [ MDL-40903 ]
            Frédéric Massart made changes -
            Labels docs_required patch qa_test_required triaged ui_change patch qa_test_required triaged ui_change
            Helen Foster made changes -
            Labels patch qa_test_required triaged ui_change patch triaged ui_change

              Dates

              • Created:
                Updated:
                Resolved:

                Agile