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

March 20, 2010 Posted by | Office 2010, SharePoint 2010, SharePoint Designer 2010, SharePoint Development, SharePoint Workspace 2010 | , , , | Leave a comment

Question: Not able to get Email Alerts when using an Email Enabled Windows Security Group in SharePoint 2007

I have a situation where I have an email enabled security group with individual users in it, this security group is added to a SharePoint group. Here are some known

  • I am using the Site Owner to Add Alerts on behalf of users
  • if you enter the email address a user into the "Send Alert To" field and click ‘check name’, it resolves to the User
  • if you enter the email address of the Security group into the "Send Alert To" field and click ‘check name’, it come back "No Matches Found", same if you go to the Browse Icon
  • If you try to create the alert anyway using the security group, it creates the alert but tells you that there is no email address associated with the security group
  • If  you just add the preferred name of the Security Group to the "Send Alerts To" field then it resolves; but it creates the alert but tells you that there is no email address associated with the security group

However

  1. I created a new Email Enabled Security Group and two Test users today
    1. Test user 2 is a member of the Email Security Group
    2. I am able to send emails to test user 1, test user 2, and the security group in Outlook
  2. I did a full import into SharePoint and they all show up WITH their associated Email Address in the Profile
  3. I added the Security Group [Add User] directly into the Site as a contributor
    1. Tried to setup an alert. you get what is in top bullet 3 and 4
  4. I added the Security Group to a SharePoint Group, then added the SharePoint Group to the Alerts; failed…

I pulled down a feature from CodePlex http://www.codeplex.com/AdvancedAlert and tried list number 4 above; failed, but if i added an Individual User to the SharePoint Group and did number 4, the individual user gets alerts

I saw this out there also.. tired it… failed http://blog.gavin-adams.com/2007/10/26/sending-alerts-to-groups-in-sharepoint-2007/

Thoughts?

RESOLUTION

I found out that the Web Application Pool along with a few other accounts are Local Accounts

 

So the test/fix

· I created a new Web Application and used a domain account they had out there as the Web App Pool account

· I NOW am able to resolve the Security Group Email address

· I NOW can receive the initial alert email

· Once I added the Security Group to a Permission Group in SharePoint for the site (View, Read, Contribute) directly

    • I can receive security trimmed email alerts

Next we document and use the KB article 934838 to change the accounts in production

Tuck this one away people…

March 11, 2010 Posted by | SharePoint Administration, SharePoint Error/Resolution, Strange Stuff | Leave a comment

Glimpse into Mysites and the new Social Aspect of SharePoint 2010

Synopsis:  Just wanted to show off some of the slick features in the new SharePoint 2010 MySites and the brand new Social Aspect that comes with User Profiles and Tagging.

 

image

Above:  A look at your profile in SharePoint 2010, hmmm think about usability, it seems like I have worked with other social media products that have a similar structure and layout. I want to call out the status update bubble on my profile picture which your colleagues will be able to see upon updates. Also want to call out the “Ask Me About” section with bulleted items, these items are now Tags which will assist you in finding other people with shared skill sets and interest. Notice the “ My Organization Chart” also, pulled in directly for Active Directory or your ‘source of record’ for your profiles.

 

clip_image004

Above: A really slick Silverlight Application which allows you for lack of a better word “Fan” through your organizational structure as you would your music/video album; usability again.   This view as i clicked on Dave Chappelle are my direct reports.  Yes, I robbed the pictures from my Facebook friends profile pictures.  In this example, Dave doesnt have any direct reports to him. Notice fanned out left and right are my direct Reports Bart Tubalinal (@bart_tubalinal) and Hardeep Singh (@hardeepsinghm) my work colleagues in real life, obviously this image is not a true reflection of our internal structure …my disclaimer..

 

image

and how could I forget to display Jamar Wright (@jamarwright)  dude.. what was i thinking…

clip_image005

Above:  Notice however how Hardeep has people below him and how they are represented, in fact, how we are all represented in the Organization Chart.  Visually it is very appealing and structurally easy to navigate.

clip_image006

Above:  Calling out how the Organization Structure even at layers below is very transparent and easy to navigate.

 

Hope you like it.. it is really cool

March 9, 2010 Posted by | SharePoint 2010, SharePoint Administration, SharePoint General | , , | 8 Comments

SharePoint 2010 and Office 2010 Release date Announced as May 12th 2010

According to Apan Shah, Director, SharePoint

Excerpt below taken from… http://blogs.msdn.com/sharepoint/archive/2010/03/05/sharepoint-2010-office-2010-launch.aspx

 

Today, we officially announced that May 12th, 2010, is the launch date for SharePoint 2010 & Office 2010. In addition, we announced our intent to RTM (Release to Manufacturing) this April 2010. 

It’s an exciting time for us! We hope you can virtually join us on May 12th at 11am EST to listen to Stephen Elop, President of the Microsoft Business Division, announce the launch. You can register for the event @ http://sharepoint.microsoft.com/businessproductivity/proof/pages/2010-launch-events.aspx

Arpan Shah
Director, SharePoint

Published Friday, March 05, 2010 2:52 PM by arpans

March 2, 2010 Posted by | Office 2010, SharePoint 2010, SharePoint General | Leave a comment

How to Backup Solutions, Sites in SharePoint 2010 Beta using Central Admin and STSADM

Synopsis:

So the idea here is to prepare to move my work I had in SharePoint 2010 Beta to Release Candidate.  I spent quite a bit of time in SharePoint Saturdays, Conferences, and just figuring stuff out just to ditch it as I upgrade my environment. That said, I wanted to backup as much as i can from my work especially my solutions i created for BCS and the LOB System Databases I used in my Demos. What I will outline below is the methods Out of Box (OOB) that you can use in SharePoint 2010 Beta [hopefully noting much changes in RTM, unless they make it better] to backup your solutions and web apps. I can certainly do this while i build out my next environment which will be after much consideration:

  • A Portable Solution i.e. my IBM Lenovo T61P Dual Core 2.33 with 8 GB RAM
  • Windows 7 x64 Professional
    • Virtual Box
      • One Host as Windows Server 2008 R2 Core
        • Active Directory
        • SQL Server
        • Some kind of SMTP Server
      • One Host as SharePoint Server 2010 RC
        • Squeeze Every Bit of Service App as possible on it
  • Office 2010 RC
  • Visual Studio 2010 RC

Step 1 – Identify the items you want to Backup/Preserve

I identified the following items to keep as i move forward with the some prioritization

  • Must Have
    • Backups of My Visual Studio Solutions as a part of a SharePoint Solution
    • Backups of my Content Database
    • Backups of my Other Databases for Demo Purposes
  • Nice to Have
    • Actual MDF and LDF from SQL because i am a meticulous person; some call it anal
    • The Solution Folder under My Documents for Visual Studio 2010, so I can have my code source files
  • Everything Else
    • All my files along the way worth saving especially drivers, pictures, sample docs to mess with

Step 2 – Perform the Backups in a few Flavors

Using Central Administration in SharePoint 2010 Beta

The first thin I did was to open Central Admin. For our purposes today we will be working with the “Backup and Restore” section; second column second row

clip_image001

After you click Backup and Restore you have a few options, we are actually going to use both of them so we can get the experience. Obviously that is overkill but this serves as a tutorial for us later on. First we will tackle the Farm Backup and Restore then the Granular Backup

clip_image002

Once you click “Perform a Backup” under “Farm Backup and Restore” you get the window below

clip_image003

clip_image004

First we will option to backup all the solutions we have created and at least have saved thus far in the Solution Gallery in SharePoint

clip_image005

Once you have finished selecting the files; in this case only solutions to backup. We also have a directory configured for the drop spot for for our backup files. We then will click next…

clip_image006

We can Monitor the process by clicking the Refresh Button/Link

clip_image007

We can see the processing is Preparing Below

clip_image008

Now the process is running

clip_image009

Finally, the process finishes…

clip_image010

Once we are done, we can inspect the results. Below you will see the status, elapsed time, and location.

clip_image011

Next we will backup using Full Backup process the Web App and all items for Port 80

clip_image012

See status below…

clip_image013

clip_image014

 

clip_image015

Below you will see the folders that are created by default when using the OOB tool and “Farm Backup and Restore”

clip_image022

clip_image023

The second option available to us in SharePoint 2010 Beta for backup is the Granular Backup which allows you to do a “Site Collection” backup. We have two SC’s under a managed path that we will backup.

clip_image016

I goofed with the nomenclature here below, but i wanted you to see the error handling now in SP 2010; very descriptive.

clip_image017

Once the SC is identified, you must provide a path and a File Name, unlike the previous method where you had to just determine the folder, here just as in STSADM commands, you must specify the file name.

clip_image018

Below you will see the Site Collections available; we did BCSAlpha first, now we do Charlie…

clip_image019

clip_image020

clip_image021

As you will note below; there is a backup file created for both BCSAlpha and Charlie

clip_image024

Next, just for show I will do the same backup by using STSADM commands. What i found interesting is that the file sizes were different using this method.  You should also notice the “SharePoint Root” folder is now “14”

clip_image025

And now for Charlie….

clip_image026

Next I opened up SQL Management Studio and made a backup of my Databases

clip_image027

 

clip_image028

There you have it….

March 1, 2010 Posted by | SharePoint Administration, SharePoint General, SharePoint How-To, SQL Server | 5 Comments

   

Follow

Get every new post delivered to your Inbox.

Join 3,968 other followers