SharePoint 2013: Center or Centre? Search knows the US/UK spelling variations!


Weird what you stumble across in SharePoint! There is no end to finding things!

Center or Centre? Organization or Organisation? Harbor or Harbour?

SharePoint 2013 search, both On Prem and Office 365, appears to have a US/UK synonym list built-in. I can't find documentation for it anywhere, but it seems to work as expected. Below a few of the words I tested. Search for one and you will find documents with the other.

  • center/centre
  • neighbor/neighbour
  • organization/organisation
  • color/colour
  • flavor/flabour
  • honor/honour
  • caliber/calibre
  • practice/practise
  • license/licence
  • defense/defence
  • connection/connexion
  • realize/realise
  • spelled/spelt
  • analyze/analyse

My editor's spell checker marks all but one of the second terms as misspelled! It seems to like "spelt".

To see a list of these common spelling variations see https://en.wikipedia.org/wiki/American_and_British_English_spelling_differences




SharePoint 2013: Hide List and Library Column Headings


This is an update to an older article to include support for SharePoint 2013.

Hiding Column Headings

I had a request to hide the column headings of a list displayed in a web part. First thought was that they wanted to hide the toolbar, but they were asking about the clickable column headings. I think they were wanting to make a page look more like a regular web page instead a page full of lists. By the way, this makes for a better way to display a view with only one column.

Note: This will of course remove the ability of the site visitor to sort and filter the web part.

Note: This will also work in the view page (view pages use web parts!), but in SharePoint 2010 and 2013 adding a web part to a view page will change how the ribbon gets displayed and will remove the View dropdown menu from the title area crumb trail.





With Toolbar set to "No Toolbar":


Remove additional clutter…

You can edit the web part and then click "Edit the current view" further clean up the display of the list.

  • Remove the checkbox column: In the Tabular View section uncheck "Allow individual item checkboxes".
  • Remove the "…": In the Columns section uncheck "Name (linked to document with edit menu)" and checkmark "Name (linked to document)".
  • Remove the hyperlink: In the Columns section uncheck "Name (linked to document with edit menu)" and checkmark "Name (for use in forms)".
  • Remove any unneeded columns such as Modified or Modified By.




  • Add your web part for the list or library to a page.
  • For a minimal look set the web part's Toolbar Type property to “No Toolbar”.
  • Copy the JavaScript below to a Notepad file (name it something like “HideHeading.html”) and upload this file to a library such as Site Assets.
  • In the library where you uploaded this file, click the "…" and copy the displayed URL. It should look something like this:
  • Below your list / library web part add a Content Editor Web Part (CEWP).
    • If the CEWP displays it’s title bar then in the Appearance section set the Chrome to “none”.
    • Paste the URL copied above into the Content Link box.
    • In the web part properties editor, click OK.
    • In the PAGE ribbon, click Save.
  • Or (for SharePoint view pages)
    • Edit the view page in SharePoint Designer 2013. 
    • Copy and paste the Javascript to just before the end tag for PlaceHolderMain (just before </asp:Content>).
  • If you want to hide the column headings of multiple web parts modify the IF statement like this Three web parts

Web part summary name!

In SharePoint 2007, the summary name is usually just the list’s name: “Shared Documents”.

In SharePoint 2010, the summary name is usually the list’s name PLUS the list’s description. For example the default for Shared Documents is: “Shared Documents Share a document with the team by adding it to this document library.”  (including the period)

To find the correct name use your browser’s View Source option to display the HTML of the page and search for “summary=” and copy the text that follows. Or, use the browser's developer tools (usually F12) and search for "summary="

    <table  …  summary="Shared Documents Share a document with the team by adding it to this document library."   … >


The JavaScript

Need to change multiple web parts? Edit the line that contains "if (x[i].summary==""

Two web parts:
             if (x[i].summary=="Tasks" | x[i].summary=="Shared Documents"
Three web parts:
             if (x[i].summary=="Tasks" | x[i].summary=="Links" | x[i].summary=="Shared Documents"

<script type="text/javascript">
// CEWP trick from techtrainingnotes.blogspot.com!

// techtrainingnotes.blogspot.com/2015/07/sharepoint-hide-list-and-library-column.html
// Hide column headings in web parts

function TTNHideHeadings()
  //Find the list  (change "Documents" to your web part's "summary" name)
  var x = document.getElementsByTagName("TABLE"); // find all of the Tables 
  var y;
  for (var i=0;i<x.length;i++) 
    if (x[i].summary=="Documents")  //find the table with this name
      y = x[i].getElementsByTagName("TR");
      y[0].style.display="none";  //hide the first row

try {
  // for 2010 and 2013
  ExecuteOrDelayUntilScriptLoaded( TTNHideHeadings, "sp.js" );
catch (e) {
  // for 2007


Using SharePoint Serach To Find Sites You Have Access To


Did you ever wonder if there's more to SharePoint? Sites you may have permissions to, but no one ever told you about? Sites like the rumored jokes site and the "free stuff" site? You can use search to find these sites!

ContentClass is a SharePoint 2013 Managed Property that is used to find many SharePoint things by their "type". Two ContentClass values of interest when searching for sites are "STS_Site" and "STS_Web".

Tip: For more on what you can do with ContentClass see SharePoint Power Searching Using ContentClass and also here: http://techtrainingnotes.blogspot.com/2015/02/sharepoint-2013-list-and-library.html



The STS_Site property is used to find site collections, or actually just find the top level sites of site collections. To list all of the top level sites that you have permissions to see, search for "ContentClass:STS_Site". (See warning below!)


My test user Sam found 8 site collections and my administrator account found 38.



The STS_Web property is used to find subsites. To list all of the subsites that you have permissions to see, search for "ContentClass:STS_Site". (See warning below!)


Sam found 9 subsites while my administrator account found 158.


Find all sites you have access to…

Just combine both searches with an "OR" to show all of the sites you have access to. (Remember that Boolean operators like AND, OR and NOT must be in UPPER case.)



Adding Keywords

A little tip: If you add keyword to your STS_Web and STS_Site queries you will not be searching content in the site. You instead will be searching for that keyword as a property of the home page or content that might be displayed on the home page. The following search will only return results when "plane" in somewhere on the home page of the site:



Warn'n matey, here be dragons, or at least duplicates…

SharePoint 2013 search hides duplicates by default and treats many of the things returned by STS_Site and STS_Web as duplicates. Over half of my subsites are missing using an out of the box search! Administrators can fix this little issue by following the "Option 2" steps here: http://techtrainingnotes.blogspot.com/2015/04/sharepoint-2013-search-weirdness-part-1.html.


STS_Site <> SPSite

A note to developers and administrators: SPS_Site is not the same as SPSite. It's actually finding SPWebs, but only finding those that are top level webs.




SharePoint 2013 Search Weirdness – Part 4: More Duplication Weirdness


A continuation of the "Search Weirdness" series!

How many Announcement Lists do I have?

In the first article of this series I showed how something like a series of Purchase Orders that differ in only the PO number, date and a few other details can appear to SharePoint 2013 search as duplicates and be excluded in the default search results. I have found something stranger… it seems that sometimes all Announcement lists look the same to search and are also treated as duplicates. Lists!

As an example, I did a search to find all Announcement lists using ContentClass:STS_List_Announcements and found only 8 in my entire test farm.


I then edited the search results page and changed the duplicates setting (steps here) and then found all 23 of the Announcement lists.


I duplicated the issue in both a test farm (15.0.4649.1000 June 2014 CU) and in the today's version of Office 365. Going forward I'm recommending that the "Remove Duplicates" feature be disabled on all search result pages. Now all I need to do is write a PowerShell script to do this.


Another Test

Just in case it has something to do with the Enterprise Search Center, I tried the test using "This Site" in a site that had two announcement lists, one titled Announcements and the other titled Jokes. The search only found one list. Note that in the refiner section there are two authors listed. If I click Sam then I can see the Jokes lists while if I click Mike I can see the Announcements list. But never both! The refiner seems to know that they are both there.



The problem with this duplicate problem is that the "This Site" search sends me to the _layouts/15/osssearchresults.aspx page, which is not customizable with Edit Page. I have no place to turn off the "Remove Duplicates" feature!



In the Enterprise Search Center, edit each results page to turn off the "Remove Duplicates" feature. For "This Site"… tell the users to use "Everything" instead, which redirects them to the Enterprise Search Center.

If you need to restrict the "Everything" search to a single site then use this:

   contentclass:STS_List_Announcements   site:yourserver.sharepoint.com/sites/training





SharePoint 2013 Search Weirdness – Part 3: When do Daily and Weekly Search Alerts Get Sent?


A continuation of the "Search Weirdness" series!


Search Alerts are Different!

Unlike list and library alerts:

  • You cannot create them for other people. There's no place to type an email address.
  • You cannot request an immediate alert.
  • You cannot pick a time:

List / Library alert options:


Search Alert options:



So when are they run?

You would assume (always a dangerous thing to do) that Daily and Weekly summary search alerts would get created overnight. Turns out they get sent at an exact time, but a different one for each alert!

While working on a new SharePoint 2013 search class I was trying to find out which timer job created the alert emails and if I could set the time they are sent. TechNet documents only a single timer job, "Immediate Alerts", that runs every five minutes. While I could change that interval, I could not find an option for the "nightly jobs". Turns out there isn't any such thing.

I had always assumed (again, dangerous) that these ran overnight. The only documentation I had found in TechNet only said this:

"The daily alerts will have a 24-hour day, date, and time span calculated and stored in the respective database table. A weekly alert will have a seven-day day, date, and time span calculated and stored as part of the individual alert record."

It just says "calculated" and does not say "when". Then I ran across this blog article by Chris Domino and the light bulb went off:


When you create a daily alert it is scheduled to run every day at the time you created the alert. I.e. You created the alert at 2:00PM, it will processed every day shortly after 2:00PM. The same applies to weekly alerts. You created the alert at 2:00 PM on a Tuesday, it will be processed every Tuesday at 2:00 PM. I went out and looked as the SQL tables (never do this at home!) and there it was, to the minute, scheduled 24 hours or 7 days in the future.


But that's for an on premise SharePoint installation. Office 365 is different!

In my Office 365 tenant my daily alerts are initially scheduled 17 hours in the future and then every 24 hours after that. My guess is that Office 365 is using GMT. So when I schedule a daily alert at 3:45 PM it runs 8:45 AM every day. Five hours off. Hum…  would that mean my tenant is running in Central time? Don't know… just guessing…


Another day… another new thing to discover…




SharePoint 2013 Search Weirdness – Part 2: Can't Find My Videos!


A continuation of the "Search Weirdness" series!


Can't Find My Videos!

I have a bunch of videos in my site. They could be anywhere:

  • A document library
  • An Assets library
  • An Office 365 Video Portal
  • An attachment to a list

How do I find them?


By File Type?

So to try to find them all I try this search:



Ok, that was because the "wmv" file type is not in Central Administration's list of File Types. As we cannot change that in Office 365, we need a more universal method. So how about:


Ok, now I have results! But… only 12 files, and I know I have many more!


By the file extension alone?

What if we just search for "WMV"? Well, it depends… First, that's just one of the possible video extensions. Second, you will find any file that has those three letters, such as an acronym. But… (there's always a "but") In Office 365 / SharePoint Online the file extension is not indexed in Asset libraries. Strangely, with 2013 On Premise the text "WMV" is indexed, but not as a file extension. I.e. you can find the Asset library videos using "WMV", but not "SecondaryFileExtension:WMV".


Ok, found a few more files!


By Content Types?

That's a good idea, but this will not find videos assigned a default content type (like those uploaded using drag and drop) or stored as list attachments. Also, the "video" content type is used in Asset libraries, not in Video Portals.


Or better, use the video content type IDs:

ContentTypeId:0x0120D520A808* OR ContentTypeId:0x010100F3754F12A9B6490D9622A01FE9D8F012*

The first content type for "Video" as found in the Asset libraries. The second content type is for the Office 365 Video Portal videos. The "*" is added to include any content types you create that inherit from these two.


By File Name?

Ok, I know the file name of one of the videos, and I know people have uploaded it to multiple sites… So let's try a name search.


Found some files!  These were found in a document library, an Assets library and an Office 365 Video Portal. But… only three, and I know there are more.

As the file name is relatively unique, let's try just that…


Ok, now I have found four of the airshow2 videos. Where did the extra one come from? The new file is from a folder in the same library. I think SharePoint saw it as a duplicate and ignored it the File Name search, but for some reason displayed it in the "name without extension" search. (See What's a Duplicate?)

But's there at least two more hanging around. one is an attachment to an announcement, and will not be found by file name! The other was uploaded to an Asset library and the user gave it a new "title" while uploading it. The real file name is buried there, but search does not see it. (See SharePoint 2013 Asset Library Secrets!)


What about a "Videos" search?

The Enterprise Search Center adds a "Videos" search vertical.


This search also found four of the videos by that name, but also missed the attachment. The Local Video Results Result Source uses two content types and nine file extensions to try to find videos.

 OR ContentTypeId:0x010100F3754F12A9B6490D9622A01FE9D8F012* 
 OR (
     SecondaryFileExtension=wmv OR 
     SecondaryFileExtension=avi OR 
     SecondaryFileExtension=mpg OR 
     SecondaryFileExtension=asf OR 
     SecondaryFileExtension=mp4 OR 
     SecondaryFileExtension=ogg OR 
     SecondaryFileExtension=ogv OR 
     SecondaryFileExtension=webm OR 

Notes: The first content type for "Video" as found in the Asset libraries. The second content type is for the Office 365 Video Portal videos. The "*" is added to include any content types you create that inherit from these two.


What's going on here???

File extensions:

  • The common video file extensions are not in the default list of files types used by search. So FileType:wmv will not work.
  • While an on premise admin can add these extensions to the search service, Office 365 admins cannot.
  • Use the SecondaryFileExtension property when searching by file extension.
  • Searching by file extension is not useful when the videos are stored as an attachment or in an Asset library.

File names:

  • Search does not index the file name for attachments.
  • Files uploaded to an Asset library and renamed by the user will not be seen by search by the original file name. (Even though the file still has the original name!)


  • The content of an attachment gets merged with the content of the item and are indexed as a single entity. As a video generally has no useful text content, it will not usually be found by search when attached to a list item.


Best Practices?

  1. Use good governance to encourage a single way to store videos. Whether that is a Video Portal in Office 365 or an Asset library when on premise. It probably does not matter where, as long as there is a consistent way to find videos. Avoid storing videos in regular document libraries.
  2. Use Asset libraries when metadata and a convenient player/viewer is needed.
  3. Use a Video Portal when using Office 365 / SharePoint Online AND metadata is not important. The only "metadata" is the channel the video is uploaded into, the title and the description.
  4. Consider using a Video Portal as the content is stored in Azure instead of SharePoint and distributed as a CDN.
  5. Never store videos as attachments. Add a link in the task or announcement to a video in a library or Video Portal.


Office 365 Notes

Rule #1 for Office 365, like the weather in Cincinnati, if you don't like it, hang around. It will change. Anything written here about Office 365 is subject to change.

The Video Portal is not a pure SharePoint environment.

  • The videos are not stored in SharePoint libraries. They are stored in Azure
  • You cannot create views, add columns or customize the metadata. The only properties are the title and the description.
  • Searching for videos in SharePoint will find videos in the Video Portal, but only by the name, filename and description.
  • Videos are played using Flash or HTML5. (Asset libraries use Silverlight!)
  • The Video Portal will probably change. (See Rule #1)


Want to see more about what happens to your video file when you upload it to a Video Portal? Watch this video: https://www.youtube.com/watch?v=HXSZ0jYBKlM




SharePoint 2013: Create a Quote of the Day Web Part (a CEWP trick!)


This is a 2013 version of the 2007 and 2010 article found here: http://techtrainingnotes.blogspot.com/2010/10/sharepoint-create-quote-of-day-web-part.html


Quote of the Day / Tip of the Day

Want to display some “wise words” for your coworkers? You need a Quote of the Day web part!


You could display a picture or product of the day:



This web part is another simple Content Query Web Part solution similar to the ones found in my SharePoint 2010 Customization book. But… this one is for 2013!

  • Works from a normal SharePoint list.
  • Displays a random quote from the list.
  • Can display a new quote on each page view, or just one new quote a day.
  • Can be used to display quotes, product announcements or any kind of text, pictures or other content that you can add to a SharePoint rich text editor column.


Create the Quotes list

While you could use a Custom List, I used an Announcements list as it already had what I needed, a Title field and a Rich Text field.

  1. Go to Settings (gear) and click Add an App.
  2. Find and click Announcements.
  3. Add a name for the list such as “Quotes”.
  4. The description is optional, but is best left blank as it adds a little complication later on.  (I.e., don't click Advanced Options and add a description!)
  5. Click Create.
  6. If you are not using the Announcements list type then from the list’s Settings menu click Create Column and add a “Multiple Lines of Text” column. Name the column “Quote” (although any name will work) and click “Rich text (Bold, italics, text alignment).
  7. Add a few quotes by clicking "new announcement" or New from the ITEMs ribbon. You can use all of the rich text formatting options if you like. (Bold, colors, etc.)
  8. Create a new view by clicking the Create View link in the LIST ribbon.
  9. Create the view as a Standard view and name it something like “QuoteView”. Un-checkmark all columns except for “Quote” column (the “Body” column if using an announcements list).
  10. Expand the Tabular View section (scroll down to find it) and uncheck "Allow individual item checkboxes".
  11. Click OK.

You now have the list that will store the quotes. You will now add two web parts to a page. One which is the list of quotes, and the other which is a Content Editor Web Part with the JavaScript and HTML code.


Add the Quotes list web part to the page

  1. Go to the page where you want to add the “Quote of the Day”, most likely your home page. 
  2. Click Settings (gear), Edit Page.
  3. Click where you would like to add the quotes.
  4. In the INSERT ribbon click Web Part and add the web part for the quotes list.
  5. In the web part click dropdown arrow and then Edit Web Part.
  6. Select the view you created above (“QuoteView”).
  7. Click OK.

This web part will be hidden when the JavaScript runs.


The JavaScript and HTML file

  1. Open Notepad or your favorite HTML editor.
  2. Copy the sample code from below and paste into your editor.
  3. Either delete my sample <style> block (it displays the quote in red) or customize your own style.
  4. Find the line with "var quotesWebPartName=" and change "Quotes" to your list's name.
  5. (Optional) Find the line with "var OneQuotePerVisit = false" and change it to true so the user can only see one quote per day.
  6. Save the file.
  7. Upload the file to a library where all of your users have at least Read or View access. "Site Assets" is a good choice.
  8. Find the URL of the uploaded file by clicking the "…" next to the file name. Copy the URL so we can paste it into the CEWP below.


The Content Editor Web Part

  1. Add a Content Editor Web Part (CEWP) and move it so it is near the quotes web part. While the list web part can go anywhere, the CEWP must go where you would like to display the quote of the day. 
  2. Click the CEWP’s dropdown menu and select Edit Web Part.
  3. Paste the URL you copied earlier into the Content Link box.
  4. In the Appearance section add a title for the web part (perhaps “Quote of the Day”).
  5. At the bottom of the web part properties box click OK.
  6. Save your page and test! Refresh the page to see if the quote changes.



The JavaScript

Copy and paste the following JavaScript into Notepad or your favorite HTML editor. (see above)

<!-- add your own formatting here... (optional)-->
<style type='text/css'>
  #TTNQuoteText { color:red }

<!-- Quote will be displayed here -->
<span id="TTNQuoteText"></span>

<script type="text/javascript">

function TTNShowQuote()
// another CEWP trick from http://TechTrainingNotes.blogspot.com
// http://techtrainingnotes.blogspot.com/2010/10/sharepoint-create-quote-of-day-web-part.html

// name of the quotes library web part
  var quotesWebPartName="Quotes"; 

// set this to "true" so the user will see the same quote 
// for 12 hours or until they close and reopen the browser
  var OneQuotePerVisit = false;

// don't change these
  var QuoteList;
  var QuoteArray = [];
  var quoteCount = 0;

  var TTNTables = document.getElementsByTagName("TABLE");
  var i=0;
  for (i=0;i<TTNTables.length;i++) 
    if (TTNTables[i].summary)
    if (TTNTables[i].summary == quotesWebPartName)
      // Get the table with the quotes
      QuoteList = TTNTables[i].getElementsByTagName("tbody")[0];

      // hide the links list web part, but only if not in edit mode
      if (PageState.ViewModeIsEdit != "1")

  if (!QuoteList)
    document.getElementById("TTNQuoteText").innerHTML="Web Part '" + quotesWebPartName + "' not found!";

  //Count the quotes
  var links = QuoteList.getElementsByTagName("TR") // find all of the rows
  var url;
  var quoteCount = 0;
  for (i=0;i<links.length;i++) 
    //if (links[i].childNodes[0].className=="ms-vb2")
      QuoteArray[quoteCount] = i; 

  if (quoteCount==0)
    document.getElementById("TTNQuoteText").innerHTML="No quotes found in web part '" + quotesWebPartName + "'!";

  var id=-1;

  // check for a cookie and use last ID if found

  if (OneQuotePerVisit)
    // check for a cookie with the last quote ID
    if (document.cookie.length>0)
    if (c_start!=-1)
      c_start=c_start + "LastQuoteDisplayedID".length+1;
      if (c_end==-1) c_end=document.cookie.length;
      id = unescape(document.cookie.substring(c_start,c_end));

  if (id == -1) 
    // generate a random quote ID
    id = Math.floor(Math.random() * QuoteArray.length) 
  // display the quote
  document.getElementById("TTNQuoteText").innerHTML= QuoteList.getElementsByTagName("TR")[QuoteArray[id]].childNodes[0].childNodes[0].childNodes[0].innerHTML;

  if (OneQuotePerVisit)
    // set a cookie so they see the same quote for xx hours (.5 = 1/2 day = 12 hours)
    var exdate = new Date();
    exdate.setDate(exdate.getDate() + 1);
    document.cookie="LastQuoteDisplayedID=" + id //+ ";expires=" + exdate.toUTCString();


// add our function to the SharePoint OnLoad event



Only have about 100 more of these to update from 2007/2010 to 2013!




Windows 10


I've had Windows 10 on my laptop for the last few weeks and thought I'd give a little report.


Hardware used for testing

Most Windows 10 testers seem to be installing it in a virtual machine. I have an older, but high end laptop that I was going to upgrade to an SSD drive to extend its life a bit. After putting the drive in, I thought… lets throw Windows 10 on here for a while, and then reformat and install Windows 7 again. Well, Windows 10 is still there.


  • HP Pavilion DV7-2185dx quad core
  • 8 GB RAM
  • Crucial 500GB BX100 SSD

If you have been to one of my presentations in the past, this is the 17" HP gaming boat anchor that had all of the stickers on it. It has been a good reliable machine, but the RAM could not be expanded to the 32 GB that I needed to make SharePoint 2013 VMs happy.


Hardware Issues

Really, I had very few issues, especially for a beta! The install was fast and worked the first time, except for the two issues below. Overall the install was a good experience.

Touchpad: The first issue I ran into was just touching the laptop's touchpad locked up Windows 10. Completely froze it. For a few weeks I checked after each Windows Update and searched the web for updated drivers. Could not find a solution. All was OK if I remembered immediately after startup to press the little button to disable the touchpad. Finally I decided it was just better to completely disable the touchpad. So I did, And it still crashed. I then decided to just "kill" the touchpad and uninstalled the drivers. Magically, the touchpad started working perfectly!

SD card: The SD card slot also did not work correctly. The machine beeped when you inserted a card, but it could not read it. I tried a new card and every attempt to read or format it just timed out. Solution… "kill it"! I uninstalled the drivers and it immediately started working!

Uninstalling the Drivers is the Solution?

I ran the Troubleshooter and the other Windows tools. I ran Windows update. Nothing fixed my issues. But uninstalling drivers immediately fixed things! Maybe the Windows 10 installer misidentified the devices and installed incompatible drivers, and uninstalling those returned me to the generic drivers. I may now be missing some features like the "three finger" actions, but it all now works.


Before I Nitpick…

I really like what is being done behind the scenes with Windows 10. For that matter, I'd be a very happy camper if Windows 10 was available with a Windows 7 desktop. There's a lot of new interesting things going on under the hood. A lot has been published in blog articles and in the Ignite presentation videos, so I won't repeat it here.


The New Start menu

Better, much better than Windows 8, but not as good as Windows 7. I never liked the Windows 8 tiles and typically ended up doing what I saw every Microsoft rep doing in their demos… typing the name of the program or feature. I'm one of those people who use a computer for work. I don't spend all day playing with things. I want a user interface that will give me quick access to my tools. I don't want randomly sized, randomly placed, blinking tiles, even if I can, with a lot of time, move and resize them. While titles are useful on my Windows Phone, and maybe a keyboard-less tablet, my work machines all have keyboards and mice. I'm not saying to get rid of the tiles… I'm sure someone likes them… but give us keyboard and mouse users a useful option.

As it does not look like I can customize the Start menu to include a Windows 7 like selection and navigation I have:

  • Removed all of the default tiles.
  • Added my most often used programs (I can't bring myself to call everything an app!) to the Start menu and then reset the tile size to Small. These include, Word, Excel, etc.
  • And for the rarely used programs I use the tedious, alphabetical only, "All apps" button to find my programs.
  • And if I can't find it, I'll do a search.

(Yes, I know about the 3rd party replacement start menus, and may end up using one. But for now I'm trying to stay "out the box" as much as possible.)


The Search Box

I really want to remove the "search the web" feature from the "Search the web and Windows" box. As a trivial example, I did a search for Solitaire. It's not included in the default install and the search only gave me links to the "Store" and the web. If I don't have it, just tell me "not found".



Windows 10 does not assume you want privacy. By default all of the apps have access to the camera and microphone. I turned those off along with most of the other privacy related stuff like the Cortana "Getting to know me" feature that monitors my typing, voice, calendar and contact info. At least the "Location" tracking feature is disabled for apps by default. I know that this is not what Microsoft wants me to do, as the Windows 10 Cortana search feature depends on knowing all of my personal stuff to do "smart" searches for me.


Edge/Spartan and IE 11

Edge/Spartan just seems to simplistic so far. I can't find options that I need like Open New Session (I do a lot of testing with multiple logins.). Funny thing is it seems the IE 11 shipped with the Windows 10 beta has issues. Can't really pin them down, but it just behaves differently than the IE 11 running on my Windows 7 machine. One issue I found is that it will not play Amazon Prime videos due to a "Silverlight error". Edge will work with Amazon videos, but much of the video player navigation does not work and it won't go full screen. (Firefox works perfectly!)

Edge is new, and not a final product, so I'll withhold judgment for now. I do like the idea of Microsoft starting over from scratch with a new browser.



Now moving back to my Windows 7 machine to get my work done!



      Cincinnati PowerShell User Group Meeting this week!

      Info. and RSVP here: http://meetu.ps/2JkRsx

      The PowerShell User Group is back! (But the future is up to you!)

           PS C:\> Get-Speaker | Plan-Meeting | ShowUp-AndLearn!

      Sponsor:  SAPIEN Technologies
      is supplying the food!
      Ed Wilson "The Scripting Guy" from Microsoft will be here to help us (re)kickoff the PowerShell User Group. If you would like to see future meetings, place your vote by showing up for this meeting!
      Wednesday, June 3rd 6:30 PM at MAX Technical Training. (Food and networking starts at 6:00!)

      Speaker: Ed Wilson "The Scripting Guy"
      Title: Garbage in, Garbage out: Data grooming with Windows PowerShell
      Everyone has heard the old adage, "garbage in, garbage out" when talking about databases, or other online data storage / retrieval systems. But do you know that Windows PowerShell can help you with your problem? In this session, Microsoft Scripting Guy Ed Wilson talks about using Windows PowerShell to perform data grooming. He shows how cleaning up names, street addresses, cities, states, and even zip codes by using basic string manipulation techniques. By focusing directly on the data transformation itself, he extracts principles that can be used regards of the database, or other data storage system. After focusing on the individual components of the process, he puts the whole thing into a single script for transforming the sample data. This session is heavy with live demonstration.

      Ed Wilson is the Microsoft Scripting Guy, and writes the daily Hey Scripting Guy blog. He is the co-founder of PowerShell Saturday, and the Charlotte PowerShell User Group. He is a frequent speaker at conferences, user groups and other places where groups of computer people may be found. He has written books about every version of Windows PowerShell, as well as other books related to automation and operating systems.  His most recent book is Windows PowerShell Best Practices.



      SharePoint 2013 Asset Library Secrets and Wierdness!


      Asset Libraries are… weird. When you just upload videos using only the Upload button, and just view the videos, then all is good. But if you want the link to the video file, or you upload without the Upload button, or you want to search for all videos, then weirdness happens! Especially in Office 365 / SharePoint Online.

      In this article:
      • Finding the URL to an Asset library video.
      • Two Three ways to upload a video, with TWO THREE different results!
      • Searching Asset Libraries.

      Finding the URL to an Asset library video

      The Asset library does a pretty good job of hiding the full URL to a video file. A "video asset" item is actually a folder. The folder contains the video and supporting files like preview thumbnails.

      So, if you upload a video named butterfly.wmv to http://yourSite/sites/demo/Assets the path to the video would be http://yourSite/sites/demo/Assets/butterfly/butterfly.wmv. If you changed the Name property while uploading the file to "Pretty bugs" the URL would then be http://yourSite/sites/demo/Assets/Pretty%20Bugs/butterfly.wmv.

      There are two ways to discover the "real" URL, mouse over a download link or use SharePoint Designer.

      Mouse over:
      1. In SharePoint 2013, click the video to display the VideoPlayerPage.aspx page.
      2. Mouse over the DOWNLOAD link and right-click and select Properties.
      3. Copy the Address (URL), paste into Notepad and "un-escape" the SourceUrl parameter. (Not fun!)
      SharePoint Designer:
      1. Launch SharePoint Designer and open your site.
      2. In the Navigation area click "All Files". (If you don't see All Files then your administrators may have partially locked down SPD.)
      3. In the list of files and folders click the Assets library.
      4. Find and click your video (you will see the "Name" as entered in the file's properties during upload, not the file name.)
      5. Find the video file, right-click it and click Properties.
      6. Copy the Location.
      If you just want to display the video in the page using a Media Web Part:
      1. Edit the page.
      2. Click INSERT.
      3. Click Web Part.
      4. From the Media and Content category select Media Web Part and click Add.
      5. Edit the web part (click the web part's dropdown).
      6. From the MEDIA ribbon click Change Media.
      7. Click From SharePoint and navigate to your assets library and pick a video.

      Two Three ways to upload a video, with TWO THREE different results!

      Uploading a file to a library is just uploading a file, right?
      The Upload Button
      Click the Upload button and the video will be uploaded as a full featured "Asset Library Video"!  A folder will be created with the "Name" entered by the user and the video will be stored in that folder with the original file name.

      (I didn't have Silverlight loaded on the test workstation.)
      The Upload Button (with a duplicate file!)
      Here again, Office 365 is different than On Premise. With 365 if you upload the same file again, using the Upload button, you won't get a "Duplicate" error, it will just upload the file as an ordinary library file, but with a default Content Type of "Video Rendition". BUT… click OK and the file disappears! No error messages, just no file in the library! (Best guess… there was a server side error when trying to create the duplicate folder and no error was returned to the user.) With On Premise the upload just seems to freeze and never completes.

      Drag and Drop (Office 365 / SharePoint Online only!)
      Note: This is only a problem in Office 365!
      Drag a video from Windows Explorer onto the Asset Library page and you will get a "plain old library file" with the Content Type set to "Image". (Image is the default Content Type.)
      • If you edit the properties of the file you can only change the Content Type to "Image" or "Audio".
      • SharePoint does not stop and ask for any metadata and simply uploads the file and assigns the "Image" Content Type.
      • There is no folder created.
      • Clicking this video only displays its properties. The link there only offers to download it, not display it in the browser.

      You can actually upload the same video twice, once as an Asset Library Video and once as a "plain old library file". Remember that the Asset Library Video is really a folder.

      Searching Asset Libraries

      If you search an asset library by file extension you will not find any Asset Library Videos. You will only file the "plain old library file" videos that were uploaded using Office 365 drag and drop. The examples below are from the library's search box, but you get the same results from the site search box or the Enterprise Search Center.

      Search by file extension will find other file types uploaded to the Asset library:
      Best way to search? Cover all of the bases! Use the Videos vertical in the Enterprise Search Center or the following search (borrowed from the Local Videos result source).

       OR ContentTypeId:0x010100F3754F12A9B6490D9622A01FE9D8F012* 
       OR (
           SecondaryFileExtension=wmv OR 
           SecondaryFileExtension=avi OR 
           SecondaryFileExtension=mpg OR 
           SecondaryFileExtension=asf OR 
           SecondaryFileExtension=mp4 OR 
           SecondaryFileExtension=ogg OR 
           SecondaryFileExtension=ogv OR 
           SecondaryFileExtension=webm OR 
      The first content type for "Video" as found in the Asset libraries. The second content type is for the Office 365 Video Portal videos. The "*" is added to include any content types you create that inherit from these two.


      • In an Asset library there are "videos" and "Asset Library Videos". Which you get depends on how you upload them.
      • "Asset Library Videos" files are well hidden in a folder and their true URLs can only be discovered using SharePoint Designer, PowerShell, code or from the "DOWNLOAD" link in the videoplayerpage.aspx page.
      • Searching for videos where the videos could be in a library, an Asset Library or an Office 365 Video Portal is best done using the "Videos" vertical in the Enterprise Search Center.


      Note to spammers!

      Spammers, don't waste your time... all posts are moderated. If your comment includes unrelated links, is advertising, or just pure spam, it will never be seen.