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

HTML should be stripped from report builder CSV export

    XMLWordPrintable

Details

    • MOODLE_400_STABLE
    • MOODLE_400_STABLE
    • Hide

      Custom reports

      1. Log in as admin
      2. Create some new users
      3. Navigate to Reports > Report builder > Custom reports in site administration
      4. Create a new report from Users report source
        • Ensure Include default setup is unchecked
      5. In report editor, add the following columns:
        • User > Full name with link
        • User > Surname
        • User > Email address
      6. Press Preview
      7. Download report as Portable Document Format (.pdf)
      8. Open downloaded PDF
      9. Confirm the Full name with link column contains HTML tags (links to the user profile)
      10. Download report as Comma separated values (.csv)
      11. Open downloaded CSV
      12. Confirm the Full name with link column does not contain HTML tags
      13. Close the editor

      System reports

      1. Log in as admin
      2. Navigate to Reports > Config changes in site administration
      3. Download report as Portable Document Format (.pdf)
      4. Open downloaded PDF
      5. Confirm the Full name with link column contains HTML tags (links to the user profile)
      6. Download report as Comma separated values (.csv)
      7. Open downloaded CSV
      8. Confirm the Full name with link column does not contain HTML tags
      Show
      Custom reports Log in as admin Create some new users Navigate to Reports > Report builder > Custom reports in site administration Create a new report from Users report source Ensure Include default setup is unchecked In report editor, add the following columns: User > Full name with link User > Surname User > Email address Press Preview Download report as Portable Document Format (.pdf) Open downloaded PDF Confirm the Full name with link column contains HTML tags (links to the user profile) Download report as Comma separated values (.csv) Open downloaded CSV Confirm the Full name with link column does not contain HTML tags Close the editor System reports Log in as admin Navigate to Reports > Config changes in site administration Download report as Portable Document Format (.pdf) Open downloaded PDF Confirm the Full name with link column contains HTML tags (links to the user profile) Download report as Comma separated values (.csv) Open downloaded CSV Confirm the Full name with link column does not contain HTML tags

    Description

      When exporting a reportbuilder table it includes any html like links to user profile fields etc.

      While we could implement if is_downloading checks on each column it seems like it would be more efficient to strip html from all columns when exporting to csv.

      pholden it would be good to hear your thoughts on this?

      Attachments

        Issue Links

          Activity

            People

              pholden Paul Holden
              danmarsden Dan Marsden
              Mikel Martín Corrales Mikel Martín Corrales
              Sara Arjona (@sarjona) Sara Arjona (@sarjona)
              Angelia Dela Cruz Angelia Dela Cruz
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours, 25 minutes
                  2h 25m

                  Clockify

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