Want to disable #Lync / #Skype #IM presence in #MSProject 2013?

April 15, 2015 at 9:26 am | Posted in Add-on, Administration, Configuration, Customisation, Functionality, Information | Leave a comment
Tags: , , , , , ,

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:

image

Lync / Skype for Business Presence disabled:

 image

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:

image

This will create the following key:

image

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 #MSProject

April 15, 2015 at 7:56 am | Posted in Administration, CU, Fixes, Functionality, Information | Leave a comment
Tags: , , , , , , ,

The Office 2013 April 2015 Cumulative Updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/3050766

Project Server 2013 April 2015 Server Roll up package:
https://support.microsoft.com/en-us/kb/2965263

Project Server 2013 April 2015 CU:
https://support.microsoft.com/en-us/kb/2965278

Project 2013 April 2015 CU:
https://support.microsoft.com/en-us/kb/2965279

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:

https://support.microsoft.com/en-us/kb/3050766

Project Server 2010 April 2015 Server Roll up package:
https://support.microsoft.com/en-us/kb/2965293

Project Server 2010 April 2015 CU:
https://support.microsoft.com/en-us/kb/2965302

Project 2010 April 2015 CU:
https://support.microsoft.com/en-us/kb/2965204

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 #PS2013

April 13, 2015 at 9:49 am | Posted in Add-on, Administration, Configuration, Functionality, Information, Reporting, Workarounds | Leave a comment
Tags: , , , , , , ,

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:

image

If I generate a reporting for this project using the equivalent fields from the OData API, see below:

image

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:

Tasks()?$Select=ProjectName,TaskName,TaskStartDate,TaskFinishDate,TaskIndex

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:

Option 1:

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:

image

The OData query used is below:

Tasks()?$Select=ProjectName,TaskName,TaskStartDate,TaskStartDateString,TaskFinishDate,TaskFinishDateString,TaskIsManuallyScheduled,TaskIndex

Now click Add Column > Add Custom Column:

image

Give the column a name then create the formula:

image

Click OK to add the new custom column, repeat for the finish date:

image

After re-ordering and removing some columns my dataset now looks like this in the Query Editor:

image

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:

image

Now I am happy with the query I click the Close & Load button on the Home tab:

image

This will load my data into Excel:

image

As you can see the data displayed in my calculated columns on my report match the data in the fields on my Project Plan:

image

Option 2:

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:

image

In my updated Excel Report:

image

The OData query used is below:

Tasks()?$Select=ProjectName,TaskName,TaskStartDate,TaskFinishDate,DisplayedStartDate,TaskIndex

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. 

#ProjectServer and #SharePoint 2010 / 2013 March 2015 Cumulative Update #PS2010 #SP2010 #PS2013 #SP2013 #MSProject

March 12, 2015 at 7:47 am | Posted in Administration, CU, Fixes, Functionality | Leave a comment
Tags: , , , , , , ,

The Office 2013 March 2015 Cumulative Updates are now available, please see the links below:

http://support.microsoft.com/kb/3040794

Project Server 2013 March 2015 Server Roll up package:
http://support.microsoft.com/KB/2956162

Project Server 2013 March 2015 CU:
http://support.microsoft.com/kb/2956178

Project 2013 March 2015 CU:
http://support.microsoft.com/kb/2956187

Also worth noting, if you haven’t done so already, install the March 2013 Public update: http://support.microsoft.com/kb/2768001 or Service Pack 1 http://support2.microsoft.com/kb/2880556 if installing the March 2015 CU.

The Office 2010 March 2015 Cumulative Updates are now available, please see the links below:

http://support.microsoft.com/kb/3040794

Project Server 2010 March 2015 Server Roll up package:
http://support.microsoft.com/KB/2956198

Project Server 2010 March 2015 CU:
http://support.microsoft.com/kb/2553480

Project 2010 March 2015 CU:
<no update this month>

SP2 is a pre-requisite for the Office 2010 March 2015 CUs.

As always, fully test these updates on a replica test environment before deploying to production.

For more details see: http://blogs.technet.com/b/projectsupport/archive/2015/03/11/microsoft-project-server-2010-and-2013-march-2015-pu-announcement.aspx

#ProjectServer / #ProjectOnline Users and Resources #PPM #Project

February 26, 2015 at 7:29 am | Posted in Administration, Functionality, Information | Leave a comment
Tags: , ,

A quick post just to highlight a difference between Project Server 2013 on-premise and Project Online regarding being able to deselect “User can be assigned as a resource” from the Edit User page.

For Project Online this option is disabled as you can see below:

image

For Project Server 2013 (on-premise) this option is enabled:

image

For Project Server 2013 on premise where you can deselect this check box it is recommended that you don’t use this option as un-checking it can potentially cause issues in some scenarios hence this option being disabled in Project Online. I imagine that there will be a change for Project Server 2013 on-prem soon that will bring this inline with Project Online.

#ProjectOnline / #ProjectServer #Project Cost and Work Report #JavaScript #jQuery #Office365 #SharePoint #BI #PPM

February 25, 2015 at 5:34 pm | Posted in Administration, Customisation, Functionality, Information, Reporting | Leave a comment
Tags: , , ,

This script will enable users to display the project cost and work on a column chart. The projects displayed are filtered by the selected Enterprise Project Type (EPT). The script can be downloaded from the script gallery below:

https://gallery.technet.microsoft.com/Server-Online-Cost-and-83bbff27

To get the script to work you will need to download the following jQuery library: jquery-2.1.1.min.js – jQuery download Another version of this library may work but this was the one I used / tested with. Upload this library to your PWA site collection then update the script file with the correct location. I uploaded this file to the site collection document library as you can see in the code below:

image

The script also makes use of a charting library called Highcharts. Highcharts is available from a company called Highsoft. Highcharts is only free for non-commercial use, see the link below for details:

http://shop.highsoft.com/faq/non-commercial#what-is-non-commercial

If you do use this library in scripts or applications that you sell / anything commercial you will need to purchase the correct licence to do so.

Other charting libraries can be used, just update the code based on the requirements of your chosen charting library.

This script also uses the ProjectData Odata API so users will need access to this API for the report to work.

Once the script is downloaded, upload this to the PWA site collection, in this example it was uploaded to the shared documents library. Choose where you want the script to be accessed, in this example I created a new page, added a content editor web part on the new page then referenced the uploaded script using the content editor web part:

image

Once loaded, the page will look like this:

image

The selection menu will contain the Enterprise Project Types (EPT), selecting an EPT will then update the two charts with those projects and display the cost and work.

A quick video can be seen here: http://screencast.com/t/pRbxh1kq

This only uses intrinsic fields so should work for any Project Online environment but do test it thoroughly first. You might want to improve the error handling, data filtering etc. before deploying to a production environment. Also remember this does require the user to have access to the ProjectData API for this to work.

The script is provided “As is” with no warranties etc.

#ProjectServer and #SharePoint 2010 / 2013 February 2015 Cumulative Update #PS2010 #SP2010 #PS2013 #SP2013 #MSProject

February 16, 2015 at 6:46 pm | Posted in Administration, CU, Fixes, Functionality, Information | Leave a comment
Tags: , , , , , , ,

The Office 2013 February 2015 Cumulative Updates are now available, please see the links below:

http://support.microsoft.com/kb/3032763 

Project Server 2013 February 2015 Server Roll up package:
http://support.microsoft.com/kb/2920796

Project Server 2013 February 2015 CU:
http://support.microsoft.com/kb/2880996

Project 2013 February 2015 CU:
http://support.microsoft.com/kb/2956091

Also worth noting, if you haven’t done so already, install the March 2013 Public update: http://support.microsoft.com/kb/2768001 or Service Pack 1 http://support2.microsoft.com/kb/2880556 if installing the February 2015 CU.

The Office 2010 February 2015 Cumulative Updates are now available, please see the links below:

http://support.microsoft.com/kb/3032763

Project Server 2010 February 2015 Server Roll up package:
http://support.microsoft.com/kb/2899557

Project Server 2010 February 2015 CU:
http://support.microsoft.com/kb/2881024

Project 2010 February 2015 CU:
http://support.microsoft.com/kb/2589387

SP2 is a pre-requisite for the Office 2010 February 2015 CUs.

As always, test these updates on a replica test environment before deploying to production.

For more details see: http://blogs.technet.com/b/projectsupport/archive/2015/02/11/microsoft-project-server-2010-and-2013-february-2015-pu-announcement.aspx

#ProjectOnline #Excel #PowerQuery Report #Office365 #PS2013 #BI #OData

January 20, 2015 at 1:21 pm | Posted in Administration, Configuration, Customisation, Functionality, Information, Reporting | 2 Comments
Tags: , , , , , ,

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 in this post but there is plenty of information available already.

So firstly, what is Power Query. In short, Power Query is an add in for Excel that enables you to work with many different data sources and transform that data as required. An intro can be seen here. Power Query is formula based but this is different formula syntax to what you use in Excel. The Power Query formulas are based on what was known a “M” language, an intro to the formulas can be found here.

Now we will look at creating a simple Excel Power Query report for Project Online using the OData API. The first report we will create will be a simple report that allows you to dynamically filter the data based on a text value in a cell. The dynamic filtering is useful when you are looking at large amounts of data such as time phased assignments in Project Online. The example we create below doesn’t really benefit from the dynamic filtering as the data set is small but this is only an example to show you how this works.

Get your Project ODATA url, for this example and am using the following:

https://<URL TENANT>/sites/pwa/_api/ProjectData/Projects()?$select=ProjectName,ProjectOwnerName,ProjectWork,ProjectCost,ProjectDuration,ProjectPercentCompleted,ProjectDescription,EnterpriseProjectTypeName

Launch Excel and click the Power Query tab then From Other Sources > From OData feed:

image

Paste in the URL:

image

Click OK. You will then be presented with an authentication window. Select “Organizational account” from the left hand side navigation and click Sign In. In the new window that appears enter the credentials for an account that has access to the ProjectData API.

Once authenticated you will see the Power Query Preview window load with the data:

image

You can see the formula used in the formula bar:

image

If you can’t see the formula bar, click the View tab and check the Formula bar check box:

image

We now have our Project Online data in Power Query ready to be used as a data source. In this example I have already selected the columns I wanted, but if you just used the Projects feed with no select (..pwa/_api/ProjectData/Projects()) you would see all of the columns displayed. At that point you can then easily chose which columns you would like in your data source by selecting the columns you don’t need then right click and chose Remove Columns.

image

Then you can see those columns have been removed. The formula bar has been updated with the latest steps:

image

You will also see another step appear in the applied steps, see it has the “Removed Columns” step:

image

At any point in time you can switch back to a previous step or even delete a step. If I click back on the source step I see the original data set with the two columns I deleted:

image

For the purpose of this post I will delete the “Removed Columns” step but before I do I want to show the Advanced Editor screen. This is available from the View tab:

image

This editor enables you to type the query yourself rather than using the UI menus. Some things you might want to do might not be possible from the UI and you are required to type / update the query. I will now delete the “Removed Columns” steps and you can see the query has been updated:

image

I can manually update the query update the data set, for example I can manually update the query to remove columns:

image

You will then see the data update and an applied step appear:

image

Now I am happy with my simple data set, but before I do anything I will update the query name to “Projects”:

image

Now chose “Close & Load To…” from the Home tab:

image

Then chose “Only create the connection” also check the check box to load the data to the data model:

image

You will then see the Excel sheet with the Workbook Queries window that allows you to preview the data:

image

Before we create the Excel report, I want be able to filter the data based on the Project Owner. Next insert a table like below:

image

Enter any Project Owner name for now, I used he MOD Administrator in this example as that user is the Project Owner for a few projects. Give the table a name, in this example I called it ProjectOwnerTable.

Now click the Power Query tab then “From Table”:

image

The Power Query editor will load with the following:

image

Switch to the advanced editor to see the query:

image

Update the query to change the type and select the record:

image

The record will then be displayed:

image

Now click the “Close & Load To…” from the Home tab and chose the “Only create connection” and check the check box to add the data to the data model.

Now load the first Projects query that was created in Power Query and switch to the advanced editor:

image

This needs to be modified to filter for the Project Owner in the new table that was created. See the updated query below:

image

You will need to enable the data in privacy option:

image

image

Click Close and load to save the changes in the Power Query editor and you will see the Excel worksheet:

image

Now you can create the Excel report, for this I will add a Pivot Table using an External Data source then selecting my data model:

image

Then update the pivot table with the fields:

image

Change the layout etc.

image

image

This is filtered to the projects where the owner is MOD Administrator, if I want to see other projects, update the Project Owner on row 2 and refresh the data:

image

image

A very quick and simple intro the Power Query for Excel with Project Online data using the ProjectData Odata API.

I hope to give more examples in the future.

#ProjectServer #PS2013 update reference #PPM #MSProject

December 22, 2014 at 10:56 am | Posted in Administration, CU, Fixes, Functionality, Information | Leave a comment
Tags: , , , ,

A quick post to highlight a couple of great links from Brian Smith for Project Server 2013 / Project Pro 2013 updates / patches. See the links below:

Project 2013 client update reference: http://blogs.technet.com/b/projectsupport/p/msp13.aspx

Project Server 2013 update reference: http://blogs.technet.com/b/projectsupport/p/ps13cu.aspx

Bookmark these links today! Smile

#ProjectServer and #SharePoint 2010 / 2013 December 2014 Cumulative Update #PS2010 #SP2010 #PS2013 #SP2013 #MSProject

December 11, 2014 at 12:37 pm | Posted in Administration, CU, Fixes, Functionality, Information | Leave a comment
Tags: , , , , , , ,

The Office 2013 December 2014 Cumulative Updates are now available, please see the links below:

https://support.microsoft.com/kb/3020816

Project Server 2013 December 2014 Server Roll up package:
https://support.microsoft.com/kb/2910911

Project Server 2013 December 2014 CU:
https://support.microsoft.com/kb/2910944

Project 2013 December 2014 CU:
https://support.microsoft.com/kb/2910920

Also worth noting, if you haven’t done so already, install the March 2013 Public update: http://support.microsoft.com/kb/2768001 or Service Pack 1 http://support2.microsoft.com/kb/2880556 if installing the December 2014 CU.

The Office 2010 December 2014 Cumulative Updates are now available, please see the links below:

http://support.microsoft.com/kb/3020815

Project Server 2010 December 2014 Server Roll up package:
http://support.microsoft.com/kb/2899587

Project Server 2010 December 2014 CU:
http://support.microsoft.com/kb/2910889

Project 2010 December 2014 CU:
http://support.microsoft.com/kb/2910893

SP2 is a pre-requisite for the Office 2010 December 2014 CUs.

As always, test these updates on a replica test environment before deploying to production.

For more details see: http://blogs.technet.com/b/projectsupport/archive/2014/12/10/microsoft-project-server-2010-and-2013-december-2014-cu-announcement.aspx

Next Page »

Create a free website or blog at WordPress.com. | The Pool Theme.
Entries and comments feeds.

Follow

Get every new post delivered to your Inbox.

Join 772 other followers