Mapping the Office Item Type for External Content Types in BCS Meta Man

 BCS, BCS Meta Man, Business Connectivity Services, SharePoint 2010.

What are we going to do?

We are going to use our Customers information from our External System and use it to sync a Contacts list within Outlook 2010 via an External List.

Prerequisites

  • SharePoint Server 2010
  • Visual Studio 2010 Professional or higher
  • BCS Meta Man
  • AdventureWorks2000 SQL Database

Walkthrough

  1. Create a new empty SharePoint 2010 project in Visual Studio 2010.
  2. Add a new item to this project. From the Lightning Tools project items group add a BCS Meta Man project item
  3. From the main menu click on BCS Meta Man –> BCS Meta Man Data Explorer and connect to your database you wish to use.
  4. Drag and Drop any table you want. For this walkthrough we have used the AdventureWorks2000 Customer table.

    image thumb Mapping the Office Item Type for External Content Types in BCS Meta Man

  5. To edit the Customer External Content Type, Right-Click on it and select ‘Manage Entity’

    image thumb 1 Mapping the Office Item Type for External Content Types in BCS Meta Man

  6. Change the ‘Office Item Type’ from ‘Generic List’ to ‘Contact’

    image thumb 2 Mapping the Office Item Type for External Content Types in BCS Meta Man

  7. Change to the ‘Methods’ Tab and click on the ‘Specific Finder Method’, you will see we have a warming telling us that we need to map some required fields

    image thumb 3 Mapping the Office Item Type for External Content Types in BCS Meta Man 

    [Click the image to see a larger view]

  8. Click on the ‘Title’ Field, and then set it’s Office Item Type Mapping to ‘Title’

    image thumb 4 Mapping the Office Item Type for External Content Types in BCS Meta Man 

  9. Repeat this process for the ‘FirstName’ , ‘MiddleName’ ,‘LastName’, ‘CompanyName’ , ‘EmailAddress’ and ‘Phone’ fields, mapping them to the correct Type.
  10. When you have finished, save the settings in the Entity Management screen. Then deploy your Model by pressing F5 within Visual Studio.
  11. Create a new ‘External List’ on your Site, give it a name and use the just-deployed External Content Type. Click ‘Create’

    image thumb 5 Mapping the Office Item Type for External Content Types in BCS Meta Man

  12. We should now have an External List showing our Customer data

    image thumb 6 Mapping the Office Item Type for External Content Types in BCS Meta Man 

  13. Click on ‘List’ on the Ribbon and then click on the ‘Connect to Outlook’ button

    image thumb 7 Mapping the Office Item Type for External Content Types in BCS Meta Man

  14. After a short while a dialog box will pop-up asking you to install, Click ‘Install’

    image thumb 8 Mapping the Office Item Type for External Content Types in BCS Meta Man

  15. Once the installation has been completed you can click ‘Close’

    image thumb 9 Mapping the Office Item Type for External Content Types in BCS Meta Man

  16. Open Outlook, you will have a section called ‘SharePoint External Lists’, within this section you will have our ‘Demo of Office Item Type’ Contacts

     image thumb 12 Mapping the Office Item Type for External Content Types in BCS Meta Man

  17. When you click on this list you will see all of our Customer contacts are synced with Outlook

    image thumb 13 Mapping the Office Item Type for External Content Types in BCS Meta Man 

You can now use these as normal contacts within Outlook. You can disconnect your computer and take the data offline, as well as create or edit the contacts and sync the changes back to your external system if your external content type has the correct methods.

<Phill/>

Leave a Comment

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

*

* Copy This Password *

* Type Or Paste Password Here *

*