How to Integrate Project Management Central Reporting with Time Tracking and Management on SharePoint 2013

Please note that the contents of this post applies to the following applications:

  • Project Management Central R4.0 (PM Central)
  • Time Tracking and Management R1.6 (TTM)
  • SharePoint Server and SharePoint Foundation 2013

PM Central’s reporting capabilities allow users to view data related to time as well as costs related to tasks and/or resources on projects. However, the reports only provide an estimate for the time and cost per resource for each task and/or project based on the task’s percent complete;  they do not provide any time or cost tracking reports based on the real-time reports of the resources’ time spent. In order to track the exact time for each resource, you will need to integrate PM Central with TTM to leverage TTM’s time tracking capabilities.

To accomplish this, you will need to follow the steps below in order to integrate PM Central with TTM:

  • To begin, if you have not already, install PM Central R4.0 and TTM R1.6 onto your SharePoint Server or SharePoint Foundation 2013.

Prepare PM Central site for Application Integration:

1. The reporting features detailed in this article require that your project(s) utilize the full template. That stated, you will need to create your portfolio site and the project site using the full template.

2. At the portfolio site, click the Central Actions icon and select PM Central Control Panel.  Under Report Center, click View Reports:

The following report tabs integrate with TTM:

  • Actual Work (Project Tracking vs. Time Entry)
  • Work (Planned) vs. Actual Work (Time Entry)
  • Actual Work (Time Entry)
  • Actual Cost (Project Tracking vs. Time Entry)
  • Cost (Planned) vs. Actual Cost (Time Entry)
  • Actual Cost (Time Entry)

    3. Integrate PM Central and TTM:

    • At the portfolio site, click on Central Action and select PM Central Control Panel. Under Application Integration, select Time tracking and management integration:

    • Input the URL of the TTM site which you wish to integrate with the PM Central site. Please note that you can use an absolute path or relative path.
    • Input the URL and click the Check Site URL icon to make sure that the TTM site URL is valid:

    • Once validated, click OK on the page. Next, click OK on the pop-up form that appears.

      Prepare TTM site for Application Integration:

      To begin, you will need to configure TTM for Time Sheet Entry

      To accomplish this, at the TTM site, navigate to the My Timesheets section and select Timesheet Entry.  Go to Edit tool part and follow the steps below:

      • In the Timesheet Task Data Source section, under Data Source, choose the Bamboo List Rollup radio button:

      • In the Bamboo List RollUp section, select Schema from the List Rollup of the PM Central Site. Your Data Source Column Mapping will auto-map as pictured below:

      • In the Administrative Time List section:

      • In the Timesheet Resource Data Source section, you will notice that the section is preconfigured to capture resources from the Enterprise Resource Pool of the PM Central Site whose URL you input:

      • Click Save & Close to close the configuration form.
      • Click Apply and OK to complete configuring TTM for PM Central Site integration.

      Enable cost tracking:

      The Enable Cost Tracking feature is used to establish a value of Standard Rate and Maximum Unit for a resource from the Enterprise Resource Pool list and calculate the cost of that resource.  To enable this feature, click the checkbox marked Enable cost tracking, and click the Save button:

      PM Central and Time Tracking and Management will now be successfully integrated and able to provide time and cost tracking reporting capabilities. To learn more about how Pm Central and TTM work together, check out User’s Guide to Time Tracking and Management for SharePoint 2010: Configuring PM Central for Time Tracking and PM Central and Time Tracking Management – Better Together as a Solution.


      SharePoint

      Applications

      SharePoint apps are stand-alone applications that perform specific tasks on a SharePoint site. Apps can perform functions such as managing a discussion board or knowledge base, performing project management or time tracking tasks, or doing other workflow operations.

      SharePoint

      Product Suites

      Experience greater power and savings by bundling our SharePoint apps and web parts.


      Essentials


      Essentials Plus


      Bamboo Premier


      Project Management Suite


      Knowledge Management Suite


      External User Manager


      SharePoint

      Web Parts

      Extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of Web Parts. Web Parts are the building blocks of pages on a SharePoint site that can be used to customize the user interface and content of a site page. 

      SharePoint

      Product Suites

      Experience greater power and savings by bundling our SharePoint apps and web parts.


      Essentials


      Essentials Plus


      Bamboo Premier


      Project Management Suite


      Knowledge Management Suite


      External User Manager


      Office 365

      Cloud Parts

      Cloud Parts are functional components that extend your SharePoint environment whether it’s hosted, on-premises, or part of Microsoft Office 365. More than mere ports of existing software to the cloud, our Cloud Parts have been built from the ground up to take advantage of the best that the cloud has to offer.

      SharePoint

      Product Suites

      Experience greater power and savings by bundling our SharePoint apps and web parts.


      Cloud Parts Suite for O365/SP Onl.


      Featured Services

      SharePoint Health Check

      A SharePoint Health Check will identify the causes of issues and risks associated with your specific environment, and is custom tailored to provide you with the best recommendations to optimize your SharePoint environment.

      SQL Health Check

      Document recommendations relating to performance, stability, availability, or a specific focus you request of your SQL Server database instances.

      My SharePointXperts

      The truth is that each SharePoint skill may not be a full time job for many organizations, and it is nearly impossible for one person to do everything you need – so augment your team with SharePointXperts; providing the skill sets you need when you need them!