SharePoint 2007: Configure the Document Library Document Opening before the migratation to SP Online

Question

When you are working on migration project from SP2007 (it's the end of it's life, but still exist in production), you have to fight with the file opening settings to support the Office Web Application solution.
SP 2007 is not basically supporting the Office Web Apps but there is a tip to know to support that after migration without change the settings manually in SPO for each doclib.
&nbsp;
From the SharePoint 2007 site
You can change that settings with the SharePoint 2007 web page, via the option:

Document library Settings &gt; Advanced Settings
&nbsp;

You have to select the second option "Display as a Web Page” which will be supported in SPO after the migration:

&nbsp;
&nbsp;
&nbsp;
&nbsp;From&nbsp;PowerShell
The other option to use is the following script which will do that change into all site/subsites for all the existing DocLib from a given SP2007:
&nbsp;

function Check-DocumentLibraryOpenSettings([string]$SiteCollectionURL) {&nbsp;&nbsp;&nbsp;&nbsp; [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") &gt; $null
&nbsp;&nbsp;&nbsp;&nbsp; Write-Host " -------------------------------------------------------- "&nbsp;&nbsp;&nbsp;&nbsp; Write-Host "Site collection URL to configure:", $SiteCollectionURL&nbsp; -foregroundcolor Red&nbsp;&nbsp;&nbsp;&nbsp; $Thesite = new-object Microsoft.SharePoint.SPSite($SiteCollectionURL)
&nbsp;&nbsp;&nbsp; #Loop all Sub Sites&nbsp;&nbsp;&nbsp;&nbsp; foreach($Web in $TheSite.AllWebs)&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Write-Host "-----------------------------------------------------"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Write-Host "Site Name: '$($web.Title)' at $($web.URL)"&nbsp; -foregroundcolor green&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Write-Host "-----------------------------------------------------"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; foreach($list in $Web.Lists)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; #Filter Doc Libs, Eliminate Hidden ones&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(($List.BaseType -eq "DocumentLibrary") -and ($List.Hidden -eq $false) )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Write-Host "List Name: '$($List.Title)'", "- Open Option before the change:", $List.DefaultItemOpen&nbsp; -foregroundcolor Magenta
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $List.DefaultItemOpen =&nbsp; [Microsoft.SharePoint.DefaultItemOpen]::Browser; #Mode Web Application&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; #$List.DefaultItemOpen =&nbsp; [Microsoft.SharePoint.DefaultItemOpen]::PreferClient; #Mode&nbsp;MS Office rich client&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $List.Update();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp; Write-Host " -------------------------------------------------------- "&nbsp;&nbsp;&nbsp;&nbsp;  }
cls Check-DocumentLibraryOpenSettings “http://myWebApplication2007/sites/MySiteCollection”

&nbsp;
When you do that change, you can use your Migration tool to push the doclibs in SPO
&nbsp;
Fabrice Romelard [MVP]
&nbsp;
Original post in french:

Office 365: Comment configurer l’ouverture des fichiers stockés dans une Document Library

&nbsp;
Other references used:

https://social.technet.microsoft.com/Forums/lync/en-US/8b85e2cd-0cde-4a03-97fc-beec2738d6d9/sharepoint-2007-configure-the-default-behaviour-for-browserenabled-documents?forum=sharepointadminlegacy
https://social.msdn.microsoft.com/Forums/office/en-US/8773ec96-556d-4389-8d8d-9f35c5709324/get-all-document-libraries-folderitems-in-a-site-collection-using-power-shell?forum=sharepointadminprevious

fromelard · Answer

Another associated tip if you have document library with many files in Checked out mode:
&nbsp;-&nbsp;http://blogs.developpeur.org/fabrice69/archive/2018/02/19/sharepoint-2007-forcer-le-check-in-des-fichiers-avant-la-migration-vers-sharepoint-online.aspx
&nbsp;
You will find 2 functions you can adapt and use before the content migration.
Fab

Forum Discussion

SharePoint 2007: Configure the Document Library Document Opening before the migratation to SP Online

Share

Resources