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

    • Icon: Improvement Improvement
    • Resolution: Won't Do
    • Icon: Minor Minor
    • None
    • 2.3.2
    • Database activity module
    • MOODLE_23_STABLE
    • wip-MDL-36274-master
    • 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.

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

            Unassigned Unassigned
            abgreeve Adrian Greeve
            Damyon Wiese Damyon Wiese
            Sam Hemelryk Sam Hemelryk
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.