Forum Discussion

JoanneBentley-b's avatar
JoanneBentley-b
Community Member
2 years ago

How do you export your RISE Dashboard of courses to Excel?

My boss wants a full list of courses on my dashboard from the past 5 years which is ~400 courses and microbursts. I need title, when they were developed, how many lessons, etc. I've started doing it by hand but figure there must be a shortcut to summarize 20 pages from dashboard view.

19 Replies

  • AnneW1's avatar
    AnneW1
    Community Member

    I can get this to work but only for the 16 courses that display per page in Rise. We have 65 courses, so I have to navigate to each page of 16 courses, run this extension, and copy and paste into a master Excel file. How do you display all your Rise courses on one web page if there are more than 16 courses?

    • Hi AnneW1​!

      I understand you're looking to display more Rise 360 content within the dashboard.

      I noticed that you've also opened a support case, and connected with my teammate John Carlo. As he shared, currently the Rise 360 dashboard can only display up to 16 courses per page. Rise 360 also does not currently support a feature to export a list of your Rise 360 courses.

      Not to worry! We've shared your feedback and requests with our product team. We'll be sure to notify you if these enhancements make it to our product roadmap.

      • AnneW1's avatar
        AnneW1
        Community Member

        Hello, I think this request has been out there for over a year, realistically, do you think it will happen in the next few months? Also, is the Chrome extension Articulate Rise Helper as a workaround to this something you guys did? because that is also not working for me. Thanks!

      • PrasoonN's avatar
        PrasoonN
        Partner

        Just checked it is working fine. What exact problem are you facing.

        Also do this :
        1. open your rise page

        2. open the plugin

        3. refresh the page once

        4. You will see "Page1" marked in the widget. 

        In case this does not work out, share a recording of the same to see and analyze. 

    • AnneW1's avatar
      AnneW1
      Community Member

      Hi, I have installed this extension but cannot get it to work. It is not adding the pages to the "pages processed" window.

    • SamHill's avatar
      SamHill
      Super Hero

      I can confirm this works on grid view but not list view.

      Great extension!

  • Here's a method using a Bookmarklet. This is just a special bookmark that executes JavaScript.

    Simply open your browser, and create a new bookmark. In Chrome, this is done via the Bookmark Manager (CTL+SHIFT+O) and then selecting Add new bookmark via the menu in the top right (three vertical dots). Just give it a Name, for example Get Courses, and then copy and past the following code into URL field.

    javascript:(function(){let csvData="Course Title,Author,Updated Date,Lesson Count\n";const formatText=(textElement)=>{let text=textElement?.textContent||%27%27;return%20text.replaceAll(%27,%27,%27%27).replaceAll(%27%C2%B7%27,%27%27).replaceAll(%27%C2%A0%27,%27%27).trim();};document.querySelectorAll(%27[aria-label=%22courses%22]%20li%27).forEach(course=%3E{const%20details=course.querySelectorAll(%27div%27)[0];const%20author=formatText(details.querySelector(%22[class*=content-author_authorName]%22));const%20updated=formatText(details.querySelector(%22[class*=block-view-item-common_updated]%22));const%20title=formatText(details.querySelector(%22[data-ba=\%22create.link\%22]%22));const%20lessonCount=formatText(details.querySelector(%22[data-ba=\%22ContentTypeLabel.lessonCount\%22]%22));csvData+=`${title},${author},${updated},${lessonCount}\n`;});const%20csvContent=%22data:text/csv;charset=utf-8,%22+encodeURIComponent(csvData);window.open(csvContent);})();

    You can then navigate to the Rise course library and select the Bookmarklet.

     

  • We have a chrome extension that helps us download all this data as a CSV file

    • SamHill's avatar
      SamHill
      Super Hero

      Is that something you can share with the public?

      • PrasoonN's avatar
        PrasoonN
        Partner

        Sure, I will ask my team to deploy it as a chrome extension. Will update here once done.

  • HilaryHudson's avatar
    HilaryHudson
    Community Member

    Agreed that this is a needed and basic expected feature of a system such as Articulate.  I too have made a request.  

  • Hi Joanne. I am having the same issue. Thanks Jose for the info about sending a feature request. I have now done this. 

  • That is a real shame. Any hope that this feature will be added soon? Being able to export a dashboard to excel shouldn't be a big ask.

  • Hi Joanne,

    There isn't a way to export course titles and lesson counts into Excel from the dashboard. I hope some of our community members will chime in if they have found a solution for this.