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 Find the SharePoint Workflow History Task List

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

By default, Workflow Tasks list is a Hidden List and it is not listed under View All Site Content, however, you can manually navigate to it via: http://[servername]/[sitename]/lists/Workflow%20History For Instance: In below URL, snappsdev14 is the Server name and PWA is the site name. http://snappsdev14:99/PWA/lists/Workflow%20History


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

How to Upload Files to a SharePoint Document Library Using PowerShell Script

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

# create the Variable Path and Pass the source folder path $path = “D:\Source File\”; # create the Variable destination and pass the URL of the SharePoint List $destination = “http://projectserver14:99/PWA/SharePointListURL/“; # Store the current user default credentials in the Variable Credentials $credentials = [System.Net.CredentialCache]::DefaultCredentials; # Create the object of the Webclient $webclient = New-Object

Read More


Blog Posted In Blog Posted In: How to, SharePoint
Blog Posted In Comments Off on How to Upload Files to a SharePoint Document Library Using PowerShell Script

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

Quick Tour of Using the Support Site

Posted By Posted by: Peter Williams on May 20, 2013

Open Internet Explorer and browse to:- https://support.epmondemand.com.au/ (for EPMonDemand customers) or https://support.epmpartners.com.au/ (for EPM Partners application support agreement)A redirection to a Microsoft Authentication website occurs. Log in using your Microsoft account credentials. For assistance on how to register to this support site so as to gain access, please see our blog article Requesting Access to the Support Site. To

Read More


Blog Posted In Blog Posted In: Blog, Project Server
Blog Posted In Comments Off on Quick Tour of Using the Support Site

User Account Management for EPMonDemand

Posted By Posted by: Peter Williams on May 19, 2013

Note: This article is applicable only to Project Server 2013 EPMonDemand customers. Adding / Managing Users Log in to the Support Portal as you normally would, see Requesting Access to the Support Site if you need access. After successfully logging in, click on the User Accounts tile. A list of users will be displayed for the customer(s) that your

Read More


Blog Posted In Blog Posted In: Blog, Project Server
Blog Posted In Comments Off on User Account Management for EPMonDemand

Restart User Registration

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

Note: This article is applicable only to Project Server 2013 EPMonDemand customers. Restarting User Registration Process In the event that user registration for a particular user must be restarted, it is possible to restart the registration process by reissuing a user token, this will have the following effect; A new Token will be created if

Read More


Blog Posted In Blog Posted In: Blog, Project Server
Blog Posted In Comments Off on Restart User Registration

Customer Information Management

Posted By Posted by: Peter Williams on May 17, 2013

Note: This article is applicable only to Project Server 2013 EPMonDemand customers. Updating Customer Details Log in to the Support Portal as you normally would, see Requesting Access to the Support Site if you need access. After successfully logging in, hover the cursor over Navigate and click on theCustomers link from the drop-down menu that appears. A list of

Read More


Blog Posted In Blog Posted In: Blog, Project Server
Blog Posted In Comments Off on Customer Information Management

Earned Value Demystified

Posted By Posted by: Laith Adel on May 16, 2013

What is Earned Value Analysis? žEV is KPIs that measure the Cost and Schedule performance of a project., žIt’s like (green, orange and red) but better. ž Here is the main blocks of the EV calculations: So What? Earned value indicators that are variances or ratios can help you determine if there is enough money left

Read More


Blog Posted In Blog Posted In: Project Server, Reporting
Blog Posted In Comments Off on Earned Value Demystified

Creating Hierarchical ‘Look Up’ Values in a SharePoint list on a Project Site

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

Issue: By default, project site column doesn’t support hierarchical values in the lookup table. Workaround: To fix the above issue, we can configure the Project Site list column look up values as per the below snapshot: Solution Steps: 1. Create the custom SharePoint list. For example, we have created the SharePoint list name as “DepartmentValueList”

Read More


Blog Posted In Blog Posted In: How to, Project Server, SharePoint
Blog Posted In Comments Off on Creating Hierarchical ‘Look Up’ Values in a SharePoint list on a Project Site