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

Check database module fields with more than one value for different types of delimiters when importing into the database module.

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide
      1. Create a database activity.
      2. Create at least two fields (Latitude/longitude and Url - Enable 'Autolink the URL').
      3. Save the default templates.
      4. You may want to add an entry into the database and export your entries so that you have something to work with. (Make sure that you save it as a csv).
      5. Alter the csv file and try the following:
      • lat/long with a comma separator (-31.8747,115.9837)
      • lat/long with commas (-31,8747,115,9837)
      • lat/long with a space (-31.8747 115.9837) existing behaviour.
      • lat/long with a colon (-31.8747:115.9837)
      • lat/long with a pipe symbol (-31.8747|115.9837)
      • lat/long with whole numbers separated by a comma (55,33)
      • A Url with a space between the link and the title (www.google.com google)
      • A Url with a tab between the link.
      • A Url with a pipe symbol between the link.
        Make sure that the above combinations are imported with no problems into the database activity.

      Please note that this patch doesn't include every possible delimiter that you might be able to conceive of. This patch is only designed to include likely possibilities.

      Show
      Create a database activity. Create at least two fields (Latitude/longitude and Url - Enable 'Autolink the URL'). Save the default templates. You may want to add an entry into the database and export your entries so that you have something to work with. (Make sure that you save it as a csv). Alter the csv file and try the following: lat/long with a comma separator (-31.8747,115.9837) lat/long with commas (-31,8747,115,9837) lat/long with a space (-31.8747 115.9837) existing behaviour. lat/long with a colon (-31.8747:115.9837) lat/long with a pipe symbol (-31.8747|115.9837) lat/long with whole numbers separated by a comma (55,33) A Url with a space between the link and the title (www.google.com google) A Url with a tab between the link. A Url with a pipe symbol between the link. Make sure that the above combinations are imported with no problems into the database activity. Please note that this patch doesn't include every possible delimiter that you might be able to conceive of. This patch is only designed to include likely possibilities.
    • Affected Branches:
      MOODLE_23_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      wip-MDL-36274-master

      Description

      Currently when importing coordinates and urls into the database module the only delimiter accepted is a space.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              abgreeve Adrian Greeve
              Peer reviewer:
              Damyon Wiese
              Integrator:
              Sam Hemelryk
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated: