Feature #17739
openEmbedding docs from Word in Microsoft 365 Cloud
0%
Description
Hi All,
As you may or may not know, CUNY has been transitioning all faculty, staff, and students to Microsoft Office 365 cloud. So instead of having Microsoft Office software, everyone now gets these tools and saves docs etc in the 365 cloud.
Someone in a training asked about embedding the Live cloud-hosted word docs into a commons site, similar to how Google docs works, so that when they update their Word doc the commons embed is also updated. This is different from how Word and the Commons works now, where faculty have to upload the static document.
Some examples of sharing links from a test cloud-hosted word doc:
<iframe src="https://cuny907-my.sharepoint.com/personal/laurie_hurson91_login_cuny_edu/_layouts/15/Doc.aspx?sourcedoc={96b7fb55-e6e5-4108-958b-7b002bdb593e}&action=embedview" width="476px" height="288px" frameborder="0">This is an embedded <a target="_blank" href="https://office.com">Microsoft Office</a> document, powered by <a target="_blank" href="https://office.com/webapps">Office</a>.</iframe>
Files
Updated by Raymond Hoh 3 months ago
- Status changed from New to Testing Required
Hi Laurie,
I've setup the OneDrive plugin on cdev.
To test:
1. Activate the "OneDrive" plugin on a site
2. Create a new post and add the "OneDrive" block
3. Copy the sharing link for your OneDrive file. Ensure the sharing link was created with the "Anyone with the link can view" option. See https://github.com/hwdsb/onedrive/wiki/Sharing-a-file-and-getting-the-link.
4. Paste the sharing link into the block. That should be it!
Let me know if that works for you.
One important thing to note is only Word, Excel, Powerpoint and Visio files can be directly embedded when using OneDrive from SharePoint / Microsoft 365. If embedding from a OneDrive Personal account, you can also embed audio, video and images.
Boone, it's also possible for a user to select a file from OneDrive directly from the block, but this requires setting up an Azure app. See https://github.com/hwdsb/onedrive/wiki/File-Picker-Set-Up. This will probably require some bureaucratic hurdles to jump through, so I think it's not imperative to set this up at this time.
Updated by Boone Gorges 3 months ago
Boone, it's also possible for a user to select a file from OneDrive directly from the block, but this requires setting up an Azure app. See https://github.com/hwdsb/onedrive/wiki/File-Picker-Set-Up. This will probably require some bureaucratic hurdles to jump through, so I think it's not imperative to set this up at this time.
Thanks for this! I agree that we shouldn't pursue at the moment.
Updated by Laurie Hurson 3 months ago
- File Recording #19.mp4 Recording #19.mp4 added
Hi Ray,
I am not sure what I am doing wrong but my Word file isn't visible when I share. See video attached.
This is the "anyone can view" link Word gave me, and it works when you open in a browser but not through the plugin block.
Thanks for your help with this.
Updated by Raymond Hoh 3 months ago
Hi Laurie,
I think the issue here is with the way the cuny907
SharePoint install has configured embedding to require users to sign in to their Microsoft 365 account. What happens when you login? Are you able to see the embedded Word document?
Updated by Laurie Hurson 3 months ago
- File Recording #20.mp4 Recording #20.mp4 added
Hi Ray,
Test this again with the additional step of trying to log in and the Commons or onedrive does not seem to recognize the sign in. What i mean is that even once I have logged in, the block still displays "login" screen. See video or here on cdev: https://sitetest4.commons.gc.cuny.edu/2023/03/09/one-drive-test-2/
This isn't pressing, maybe something we can work toward figuring out for the Fall.
Updated by Raymond Hoh 3 months ago
- File 2023-03-09_113532.png 2023-03-09_113532.png added
Hi Laurie,
I'm able to see your test embed. See attached screenshot.
I think the issue is due to how Firefox is blocking third-party cookies. Can you try either allowing third-party cookies temporarily in Firefox or adding a cookie exception for the cuny907-my.sharepoint.com
domain?
In Firefox, you can add a cookie exception for a domain by:
1. Going to the address bar and navigating to about:preferences#privacy
.
2. Scroll down to "Cookies and Site Data"
3. Click on the "Manage Exceptions" button
4. Add the cuny907-my.sharepoint.com
domain and either press the "Allow for Session" or "Allow" button and save.
5. Next, reload the page to see if the embed is working.
You can also test by using another browser like Google Chrome or Microsoft Edge with third-party cookies allowed.