Fabian Williams SharePoint Blog

Solving problems with SharePoint day and night

Using a Regular Content Type with an External List Column as part of its properties then Consuming in MS Word


So I love it when my fellow Twitter Colleagues come up with Ideas and I Proof of Concept it in SharePoint 2010, in-fact, I think we should come up with a “Stump the SharePoint 2010 Guys with Beta Bits” gig…

Nick Hadlee (hope you don’t mind me using your name) @nickhadlee had a question “Can #SharePoint External Data columns be included in Normal Content Types or only List Columns”

So we put it to the test…

Activities
  • Create a Content Type as you would do in SharePoint 2007
    • Type Document
  • Create a “New” Site Column in the recently created Content Type
    • Site Column is of Type “Lookup Column” – to an External List which contains LOB System Data
  • Create a Document Library which is defaulted to MS Word Document
    • Allow for management of Content Types
    • Add the Content Type we created
    • Open a Word Document from that Template
    • Consume the External List Data from the Lookup Column

clip_image001

So we need to create a new “Content Type” by clicking on Site Actions, View All Site Settings…

clip_image002

Click “Create” for the new Content Type

clip_image003

Name new New Content Type as you would in SharePoint 2007 as above

clip_image004

So.. we cheat here by creating our new “Site Column” and we will do a ‘Lookup’ to an External List…See below for the walkthrough for that.  See the second screenshot below for the link to the External Data List.

clip_image005

clip_image006

Once complete you will notice the Newly Created Column called “NickEmployeeCol” and of type “Business data

clip_image007

Next we create a new Document Library that is defaulted to hold MS Word Documents, we click ‘Advanced Settings’ under General Settings category so we can “Manage Content Types”… nothing new here…

clip_image008

And we go ahead and click “New Document” below to get a Word template

clip_image009

So in the above and below we have a test document library and we are going to use the new content type we created… see below and above

image

As we did in previous post, we have both the DIP and the ability to consume the External List data from the Quick Parts menu in MS Word.

clip_image010

clip_image011

Advertisements

November 11, 2009 - Posted by | SharePoint 2010, SharePoint Development, SharePoint How-To | , , ,

1 Comment »

  1. Social comments and analytics for this post…

    This post was mentioned on Twitter by fabianwilliams: please see my blog inspired by @nickhadlee shows using a Content Type w/t External List Data http://bit.ly/4pqHsm #sp2010 #sharepoint #BCS…

    Trackback by uberVU - social comments | November 12, 2009 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: