Category Archives: External Content Types

Adding Text Search to the Project Center Interface

Posted on June 11, 2012 by

Update 6/15/2012: See the comment at the bottom. …well not really, but essentially I’ll be discussing how to create the functionality that does that.  My self-assigned goal in this post is to enable SharePoint search to perform a text search … Continue reading →

Posted in Admin, External Content Types, InfoPath, PDP | Tagged , | 1 Comment

Incorporating Project Server Data into Word Documents

Posted on May 10, 2012 by

This is a topic I’ve briefly played with before – how to automatically incorporate Project Server data into Office documents.  The REST API has long been the go to tool for doing such things, as the API allows us to … Continue reading →

Posted in BI, External Content Types, Reporting | Tagged | 1 Comment

Surfacing Risk Data in an External List

Posted on July 22, 2011 by

…so now that we have a custom SQL view developed and that data is surfaced in the form of an External Content Type, let’s add it to our SharePoint site. Navigate to a SharePoint site, select the option to View … Continue reading →

Posted in BI, External Content Types, Reporting, SharePoint | Tagged , , , | 3 Comments

Creating an External Content Type for Project Risks

Posted on July 21, 2011 by

In this post, I will talk about how to surface the custom SQL view we developed in the previous post through External Content Types and SharePoint Business Connectivity Services (BCS). Now this isn’t a new topic.  The only difference is … Continue reading →

Posted in BI, External Content Types, Reporting, SharePoint | Tagged , , , | 1 Comment

Customizing SQL Views to Provide Useful Datasets

Posted on July 20, 2011 by

In my last post, I decided to take a look at how to use External Content Types to surface Project Server Reporting database data on Risks and Issues.  In this post, I plan to talk about some quick and easy … Continue reading →

Posted in BI, External Content Types, Reporting, SharePoint | Tagged , , , | 1 Comment

Centralized Risk Repositories with External Lists

Posted on July 19, 2011 by

I was plugging away at the Project Server newsgroup when one of the contributors asked an interesting question.  After trying to aggregate Issues from each of the project sites to a single centralized repository using Content Query Webparts, Bart E. … Continue reading →

Posted in BI, External Content Types, Reporting, SharePoint | Tagged , , | 3 Comments

Creating a Centralized Document Repository with External Content Types

Posted on April 5, 2011 by

The last couple posts I’ve written have focused on using External Content Types (ECT), a feature delivered within SharePoint 2010 as part of the Business Connectivity Service.  This post continues that discussion with an example of creating a shared document … Continue reading →

Posted in Collaboration, External Content Types, PDP | Tagged , , , | 3 Comments

Taking Timephased Snapshots of Project Server Data

Posted on April 1, 2011 by

Ask Project Server implementers what the “killer app” for Project Server would be, and most would tell you it would be adding the ability to take timephased snapshots of project data.  Think of it….each week, your organization takes a snapshot … Continue reading →

Posted in BI, External Content Types, Reporting, Status Reports | Tagged , , , , | 3 Comments

Customizing External Lists of Project Data

Posted on March 29, 2011 by

In my previous post, I talked about using External Content Types to generate an External List within SharePoint 2010.  The main question, as always, is why would you want to do this? ….a couple of reasons: Your end users are … Continue reading →

Posted in BI, External Content Types, Reporting | Tagged , , , , | 1 Comment

Using External Content Types with Project Server 2010

Posted on March 25, 2011 by

External Content Types (ECT) are yet another function with SharePoint 2010 that allow users to create simple powerful solutions with Project Server data.  ECTs allow users to pull data directly from the Reporting database and surface it within SharePoint lists.  … Continue reading →

Posted in BI, External Content Types, PDP, Reporting | Tagged , , , , , , | 7 Comments