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

Taking Timephased Snapshots of Project Server Data

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

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

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 , , , , , , | 9 Comments