Fabian Williams SharePoint Blog

Solving problems with SharePoint day and night

No Code SharePoint BCS solutions with Workspace 2010 & Outlook 2010 & SPD 2010


Synopsis:

I have not done a blog in a while on SharePoint Business Connectivity Services (BCS) and as I prepare for my next SharePoint Saturday (Arabia), which will go into BCS from a SPD 2010 perspective I wanted to add some additional tid-bits on SharePoint workspace for people unfamiliar with it or its predecessor Microsoft Groove.

 

Below you will see screen shots for how to set up SharePoint Workspace 2010 (formerly Groove), and the integration to SharePoint Server 2010; further, I will demonstrate how you offline List/Libraries with both Workspace and Outlook to a SQL Server LOB system.

clip_image001

Above:  To create a new SharePoint Workspace link, you click “New”

clip_image002

Above:  There are a few options available to you here, in our example we will be doing a copy of SharePoint sites (offlining) to our local environment so we choose SharePoint Workspace

clip_image003

Above:  Enter the site that you are interested in Off-lining to Workspace

clip_image004

Above:  If you click “Configure” button you get the screen above which allows you to see exactly what is coming down to your Workspace… I haven’t played with modifying the default settings

clip_image005

Above:  Once you click “Ok”, you will have various site list and libraries that will sync up to your SharePoint Workspace; notice that the Site Pages are not supported.

clip_image006

Above:  Just as in Microsoft Outlook, as you connect to BCS External Content Types, you have to install a VSTO file on your local client (laptop/desktop) and this now will use BCSSync.exe to direct sync between your Rich Client and the LOB System.

clip_image007

Above:  this is the installation of the VSTO file

clip_image008

Above:  The VSTO file is successfully installed.

clip_image009

Above:  Same for additional list and libraries

clip_image010

Above:  ditto

clip_image011

Above:  ditto

clip_image012

Above:  When competed you see a check box to denote success and any warnings and errors.

clip_image013

Above:  Notice in the External List called “Store Sales” you have both a data view and individual view for the list. You are able to add, edit, and delete items in SharePoint workspace that will sync with SharePoint and the LOB system

clip_image014

Above:  As an example let us look at Elin Woods profile here, but we have renamed it Tiger for now…

clip_image015

Above:  We note that in the SharePoint browser UX we see the same thing as in Worspace

clip_image016

Above:  We make the edit to change the first name back to Elin…

clip_image017

Above:  We commit the change to the Workspace

clip_image018

Above:  We verify that the change is made as seen above….

clip_image019

Above:  Next we will connect Outlook to the same External List. To to this we will click on the “Connect to Outlook” icon in the SharePoint browser UX

clip_image020

Above:  When you do that, you will see the VSTO fill being installed on your local client

clip_image021

Above:  Once complete you now have access to the List in MS Outlook.

clip_image022

Above:  Verification phase… we are in SQL Management Studio looking at the LOB System

clip_image023

Above:  Next we will make a change to Fabian Williams Name

clip_image024

Above:  Save our Changes

clip_image025

Above:  Verify it in the Browser UX

clip_image026

Above:  Verify it in SharePoint Workspace

clip_image027

Above:  Verify it in the LOB System

Advertisements

March 20, 2010 - Posted by | Office 2010, SharePoint 2010, SharePoint Designer 2010, SharePoint Development, SharePoint Workspace 2010 | , , ,

No comments yet.

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: