Link to home
Start Free TrialLog in
Avatar of Buzz yates
Buzz yatesFlag for United States of America

asked on

SharePoint Online (MS365) - Documents with Embedded url

We are in the process of Migrating our documents from MOSS 2007 to MS365's SharePoint Online.  We have thousands of documents with embedded URLs.   I need a way to mass change these urls because I believe a DNS aliasing will not work.   An example is below.

Embedded url in a work or excel spreadsheet:   http://PHQ327/stores/DeptDoc/Pages/EmergencyProcedures.docx 


What it needs to be corrected to:  https://PHQ327.sharepoint.com/sites/PHQ327/stores/DeptDoc/Pages/EmergencyProcedures.docx
Avatar of Jamie McAllister
Jamie McAllister
Flag of Switzerland image

There's a community Powershell script here that does this when the documents are in place;

https://mysharepointexclusive.wordpress.com/2013/08/30/programmatically-update-embded-hyperlink-on-a-document-on-sp-document-library-with-powershell/

Not perfect for you of course, O365 restricts your Powershell options. You'd have to change it to work;

https://technet.microsoft.com/en-us/magazine/hh750396.aspx

Or you could code an equivalent process (STSADM or other code) in your 2007 install before migration.

Not aware of a tool that would do it during the migration itself.

One other option highlighted here is to use 'Pipetools' to do the replace, referencing the files via filepath notation. Not sure that'd work or scale but hey;

https://social.technet.microsoft.com/Forums/office/en-US/e46ad947-ba6a-4a30-bbf0-c17d26edcb14/embedded-links-inside-of-word-documents-in-sp-document-library?forum=sharepointgenerallegacy
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.