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

Database: Excel export of URL field produces file with garbled text

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Critical Critical
    • 2.1
    • 1.9.5, 2.0.3
    • Database activity module
    • None
    • MOODLE_19_STABLE, MOODLE_20_STABLE
    • MOODLE_21_STABLE
    • MDL-19864_database_excel_export
    • Hide

      Start with MDLQA-964 - if you are adventurous try exporting the Modules and Plugins database as an xls and see what happens. Actually I tried exporting as CSV and ODS and also had problems with both of those. Peace - Anthony

      Show
      Start with MDLQA-964 - if you are adventurous try exporting the Modules and Plugins database as an xls and see what happens. Actually I tried exporting as CSV and ODS and also had problems with both of those. Peace - Anthony

      I'm not sure what Excel needs to have done in order to export the URL. It would be good to have both the URL and the text associated with it if autolink is selected. Currently the export function (defined in /mod/data/field/url/field.class.php) returns the text of the URL concatenated with a space and then the text of the field. If an introductory space is added then things work fine in Excel however it is not an active hyper link in the excel file at that point. I'll ask in the developer forum to see if anyone else has any insights and then work toward a patch. Peace - Anthony

        1. grep for excel in codebase.txt
          17 kB
        2. MDL-19864-orig.png
          MDL-19864-orig.png
          194 kB
        3. MDL-19864-withspace.xls.png
          MDL-19864-withspace.xls.png
          250 kB

            andyjdavis Andrew Davis
            aborrow Anthony Borrow
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Rajesh Taneja Rajesh Taneja
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

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