Consuming the External Content Type through SharePoint Designer in Microsoft Outlook 2010


Follow up from: Connect To Outlook: SharePoint External Content Type with SharePoint Designer and SQL LOB System

Part 2… Consuming the External Data List Columns inside Microsoft Word 2010 through Form Fields

Synopsis

In this blog we will demonstrate the following:

  • Reading and Updating LOB System Data surfaced as an Outlook Contact in MS Outlook 2010
  • Validating the effort through Testing

Process

We begin the process by picking up where we left off in our previous post Connect To Outlook: SharePoint External Content Type with SharePoint Designer and SQL LOB System Now we will just treat these contact as any other contact in our Outlook System.

clip_image001

In the screen shot above we notice on the middle Left Hand Side that we are attached to a SharePoint External List called “Test BCS Site Alpha – AW Company Contact” and we have 290 items returned to us. We will concentrate our efforts on the same Sir Michael Sullivan III we used earlier

clip_image002

So under closer inspection above we can see that not only do we have our data we mapped in the External Content Type mapping in SharePoint Designer but 2/3rds down you can see a pane called CompanyContactListDetails where the unmapped data is also present works almost like what Outlook Business Contact Manager gave us. So next I tried to get fancy “jiggy” with it by seeing if I could not only change the fields that were in the LOB system but also what was native as Outlook Properties… but no dice.. it said that the System didnt support it.. I will try to figure that out later..

Yes I used @MeetDux Twitter Profile Pic.. LOL Im sure he will get a kick.

clip_image003

In the end I am just going to modify the Fields that are directly related to the External Content Type and LOB System. I made a change to the Email address and made him Michael.Sullivan@FabianWorld.com

clip_image004

As you can see below in Outlook… the changes were persisted…

clip_image005

As well as in the SharePoint UX .. see below and ….

clip_image006

As well as in the LOB System in SQL Server..

clip_image007

So now you have seen how you can make Updates in a Rich Client such as Outlook to affect changes in the LOB System all the way in the Back End.

Leave a comment

Your email address will not be published. Required fields are marked *