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:
      100
    • Rank:
      164
    • 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.

        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 Škoda made changes -
          Status Waiting for testing [ 10005 ] Testing in progress [ 10011 ]
          Petr Škoda 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 Škoda made changes -
          Status Waiting for testing [ 10005 ] Testing in progress [ 10011 ]
          Petr Škoda 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 Škoda 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