Microsoft Collaboration, CTO viewpoint, and New York

The blog for Office 365, Power Apps, Flow, SharePoint, cloud, ….. plus a little NYC

You are currently browsing the Microsoft category.

Teams Versus Groups

Increasing the speed of Office 365 search crawl

With SharePoint on premise there’s plenty of search options to increase the frequency of the search crawl, to the search results show up quicker.

– Increase the incremental search periods

– Add on an app server to take on the additional search horse power

– Target sites or site collections that require quicker search crawls

The list can go on….

 

But with Office 365, this ability isn’t there..

Chris O’Brien has a good explanation on this: waiting-for-search-crawl-in-office-365 with some work arounds, but queries can break.

 

One approach I discovered was to set the server resource quota to 10,000. By default it’s 300. This setting can be found in the SharePoint Admin Center.

https://tentant.sharepoint.com/_layouts/15/online/SiteCollections.aspx

 

 

When I did this I was getting search results in 5-10 mins after a document was uploaded.

 

 

 

 

 

 

 

 

 

 

So your Office Web Apps isn’t working….Suddenly stopped working

This happened to me the other day.

So how to troubleshoot… Look in the ULS logs.

To configure office web apps you’ll need:

-Office Web Apps Farm Internal URL:
-Office Web Apps Farm External URL
-CertificateName
-AllowHttpSecureStoreConnections
-AllowHttp

For me it turned out to be the certificate.

I found errors in Office Web Apps ULS logs, so I had also run Get-OfficeWebAppsFarm command which showed me the same error that the computer is not part of an Office Web Apps Server Farm. So I tried creating new farm using New-OfficeWebAppsFarm comment yesterday where I used “*.domainname.com” as certificate name in this command, but I got error that certificate was not found. Then today I used the friendly name of certificate and it worked.

New-OfficeWebAppsFarm -InternalUrl “https://sharewap.greenpages.com” -ExternalUrl “https://sharewap.domainname.com” -CertificateName ” domainnameDigiCert Wildcard” -EditingEnabled

This problem usually happens due to windows updates getting installed on Office web apps server.

10 things a SharePoint Architect should know before they go contracting

This was a presentation that I did at SharePoint Saturday Boston 2016

SharePoint – How to go contracting from Peter Ward

 

Microsoft SharePoint 2013 Disaster Recovery Guide

The name of the game in of this SharePoint book is SharePoint Disaster Recovery (DR), which also falls into the category of business continuity or high availability. The depth and breadth of the SharePoint DR can be quite daunting because often the reader is new to SharePoint and does not quite know how the pieces of the puzzle all fit together and is facing the challenge of determining how to implement a DR within their organization.

This book is structured to fill in the SharePoint knowledge gaps of how to apply a SharePoint DR approach that is documented, easy to understand and is executable.

By applying knowledge from each chapter, this book will demystify the DR process and you will learn how to identify risk and appropriate DR approaches, and out of the box SharePoint tools for your DR plans.

2012: A Year of Microsoft Milestones

Changing the URL in a Links list: How To

Problem:

You’ve just copied a link list template to another site collection, or performed a 2007 to 2010 migration and have realized that the all the urls in the list point to an old site and a mega cut and paste is required

So you think the data sheet can do the trick…. No

And MS Access can help….. Well no

I was surprised at this as well.

This post explains how to dump the list into Excel and run a macro to change the URL and then paste the new links into the list. This is easier than you think by using Excel a tool that you already have.

I’m not an Excel expert and there could be more elegant ways of doing this in Excel

Much of what is explained is in this Excel file: Example file

Steps:

Dump the list into Excel.

  1. Click on the Export to Excel from the Ribbon in Excel.

 

  1. Create a macro in Excel.

See short video. To see how to create a macro. This could be anything. What is key is to create a macro that you can edit. See figure below:

 

 

 

  1. Edit the macro. Click the edit button on the dialog.

And paste in the following, macro code.

Sub ReplaceText()

‘ ReplaceText Macro

‘ Keyboard Shortcut: Ctrl+r

 

Call ReplaceHyperlinkURL(“co.uk”, “com”)

End Sub

The code above when run will replace the “co.uk” part of a URL with “com”. This could be anything really.

  1. Run the macro from the dialog box

 

All the cells will be searched and if there’s a match, it will replace the text.

Now that the URL’s have been changed.

 

  1. Copy and paste the URL’s in Excel back into SharePoint, using the datasheet view.

You just need to paste the URL column.

Alternate Access Mapping- explained

From technet

Alternate Access Mappings (AAM) is a feature of SharePoint that allows a website to function correctly under different URL scenarios, including, reverse proxies and load balancing. In this video, Hilton Giesenow, host of http://www.themossshow.com/ SharePoint podcasts, demonstrates how to configure and make use of the this feature under different scenarios, including extending an existing site collection

Useful technet resources

Services architecture planning for SharePoint Server 2010
(http://technet.microsoft.com/library/cc560988%28office.14%29.aspx)

Add or remove a service application connection to a Web application (SharePoint Server 2010)
(http://technet.microsoft.com/en-us/library/ee704550.aspx)

 Logical architecture components for SharePoint Server 2010
(http://technet.microsoft.com/en-us/library/cc263121.aspx)

Services architecture planning for SharePoint Server 2010
(http://technet.microsoft.com/library/cc560988%28office.14%29.aspx)

Add or remove a service application connection to a Web application (SharePoint Server 2010)
(http://technet.microsoft.com/en-us/library/ee704550.aspx)

xtranet topologies for SharePoint 2010 Products: Model for SharePoint Server 2010
(http://technet.microsoft.com/en-us/library/cc263513.aspx)

Hardware and software requirements for SharePoint Server 2010
(http://technet.microsoft.com/en-us/library/cc262485.aspx)

Plan for backup and recovery in SharePoint Server 2010 (http://technet.microsoft.com/enus/library/cc261687.aspx)

SharePoint ECM- Going green event- ppt deck