This was a flow I developed a few years ago now but never got around to publishing a blog post for it. It is quite a simple Power Automate flow that demonstrates updating a Project Online project level enterprise custom field value for a field that uses a lookup table. The full Power Automate flow... Continue Reading →
#ProjectOnline Project Ideas list view with Project GUID #Office365 #SharePoint #JavaScript #jQuery
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 →
#ProjectOnline #Excel #PowerQuery Report #Office365 #PS2013 #BI #OData
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 →
Free #ProjectOnline /ProjectServer advice sessions @ #ProjChallenge #PPM #Microsoft #Project #PMOT
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 →
#ProjectServer #PowerView report in #Excel 2013 #PS2010 #PS2013 #Office2013
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 →
Create and publish a Project in #ProjectServer via #PowerShell #PS2010 #MSProject #SP2010
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 →
#ProjectServer 2010 PSI #PowerShell examples #PS2010 #MSProject #SP2010
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 →
Unknown error when saving #ProjectServer Security Group #PS2010 #MSProject #SP2010 #EPM
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 →
Some #ProjectServer default fields not in the Reporting Database #PS2010 #MSProject #SP2010
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 →
Report on Project Server baseline save dates? #ProjectServer #PS2003 #PS2007 #PS2010 #MSProject #EPM
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 →
You must be logged in to post a comment.