Modern Work Management – Project and the Power Platform blog
Microsoft Project, Project Online, Project for the Web and the Power Platform
For those of you that are familiar with the project ideas lists in Microsoft’s PPM PWA application you might want to skip this first paragraph. Any list you create in the PWA site collection at the top level you will see a button Create Projects, if you are not familiar with this feature take a... Continue Reading →
Something I have been meaning to blog about for a while now is Power Query. There is nothing revolutionary in this post but hopefully it will give the readers some idea of how powerful Excel Power Query can be if they have not seen / used it before. We will only touch the surface here... Continue Reading →
Just a quick email to let you know that I will be at Project Challenge in October 2014 at Olympia, London. I will be there over the two days and available for free 20 minute sessions where general advice can been given for common business or technical issues relating to the Microsoft PPM toolset. For... Continue Reading →
This post will take a brief look at creating a map view of Project Server data – this does assume you tag your projects with a location! For the purpose of this post I will use the example Excel file shown below – this pulls data from one of my test Project Server PWA instances,... Continue Reading →
Following on from a recent post on Project Server PSI PowerShell scripts, I thought of a nice slightly more advanced example. The script below will create a new project using the specified project template. $ProjName = Read-Host -Prompt "Enter the Name of the Project" Write-host "The Project is called $ProjName" $svcPSProxy = New-WebServiceProxy -uri "http://vm353/pwatest/_vti_bin/PSI/Project.asmx?wsdl"... Continue Reading →
Following from a post I wrote mid last year on Project Server data export using the PSI and PowerShell I thought I would create a new post to show further simple examples of getting Project data via the PSI using PowerShell (no coding!). Firstly I will just explain each part of a simple script using... Continue Reading →
I came across this issue on my test instance a while back and never bothered to investigate it or fix it, when trying to save the security group the following error was returned: The group could not be saved due to the following reason(s): An unknown error has occurred. An unknown error has occurred. After... Continue Reading →
Not all default fields are available in the Project Server Reporting database, for example the Contact and Resume fields. To be able to easily include these fields in reports using direct T-SQL you will need to get the values for these fields in the Project Server Reporting database. The easiest was to achieve this is... Continue Reading →
Quite often clients want to report on the dates when the baselines were saved. This information is not available out of the box in the databases using T-SQL. This post explains how to get this data into the database so that is accessible using T-SQL in the Reporting database. Firstly we need to create 11... Continue Reading →
