Clearing Microsoft Project cache to resolve issues on opening, saving or publishing projects

Posted By Posted by: Eremo Zanye on July 23, 2019

Cache is a component of Microsoft Project that stores your project data locally on your computer, the concept exists to boost the speed in which data is retrieved. The functionality works in such a way that when you save a project for the first time, all the data information about that project is saved in

Read More


Blog Posted In Comments Off on Clearing Microsoft Project cache to resolve issues on opening, saving or publishing projects

Synchronising PWA schedules to the appropriate SharePoint Task List when dealing with multiple Task Lists

Posted By Posted by: Eremo Zanye on July 15, 2019

Background You may be required to develop a project site with the need for custom lists to be added to existing default lists – Risk, Issues, etc. If the custom list is using the out-of-the-box task type, then a problem may arise. Before discussing the issue, I’ll briefly explain the feature of synchronising a project

Read More


Blog Posted In Blog Posted In: Blog, How to, SharePoint
Blog Posted In 

How to close a Project (not task) to timesheets

Posted By Posted by: Dan Stopher on July 2, 2019

In the PPM community it is fairly well understood that we can use the “Lock Tasks to Timesheets” function to stop a timesheet user being able to log time against those tasks in a timesheet. However, I recently had the request where the client was not logging effort against tasks but rather projects and wanted

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online
Blog Posted In 

Updating a Project Site Template

Posted By Posted by: Cheston Hsu on June 26, 2019

The Project Site Template dictates the look, feel as well as the contents of a project site when created. Hence, it is extremely important that any changes that are made on the template are changes that you would like to see on your FUTURE project site. The below is a guide on how to update

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online
Blog Posted In 

How to get a unique project number between different Enterprise Project Types

Posted By Posted by: Ahmed Taee on June 14, 2019

I was faced with a requirement to produce unique project numbers in sequence despite of the project EPT type. Project numbers such as: PPMxxxxxx (x are consecutive numbers starting from 000001). Requirements Project Server 2016 or Project Online. SharePoint Designer 2013. So this was the approach I took in producing the unique project numbers:  Create

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online
Blog Posted In 

Using PowerBI REST API to overcome frustrating oData URL filter limitation

Posted By Posted by: Peter Williams on May 28, 2019

The Problem I had a need to create report that consumed the following data sources: Project Online timesheet data SharePoint Online list info On-Premise SharePoint list info Zendesk ticket data I have a reasonable amount of experience using PowerBI to query and consolidate this information. My desire was to have a report that used essentially

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online, Reporting
Blog Posted In 

Update Project Online Resource Custom Field with Lookup Value Using PowerShell

Posted By Posted by: Ahmed Taee on April 29, 2019

Preface There are plenty of useful blogs that discuss how to update custom fields using PowerShell (or .Net) in Project Online/Project Server 2013 or later, but most don’t discuss how to update custom fields which utilize a lookup table. As it turns out, this is rather tricky. Objective To update a custom field that utilizes

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online
Blog Posted In 

Bulk Publish Enterprise Projects Using Microsoft Project Desktop Client

Posted By Posted by: Peter Williams on April 2, 2019

There is all too often a need to bulk publish all enterprise projects. For example, a project custom field formula, or perhaps a lookup value, has been modified; that change won’t appear in reports correctly until all the projects are published. Performing the bulk publish can be achieved by utilizing a small custom PowerShell script

Read More


Blog Posted In 

Create Schedule Template with Resource Utilisation Configured to Resource Engagements

Posted By Posted by: Khurram Jamshed on February 26, 2019

When it comes to resource planning of your project, you can either take a top-down approach that happens at the start of the project. Or a bottom-up with a detailed Resource Plan being created at the project planning phase. Microsoft Project Online as a tool can be utilised to support both approaches: 1. Top-down resource

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online
Blog Posted In 

Create a Word document automatically from Project Data using Flow

Posted By Posted by: Khurram Jamshed on February 20, 2019

Microsoft Project Online solution enables the storage of project data in a central repository to increase visibility across the organisation. Reporting on that data can be generated using different tools available such as SSRS, Power BI etc.  An example of the reporting output is a nicely formatted Word document with the most up-to-date project status

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online, Reporting
Blog Posted In