Archive

Author Archive

Formatting #ProjectServer PDP using #CSS and #JavaScript

April 23, 2015 Leave a comment
We place Project Server custom fields to Project Detail Pages using Basic info web-part.

There is often a need a when we have to drop more than one basic info web-part to a same page to group similar fields. I usually do this when i have to put similar fields under one group heading.

When you add custom fields to the page using more than few webparts, following potential issues can occur:

  1. Due to an extra padding automatically included by default for each webpart. You will observe a noticeable gap between each webpart on same page. And OOB configuration of webpart doesn’t have any way to reduce this gap. So in some cases, it may become unacceptable for customer. 
  2. Dropping custom fields on same page using several Basic info webparts can also cause alignment issue between custom fields. 

Below image depicts both issues:

And here comes an easy solution to reduce the gap between webparts, add the below css to PDP using content editor webpart, and it will reduce spacing to 0:

<style type="text/css">
     .ms-webpartPage-root {
         border-spacing: 0px !important;
     }
       .ms-webpartzone-cell {
         margin: 0px !important;
     }
 </style>

For alignment of custom fields, use below JavaScript through content editor webpart on the page:
(you can use width value to adjust width of page according to your need)

<script src=”http://bit.ly/1d6tFm3&#8243; type=”text/javascript”></script><script type=”text/javascript”>
$( document ).ready(function() {

    $(“tr td.ms-formlabel”).width(“500px”);

})
</script><br/>

(source of above JavaScript code is from Martin Laukkanen’s blog)

Lets witness the magic now:
Before:                                              After:  

    

 until next time.

via All about Enterprise Project Management (EPM) http://bit.ly/1d6tFm6

Khurram Jamshed
The author of the blog has an extensive experience of working as an EPM Consultant. Currently he is located in Dubai, UAE and working for Microsoft partner organization as Project Server specialist. He has a thorough experience of providing Project Management technical/functional consultancy to all sort of organizations. He is a certified PMP, a Project Server MCITP, and also received a MS community contributor award 2011.

This article has been cross posted from khurramjamshed.blogspot.com/ (original article)

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

April 15, 2015 Leave a comment
Paul Mather
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011.
I am also a certified Prince2 Practitioner.

This article has been cross posted from pwmather.wordpress.com (original article)

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): http://bit.ly/1Od9oGX

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.

Categories: Paul Mather, Work Tags:

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

April 15, 2015 Leave a comment
Paul Mather
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011.
I am also a certified Prince2 Practitioner.

This article has been cross posted from pwmather.wordpress.com (original article)

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

http://bit.ly/1Od9mi2

Project Server 2013 April 2015 Server Roll up package:
http://bit.ly/1EE7M8n

Project Server 2013 April 2015 CU:
http://bit.ly/1Od9oGW

Project 2013 April 2015 CU:
http://bit.ly/1Od9oGX

Also worth noting, if you haven’t done so already, install Service Pack 1 http://bit.ly/1uorn2C first if installing the April 2015 CU.

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

http://bit.ly/1Od9mi2

Project Server 2010 April 2015 Server Roll up package:
http://bit.ly/1Od9oXa

Project Server 2010 April 2015 CU:
http://bit.ly/1EE7MoG

Project 2010 April 2015 CU:
http://bit.ly/1Od9oXc

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.

Categories: Paul Mather, Work Tags:

#ProjectOnline / #ProjectServer reporting on auto / manually scheduled tasks #BI #Office365 #Excel #PowerQuery #PS2013

April 13, 2015 Leave a comment
Paul Mather
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011.
I am also a certified Prince2 Practitioner.

This article has been cross posted from pwmather.wordpress.com (original article)

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. 

Categories: Paul Mather, Work Tags:

#Project #MVP Award #ProjectOnline #PS2013 #ProjectServer #MVPBuzz #Microsoft

Paul Mather
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011.
I am also a certified Prince2 Practitioner.

This article has been cross posted from pwmather.wordpress.com (original article)

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!

Categories: Paul Mather, Work Tags:

#Microsoft Ignite #Project Sessions #ProjectServer #SharePoint

March 20, 2015 Leave a comment
This year’s most talked about event is Microsoft Ignite 2015.
Unlike previous times, when Microsoft used to host separate conferences to showcase different technologies during different times of the year. This time Microsoft will be hosting an inaugural, unified Microsoft commercial technology conference the week of May 4, 2015 in Chicago, Illinois.

This can give attendees an opportunity to explore broader range of learning opportunities across all of Microsoft’s technologies, including actionable best practices from industry experts.

Being someone with Project and Project Server passionate/specialist/learner/consultant etc. etc. I have extracted Project related topics from that huge sessions catalog which Microsoft is updating every day with new content. 

There would be 8 sessions focusing on Project Server, Project Online and Project by some known industry experts. To all the PPM relevant audiences out there, this is something you can look for from MS Ignite 2015.

1. Microsoft’s Vision and Roadmap for Work, Project, and Portfolio Management 

Session focus on sharing Microsoft vision for work, project, and portfolio management and provide insights into our future product investments.
Target Audience: C-level

2. Microsoft Project Pro for Office 365: An Overview

Session to showcase features available in Microsoft Project so you can impress your boss, deliver your projects on-time and under-budget, and be the envy of all your co-workers.
Target Audience: IT Generalist

3. IT Project and Portfolio Management in the Cloud

Jean Donati, Krishna Mamidipaka and Mike McLean
This session will highlight end-to-end Project Portfolio Management using Project Online and Project Pro for Office 365.
Target Audience: C-Level, IT Generalist

4. Developer to Developer: Meeting Custom Needs with Microsoft Project

Aesha Shah, Dan MacDonald and Eli Sheldon
Session about the App Marketplace, CSOM API, remote event receivers, and a little bit about workflow. Making the transition to Project Online may be easier than you realize.
Target Audience: Developers, Technical Consultants

5. Real World Reports: Business Intelligence in Microsoft Project Online and Project Server 2013

Allan Rocha, Andrew Lavinsky and Mike McLean
Session focus on BI capabilities of Project online and on-prem versions to demonstrate how you can create real-time reports and dashboards using tools such as Microsoft Excel 2013, Excel Services, Microsoft PowerPivot, Power View, and OData.
Person like me would definitely be looking forward to attend this session. Another point to consider about this session is its presenters, Allan and Andrew, both are known names within PPM industry and have track record of presenting some awesome sessions in past.
Target Audience: Developers, Technical Consultants

6. How to Deploy Microsoft Project: Online and Server

Allan Rocha, Andrew Lavinsky and Mike McLean
This sessions will take you step-by-step through the deployment process.
Good opportunity to learn/re-visit about recommended practices of deploying solution, especially if it’s a large scale deployment.
Target Audience: Implementers, Technical Consultants/Specialists

7. Supporting Microsoft Project Online and Project Server: Tips and Tricks

Brian Smith
Learn the tips and tricks for successful troubleshooting of issues both in Project Online and Project Server. Some of the tools described will be applicable to Online and on-premises customers, such as client side logging and web debugging – and also some specific on-premises tools to help understand ULS logs and database issues. A glimpse of how Microsoft supports the cloud is also included.
Listen directly from Microsoft support public facing, well known within PPM community, Brian Smith. A must attended session for technical experts and support experts.
Target Audience: Implementers, Technical Consultants/Specialists

8. Microsoft Project Online Customization: Best Practices

Brian Smith
This session covers best practices that MS have learned in the past two year of running the service. It discusses how to customize Project Online for better performance.
Target Audience: IT Decision makers
To know about all the sessions, click here: Microsoft Ignite sessions

It would definitely be an awesome learning platform, providing the fact that Microsoft is also planning to showcase SharePoint 2016. You can learn about few SharePoint 2016 related sessions here: Top 3 sessions to learn more about SharePoint Server 2016 at Microsoft Ignite

Good luck to all those who are attending.

Until next time.

via All about Enterprise Project Management (EPM) http://bit.ly/1x7r0RU

Khurram Jamshed
The author of the blog has an extensive experience of working as an EPM Consultant. Currently he is located in Dubai, UAE and working for Microsoft partner organization as Project Server specialist. He has a thorough experience of providing Project Management technical/functional consultancy to all sort of organizations. He is a certified PMP, a Project Server MCITP, and also received a MS community contributor award 2011.

This article has been cross posted from khurramjamshed.blogspot.com/ (original article)

I am Back.

March 20, 2015 Leave a comment
Its been a while that i was away.

Those who were wondering, if any, about my whereabouts. Its my pleasure to announce that i am alive and rocking :)

Last year had been a massive year for me, both at personal and professional fronts.
Became a father for 2nd time, and relocated to a different place. It all became a little too overwhelming during past few months, more than i have anticipated, but its all settling down well now.

So its about time to get back to business. Time to pen down more stuff. Time to reconnect.

Lets rock & roll.

via All about Enterprise Project Management (EPM) http://bit.ly/1FHiniO

Khurram Jamshed
The author of the blog has an extensive experience of working as an EPM Consultant. Currently he is located in Dubai, UAE and working for Microsoft partner organization as Project Server specialist. He has a thorough experience of providing Project Management technical/functional consultancy to all sort of organizations. He is a certified PMP, a Project Server MCITP, and also received a MS community contributor award 2011.

This article has been cross posted from khurramjamshed.blogspot.com/ (original article)

Follow

Get every new post delivered to your Inbox.

Join 1,770 other followers

%d bloggers like this: