Microsoft Office 365 Planner Side by Side with Project Online

Posted By Posted by: EPM Partners on September 14, 2016

Microsoft released their planner service last June for Office 365 Enterprise subscriptions. It is another way to address how we manage tasks and digitally experience teamwork. If you’ve googled Microsoft Planner, you probably have read comparisons with tools like Trello. Most bloggers come up with a conclusion that Planner is simpler than Project Online and it

Read More


Blog Posted In Blog Posted In: Blog, Project Online, SharePoint
Blog Posted In 

How to Migrate Projects to PWA & Retain Cross-Project Dependencies

Posted By Posted by: Dan Stopher on April 22, 2015

Context: As we work with clients to leverage the benefits of Project Server, clients frequently ask how they can migrate locally-saved master schedules to Project Server while retaining cross-project dependencies. The objective of this blog is not to cover the broader topic of schedule migration and general best practice, or how to create cross project dependencies (great

Read More


Blog Posted In Blog Posted In: How to, Troubleshooting
Blog Posted In 

How to Make PDP Read Only for Certain Users or Groups

Posted By Posted by: EPM Partners on June 15, 2014

Requirement There is a particular PDP (say, financial information) which should only be editable by a PMO and the rest (including PM) should see it as read-only mode.   Solution There were a few solutions available on other blogs (see alternative solutions section below) but i wanted to have a simpler solution. It’s relatively easy

Read More


Blog Posted In Blog Posted In: How to
Blog Posted In 

How to Edit or Access Your Schedule in Project Server

Posted By Posted by: EPM Partners on April 17, 2014

  Environment: Project Server 2010/2013 Solution: Choose one of the below options:   Option 1 – Using Project Web App Log on with user PM/Admin credentials to Project Web App > Projects > Click on the Project Name > Click on the Schedule PDP > Click on Task Tab > Click on Edit > In Microsoft Project Note: If

Read More


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

Installing SharePoint and Project Server 2013 Configuration Wizard Error: No user found

Posted By Posted by: EPM Partners on March 4, 2014

We were recently completing an installation of SharePoint and Project Server 2013. During the process we were utilizing an installation script, but we received the same behavior whilst utilizing the configuration wizard.  While it was trying to create a new SharePoint Configuration database the installation would fail.  Each Instance would create the shell of the

Read More


Blog Posted In Blog Posted In: How to, Troubleshooting
Blog Posted In 

Project Server Security Scenarios – Part 1

Posted By Posted by: EPM Partners on January 14, 2014

In this blog series, we will talk about implementing some specific security requirements in Microsoft Project Server 2010 / 2013. We assume that you already have some basic idea about Groups, Categories & Permissions but if that’s not the case, you can learn about Project Server 2010 Security Model (also applicable on Project Server 2013)

Read More


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

The Server Farm Account Should Not Be Used For Other Services

Posted By Posted by: EPM Partners on October 30, 2013

Summary: As a good practice, the account that is used to run the SharePoint 2010 Timer service and other system services in the SharePoint farm should not be used for other services in the farm. Cause: The farm account, which is used for the SharePoint 2010 timer service and the Central Administration site, is highly privileged and

Read More


Blog Posted In 

How to Concatenate Two Column Values in a CSV File

Posted By Posted by: EPM Partners on August 20, 2013

#Import the CSV file in the Variable and Select the column names that you want to be displayed into #updated CSV file $CSV = import-csv “D:\CSV File\Temp.csv” | select Surname,Given_Names,Email_Address,Employee_ID,Employee_Number,User_Name,Position_Title, @{n=’ResourceName’;e={$_.Surname + ” ” + $_.Given_Names}} # script @{n=’ResourceName’;e={$_.Surname + ” ” + $_.Given_Names}} will create the new #column Resource name and concatenate the Surname

Read More


Blog Posted In Blog Posted In: How to
Blog Posted In 

How to Insert a Sequential Unique Integer ID Value in a CSV File Using PowerShell

Posted By Posted by: EPM Partners on May 30, 2013

#Import the CSV file data into Variable and add the blank new ID column $CSV = import-csv “D:\Temp File\Temp.csv” | select Employee_ID, @{Name=”Id”;Expression={$_.””}} # so we start from ID = 1 in the CSV file $x=1; # this will loop each row in CSV and insert the incremental unique ID value FOREACH($ReadData in $CSV) {$ReadData.Id=$x;$x++}

Read More


Blog Posted In Blog Posted In: How to
Blog Posted In 

Query Risks & Issues from Content Database

Posted By Posted by: EPM Partners on May 2, 2013

Sometimes you need to be able to query custom fields from the default risks and issues list using SQL queries and apply conditions/filters. Risks from Content DB SELECT     REPLACE(w.FullUrl, ‘PWA/’, ”) AS ProjectName, d.nvarchar3 AS CurrentStatus, d.nvarchar8 AS Priority, d.nvarchar6 AS IssueType, d.nvarchar7 AS Severity,                       d.nvarchar9 AS IssueName, d.ntext2 AS ActionUpdateDiary, d.ntext3 AS FinalResolution,

Read More


Blog Posted In Blog Posted In: How to, Reporting
Blog Posted In Comments Off on Query Risks & Issues from Content Database