Archive for the ‘MSProject’ Category

Quick Adhoc Report in MS Project

Monday, June 27th, 2016

Do you need to create a quick ad-hoc reports on your project as a Project Manager?

In Microsoft Project Professional 2013 or later, you can use the REPORT tab to use default reports or create new ones. The reports can be created in Excel / Visio format that can later be exported to the PDF or other formats.

MSP2013_MSP_VisualReports

MSP 2013 Visual Reports

 

Later you can upload your report on project site, keeping the same file name. Set email alert on the file to notify Business Sponsor, Stakeholder and others that need to view updated report whenever a new version is uploaded or a weekly alert. SharePoint will sent email alert automatically to those users.

Follow it on a weekly basis and your stakeholders get weekly status reports.

MS Project Calculation Option and ERROR

Tuesday, March 29th, 2016

Microsoft Project Calculation Option and ERROR on few fields

V: 1.0, Updated: 03/29/2016

Scenario

Microsoft Project as a scheduling application, runs different formulas behind the scene.  You may run into the following scenarios:

  1. Some of the columns (fields) in Microsoft Project will not show the updated data
  2. Some of the fields will show #ERROR instead of the data

Cause

Microsoft Project has a calculation option that is set to On. Go to File > Options > Schedule > Scroll down to Calculation section on right. You will find On and Off options there. It defaults to On. You can hit Ctrl F9 to turn on or Off the calculation setting in Microsoft Project. Notice the bottom left of status bar and you will see the calculation change messages.

MSP2013_Calculations_01

 

The setting says ‘Calculate project after each edit‘. In case no edits are made, the project will not calculate data! In situations, you will see #ERROR message in cells for few fields. For example create a Date field and use formula Now() to populate current date in that field.

MSP2013_Calculations_02

 

Resolution

Even with Calculation option set On, if you see the #ERROR or don’t see the correct data, hit the F9 key. It will force the calculation and will update the data in Microsoft Project.

MSP2013_Calculations_03

 

 

Summary

There are four ways to let Microsoft Project perform the calculations. We discussed few options above. Below are four calculation options in Microsoft Project and one of which can be used:

  1. File > Options > Schedule > Calculation and set to On
  2. Hit Ctrl F9 to turn on / Off calculation option
  3. Right click on the top left cell in the view and choose Calculate Project from the menu MSP2013_Calculations_04
  4. Add Calculate Now or Calculate Project commands to the Quick Access Toolbar

 

Add Commands to the Quick Access Toolbar

  1. To add commands to the Quick Access Toolbar, right click on it on top right  and choose ‘Customize Quick Access Toolbar‘ (of go to File > Options > Quick Access ToolbarMSP2013_Calculations_05_CustomizeRibbon
  2. Choose ‘All commands‘ under ‘Choose commands from’ drop down. From the list of commands, select Calculate Now and click Add button in the middle to add it to the right side. [You can add Calculate Project command as alternate] MSP2013_Calculations_06_CustomizeRibbon
  3. You will see the commands icon in Quick Access Toolbar MSP2013_Calculations_07_CustomizeRibbon

 

Keywords

  • #ERROR in Microsoft Project
  • #ERROR in Project Calculation
  • Manually recalculate project data
  • Auto recalculate project data
  • Tasks not Scheduled as expected
  • Scheduling issue in Microsoft Project
  • Four calculation options in Microsoft Project

Create New Project from Existing in MS Project

Monday, March 21st, 2016

Creating a new project using an existing Project

[If your project was on Project Server, first save as the project on your desktop as .mpp file]

  1. Open MS Project Professional 2013 and make sure you are connected to MS Project Server PPM
  2. Go to File menu > New
  3. Under Featured tab click on ‘New from existing project’ icon

MSP2013_UseExisting_ProjectTemplates2

  1. In ‘New from Existing Project’ dialog box, navigate to the .MPP project file from your desktop and click Open
  2. Click on File > Save As > Save button
  3. In the next dialog box, enter the name of the project and click Save

MSP2013_UseExisting_ProjectTemplates3

  1. Continue to modify the project after the status bar in bottom middle says ‘Save completed successfully’

 

Creating a new project using Enterprise Templates

Only Project Server Administrators can save projects as Enterprise Templates.

  1. Open MS Project Professional 2013 and make sure you are connected to MS Project Server PPM
  2. Go to File menu > New. Then click on Enterprise tab on the right side (the view defaults to Featured)

MSP2013_UseExisting_ProjectTemplates

  1. Click on one of the relevant template
  2. Before making changes, click the File > Save option
  3. Enter the name of the project and other custom fields information
  4. Click OK
  5. Continue to modify the project after the status bar in bottom middle says ‘Save completed successfully’

Protected: Project PPM Reporting and BI

Tuesday, March 1st, 2016

This content is password protected. To view it please enter your password below:

MS Project cant Connect with MSPS MSProjectServer

Friday, December 26th, 2014

Microsoft Project can’t Connect with Microsoft Project Server EPM due to Version Mismatch

Version: 1.2, Modified: 12/29/2014

Microsoft Project Professional edition is the desktop client in Microsoft Project Server (MSPS). The version of the server and client software should be at a supported level in order of the two to work together. Service Pack or Cumulative Update (CU) patches if deployed without planning can cause issues in MS Project Server Enterprise Project Management (EPM) system.

There are different reasons as to why MS Project Professional can’t connect with MS Project Server EPM.

Below are some of the scenarios:

a. Not using the right edition of MS Project (Professional VS Standard)

b.  Not using the right edition of MS Project Professional with the right edition of MS Project Server (2010 VS 2013)

c. Not using the correct URL of Project Web Access (PWA)

d. Not having enough permissions (a user with team member or lower rights trying to connect MS Project Professional to MS Project Server)

e. Not using the right version of MS Project Professional with the right version allowed by MS Project Server in PWA > Server Settings

The focus of this article is about the last scenario. I’ll also cover special case of this scenario.

e. Not using the right version of MS Project Professional with the right version allowed by MS Project Server in PWA > Server Settings

There are known issue if your MS Project Server (MSPS) is at latest patch version and your desktop MS Project Professional edition used it too old.

MS Project Server 2010 / 2013 / Project Online circumvent this problem by allowing the Project Server Admins / PMO Admins / PMO Analysts to set limit on the least version of MS Project Professional that can connect with the Project Server.

Which MS Project Professional product can connect with which MS Project Server product

The short summary is:

  • MS Project Professional 2010 can only connect with MS Project Server 2010
  • MS Project Professional 2013 can connect with MS Project Server 2013 & MS Project Online
  • MS Project Standard can’t connect with MS Project Server.
Softvative Infographics - Microsoft Project Professional and MS Project Server Editions Compatibility
Softvative Infographics – Microsoft Project Professional and MS Project Server Editions Compatibility

Review the Infographic slides:

How to Control Which version of MS Project Professional Can connect with MS Project Server EPM

Microsoft Project Server 2010 / 2013 has the configuration setting that allows you to control which version of MS Project Professional within the same edition (2010 or 2013) can connect with the MS Project Server.

The settings are located in Project Web Access (PWA) > Server Settings > Additional Server Settings.

Microsoft Project Web Access (PWA) > Server Settings > Additional Server Settings link
Microsoft Project Web Access (PWA) > Server Settings > Additional Server Settings link

On that ‘Additional Server Settings’ page there is a setting to set the minimum version number of MS Project Professional that can connect with that instance of the MS Project Server EPM. Ms Project Professional versions prior to that number will not be able to connect with MS Project Server.

PWA Additional Server Settings > Project Professional Versions
PWA Additional Server Settings > Project Professional Versions

You can see this pilot instance supports a minimum of 14.0.6123.5000 version of MS Project Professional. That version is dated back to June 2012. That is little too old.

As per ITIL best practices for Configuration Management and Problem Management and also as per Information Security’s Patch Management Life cycle, the application versions should be maintained at the best possible levels. Even from Information Risk Management prospective, sometimes supporting too old version means also keeping old vulnerabilities alive in your new system. There is lot more to talk about on these best practices related to this topic. But that is little out of scope at this time for the topic.

Special Case Scenario due to version mismatch

I’ve seen a special case where a Project Manager was not able to connect to MS Project Server with everything correct as per the scenarios discussed at the beginning of this article.

The PM was getting the error listed below when launching MS Project Professional using connection with MS Project Server.

The following job failed to complete.
Job Type: Load
Error ID: 12015 (0x2EEF)
Error Description: An internal error occurred.
Cloud not load Project. Please try after some time. If the problem persists, contact your system administrator.

MS Project Error - The following job failed to complete Error ID 12015
MS Project can not connect with Project Server – Error ID 12015

Clicking more Info button reveals more details. You can see the version that is passed on to the PWA is not the right one.

MS Project can not connect with Project Server - Error ID 12015 - More Info
MS Project can not connect with Project Server – Error ID 12015 – More Info

Click OK to the first error message brings the second error:

Cloud not retrieve Enterprise global template.
There seems to be a problem with the database, please contact your server administrator.

Issue Cause

I verified that the MS Project Professional version was new relatively i.e. 14.0.7015.1000. That was higher than the minimum supported version configured in PWA.

Looking at the File > Help in MS Project Professional and reviewing the version screen in a large print out, I was able to find an anomaly. See the above screen shot again. It shows that MS Project Standard and MS Project Professional both as activated versions!

It turned out to be the Desktop Engineering person deployed MS Project Standard version first by mistake (& without any service packs or updates). Later he installed MS Project Professional over the same version as upgrade rather than removing the standard version. Now when the PM was trying to connect to MS Project Server using Ms Project Professional, somehow the desktop was passing the lower version 14.0.4751.1000 (see one of the screen shot above) and thus PWA was rejecting the connection.

Resolution

Uninstall any version of Microsoft Project from the desktop, reboot and then install the correct version of MS Project Professional with the the latest service pack and CU level as supported by the organization.

Revo Uninstaller – Free version  is one nice 3rd party application (Pro Version) to remove the stubborn applications. That helped in getting rid of the old version completely and then installing the MS Project Professional version again.

The correct version once installed and activated should only show MS Project Professional under File > Help.

MS Project Professional was able to connect with the Project Server.

References:

  1. Project Server 2013: Controlling the version of connecting clients–and PWA edits?
  2. How do I know???? Project Professional Versions and Consistency

Keywords:

  • MS Project can’t connect with Project Server
  • MS Project can’t connect with Project Online
  • MS Project can’t connect with PWA
  • Microsoft Project can’t connect with Project Server
  • MS Project can’t connect with Microsoft Project Server
  • Microsoft Project Professional can’t connect with Project Server
  • Microsoft Project Professional supported versions for Project Server
  • Microsoft Project Professional version inconsistencies with Project Server
  • Can not use MS Project with Project Server
  • Can not use MS Project with PWA
Visit www.softvative.com for professional services.

How to Check in your own Project that is checked out to you in another session on MS Project Server

Wednesday, August 6th, 2014

Version 1.5

Table of Contents

  • Issue and Cause
  • Resolution
  • How to view my project in read-only when it is already checked-out in another session or by someone else?
  • How can a MS Project Server Admin / PMO Can help PM / RM?
  • Risks in Force checking-In Projects

Issue and Cause

Sometimes when working with your projects in MS Project Server, Project Managers / Resource Manager (PM / RM) forget to check-in their project at the end. Few times due to latency issues the project is not checked-in when PMs / RMs close their project. That leaves the project in questions still checked-out on MS Project Server side.
Next time the PM / RM tries to open that project, they will not be able to do it. The system will prompt the PM that the project is checked out.

Resolution

A Project Web Access (PWA) user that can check-out a project, can also check-in the project. Below are the steps on how to check-in your project that says it is checked out to you.
1. Go to Project Web Access (PWA) home http://pwa.company.com/pwa
2. Click on Project Center link on the left quick launch navigation
3. Click on ‘Check-in My Projects’ link on the top ribbon area under Navigate group. If you don’t see the ribbon, make sure you are in the Projects tab and not the Browse tab of the ribbon.
4. You will be in ‘Force Check-in Enterprise Objects’ page. Make sure you have ‘Enterprise Projects’ highlighted under the ‘Select the type of object you want to force check-in:’ dropdown. From the list below, locate your project and check the box in front of that row. That will activate the Check-in button.
5. Click on the Check-In button to force check in the selected project(s).
6. Click OK to the dialog box that asks ‘Are you sure you want to Force Check-in these items?
7. The Job State column will show Processing. Refresh the page and the project should not be there in that list.
8. The project will be check-in and PM / RM should be able to check out the project again using either Project Web Access (PWA) or Microsoft Project Professional (MSPP) from desktop.
9. Click on Project Center link on left and check out your project.

How to view my project in read-only when it is already checked-out in another session or by someone else?

At the time of project showing as checked out, if a PM / RM goes into MS Project Professional, they see that project says it is check out. PM will not be able to open the project in Read/Write mode to edit it.
PM / RM can open the same project in Read Only mode. In that case the top middle title area of MS Project Professional will display the project name with [Read-Only] at the end of it.
 
Hint: Make sure you don’t make changes in the read-only project. I’ve seen PMs spending hours and hours changing a read-only project and then come to a point of no return. You will be able to save changes on desktop but not to a project that is already checked out.
 

How can a MS Project Server Admin / PMO Can help PM / RM?

MS Project Server EPM Admin can force check-in any project for PMs/ RMS. PWA Admin can follow the same steps as above. He can also do the same steps from PWA > Server Settings > ‘Force Check-in Enterprise Objects’ under Database Administration section.
 
 
 
Project Server Admin / PMO can go to the Server Settings > Manage Queue Jobs > Under ‘Job Completion States’ add ‘Success’ state to the right and review the Project Check-in job type status.
 

Risks in Force checking-In Projects

During the last checked out session if the project was not saved, there are chances that you might lose recent changes after the force check-in.

Keywords

  • why project in pwa do not checkin
  • why project do not checkin
  • PWA checkin issues

Test Your MS Project Server & sharepoint Deployment using Multiple Browsers and Platforms

Wednesday, May 7th, 2014
No wonder why it’s a nightmare to support your application across all platforms and browsers.  There are few good resources out there that help to quickly test applications on multiple browsers, platforms and devices. Organization who don’t have any standard as to which browser should be supported and which should not be; or don’t maintain and enforce the list of approved applications can benefit from these services / solutions.
I recently found the modern.ie. That saved me tens of hours of work for few MS Project Server EPM & SharePoint features.
Modern.ieMicrosoft Site that offers compatibility reports, browser screenshots, site scans and even free VMs with Ie6 to IE 11 for testing. you can download the test VMs for Windows, Mac or Linux and for Hyper-V, Vmware, VirtualBox and few other visualization platforms. After downloading VM, with 5 minutes I was able to validate the MS Project Server EPM scenario with IE 10.
BrowserStack.comBrowser Stack is paid service (as low as $35/m for 2 users). Browser based and doesn’t require VM deployments.

Sharepoint and MSProject Conference 2014 Slides and Videos

Tuesday, April 1st, 2014
In 2014, Microsoft had SharePoint Conference and Microsoft Project Conference. Those two conferences offer wealth of information including presentations, training, best practices and good knowledge base. Microsoft offered the full conference slides and videos this year. Here are the resources for those two conferences.

SharePoint Conference 2014 Slides and Videos on Channel 9
http://channel9.msdn.com/Events/SharePoint-Conference/2014/

MS Project Conference 2014 Slides and Videos on Channel 9
http://channel9.msdn.com/Events/Project/2014/

You can download the slides and videos for offline viewing. Manually downloading all contents will take too much time. Instead you can use the following Power Shell scripts to download the slides and videos in a folder on your local drive. SharePoint Conference contents are 72 GB and MS Project Conference 2014 contents are 29 GB in size

Power shell Script to Download All MS Project Conference Slides and Videos
http://gallery.technet.microsoft.com/PowerShell-Script-to-all-a0b94874/file/110942/1/DownloadProjectConferenceVideoandslides.ps1

Power shell Script to Download All Sharepoint 2014 Slides and Videos
http://gallery.technet.microsoft.com/PowerShell-Script-to-all-04e92a63/file/110503/3/DownloadSPC14Videoandslides.ps1

In my case, I renamed the scripts to DownloadPC14.ps1 and DownloadSPC14.ps1 on my local drive.

PowerShell Script in a folder

Run the scripts in Power Shell and it will start downloading the slides first and then all videos into a folders for each session.

MS Project Conference 2014 Contents 
SharePoint Conference Contents


????? ??????? ??? ? ?  ??????? ?????  
(Enjoy Sharepoint and MS Project learning)
🙂

References:
http://gallery.technet.microsoft.com/PowerShell-Script-to-all-04e92a63
http://gallery.technet.microsoft.com/PowerShell-Script-to-all-a0b94874

Sharepoint 2013 Project Server 2013 Office 2013 Resources V 2.0

Monday, July 16th, 2012

Microsoft have released the Sharepoint 2013, Project Server 2013, Project Professional 2013, Office 2013, Visio 2013, Office Web Server 2013, Lync 2013 and Exchange 2013 today. Here are some of the Sharepoint 2013 resources.

    1. Sharepoint 2013 Site http://office.microsoft.com/sharepoint/
    2. System Requirements for Sharepoint 2013 http://technet.microsoft.com/en-us/library/cc262749(v=office.15).aspx
    3. Sharepoint 2013 SDK https://www.microsoft.com/en-us/download/details.aspx?id=35585
    4. Download SharePoint Foundation 2013 with SP1 http://www.microsoft.com/en-us/download/details.aspx?id=42039
    5. Download Microsoft SharePoint Server 2013 http://technet.microsoft.com/en-us/evalcenter/hh973397.aspx
    6. Sharepoint Designer 2013 http://www.microsoft.com/en-us/download/details.aspx?id=35491
    7. MS Project Server 2013 Download http://technet.microsoft.com/en-us/evalcenter/hh973403.aspx
    8. MS Project Professional 2013 Download http://technet.microsoft.com/en-us/evalcenter/hh973401.aspx
    9. Sharepoint 2013 in Download Center http://www.microsoft.com/en-us/search/DownloadResults.aspx?q=%22SharePoint%202013%22
    10. Sharepoint 2013 Composite Handbook http://www.microsoft.com/en-us/download/details.aspx?id=36055
    11. SharePoint 2013 Upgrade Process http://www.microsoft.com/en-us/download/details.aspx?id=30371
    12. SharePoint 2013: presentation: IT pro training https://technet.microsoft.com/en-us/office/dn756397.aspx
    13. SharePoint 2013 training for IT pros http://technet.microsoft.com/en-us/sharepoint/fp123606.aspx
    14. Sharepoint 2013 Developer Training http://msdn.microsoft.com/en-US/office/apps/fp123626
    15. Sharepoint 2013 – Developer training for Office, SharePoint, Project, Visio, and Access Services http://msdn.microsoft.com/en-us/office/dn448488.aspx
    16. Installing SharePoint 2013 – Yasir Butt (Jerry) http://jerryyasir.wordpress.com/2014/03/03/installing-sharepoint-2013-on-windows-server-2012-r2/
    17. SharePoint 2010 UI VS SharePoint 2013 UI – Yasir Butt (Jerry) http://jerryyasir.wordpress.com/2012/07/17/sharepoint-2010-ui-vs-sharepoint-2013-ui/
    18. How to Install Sharepoint 2013 http://www.ericharlan.com/Moss_SharePoint_2007_Blog/how-to-install-sharepoint-2013-a220.html
    19. Try Sharepoint 2013, Office 2013, Office WebApp 2013, ProjectServer 2013, Project 2013, Visio 2013, Exchange 2013, Lync 2013 http://www.microsoft.com/office/preview/en/try-more-products
    20. Install and manage apps for SharePoint 2013 https://technet.microsoft.com/en-us/library/fp161232.aspx
    21. Test Lab Guide: Demonstrate Intranet and Team Sites with SharePoint Server 2013 http://www.microsoft.com/en-us/download/details.aspx?id=30379
    22. Test Lab Guide: Configure SharePoint Server 2013 in a Three-Tier Farm http://www.microsoft.com/en-us/download/details.aspx?id=30386
    23. Use Office Web Apps with SharePoint 2013 https://technet.microsoft.com/en-us/library/ee855124.aspx
    24. Traditional topologies for SharePoint 2013 http://www.microsoft.com/en-us/download/details.aspx?id=30377
    25. Downloadable eBook: Deployment guide for SharePoint 2013 http://www.microsoft.com/en-us/download/details.aspx?id=30384
    26. Language Packs for SharePoint Foundation 2013 http://www.microsoft.com/en-us/download/details.aspx?id=35492
    27. Language Packs for SharePoint Server 2013 http://www.microsoft.com/en-us/download/details.aspx?id=37140
    28. Language Packs for Microsoft Office Web Apps Server Preview http://www.microsoft.com/en-us/download/details.aspx?id=35490
    29. SharePoint 2013 Technical Library in Compiled Help http://www.microsoft.com/en-us/download/details.aspx?id=30382
    30. Databases that support SharePoint 2013 http://www.microsoft.com/en-us/download/details.aspx?id=30363
    31. Design Sample: Corporate Portal with Host-named Sites for SharePoint Server 2013 http://www.microsoft.com/en-us/download/details.aspx?id=30362
    32. Duet Enterprise for Microsoft SharePoint 2013 and SAP 2.0 http://technet.microsoft.com/en-us/library/ff972436(v=office.15).aspx
    33. Back up and restore: SharePoint Server 2013 http://www.microsoft.com/en-us/download/details.aspx?id=30365
    34. Services on server install workseet for traditional SharePoint Server 2013 topologies http://www.microsoft.com/en-us/download/details.aspx?id=30367
    35. Design Sample: Extranet with Dedicated Zones for Authentication for SharePoint 2013 http://www.microsoft.com/en-us/download/details.aspx?id=30368
    36. Search architectures for SharePoint Server 2013 http://www.microsoft.com/en-us/download/details.aspx?id=30374
    37. Enterprise search architectures for SharePoint Server 2013 http://www.microsoft.com/en-us/download/details.aspx?id=30383
    38. Design Sample: Corporate Portal with Path-based Sites for SharePoint Server 2013 http://www.microsoft.com/en-us/download/details.aspx?id=30378
    39. Microsoft Office 2013 Audit and Control Management Server http://technet.microsoft.com/en-us/library/jj631654(v=office.15).aspx
    40. Back up and restore planning worksheet http://www.microsoft.com/en-us/download/details.aspx?id=30372

 

 

MS Project Conference 2012 Links Learning and Training Contents

Monday, June 4th, 2012
I found few good links on MS Project Conference 2012 Contents
 
Microsoft Project Training & Learning
 
100 hours of free Microsoft PPM Content from customers, partners, MVPs and Microsoft!
 
Giles Hamson  – Project Conference 2012 video presentations now available
 
Microsoft Project Conference 2012 Session Recordings Are Live!
 
Microsoft project conference 2012 – Videos on Showcase