Celebrate Excellence in Education: Nominate Outstanding Educators by April 15!
Hi,Community--
I need to download the "Communications" content (i.e. Inbox messages) between two users in a course - see Capture.JPG att'd. Does anyone know of a way to perform this from an "Admin" role on the front end? What about from the backend that will produce a useable file (not the API-generated JSON)?
Any information and help will be appreciated!
Thank you,
@JDW223
Tagging my colleague: @cjacobs
stefaniesanders - any chance you have a BP for this?
@JDW223 , downloading conversations/messages is not something I ever needed to do; perhaps a search through answered questions will bring you closer to a solution. In the meantime, I've shared your question with the Canvas Admins and Canvas Developers groups to get additional eyes on it.
Thank you, stefaniesanders. We found a 2018 Q&A thread on the topic, but no answer described a BP with usable data. I'll keep track in the groups you tagged. - Jeanna
We found the content in "Admin Tools" > "View Notifications". I've added the Idea: https://community.canvaslms.com/ideas/16565-admin-tools-exporting-view-notifications to open discussion on adding an export feature. Thanks, all. - Jeanna
That is for Notifications. I have not seen how to download messages/conversations.
@JDW223 Thanks for including me!
The JSON that comes from the API is usable, it's just not human-friendly. It is much more usable than a text dump of the comments that you would then have to go through and parse to extract specific information.
Canvas leaves the formatting up to us. How you want it to look is probably not how I want it to look. For example, you may want it in a printout that looks like an email thread with subject line, from, to, and message. I may want it in an Excel spreadsheet so I can sort it by date or quickly count the number of messages or make a graph of how spread out they were.
JSON is all you're going to get through the API as the API is meant for computers to understand. The Canvas Admin reports generate CSV files, but those aren't directly usable. Canvas Data provides the information in a database format that you can query against. All of these require you to manipulate it to make it human friendly.
Thankfully, JSON is well supported. Recent versions of Excel can work with JSON files although I find it easier to go ahead and convert it to CSV or native Excel format first. There are a lot converters already written to convert JSON into another format. I've seen online converters for JSON to Excel, PDF, CSV, HTML, Word, and other formats. None of them are going to give you exactly what you want because it includes the field names and those have no inherent order like an email header (your email client decides what order to put the headers in when it shows them to you).
Getting it into Excel and then doing a mail merge with Word can get you a structured human-friendly document without having to write a program.
The problem there is scale. That works well for one or two pairings, but if you're going to have to do this a lot, then something (a program) to automatically download the conversations and prepare them in the format you want can save a lot of time.
Your screen appears to be from the old analytics -- it's been a while since I used the old analytics. Did it show the actual conversation or just the number of interactions?
The list conversations endpoint allows you to filter so you can get the messages to just a specific person. You would have to masquerade as one of the users.
There is also a List of CommMessages for a user endpoint that accesses the messages (emails, sms, twitter, etc) that have been sent to a user, but you would have to go through and check who the sender was when you were looking for a conversation between users (that's part of why JSON is useful). If a student had all external communications turned off, that might not be helpful. I haven't looked at it that much.
@cjacobs - see James's reply.
@James Thank You Unfortunately, the analytics version we have is only showing the number of interactions. I copied my colleague above, so we can discuss a new version, and she's more versed in the API - JSON - CSV realm of pulling the info and making it look human-friendly, haha. I hope we can find a solution to make it look more like the "email" format you describe above. Again, thank you!
The New Analytics just shows the counts as well. Don't make a rush to switch to it just for that. Generally, I find it less helpful than the old one, although it does have the ability to show which students have not viewed content and that was previously only available through the access report, which is one student at a time.
I was hoping that the old analytics might have shown the messages when you moused over it and that would give a shortcut way and getting the information. I didn't think it did, but I didn't have a way to test anymore.
They do not
Hi,
Where can I get this piece of code from? Are there any further documentation on how to use the API?
Thank you.
I must say, I object to the notation, "No one else has this question" because I've had that question for a long time, and I expect other people do too. Plus, unless, I mis-understood the question, it seems like lots of people have been asking essentially the same question online for years.
@tami , the notation "No one else has this question" is a member-driven message that was generated automatically by the software after no one clicked on "I also have this question" that displayed before the question received responses.
How we keep your questions flowing! goes into detail about how Q&A is facilitated in this forum.
Thanks for providing the links to other questions associated with this!
Hi Stefanie. Thank you for the explanation of "No one else has this question." How long does a question sit before that "I also have this question" goes away? I clicked on the link you provided but did not find anything explaining the "I also have this question" button.
Another Matter:
On that page https://community.canvaslms.com/groups/community/blog/2019/10/08/how-we-keep-your-questions-flowing , I found the categories of "Assumed Answered" interesting.
Thank you again,
Tami
Thank you for your thoughtful comments and helpful feedback! The Canvas Community will soon be moving to a different platform—you can read all about that in Canvas Community is Moving (Going Places).—and even though the UI and feature set will be different from what you see here, we'll definitely keep this in mind as we move forward.
It is surprising how ignorant the Canvas development team have been in the past few years to such a simple request. It essentially shouldn't take a developer in the team more than a couple of days to come up with this feature, but they still refuse to put it in the backlog.
@mahdimn ...
I understand the frustration...I've been there, too. I've wanted things developed that I thought were great idea, and I'm still waiting years later. I've also had some of my own ideas implemented by Instructure that I thought would never get developed (there just wasn't support from other Community members). But, for whatever reason, they decided to implement it. It sure would be nice if Instructure had all the resources in the world to develop everything we want, but that's just not reality. I would like to direct you to What is the feature development process for Instru... - Instructure Community (canvaslms.com). Specifically, check out the section on "If my idea doesn't align with a priority, is it still important?". What you and I might think is a simple fix or implementation...well, it might be just the opposite of that. The document I linked to explains more about that.
Not sure if this will help or not, but thought I'd provide that resource and some of my own personal experiences...for what it's worth. Take care, and be well.
To participate in the Instructure Community, you need to sign up or log in:
Sign In
This discussion post is outdated and has been archived. Please use the Community question forums and official documentation for the most current and accurate information.