Monthly Archives: May 2013

Page1: Project Server Question Bank

1# Does Project Server 2010 support MS SQL Server 2005?

Answer: Yes, Project Server 2010 support only 64-Bit MS SQL. Database server must be either of the following:  Microsoft SQL Server 2005 SP3 with Cumulative Update 3 (64-bit) · Microsoft SQL Server 2008 SP1 with Cumulative Update 2 (64-bit).

2# How to display RES_AVAILABILITY and RES_RATES_TABLE in SSRS Report?

Answer: Well, it can queried directly to ReportDb as it stores in Binary format. You can retrieve this information from the PSI, but it does not exist in the RDB in the format you are requesting.
However, the PSI can be queried by SSRS, so you should still be able to build your report.

3# How to install Project server 2010?

Answer: Detail outlined steps available at Microsoft Technet. Click HERE.

4# Can we customize the Office Project Professional 2010 Ribbon?

Answer: Yes, it is possible. For further details access this MSDN link.

5# How to use Powershell to migrate Project Server 2010 to Project Server 2013?

Answer: HIT here to find out the script.

6# Which version of Windows Power is Pre-requisite for SharePoint 2010 Products?

Answer: It is Windows PowerShell 2.0.  It will be installed, if necessary, when you run the Microsoft SharePoint Products Preparation Tool. By default, Windows PowerShell is located at the following path: <%SystemRoot%>\System32\WindowsPowerShell\v1.0\PowerShell.exe.

Please note :Windows PowerShell 2.0 is backward compatible with Windows PowerShell 1.0 and subsequently installs to the v1.0 folder.

7# Create Project in Project server using Powershell script?

Answer: Script is available on the Microsoft technet gallery. Click here to access http://gallery.technet.microsoft.com/projectserver/Server-2010-Powershell-d66d4b4c

8# Script to Create the WCF Webservice Proxy Object in Powershell?

Answer:

$WebSvcURL = “http://snweb10/aurTEST/servlet/services/_WS?wsdl
$proxy = New-WebServiceProxy -Uri $AurionWebSvcURL -Namespace ExportTool  -Class Program -UseDefaultCredential
Write-host -ForegroundColor yellow  $proxy

9#  Resources for Partners?

Answer:

1. PPM at Microsoft Partner network. Click here

2. Project Partner Blog – Click here

How to use Java Script to make fields on a PDP read only

Environment: Project Server 2010

Background: This can be achieved out of the box via a stages in a workflow; however, in some cases workflows are not in use or like this one the fields are being populated via some integration so we don’t want them to be read only to the integration – just to stop users overwriting the synchronized values, thereby, we have used the JavaScript solution to make the fields read only on a PDP page.

Solution Steps:

Steps 1: Insert a content editor webpart on the page , note: content editor web part should always be placed below the webpart which contains the Enterprise custom fields you want to disable.

Step 2: Edit The HTML For Content Editor Web Part, copy and paste the code as below, make sure to change the Name  of the Enterprise Custom field and you are done:)

<script type=”text/javascript”>

function MakeReadOnly()

{

// find all the elements with tag Name as INPUT

var elements=document.body.getElementsByTagName(“INPUT”);

// loop through all the elements till we find an element with type text and title as name of our field

for (index=0; index < elements.length;++index)

{

if(elements[index].type==”text”)

{if(elements[index].title==”Custom Field Name”) //Field name

elements[index].disabled=true;}

}}

Hope this helps.