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.
Above: To create a new SharePoint Workspace link, you click “New”
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
Above: Enter the site that you are interested in Off-lining to Workspace
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
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.
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.
Above: this is the installation of the VSTO file
Above: The VSTO file is successfully installed.
Above: Same for additional list and libraries
Above: When competed you see a check box to denote success and any warnings and errors.
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
Above: As an example let us look at Elin Woods profile here, but we have renamed it Tiger for now…
Above: We note that in the SharePoint browser UX we see the same thing as in Worspace
Above: We make the edit to change the first name back to Elin…
Above: We commit the change to the Workspace
Above: We verify that the change is made as seen above….
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
Above: When you do that, you will see the VSTO fill being installed on your local client
Above: Once complete you now have access to the List in MS Outlook.
Above: Verification phase… we are in SQL Management Studio looking at the LOB System
Above: Next we will make a change to Fabian Williams Name
Above: Save our Changes
Above: Verify it in the Browser UX
Above: Verify it in SharePoint Workspace
Above: Verify it in the LOB System
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
- I created a new Email Enabled Security Group and two Test users today
- Test user 2 is a member of the Email Security Group
- I am able to send emails to test user 1, test user 2, and the security group in Outlook
- I did a full import into SharePoint and they all show up WITH their associated Email Address in the Profile
- I added the Security Group [Add User] directly into the Site as a contributor
- Tried to setup an alert. you get what is in top bullet 3 and 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/
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…
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.
Published Friday, March 05, 2010 2:52 PM by arpans
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
- One Host as Windows Server 2008 R2 Core
- Virtual Box
- 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
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
Once you click “Perform a Backup” under “Farm Backup and Restore” you get the window below
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
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…
We can Monitor the process by clicking the Refresh Button/Link
We can see the processing is Preparing Below
Now the process is running
Finally, the process finishes…
Once we are done, we can inspect the results. Below you will see the status, elapsed time, and location.
Next we will backup using Full Backup process the Web App and all items for Port 80
See status below…
Below you will see the folders that are created by default when using the OOB tool and “Farm Backup and Restore”
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.
I goofed with the nomenclature here below, but i wanted you to see the error handling now in SP 2010; very descriptive.
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.
Below you will see the Site Collections available; we did BCSAlpha first, now we do Charlie…
As you will note below; there is a backup file created for both BCSAlpha and Charlie
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”
And now for Charlie….
Next I opened up SQL Management Studio and made a backup of my Databases
There you have it….