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

HTML should be stripped from report builder CSV export

XMLWordPrintable

    • 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

      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?

            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

              Created:
              Updated:
              Resolved:

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

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