Finding out the process template for a project in TFS 2013

Go to the project collection in which the project is located
Find the project ID using the

select * from tbl_Projects where project_name like '%XXXXXXXX%'
PartitionId  project_id  project_name  state last_update

1 F4C0DF3A-A3BD-458E-9356-8D071897D1C8 XXXXXXX WellFormed 2014-04-09 13:49:28.513

select * from tbl_project_properties where project_id = 'F4C0DF3A-A3BD-458E-9356-8D071897D1C8'

PartitionId project_id name value

1 48833EE1-8CBE-43A6-8653-4CF16E10FD56 Microsoft.TeamFoundation.Team.Default 60004022-0dfe-4225-a358-ec942aab72bd

1 48833EE1-8CBE-43A6-8653-4CF16E10FD56 MSPROJ <?xml version="1.0" encoding="utf-8"?>

<MSProject>

  <Mappings>

    <Mapping WorkItemTrackingFieldReferenceName="System.AreaPath" ProjectField="pjTaskOutlineCode9" />

    <Mapping WorkItemTrackingFieldReferenceName="System.AssignedTo" ProjectField="pjTaskResourceNames" />

    <Mapping WorkItemTrackingFieldReferenceName="System.Id" ProjectField="pjTaskText10" ProjectName="Work Item ID" />

    <Mapping WorkItemTrackingFieldReferenceName="System.IterationPath" ProjectField="pjTaskOutlineCode10" ProjectName="Sprint" />

    <Mapping WorkItemTrackingFieldReferenceName="System.Reason" ProjectField="pjTaskText14" />

    <Mapping WorkItemTrackingFieldReferenceName="System.Rev" ProjectField="pjTaskText23" />

    <Mapping WorkItemTrackingFieldReferenceName="System.State" ProjectField="pjTaskText13" ProjectName="State" />

    <Mapping WorkItemTrackingFieldReferenceName="System.Title" ProjectField="pjTaskName" />

    <Mapping WorkItemTrackingFieldReferenceName="System.WorkItemType" ProjectField="pjTaskText24" />

    <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.BacklogPriority" ProjectField="pjTaskNumber1" ProjectName="Backlog Priority" />

    <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.RemainingWork" ProjectField="pjTaskRemainingWork" ProjectUnits="pjHour" IfSummaryRefreshOnly="true" />

    <LinksField ProjectField="pjTaskText26" />

    <SyncField ProjectField="pjTaskText25" />

  </Mappings>

</MSProject>

1 F4C0DF3A-A3BD-458E-9356-8D071897D1C8 Process Template Microsoft Visual Studio Scrum 2013

Configuring OLAP on Project Server 2013

·         Central Admin, Application management select manage service applications.  

        Click on Project service application

               Point to Proj Web App instance (PWA) and click on Manage

·         Click on OLAP Database Management

·         On the OLAP Database Management page, click New and Configure the OLAP Database build settings page

·         If you get the following error

·         Download  SSAS Management objects SQLSERVER2008_ASAMO10_amd64.msi  from

http://www.microsoft.com/en-us/download/details.aspx?id=30440

and install it on all the servers where Project Server 2013 is installed.

·         If you get following error

·         Failed to build the OLAP cubes. Error: Failed to create the Olap database: ProjectServerPWA. Error: Cannot set StorageEngineMode property of database 'ProjectServerPWA' to 'Traditional' because Analysis Services is in Tabular mode.

·         Change the C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config\msmdsrv.ini file

·         You cant directly edit it, copy it over to desktop . modify it and overwrite the original file

·         Restart SSAS service

·   

Developing SharePoint Online website for Anonymous users

Microsoft  creates one public site collection per tenant. This public site URL will be like livecompanyname-public.SharePoint.com

We cannot create child sites in this public site.

 There is currently no best way to develop a second public site collection for anonymous users in SharePoint Online.

Following are alternatives we can have
 You can enable external sharing on admin side and create a site collection with Sharing enabled for anonymous users. This site collection allows sharing the site to anonymous users by invitation.
These anonymous users can only have Read-only access based on out of the box functionality.
. If you want to capture data from anonymous users for this type of site, there are three alternatives

1. Modify the contact form so that we can capture the fields that we need.
2. Use the following web-part or write something similar to create a contribute privileges .   https://anonymous365.codeplex.com/releases/view/105618
3. The external user can create a live account and use that to login to the site. This live account in most cases can be treated as a normal AD account in office 365 and can be given contribute privileges. The problem with  this approach is, the site is not truly anonymous like the one we specify in SharePoint 2010. We would have to share the site to the user's email Id. 

Thanks
Nate