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.

17 Replies

  • 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. 

  • 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. I am having the same issue. Thanks Jose for the info about sending a feature request. I have now done this. 

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

  • 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.

  • 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.

     

    • SamHill's avatar
      SamHill
      Super Hero

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

      Great extension!

    • AnneWierum-15ad's avatar
      AnneWierum-15ad
      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.

  • 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?

    • StevenBenassi's avatar
      StevenBenassi
      Staff

      Hi AnneWierum-15ad​!

      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.

      • AnneWierum-15ad's avatar
        AnneWierum-15ad
        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!