Anders Dissing

SharePint

2013-05-15T14:28:00.001+02:00

Der SharePint, fredag den 24. maj kl. 17 på BrewPub, Verstergade 29, 1456 København K. Hvis du ikke ved hvad SharePint er, så kan du læse om det her http://sharepointbrugergruppe.dk/Pages/SharePint.aspx

SPBG SPBG knowledge sharing meeting

2013-04-10T19:31:00.000+02:00

On April 25 keeps SPBG knowledge sharing meeting in with Creuna, Hammerensgade 4, 1267 K. The speaker is Abi (@abi_london). Abi are from AvePoint will talk about backup and restore.

You can read more about it here http://spbg.dk/Lists/Mder/DispForm.aspx?ID=56 and sign up here http://spbgerfa20130425.eventbrite.com/

New CodePlex project Create host named site collection

2013-04-08T19:16:00.000+02:00

I just releast a new codeplex project to help create host named site collection.
Project contains a central administration page that creates the host named site collections. Fill in the form and at the top of the page, the code to be used be to create site collection via PowerShell appear.

You can find the project here

Upload content type template through PowerShell

2012-09-26T19:39:00.000+02:00

In my current project, we make use of numerous different Word templates. To make template a part of the automated build process, I made a PowerShell script that

Loop through a folder on the disk
Find subfolder, named in a given way
Find the template
Finds the content type in SharePoint
Upload the template to the content type resource folder http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spcontenttype.resourcefolder.aspx
Save the content type

And the content type is ready to get published.

PowerShell script:

 1 Add-PsSnapin Microsoft.SharePoint.PowerShell -ErrorAction:SilentlyContinue | Out-Null
 2 $url = "http://win-l2sfc3oetnn/sites/doctemp/" #ContentTypeHub Url
 3 $templateFolderPath = "C:\Projects\demos\TemplateDemo"
 4 $filter = "*.dotx", "*.potx", "*.vst", "*.xltx"
 5 
 6 $contentTypeFolders = ls $templateFolderPath | where {$_.PsIsContainer}
 7 $templateCount = (ls $templateFolderPath -Include $filter -Recurse | where {!$_.PsIsContainer}).Count
 8 $i = 1
 9 $fileMode = [System.IO.FileMode]::Open
10 
11 $contentTypeFolders | % {
12     $path = $_.FullName
13     $foldername = $_.Name
14     $ctindex = $foldername.LastIndexOf("0x")
15     
16     if($ctindex -gt 0) {
17     
18         $contenttypeid = $foldername.Substring($ctindex, $foldername.Length - $ctindex)
19         $spcontenttypeid = New-Object Microsoft.SharePoint.SPContentTypeId $contenttypeid
20         
21         ls -Path $path | % {
22             #Need to open a new spweb object, to "refresh" the current content type object, to aviod database update conflict
23             $web = Get-SPWeb $url
24             $spcontenttype = $web.ContentTypes[$spcontenttypeid]
25             $fileFullname = $_.FullName
26             $filename = $_.Name
27             
28             Write-Progress -PercentComplete (($i / $templateCount) * 100) -Activity "Uploading templates" -Status "$filename on content type $($spcontenttype.Name)"
29             
30             $i++
31             try{
32                 #open the document template, as a filestream
33                 $fileStream = New-Object "System.IO.FileStream" -ArgumentList $fileFullname, $fileMode
34                 #add the file (SPFile) to the content type resource folder http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spcontenttype.resourcefolder.aspx
35                 $spcontenttype.ResourceFolder.Files.Add($filename, $fileStream, $true) | Out-Null
36                 $fileStream.Close()
37                 #set the current document template file to be the document tmeplate
38                 $spcontenttype.DocumentTemplate = $filename
39                 #update the content type
40                 $spcontenttype.Update($true)
41             }
42             finally{
43                 $fileStream.Close()
44             }
45         }
46     }
47 }

Download link

QuickPart values do not update with a blank Word templates

2012-09-19T18:03:00.000+02:00

In my current project, we make use of numerous different Word templates, but the basic for them all is they have a header and footer and they are the same. Header and footer containing quick-party showing SharePoint metadata, for e.g. status of the document. Of cause the values must be updated if the user changes them either from Word (document information panel) or from the SharePoint UI. We made a lot of templates, from meeting minutes to a letter template and all the values from the quick-party fields updated fine but our most simple Word template that only contain, header and footer, did not work. After a very long search we came to the Word template must include a text and a space is enough.

This will not work:

This will work:

Custom document infomartion panel, InfoPath form as letter selector

2012-09-12T22:07:00.000+02:00

I got a request from a customer, where they needed to add a custom address field to the head in a Word template. The address list need to come from a single source and easy to by update.

The tasks look like this:

Create the custom address list in SharePoint. Need a multiline field, where the address with line breaks can be added.
Content type with a Word template and custom information panel “InfoPath form”
The InfoPath form
Configure the document library
The Word template
Upload the Word template
Test

Creating the list for the address

Create a custom list.

Adding the multiline field.

Add value to the list.

Creating the content type

I call my content type “Letter”.

Add multiline text field, to the content type. In my demo i use the build in field Address.

When done, the content type look like this. Click on the document infomartion panel settings link.

Clikc on the "Create a new custom template” link.

InfoPath view

When InfoPath is finish loading, click on the “show field” button in the ribbon, “manage data connection” and then “Add…”.

Datasource wizzard

Follow the data connection wizzard.

The locatition is the url to the SharePoint site where the custom address list is created.

The done, the new data connection is add to the data connection lists.

Change the control

Right click on the Address field textbox, select “Change Control” and select “Drop-Down List Box”.

Change the control properties

Click on the Address field and select Drop-Down List Box Properties.

Change the properties to look like this.

Change the design a bit

Remove the line break after the first horizontal region.

Publish my form

Click on the Quick Publish button, in the right top corner.

InfoPath will akes if you want to save the InfoPath template, before publish it.

Configure and add content type to document library

On the document library, go to the document library settings page and under the “Advanced settings” page, change the setting “Allow management of content types” to true.

And the “Letter” content type.

Create the Word template

Go back to the document library and create a document based on the content type. This is the easyed way to create a template with the proper field add to the Word template.

Then Word is finish loading, go to the backstage, by clicking on the “file” icon, then click on the “properties” and select “Show Document Panel”.

Go back to Word.

In my demo, i edit the header. Go the Ribbon, under the “Insert” tab, select “Quick Part”, “Document Property” and then the “Address” field.

My template ends up looking like this.

Save the document as a “dotx” file (Word template file).

Upload the template

Find the “Letter” content type, select the “Advanced settings”.

Upload the template og click on the “OK” button.

The test

Go back to the document libary, click on the “Letter” content type in the “new document” button in the Ribbon.

Select the address in the document infomation panel.

And we are done

A great migration tool

2012-09-05T12:35:00.000+02:00

On my current project, we needed that to merger quite a lot of documents from one SharePoint to another SharePoint. To begin with, we expected that the project should do the merger of the documents and therefore we should spend a lot of time on it. We discuss it in the project group and came up with some solution proposal, which ranged from console application to PowerShell. However, we kept coming back to a problem. That we in the project did not know the structure that we had to migrate documents into, that was only our customer who is familiar structure. Of course, we could talk to the customer about how we should save every single document. After some discussion back and forth, we end up finally but not a particularly good solution. So back to the drawing board. Now, if we could create a program that could even be able to use and even stand to migrate documents, it would be the best solution. After some discussion back and forth, we end up finally, not a particularly good solution. So back to the drawing board. Now, if we could make a program that the customer could use and themselves migrate the documents, it would be the best solution. We estimate tasks and found out, if we create the program, it would take a very long time to develop. Therefore, we began to search for a 3-party tool. We found a few tools, but we found a tool from Share Gate.

ShareGate tool had several advantages, which we need, as they highlight on their website:

Drag & drop
Migrate SharePoint list items and documents
Preserve version history
Preserve created and modified information
Assign new content types
Field validation

But the most important of all, an interface that is easy and inviting, so that our customer does not need constant support to them and it's ShareGates "Copy SharePoint Content" tool.

Product Information:
Company: http://en.share-gate.com/
Product: http://en.share-gate.com/sharepoint-tools/copy-move-sharepoint-list-items-documents-with-metadata-and-version-history
Download: http://en.share-gate.com/download

SharePoint Manager 2013 release note

2012-08-27T15:41:00.001+02:00

I release the SharePoint Manager 2013 some time ago, more precisely on Jul 19 2012 and it now has over 2500 downloads on CodePlex witch I think is very good. This version is only intend as an upgrade of the 2010 version. However, I has added two new features. Both based on the feedback that has come from the 2010 version about speed. The first function is the most visual of the two. Function is plain and simply a splash screen that displays a picture as soon as you start the SharePoint Manager. The second feature is a configuration value in app.config file. The function is called “ShallowExpand”. Set it to true and the next time you start the SharePoint Manager only loads the farm and webapplication objects into treeview.

Screenshot of the loading screen:

Screenshot then the shallowexpand is false:

Screenshot then the shallowexpand is true:

But what should you expect? Keutmann and I are working to rewrite the whole core, so we would like to do SharPoint Manager yet quick and support even more properties

To use one-liner or not to use one-liner?

2012-01-21T22:12:00.001+01:00

A recurring problem in many of the projects I'm working on is a link to open a link up in a pop / model window. My first thought was to do as Venkatesh R've described it here http://geekswithblogs.net/venkatx5/archive/2010/11/17/how-to-open-a-page-in-sharepoint-2010-dialog-framework.aspx. By making a new SP.UI. $ create_DialogOptions (); object and call SP.UI.ModalDialog.showModalDialog. Not because it's hard but if you do not need the callback. So it is easier to do as described in the SharePoint Developer Team Blog http://blogs.msdn.com/b/sharepointdev/archive/2011/06/23/how-to-open-a-list-form-in-a-modal-dialog-box.aspx whereas in a one-liner can open link in a model window.
<div id="displayDiv"> <p> Please help us with our survey. Take our poll now! </ P> <input onclick = "javascript: SP.UI.ModalDialog.showModalDialog ({url: '.. / Lists / GBE / NewForm.aspx', title: 'User Survey'}); return false; "id =" btnVote "type =" button "value =" Vote "/> </ div>

Which approach would you choose? Post a comment with your solution.

Change the user profile property display ordre

2011-12-19T21:56:00.001+01:00

On the last couple of projects, the customer wants to change the display order of the user profile properties and there is the PowerShell to do it.

To see the current user profile display order call the script like this

& '.\change userprofile display ordre.ps1' http://spsite

To change the order call the script like this

& '.\change userprofile display ordre.ps1' http://spsite nameoftheuserprofileproperty sortorder

e.g. & '.\change userprofile display ordre.ps1' http://spsite firstname 5000

Download the powershell here

Playing with SharePoint Rich Text Editor (RTE)

2011-11-06T16:27:00.001+01:00

At my current project we needed to add a text highlight function button to the Rich Text Editors (RTE) ribbon, so when the user click on the button a selected text in the RTE, is wrapped with a predetermined HTML tag, indicating the text has been highlighted. Like <span css=”highlight”>the selected text</span>

The thing we need is:

1) The button in the ribbon, only showed when we are in the context of the RTE

2) The JavaScript snippet the will interact with the RTE

3) A feature the adds the ribbon button and the JavaScript to the page

The button is added to the style group like this:

<?xml version="1.0" encoding="utf-8"?>
<Elements xmlns="http://schemas.microsoft.com/sharepoint/">
<CustomAction
   Id="Ribbon.Demo.HighlightText"
   Location="CommandUI.Ribbon"
   Title="Insert Tooltips">
    <CommandUIExtension>
      <CommandUIDefinitions>
        <CommandUIDefinition Location="Ribbon.EditingTools.CPEditTab.Styles.Controls._children">
          <Button
           Id="Ribbon.Demo.HighlightText.Button"
           Sequence="12"
           LabelText="High light text"
           Alt="High light text"
           TemplateAlias="o1"
           Image32by32="/_layouts/RTE.Demo/images/highlight32.png"
           Command="Ribbon.Demo.HighlightText.Command"
           ToolTipTitle="High light text"
      />
        </CommandUIDefinition>
      </CommandUIDefinitions>
      <CommandUIHandlers>
        <CommandUIHandler
         Command="Ribbon.Demo.HighlightText.Command"
         CommandAction="javascript:HighLightText();"
         EnabledScript="true" />
      </CommandUIHandlers>
    </CommandUIExtension>
</CustomAction>
</Elements>

The JavaScript snippet looks like this:

function HighLightText() {
    var rng = RTE.Cursor.get_range().$3_0;
    var selectedText = RTE.Cursor.s_range.get_text();
    RTE.Cursor.get_range().deleteContent();
    var d = rng.ownerDocument;
    var a = d.createElement("span");
    a.innerHTML = selectedText;
    a.setAttribute("class", "highlight");
    SP.UI.UIUtility.insertAfter(a, rng);
}

Download the full project here

Events for Danes at the SharePoint Conference

2011-09-17T20:11:00.001+02:00

There are a lot of events at this year's SharePoint Conference, so in order to keep up, I've collected a list of events that are of interest to Danes.

Monday 3 October

20:00-00:00 - The RED Party presented by AvePoint
- http://www.avepoint.com/spc2011/the_red_party/
Heat Ultra Lounge (Anaheim GardenWalk,321 Katella Avenue, Anaheim) (http://www.heatultraloungeoc.com/)

20:30 – Danskerarrangement
- http://www.linkedin.com/groups/Danskerarrangement-mandag-3-oktober-kl-3830839.S.68372719

Tuesday 4 October

2000-1200 - Disneyland® Park Private Party for SharePoint Conference 2011
- http://www.mssharepointconference.com/pages/activitiespage.aspx#disney

Wednesday 5 October

17:00-19:30 - SP&TheCity Drinks&Networking (danske kvindelige deltagere)
- http://www.linkedin.com/groups/Ogs%C3%A5-i-%C3%A5r-inviterer-vi-3830839.S.50541142?qid=5df809d6-1fde-4738-8d1c-1ec08f13d637
Anabella Hotel, Tangerine Grill & Patio

20:00 - SharePint @ the SharePoint Conference 2011 in Anaheim, CA
- http://www.andrewconnell.com/blog/archive/2011/08/22.aspx
ESPNZone (http://www.espnzone.com/anaheim/)

19:30-1:00 - OktoberFiesta!
- http://events.r20.constantcontact.com/register/event?oeidk=a07e4rymr7ffc255c6b&llr=b4mprxfab
Tortilla Jo's Restaurant, Downtown Disney, Anaheim, CA

Visual Studio 2010 SharePoint Power Tools

2011-07-29T09:41:00.001+02:00

The Visual Studio 2010 SharePoint Power Tools is a set of templates and extensions that provides additional functionality to SharePoint developers who use the SharePoint developer tools in Visual Studio 2010. Below is the list of features included in the current release of the power tools.

http://visualstudiogallery.msdn.microsoft.com/8e602a8c-6714-4549-9e95-f3700344b0d9/

How to create send to connection with PowerShell?

2011-07-20T20:21:00.001+02:00

Send to connection is used in many seniors, so being able to deploy them through PowerShell is a must and it is in this way you do it:

First the XML configuration file, SendTos tag can be added multiple times if you have several applications. Under the SendTos tag is SendTo which is the connection itself. A send to consist of an Action, which can Copy, Move, or Link. Explanation which is the description for sending the link. Official filename is the name or title of sending the link. OfficialFileUrl is the URL of the site as the document to be sent, N.B. Remember that the content organizer feature must be enabled on the site. ShowOnSendToMenu is whether it should be shown in the document context menu.

<SendTos WebApplicationUrl="http://win-l2sfc3oetnn/">
  <SendTo>
    <Action>Move</Action>
    <Explanation>Move the document to 'a' site collection</Explanation>
    <OfficialFileName>Move to 'a'</OfficialFileName>
    <OfficialFileUrl>/docid/a/_vti_bin/officialfile.asmx</OfficialFileUrl>
    <ShowOnSendToMenu>false</ShowOnSendToMenu>
  </SendTo>
</SendTos>

The second part, is the PowerShell, where I loops thought the to sends tags and grab the web application. Then I test whether the connection already exists, if not I create it by adding a Microsoft.SharePoint.SPOfficialFileHost to OfficialFileHosts collection located on the web application.

[xml]$SendTos = gc $pwd\sendto.xml
 
$SendTos.SendTos | % {
	$webapp = Get-SPWebApplication $_.WebApplicationUrl.TrimEnd("/")
 
	$_.SendTo | % {
		$SendTo = $_
 
		$officialFileHostTemp = $webapp.OfficialFileHosts | ? { 
			$_.OfficialFileName -eq $SendTo.OfficialFileName 
		}
 
		if($officialFileHostTemp -eq $null)
		{
			[Microsoft.SharePoint.SPOfficialFileHost] $officialFileHost = New-Object "Microsoft.SharePoint.SPOfficialFileHost"
			$officialFileHost.Action = [Enum]::Parse([Microsoft.SharePoint.SPOfficialFileAction], $SendTo.Action)
			$officialFileHost.Explanation = $SendTo.Explanation
			$officialFileHost.OfficialFileName = $SendTo.OfficialFileName
			$officialFileHost.OfficialFileUrl = $url+$SendTo.OfficialFileUrl
			$officialFileHost.ShowOnSendToMenu = [bool]::Parse($SendTo.ShowOnSendToMenu)
			$webapp.OfficialFileHosts.Add($officialFileHost)
			$webapp.Update()
		}
		$officialFileHostTemp = $null
	}
}

Change the PowerShell UI Culture

2011-07-20T17:30:00.000+02:00

At one of my projects I’m using the new and greater multi language options in SharePoint 2010 and with ASP.Net resources it is really easy to create site in different languages. When I create a site e.g. in Danish the content type display name is translated into Danish, as expected, but when I start my SharePoint managed shell it is running in English context and if I have some PowerShell code which is dependent on language resources, then it will ask in English, but when my site is created in Danish, it may give some weird errors. The solution to this is to set PowerShell CurrentUICulture to be as the site you work with like this.

#Ensure the PowerShell process is running the same culture as SPWeb is created with
$web = Get-SPWeb "http://win-l2sfc3oetnn"
[int]$lcid = $web.Language
$culture = new-object "System.Globalization.CultureInfo" $lcid
[System.Threading.Thread]::CurrentThread.CurrentUICulture = $culture

Ribbon Toggle button demo

2011-05-29T15:33:00.001+02:00

I have a customer who need a toggle button in the Ribbon. Make a normal button in the Ribbon is straightforward and there is a lot of good articles out there. But there is not so many articles on the toggle button, Chris O'Brien and Wictor Wilen have some post, see the link, but not on handling server site code that call business logic to test which state the toggle button is in. My demo code is built around how to put a toggle button in a document library and test if it is on or off base on some server site business logic.

My demo code: http://cid-18d25562ce576dcc.office.live.com/self.aspx/Offentlig/SharePoint%20files/Ribbon.Demo.zip

Links:

How to add an application server role to your SharePoint farm

2011-03-13T13:27:00.001+01:00

To add an application sever with an application server role to your SharePoint farm run this PowerShell commands:

Connect-SPConfigurationDatabase -DatabaseServer "MySqlServer" -DatabaseName "MySharePointFarmName_SharePoint_Config" -Passphrase "myPassPhrase"
Install-SPHelpCollection -All
Initialize-SPResourceSecurity
Install-SPService
Install-SPFeature -AllExistingFeatures
Install-SPApplicationContent

For more infomation on this read this technet article “Add a Web or application server to the farm (SharePoint Server 2010)” - http://technet.microsoft.com/en-us/library/cc261752.aspx

Remove the SharePoint menu item “Edit in SharePoint Designer” in Site Action

2011-03-01T11:34:00.001+01:00

I had a customer who wanted to remove the menu option "Edit in SharePoint Designer" in the site action. It was not simply enough to disable edit in SharePoint Designer in central administration, for it does not remove the the menu item but make it just gray.
My first thought was to make a Hidde custom action, but it turns out that many of the items in the site action can not remove by a Hidde custom action. It turns out that the menu items in the site action is hardcore in the master pagen. eg. v4.master. So we have four solutions to the problem position.
1) We can remove the rights of the logged on user.
2) In v4.master file, remove the line 147 to 157th
3) Do some JavaScript that remove the menu item
4) Make a custom control or delegate control ala:

SPRibbon ribbonControl = this.Parent.Controls.Cast<Control>().First(c => (c is SPRibbon)) as SPRibbon;
SPRibbonPeripheralContent ribbonPeripheralContent = ribbonControl.Controls[0] as SPRibbonPeripheralContent;
SiteActions siteActions = ribbonPeripheralContent.Controls.Cast<Control>().First(c => (c is SiteActions)) as SiteActions;
FeatureMenuTemplate featureMenuTemplate = siteActions.Controls[0].Controls[2] as FeatureMenuTemplate;
Control editInSharePointDesigner = featureMenuTemplate.Controls.Cast<Control>().First(csd => (csd is MenuItemTemplate) && ((MenuItemTemplate)csd).Text.Equals("Edit in SharePoint Designer", StringComparison.InvariantCultureIgnoreCase));
featureMenuTemplate.Controls.Remove(editInSharePointDesigner);

Missing the open button when opening PDF files from SharePoint 2010.

2011-01-16T13:47:00.001+01:00

By the default setting of a SharePoint 2010, a users can’t open PDF files and many other files types (see the bottom of the post for all default file type allowed to download http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.administration.spwebapplication.allowedinlinedownloadedmimetypes.aspx) direct from SharePoint, neither “Display PDF in browser” mode or in the download popup, where the “open” button is missing.

The thing is SharePoint 2010 adds an additional security header to force the file to be saved to the disk before the users can open it. To fix this the BrowserFileHandling property should be set to “permissive” http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spbrowserfilehandling.aspx. This property exist both on a webapplication level http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.administration.spwebapplication.browserfilehandling.aspx and a on document library level http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.splist.browserfilehandling.aspx.

To fix this on a webapplication level, by using the GUI.

Open Central Administration
Application Management
Manage Web Applications
Select the webapplication to change
Click General Settings in the ribbon
Scroll down to Browser File Handling and select Permissive
Click on the OK button

To fix this with PowerShell on a webapplication level

Get-SPWebApplication http://vsitsp01 | % { $_.BrowserFileHandling = "permissive"; $_.update() }

To fix this with PowerShell on a document library level

$spweb = Get-spweb http://vsitsp01

$doclib = $spweb.Lists["Documents"]

$doclib.BrowserFileHandling

$doclib.BrowserFileHandling = "permissive"

$doclib.Update()

File types allowed to be download:

application/directx
application/envoy
application/fractals
application/internet-property-stream
application/liquidmotion
application/mac-binhex40
application/ms-infopath.xml
application/msaccess
application/msword
application/oda
application/oleobject
application/onenote
application/pics-rules
application/pkcs10
application/pkcs7-mime
application/pkcs7-signature
application/pkix-crl
application/postscript
application/rtf
application/set-payment-initiation
application/set-registration-initiation
application/streamingmedia
application/vnd.fdf
application/vnd.ms-excel
application/vnd.ms-excel.12
application/vnd.ms-excel.addin.12
application/vnd.ms-excel.binary.12
application/vnd.ms-excel.macroEnabled.12
application/vnd.ms-excel.macroEnabledTemplate.12
application/vnd.ms-excel.template.12
application/vnd.ms-office.calx
application/vnd.ms-officetheme
application/vnd.ms-pki.certstore
application/vnd.ms-pki.pko
application/vnd.ms-pki.seccat
application/vnd.ms-pki.stl
application/vnd.ms-powerpoint
application/vnd.ms-powerpoint.12
application/vnd.ms-powerpoint.addin.12
application/vnd.ms-powerpoint.macroEnabled.12
application/vnd.ms-powerpoint.presentation.12
application/vnd.ms-powerpoint.show.12
application/vnd.ms-powerpoint.show.macroEnabled.12
application/vnd.ms-powerpoint.slide.macroEnabled.12
application/vnd.ms-powerpoint.template.12
application/vnd.ms-powerpoint.template.macroEnabled.12
application/vnd.ms-project
application/vnd.ms-visio.viewer
application/vnd.ms-word.document.12
application/vnd.ms-word.document.macroEnabled.12
application/vnd.ms-word.template.12
application/vnd.ms-word.template.macroEnabled.12
application/vnd.ms-works
application/vnd.ms-xpsdocument
application/vnd.oasis.opendocument.presentation
application/vnd.oasis.opendocument.spreadsheet
application/vnd.oasis.opendocument.text
application/vnd.openxmlformats-officedocument.presentationml.slide
application/vnd.rn-realmedia
application/vnd.visio
application/vnd.visio.webdrawing
application/winhlp
application/x-bcpio
application/x-compress
application/x-cpio
application/x-csh
application/x-dvi
application/x-gtar
application/x-gzip
application/x-hdf
application/x-internet-signup
application/x-iphone
application/x-latex
application/x-miva-compiled
application/x-ms-application
application/x-ms-manifest
application/x-ms-reader
application/x-ms-vsto
application/x-ms-wmd
application/x-ms-wmz
application/x-msaccess
application/x-mscardfile
application/x-msclip
application/x-msdownload
application/x-msmediaview
application/x-msmetafile
application/x-msmoney
application/x-mspublisher
application/x-msschedule
application/x-msterminal
application/x-mswrite
application/x-netcdf
application/x-oleobject
application/x-perfmon
application/x-pkcs12
application/x-pkcs7-certificates
application/x-pkcs7-certreqresp
application/x-sh
application/x-shar
application/x-smaf
application/x-stuffit
application/x-sv4cpio
application/x-sv4crc
application/x-tar
application/x-tcl
application/x-tex
application/x-texinfo
application/x-troff
application/x-troff-man
application/x-troff-me
application/x-troff-ms
application/x-ustar
application/x-wais-source
application/x-x509-ca-cert
audio/aiff
audio/basic
audio/mid
audio/mpeg
audio/wav
audio/x-aiff
audio/x-mpegurl
audio/x-ms-wax
audio/x-ms-wma
audio/x-pn-realaudio
audio/x-pn-realaudio-plugin
audio/x-smd
drawing/x-dwf
image/bmp
image/cis-cod
image/gif
image/ief
image/jpeg
image/pjpeg
image/png
image/tiff
image/vnd.wap.wbmp
image/x-cmu-raster
image/x-cmx
image/x-icon
image/x-jg
image/x-portable-anymap
image/x-portable-bitmap
image/x-portable-graymap
image/x-portable-pixmap
image/x-rgb
image/x-xbitmap
image/x-xpixmap
image/x-xwindowdump
text/calendar
text/css
text/dlm
text/h323
text/iuls
text/plain
text/richtext
text/setext
text/tab-separated-values
text/x-ms-iqy
text/x-setext
text/x-vcard
video/mpeg
video/quicktime
video/x-ivf
video/x-la-asf
video/x-ms-wm
video/x-ms-wmp
video/x-ms-wmv
video/x-ms-wmx
video/x-ms-wvx
video/x-msvideo
video/x-sgi-movie

Install/Uninstall User Solution Application Wide

2010-12-12T13:51:00.001+01:00

Build on this blog post on how to get sandboxed on the farm, I also need to be able to install/uninstall sandboxed solution farm wide. There for I made they have two functions to wrap the install and Uninstall-SPUserSolution SPUserSolution.

The core code is when a call (a version 2) of the Get-UserSolution filter to get the deactiveated solutions and then call the build-in cmdlet Install-SPUserSolution

$gc = Start-SPAssignment
Get-UserSolution -SiteCollection $SiteCollection -Filter $Filter -Verboses:$Verboses | `
Where-Object -FilterScript { $_.Status -eq "Deactivated" } | `
Install-SPUserSolution -Site $SiteCollection -AssignmentCollection $gc
Stop-SPAssignment $gc

The code:

Get sandboxed solution on the farm

2010-12-12T10:33:00.001+01:00

How to get all sandboxed (user solution) installed on the SharePoint farm.

$gc = Start-SPAssignment
$gc | Get-SPSite | Get-SPUserSolution
Stop-SPAssignment $gc

The output:

Name                                SolutionId                                                      Status

----                                     ----------                                                         ------

Contacts.wsp                   3089ef04-527e-4b35-a0a2-af5f4df8a71b     Activated

Sandboxed1.wsp              a9240922-c794-433c-acf7-0ce7863b46d0 Deactivated

Sandboxed1.1.wsp           a9240922-c794-433c-acf7-0ce7863b46d0 Activated

Sandboxed1.1.wsp           a9240922-c794-433c-acf7-0ce7863b46d0 Activated

Sandboxed1.2.wsp           a9240922-c794-433c-acf7-0ce7863b46d0 Deactivated

Sandboxed1.wsp              a9240922-c794-433c-acf7-0ce7863b46d0 Activated

It is really simple to get a full list of sandboxed solutions, but the output is not useful, because we can see which site collection the sandboxed solution is store in.

This small PowerShell script will display the site collection url

function Get-UserSolution
{
	param(
		[Parameter(
    		Position=0, 
    		Mandatory=$true, 
    		ValueFromPipeline=$true,
    		ValueFromPipelineByPropertyName=$true)
    	]
    	$SiteCollection
	)
	process
	{
		Write-host "Site Collection:" $SiteCollection.Url
		$gc = Start-SPAssignment
		$SiteCollection | Get-SPUserSolution -AssignmentCollection $gc
		Stop-SPAssignment $gc
	}
}
Get-SPSite | Get-UserSolution

The output:

Site Collection: http://win-ugka6ujlm21

Name                               SolutionId                                                       Status
----                                    ----------                                                          ------
Contacts.wsp                   3089ef04-527e-4b35-a0a2-af5f4df8a71b     Activated
Sandboxed1.wsp              a9240922-c794-433c-acf7-0ce7863b46d0 Deactivated
Sandboxed1.1.wsp           a9240922-c794-433c-acf7-0ce7863b46d0 Activated
Sandboxed1.1.wsp           a9240922-c794-433c-acf7-0ce7863b46d0 Activated
Sandboxed1.2.wsp           a9240922-c794-433c-acf7-0ce7863b46d0 Deactivated
Site Collection: http://win-ugka6ujlm21/my

Site Collection: http://win-ugka6ujlm21/sites/sandbox

Sandboxed1.wsp              a9240922-c794-433c-acf7-0ce7863b46d0 Activated

The code:

Windows 7 Favorites and SharePoint

2010-11-06T17:37:00.001+01:00

One of the many cool features in Windows 7 is the Favorites

This is a list of “shortcut” that is display in the Windows Explore and in the “save as” dialog in programs like Word.

The Windows 7 Favorites works by creating a shortcut to folder and this goes for WebDav folders to.

To setup the a shortcut to a SharePoint site

To setup the shortcut and you only need to do this one time. Open Word and to go “save as” (the shortcut for this is F12), enter the url for the SharePoint site in the file name (Only the url!) and click enter or click on the save button. Then right click on the and select “Add current location to Farvorites” and wola your SharePoint is add and it is easy to browse next time when you want to save a document.

IE 9, site pinning, overlay icons and SharePoint

2010-11-01T21:14:00.001+01:00

One of the new thing in IE 9 is the site pinning. A cool new feature that allows a users to add a tab in IE9 to the taskbar. After the tab is added to the taskbar we can, from IE 9, interact with it, like overlay icons and ther is it where SharePoint comes in, as the data provider. I create an announcements list and read the current count from it and set the overlay icons to match the count all through JavaScript.

The results of adding two list items to announcements list

My code

This is the code in the PlaceHolderAdditionalPageHead content placeholder

<script src="http://ajax.Microsoft.com/ajax/jQuery/jquery-1.4.2.min.js" type="text/javascript"></script>

This is the code in the PlaceHolderMain content placeholder

<span id="statusInfomation">Loading...</span>
<script type="text/javascript">
var loadingIcon = "/_layouts/images/jumplist/search.ico"
 
var	getData = function()
{
	$.getJSON("/ie9test/_vti_bin/listdata.svc/Ie9TestAnno()/$count", function (data)
	{
		if(data != 0 && data < 6)
		{
			var icon = "/_layouts/images/jumplist/num_" + data + ".ico";
			setOverlayIcon(icon, "Now got " + data);
		}
		else if(data == 0)
		{
			setOverlayIcon("", "Now got " + data);
		}
	});
}
 
function setOverlayIcon(url, text)
{
	$("#statusInfomation").html(text);
	if(url != "")
	{
		window.external.msSiteModeSetIconOverlay(url, text);
	}
	else
	{
		window.external.msSiteModeClearIconOverlay();
	}
}
 
$(document).ready(function()
{
	setOverlayIcon(loadingIcon, "Loading...");
	setInterval(getData, 5000);
});
</script>

In function in line 21, is where I interact with the overlay icons, pure magic :D

- Happy IE 9 coding

List the controls added to a SPDelegate on a Website

2010-10-30T20:35:00.001+02:00

I need to inspect a delegate control, to discover which control there is add to it. So I create this PowerShell code to create a HttpContext, set the right Current.Items to be a real SharePoint context. Create a SharePoint Delegate Control, set the properties and then invoke CreateChildControls on it and out put the result on the screen.

[System.Reflection.Assembly]::LoadWithPartialName("System.Web") | Out-Null
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") | Out-Null
 
#parm
$delegateControlId = "SmallSearchInputBox"
$weburl = "/cwd"
$hosturl = "http://win-ugka6ujlm21"
$absoluteUrl = $hosturl+$weburl
 
#creating a fake httpcontext
$request = New-Object "System.Web.HttpRequest" "", $absoluteUrl, ""
$stringWriter = New-Object "System.IO.StringWriter"
$httpResponse = New-Object "System.Web.HttpResponse" $stringWriter
[System.Web.HttpContext]::Current = New-Object "System.Web.HttpContext" $request, $httpResponse
 
#HACK - Need a 'Microsoft.SharePoint.SPWeb' not a 'System.Management.Automation.PSObject'
[System.Web.HttpContext]::Current.Items["HttpHandlerSPWeb"] = (Get-SPSite -Identity $hosturl).OpenWeb($weburl, $false) 
 
#create and set properties for the delegate control
$dc = New-Object "Microsoft.SharePoint.WebControls.DelegateControl"
$dc.AllowMultipleControls = $true
$dc.ControlId = $delegateControlId
 
#create a method object and invole the method
$bindingFlags = [Reflection.BindingFlags] "NonPublic,Instance"
$method = $dc.GetType().GetMethod("CreateChildControls", $bindingFlags)
$method.Invoke($dc, @());
 
#list the child controls
$dc.Controls | %{
	$_.GetType().BaseType
}
 
#dispose
$StringWriter.Dispose | Out-Null
$httpResponse.Close() | Out-Null

The code:

Health Analyzer Demo

2010-09-21T16:44:00.001+02:00

What is health analyzer? This is the copy/pasta from msdns Overview of SharePoint Health Analyzer “SharePoint Health Analyzer is a feature in Microsoft SharePoint Foundation 2010 that enables administrators to schedule regular, automatic checks for potential configuration, performance, and usage problems in the server farm.”

So what we need to create a health analyzer rule?

Create a subclass of the SPHealthAnalysisRule or SPRepairableHealthAnalysisRule
Register the rule
Test/execute the rule

1) Create a subclass

In this demo I create a subclass of the SPRepairableHealthAnalysisRule and besides for implement the abstract properties from SPRepairableHealthAnalysisRule, I also override Check and Repair method.

The Check method is used to identify a single potential problem in the SharePoint environment. In this demo we are a test if a very important file exists on the c: drive.

public override SPHealthCheckStatus Check()
{
    FileInfo info = new FileInfo(@"c:\importantfile.txt");
    return info.Exists ? SPHealthCheckStatus.Passed : SPHealthCheckStatus.Failed;
}

Repair method is used to repair the problem that if the Check method return SPHealthCheckStatus.Failed. In the demo we just create the very important file on the c drive.

public override SPHealthRepairStatus Repair()
{
    try
    {
        if (Check().Equals(SPHealthCheckStatus.Failed))
        {
            FileInfo info = new FileInfo(@"c:\importantfile.txt");
            info.Create();
            return SPHealthRepairStatus.Succeeded;
        }
        else
        {
            return SPHealthRepairStatus.Succeeded;
        }
    }
    catch
    {
        //TODO: Log the error
        return SPHealthRepairStatus.Failed;
    }
}

2) Register the rule

Microsoft has a “How to: Create a Feature to Register a Health Rule” where they use a feature receiver to register rule with. But I’m big PowerShell fan, so it was naturally for me to create a simple PowerShell script to register and unregister.

Register PowerShell:

First we load the SharePoint DLL and my custom DLL. Then we call the static RegisterRules method with take the custom assembly as parameter. The RegisterRules return an IDictionary<Type, Exception>. We test if the IDictionary<Type, Exception> count is 0, if not, we display the exceptions by pipe the collection to the Format-List cmdlet.

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") | Out-Null
$assembly = [System.Reflection.Assembly]::LoadWithPartialName("HealthAnalyzerDemo")
$exceptions = [Microsoft.SharePoint.Administration.Health.SPHealthAnalyzer]::RegisterRules($assembly);
if($exceptions -ne $null)
{
	if($exceptions.Count -eq 0)
	{
		Write-Host "All rules were registered.";
	}
	else
	{
		$exceptions | fl
	}
}
$assembly = $null

Unregister PowerShell:

The only difference between the register script and the unregister script is, instead of call the RegisterRules method we call the UnRegisterRules.

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") | Out-Null
$assembly = [System.Reflection.Assembly]::LoadWithPartialName("HealthAnalyzerDemo")
$exceptions = [Microsoft.SharePoint.Administration.Health.SPHealthAnalyzer]::UnregisterRules($assembly);
if($exceptions -ne $null)
{
	if($exceptions.Count -eq 0)
	{
		Write-Host "All rules were unregistered.";
	}
	else
	{
		$exceptions | fl
	}
}
$assembly = $null

3) Test/execute the rule

Microsoft has a “How to: Test a Health Rule During Development” where they use a console application to test/execute the health rule. But this is so obviously a PowerShell thing :)

Execute rule PowerShell:

First we load the SharePoint DLL and my custom DLL. Then we create a new object of the rule class. Write the current return status from the Check method. Test if the status is equal to failed, if it is, we call the Repair method.

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") | Out-Null
[System.Reflection.Assembly]::LoadWithPartialName("HealthAnalyzerDemo") | Out-Null
$checkIfFileOnDiskExistRuleRepair = New-Object "HealthAnalyzerDemo.HealthAnalyzers.CheckIfFileOnDiskExistRuleRepair"
$status = $checkIfFileOnDiskExistRuleRepair.Check()
Write-Host "Status for"$checkIfFileOnDiskExistRuleRepair.Summary"is:"$status
if($status -eq [Microsoft.SharePoint.Administration.Health.SPHealthCheckStatus]::Failed)
{
	Write-Host "Calling the Repair method"	
	Write-Host "Result:" $checkIfFileOnDiskExistRuleRepair.Repair()
}

Summary:

It's really easy to make rules, that will give the It-pros a fight change to managed and maintain the SharePoint platform. Microsoft has some “Guidelines for Designing Health Rules”.

My demo code

Anders Dissing

SharePint

SPBG SPBG knowledge sharing meeting

New CodePlex project Create host named site collection

Upload content type template through PowerShell

QuickPart values ​​do not update with a blank Word templates

Custom document infomartion panel, InfoPath form as letter selector

A great migration tool

SharePoint Manager 2013 release note

To use one-liner or not to use one-liner?

Change the user profile property display ordre

Playing with SharePoint Rich Text Editor (RTE)

Events for Danes at the SharePoint Conference

Visual Studio 2010 SharePoint Power Tools

How to create send to connection with PowerShell?

Change the PowerShell UI Culture

Ribbon Toggle button demo

How to add an application server role to your SharePoint farm

Remove the SharePoint menu item “Edit in SharePoint Designer” in Site Action

Missing the open button when opening PDF files from SharePoint 2010.

Install/Uninstall User Solution Application Wide

Get sandboxed solution on the farm

Windows 7 Favorites and SharePoint

To setup the a shortcut to a SharePoint site

IE 9, site pinning, overlay icons and SharePoint

My code

List the controls added to a SPDelegate on a Website

Health Analyzer Demo

1) Create a subclass

2) Register the rule

Register PowerShell:

Unregister PowerShell:

3) Test/execute the rule

Execute rule PowerShell:

Summary:

QuickPart values do not update with a blank Word templates