Skip to main content


Showing posts from September, 2014

Sharepoint Map Network Drive

For a long time i have looked for a simple way to retrive and update documents stored in SharePoint. Today i found a very cool way to download all SharePoint documents to a network drive. This method works at least in SharePoint/Project Server 2007, 2010, 2013.

To map a SharePoint document library to a network drive simply navigate to the document library and copy the URL.
(In the below example i am referencing a library called "Documents")

Do not copy the "/Forms/Allitems.aspx" part.

Now in "File Explorer" leftclick on your "Computer" and select "Map network drive...".

Paste the URL to the document library and click "Finish", in my case the URL is: "".
And now the document library is mapped to your local computer.

Project Site - Project/Custom fields displayed on Project Site or Project Workspace

If you want to display project fields or project custom fields on your project site, like in the image below, there are only a limited number of possibilities. One of them is of cause to use an App, but that limits the layout to the App.

In this post, I will walk you through how to insert a script that loads and displays any project field you like. The Script is really easy to configure.
I should mention that I found part of this solution at Poul's Project blog (link) but his solution was very difficult to configure so I rewrote the whole code.

First thing you need is to upload your JQuery script file to the PWA site. if you already have a JQuery file uploaded it will properly do fine.

Download the JQuery file here and save it on your desktop.

Go to the Site Settings of the PWA and click on Master Pages.

Upload the JQuery file here and publish it.
View properties of the file and copy the JQuery file link.
Now go to yo…

Powershell procedures/cmdlets - MS Project client/Project Server

Powershell is becoming part of any IT-Administrator inventory. If you worked with Project Server 2013 or SharePoint 2013 you are properly avare of many of the many cmdlets available.

Project Server - Powershell cmdletsFor a list of the Project Server cmdlets see this Technet article:

MS Project - Powershell cmdletsUntill recently I was not aware you can access the MS Project client though Powershell. There is actally quite a big API available as you are simply attaching into the VBA/VSTO API.
To connect to the MS Project client simply start up the Powershell ISE and use the following command. $Project = New-Object -ComObject msproject.application
After you are connected the commands are very similar to the VBA counterpart, if you for example want to find the name of all the tasks.
$Project.Visible = $True $tsks = $Project.ActiveProject.Tasks Foreach ($tsk in $tsks) { Write-Host $tsk.Name }
Or if …

SharePoint 2013 CAML Designer

When integrating SharePoint with Project Server I very often need to create some CAML query to filter/order/select list items.
To write the CAML query by hand can be quite timeconsuming. And you almost certain need an application to design the query for you.

There is a lot of applications out there to do this, but in my oppinion the best application by far is CAML Designer 2013.

Simply start the application and type in the site URL where the list is located.

Click the connect button and start designing your CAML.

Super easy!!

The application also works for SharePoint Online and Project Online.

The application can be downloaded from the website, simply go to and download the click-once offline package.

Other applications that have the same or similar funktionality:

Project Server 2010 - PSI - Calendar Exceptions (AddCalendarExceptionsRow, RemoveCalendarExceptionsRow)

In the recent week we were creating an integration with vacation information from an external system into Project Server (2010).
We wanted to replicate all the calendar exceptions from the external system into Project Server.

This task looked quite simple until we got started using the PSI interface. We encountered a couple of problems and strange documentation. In our scenario we could not update the Project Server to the latest service pack so i do not know if these errors already are fixed.

In the following I will demonstrate how to delete all calendar exceptions on a resource and add only one new exception. This program was only created to outline how the PSI interface worked with calendar exceptions (creating one random exception does not make a lot of sense).

//The resource uid on the resource we want to change. Guid resUID = new Guid("10b4d15c-4b62-417b-9b4d-924000c14cac"); WS_Resources.Resource wsresource = new WS_Resources.Resource(); wsresource.Url = "http://…

Project Server Read Only Custom Fields

There are multiple ways to create read only custom fields in Project Server 2007/2010/2013. The most common way is through Javascript and a Content Editor Web part

Another more simple way is to use the build in custom fields in Project Server. The downside in this solution is that it is not as flexible as the javascript solution, however it can easily solve the most common scenarios.
Read only custom field - through standard functionality Assume we have a custom field "Project SAP Number", this field is maintained by the PMO and we do not want the project managers to change it.
We would then create a new calculated custom field.
Go to the PWA and navigate to Server Settings->Enterprise Custom Fields and Lookup Tables.
Click on New Field.
Name the new field "Project SAP Number (Read Only)" and select "Project" in Entity, "Text" in Type and "Formul…

Project Server Minimize/Hide Quick Launch

On a standard Project Server or SharePoint web page there is a quick launch in the left side of the screen. it is not always desirable to have view this side bar to the user and sometimes you just want to hide it and let the user restore it when he needs it.

Remove Quick Launch
If you just want to remove the quick launch on a SharePoint web page you can add the following script in a content editor on the webpage.

<style type="text/css">          

But if you want to let the user be able to view it on command you can do it by adding Javascript to the content editor webpart.

Hide Quick Launch