2014 Microsoft Project Conference Booth Highlights

Posted By Posted by: Laith Adel on May 2, 2014

FluentPro Booth We’ve had the pleasure of being in contact with the guys at FluentPro for many years, and our pick of nifty products this year would have to be the FluentPro “Formulas”. If you are familiar with deploying Project Server and the configuration of the Enterprise Custom Field, you will at some point realise

Read More


Blog Posted In Blog Posted In: Reporting
Blog Posted In 

How to Change the Look and Feel of a Project Site

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

When creating projects in Project Server, there is an opportunity to create site templates that are automatically utilised on project creation. In SharePoint 2013 there is a new option within the cog called ‘Change the look’.  In Project Server there are two options to change this: There is an “enterprise” site look and feel defined

Read More


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

How to Restore the Default Settings In Project Professional

Posted By Posted by: EPM Partners on February 12, 2014

Recently I made some configuration changes to Project Professional, later I realised I didn’t want all these changes any more. This led me to investigate the possibilities of restoring the default out of the box settings, rather than remembering the previous changes I had made and manually changing them one by one. The below details

Read More


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

Sever 2012 R2 and Sharepoint 2013

Posted By Posted by: EPM Partners on December 10, 2013

Recently I was working in an environment and came across an interesting experience, we were seeing some unusual behavior after a base install of SharePoint and Project Server.  Some notes of what we were seeing: 1.            .NET 3.5 was struggling to install 2.            The SharePoint 2013 pre-register would not install but could be installed manually

Read More


Blog Posted In Blog Posted In: Project Server
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 

Picture Library Slideshow Web Part Doesn’t Work When a Project Site is Saved as a Template

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

Environment: Project Server 2010 Issue Description: Recently, one of our clients requested to configure the “Picture Library Web Part” on the Project site home page. Interestingly, it was working fine until the site was saved as a template. When the new project site was created with the saved template, Picture Library Slideshow Web Part lost

Read More


Blog Posted In Blog Posted In: How to, Project Server
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 

How to Call the WCF Web Service in PowerShell

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

# Create the WebSvcURL variable and pass the WSDL URL $WebSvcURL= “http://snwebtt09/aurTEST/servlet/services/EV397_AURION_WS?wsdl“ #Create the Web Service Proxy Object $proxy = New-WebServiceProxy -Uri $WebSvcURL -Namespace ExportTool  -Class Program -UseDefaultCredential $proxy Write-host -ForegroundColor DarkBlue ===successfullyconnected to the WCF Web Service $proxy Note: Default User account need to have an access to invoke the WCF Web Service.


Blog Posted In Blog Posted In: How to
Blog Posted In Comments Off on How to Call the WCF Web Service in PowerShell

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