Wednesday, July 29, 2015

How to remove Document ID after disabling "Document ID Service" feature?

After disabling "Document ID Service" site collection feature, the field "Document ID" is still in the "Display Form". That's annoying.

However, it's easy to remove/hide it, with the help from the famous freeware "SharePoint Manager".

Go to the library, then expand "Fields", then change the property "Sealed" from True to False, click "Save"; then change the property "ShowInDisplayForm" from True to False, then click "Save" again.


PS: we cannot do the same change with this field in list content type or site content type.

Monday, July 13, 2015

The feature we really need in SharePoint (but may not get it in the next 30 years)

Recently I uploaded all my photos and videos to “Google Photos”, and realized that Google recognized all metadata and keywords of each photo and video automatically.

That resolved the most painful issue of photo management.

Then I realized that this is the critical feature we need in SharePoint.

When millions of files are stored in SharePoint, it's almost impossible to ask thousands of users to attach "tags" manually to documents. And, when the content of a file is changed, sometimes we also need to update the relevant metadata.

However, it's easy to understand that's much more complex than attaching tags to photos and videos. AI needs to understand the documents, to some extent.

Let's wait for SharePoint 2040.


PS: If this is technically impossible, I hope SharePoint can offer some "possible tags" when a document is uploaded. That should not be too hard.

Saturday, May 30, 2015

How to upload thousands of photos from different folders, to Google Photos, in one go?

Finally I got something to share which is not related to SharePoint at all.  :-)

Google just announced that they allow users to upload unlimited photos

This is crazy idea. But, if it can help Google's market value to rise for 1%, then they actually got 4 Billion USD, which is more than enough to purchase hard disks. And, if they can grab some market share from Facebook, or even beat Instagram, then they actually got much more than 40 Billion USD!

So, maybe this aggressive strategy will succeed.

Anyway, I want to try it.

I have around 40GB photos, which are stored in thousands of folders. When trying to upload them to Google Photos, it seems that I can only upload the files in one folder in one go.

That's annoying. I don't want to upload the photos in thousands of batches.

So, below is the PowerShell script to copy the photos to a cache folder, and change the file name with unique string. I concatenate the parent folder name and the file name to get the string, which is enough to keep it unique in my case. It's easy to add "modified date" to the file name if necessary.

Get-ChildItem –Path E:\Photo\PhotoDVD\PhotoDVD1\* -Include *.jpg -Recurse | % { Copy-Item -Path $_.FullName -Destination "C:\GooglePhotos\$($_.Directory.Name).$($_.Name)" -Recurse -Force -Container }

Wednesday, May 27, 2015

Request Management Service missing?

"Request Management" Service is missing on one SharePoint server? How to start it there?

This may sound silly...... what we need to do is simple: start "Microsoft SharePoint Foundation Web Application" service on that server, then "Request Management" Service will appear, then we can start it up.

It seems that "Request Management" Service is bound to "Microsoft SharePoint Foundation Web Application" service.

Hope this tip can save you 10 minutes :-)

Monday, May 18, 2015

SharePoint is on the wrong way

SharePoint 2016 is coming. Tons of new features.

But none of them really make business users excited.

Actually, in my opinion, even the cloud version "SharePoint Online" is not so attractive.

Let me share my thoughts a bit here.

SharePoint is designed for enterprise collaboration. It helps users to organize information. It's so flexible and UI friendly, SharePoint 2007 was really impressive.

A big bonus is the integration with MS Office suite. We can contribute and manage information at the same platform.

But that's it. After that, I don't see any GREAT feature.

"Wait!", you might ask, "What about the new features of SharePoint 2010 and SharePoint 2013?"

Yes, there are a lot of new features, but none of them are GREAT.

Here is an analogy. Upgrading file system from FAT32 to NTFS, we can get enormous advantages, but that doesn't mean much to business users.

Same to "cloud computing". If it works fine, do users really care whether the system is based on cloud or on-premise? They don't.

I agree that Windows 8 is much better than Windows XP, But, let's face it. If Windows XP still had main stream support, then millions of companies would stick to it. Why? Because there is no GREAT new feature in Windows 8!

What features that SharePoint really needs? The first three features appeared in my mind are: Calendar. Trello. Slack.

There is calendar list in SharePoint, but, it's too hard to combine it with "information management".

Same with Trello and Slack. SharePoint has similar basic elements, but it's too hard to use the OOTB functionality to replace Trello or Slack.

In one word: Microsoft need to focus on "business feature" instead of "technical feature".

I wish SharePoint 2016 can give the world more surprise!

(Any comments are welcome.)

Tuesday, April 21, 2015

Problem: Workflow is not started by the first event

The workflow is not started by the first event ("item created" or "item changed"), after that it works well.

It only happens in one site collection.

Soon I found the error message in ULS: "The requested workflow task content type was not found on the SPWeb"

Google search leads to this post. But re-creating Tasks list didn't resolve the problem in my case. The other posts all recommend to reactivate "OffWFCommon" feature. But it still didn't help.

Then I realized where the problem is.

SharePoint structure is based on "template". From the error message in ULS, it's easy to guess that the site content type "Tasks" is corrupted somewhere. Reactivating "OffWFCommon" feature only fixes the site content type template, not the content type instance in the Tasks list.

So the solution is simple.

1. Reactivate "OffWFCommon" feature

stsadm -o deactivatefeature -filename OffWFCommon\feature.xml -url http://sp.domain.local/sites/site1
stsadm -o activatefeature -filename OffWFCommon\feature.xml -url http://sp.domain.local/sites/site1

2. Rebuild "Tasks" list

Any comments welcome!

Wednesday, April 1, 2015

How to enable "Asset library" template

After creating a new site collection based on "Blank" site template, I noticed that "Asset library" template is not there. Then I enabled "SharePoint Server Standard Site Collection features" and "SharePoint Server Standard Site features", with no luck. Then "Wiki Page Home Page" feature, still no luck.

Internet search brings me to this post, and a few other similar posts, which all says that we need to enable "SharePoint Server Publishing Infrastructure". I am pretty sure that would work. However, "Publishing" feature is really a big chunk of stuff, and we lose "save as template" functionality after enabling it. I don't want to do that.

Thanks for the post All SharePoint Features, we can simply enable "Asset Library" feature, through the PowerShell script below.

# 4bcccd62-dcaf-46dc-a7d4-e38277ef33f4
Enable-SPFeature -identity "AssetLibrary" -URL ""