Tags: Lync, Office 2013, Office365, Project 2013, Project Online, PS2013, Skype
If you want want to disable the Lync / Skype for Business presence in Project 2013, see the steps below.
Lync / Skype for Business Presence enabled:
Lync / Skype for Business Presence disabled:
To do this, install the April 2015 Cumulative update for Project 2013 (fully test on a test machine before using in production): https://support.microsoft.com/en-us/kb/2965279
Then create the registry key as detailed in the KB article.
You can either do this manually or via PowerShell, an example PowerShell command can be seen below:
This will create the following key:
Always back up the registry before making any changes (manually or via PowerShell etc.)
To enable Lync / IM presence again update the DisableIMStatus key value data to 0 and restart Project.
#ProjectServer and #SharePoint 2010 / 2013 April 2015 Cumulative Update #PS2010 #SP2010 #PS2013 #SP2013 #MSProjectApril 15, 2015 at 7:56 am | Posted in Administration, CU, Fixes, Functionality, Information | Leave a comment
Tags: Office 2010, Office 2013, Project 2010, Project 2013, Project Server 2010, Project Server 2013, PS2010, PS2013
The Office 2013 April 2015 Cumulative Updates are now available, please see the links below:
Project Server 2013 April 2015 Server Roll up package:
Project Server 2013 April 2015 CU:
Project 2013 April 2015 CU:
Also worth noting, if you haven’t done so already, install Service Pack 1 http://support2.microsoft.com/kb/2880556 first if installing the April 2015 CU.
The Office 2010 April 2015 Cumulative Updates are now available, please see the links below:
Project Server 2010 April 2015 Server Roll up package:
Project Server 2010 April 2015 CU:
Project 2010 April 2015 CU:
SP2 is a pre-requisite for the Office 2010 April 2015 CUs.
As always, fully test these updates on a replica test environment before deploying to production.
#ProjectOnline / #ProjectServer reporting on auto / manually scheduled tasks #BI #Office365 #Excel #PowerQuery #PS2013April 13, 2015 at 9:49 am | Posted in Add-on, Administration, Configuration, Functionality, Information, Reporting, Workarounds | 1 Comment
Tags: Excel, Excel Services, Office 2013, Office365, Power Query, Project 2013, Project Online, Project Server 2013
One issue or query that has been raised a few times is that when reporting on manually scheduled tasks and auto scheduled tasks the Start / Finish date fields do not show the same data that they do in Project or PWA for the manually scheduled tasks. For example, take a look at the example project plan below:
If I generate a reporting for this project using the equivalent fields from the OData API, see below:
As you can see all tasks have start and finish dates. The Manually scheduled tasks that are either blank or have text displayed in Project Pro contain dates in the report. These default to the Project Start date. The OData query used is below:
This can be quite misleading from a reporting point of view. There are two options (probably more but two documented here!), these are detailed below in order of preference:
The preferred option would be to create a calculated field in the report, in this example, as I am using Excel I will create this in Power Query. I have my dataset in the Power Query Editor like below:
The OData query used is below:
Now click Add Column > Add Custom Column:
Give the column a name then create the formula:
Click OK to add the new custom column, repeat for the finish date:
After re-ordering and removing some columns my dataset now looks like this in the Query Editor:
The final change is to update the Data Types of the columns, in this example I updated the TaskStartDate and TaskFinishDate columns to Date/Time and my calculated DisplayedStartDate and DisplayedFinishDate columns to Text:
Now I am happy with the query I click the Close & Load button on the Home tab:
This will load my data into Excel:
As you can see the data displayed in my calculated columns on my report match the data in the fields on my Project Plan:
The other option is to create new Enterprise Custom Fields in Project Online that are calculated. Using Start date as an example, create a task level text field that is based on formula, the formula would be =[Start]. I have called the field “DisplayedStartDate”. In Project Pro:
In my updated Excel Report:
The OData query used is below:
As you can see this also gives the correct data but does introduce two additional calculated task level fields in your Project Online configuration. It is recommended to keep the task level calculated fields to a minimum – ideally below 5 for performance reasons hence this option being the least preferred.
Tags: MVP, Project 2013, Project Online, Project Server 2013
Some good news, I’m very pleased to announce that my Project MVP award was renewed for the third time after first being awarded in April 2013. I am really grateful for the recognition, especially as I still enjoy helping out the Project and Project Server / Project Online community so much. It is kind of a hobby of mine I guess, or maybe just an obsession!