..:: I like SharePoint ::.. Rotating Header Image


Convert Content via SharePoint – Word Automation Services

I already made a post about the word automation services in SharePoint 2010. I then used Powershell to convert a word document to a pdf, which both were stored in a document library in SharePoint.

That was typically for 2010:

  • Solutions have to wait for a timer job to complete the converting process
  • Files can only be in SharePoint
  • No UI
  • No message if it’s done

The reason to create a new post is, that SharePoint 2013 offers a lot more things now which make the word automation services powerful and interesting in every direction. It now can offer

  • Conversion process is synchronized, immediate response is possible
  • Convert one file at a time per request
  • Setting options in Central Administration for simoultaneous requests
  • Notify / Updating files in SharePoint items if conversion is ready
  • Support of streams
    • Convert streams as inputs and outputs for file operations
    • Storing streams in the application server and worker manager not in the database

Let’s see how we can use it. I created a small console project to check the functionality. I found some cool functions which I used from this post and expand it to my needs. A second post was about using it as web service which might be really cool if you need a converter service for other applications or applications within sharepoint. (more…)

Database Maintenance Do’s & Dont’s for SharePoint 2010

If you are responsible for a SharePoint Farm or developing things for a SharePoint farm, I bet you’ve heard things like “it’s not supported by Microsoft to do…” and those things mostly dealing with database operations like updating values or settings. But what is about doing administration stuff like defragmentation of indices or shrinking a database?

In this post I try to make some things more clear. My information is based on this technet article, so I was not creative at all. The things I will point out are valid for SharePoint 2010.

Routine database maintenance is essential for the smooth operation of Microsoft SharePoint 2010 databases

That means that we have to do some work on the SQL Server. Microsoft recommends to check database integrity, defragment indexes by reorganizing or rebuilding them as well as set the fill factor for your server.

In SharePoint 2010 the health analyzer evaluate the health of database indexes and statistics daily and reports them at the central administration. But this happens only for some SharePoint databases like

  • Configuration DB
  • Content DBs
  • User Profile Service Application Profile DB
  • User Profile Service Application Social DB
  • Web analytics service application reporting DB
  • Web analytics service application staging DB
  • Word automation services DB

Let’s see what are the details and what you should not do. (more…)

SharePoint 2013: Missing Slide Library

After searching for the SharePoint 2010 Slide Library i found this little help on Mike Smith´s blog


Just add the above mentioned link to your SharePoint URL and you are able to create the Slide Library within SharePoint 2013.

..:: I like SharePoint ::..


SharePoint Create Sites based on Site Collection with Powershell

In SharePoint 2010 and 2013 it is possible to create Site Collections by the UI, using C# Coding or Powershell. In one of our scenarios we had to prepare a web application in which each site collection should get its own Content Database and each site collection should be based on a site collection which already exists in the webapplication as a site collection.

Normally you have to save this site as template, download it, create a new site, upload the template and then you’re done. But that’s not the things administrators, users or developers like to do. We all would like to use a cool Powershell script.

So we created a Powershell Script as function, which does the job using some parameter.
Let’s see the steps it takes:

  1. Check if Content Database exist and create the new one
  2. Create a site collection with the same template in the new content database
  3. Export the template from site collection
  4. Import the template into new site collection
  5. Change the title of the web

Let’s see the code. (more…)

SharePoint 2013: eSignature with SharePoint 2013 / 21-CFR-Part-11

Electronic Signatures with SharePoint is not impossible. There are some steps to perform to enable eSignature for your SharePoint Library.

How to set up 21-CFR-Part-11 you will find here: http://download.microsoft.com/download/3/6/B/36B2F4F5-55AD-4D64-BC5B-62B536E35A62/SharePoint-2013-Configuration-Guidance-for-21-CFR-Part-11%20v2.pdf (more…)