Forum Discussion
JoanneBentley-b
12 months agoCommunity Member
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...
SamHill
2 months agoSuper Hero
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.