Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-14442

Improvements importing into database activity when using CSV files produced by export

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9, 1.9.1
    • Fix Version/s: 1.9.2
    • Labels:
      None
    • Database:
      Any
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      People have been asking for exporting all possible records of a database activity as a CSV file since one year. "All possible records" are all records from field types other than "file" or "picture". Dan Poltawski finally submitted this patch yesterday at MDL-8407. I have re-submitted it including some bugfixes recently, as "MDL-8407-20080419.patch", which works fine against the latest Moodle 1.9+.

      The patch attached here allows you to use the exported CSV file to be used to import all the records. The current implementation failed to import some fields, such as multimenu and latlong.

      In addition, the import process should be less resource eating, since it avoids to read files that are not necessary and does not create mega-objects such like $currentfield. During the import process, there is output written to the browser what has actually been done.

        Attachments

        1. MDL-14442_addslashes_2.patch
          0.9 kB
          Robert Allerstorfer
        2. MDL-14442_error-checking.patch
          2 kB
          Robert Allerstorfer
        3. MDL-14442-20080421.patch
          3 kB
          Robert Allerstorfer
        4. MDL-14442-clean_param.patch
          2 kB
          Robert Allerstorfer

          Issue Links

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  11/Jul/08