Category Archives: External Content Types

Adding Text Search to the Project Center Interface

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

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 | 4 Comments

Surfacing Risk Data in an External List

…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

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

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

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

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