Archive for June, 2010
June 26th, 2010 by Tobias Zimmergren
If you’ve been working with BCS and external lists you may have noticed that there’s no RSS feeds enabled for those lists.
So to get around this problem I’ve created a custom RSS feed generator that essentially provides you with an RSS/ATOM feed for you so you can render it in your browser or any feed-reader of choice.
Please note that this is a beta with a few things that needs fixing before it should be used, I’d like your feedback on it so I can complete it for you all to utilize.
External Lists and RSS
If you go to your SharePoint 2010 installation where you’ve got an external list you will see that you’re lacking the RSS functionality on that specific list.
The RSS feed is by default disabled, and out of the box there’s no way to enable it for this specific type of list.
Some people gave me the brilliant idea of using REST and the ListData.svc service to pull out the data from the lists. But as you know (or will know from now on) is that REST and External Lists is a no go. You can’t utilize the ListData.svc service to pick out information from your external lists, unfortunately.
A custom RSS generator for your external list
I’ve created an RSS generator feature for your external lists, which (when enabled) will give you two new buttons in your External List ribbon menu called "Custom RSS".
The first button will take you to the Feed, and the second button is there to enable you to toggle the settings for the feed (i.e. what fields to show in the feed etc). The second button is only available to administrators of that list. Pretty sweet.
Feed opened in the RSS reader in Outlook 2010
Download and Install the RSS generator
Alright, so this is not a complete feature as of yet – there’s some glitches that is to be fixed and tuned, but I would love your feedback if you try it out. Please use the contact form and submit any feedback or features you’d like to see in this RSS gadget.
You can download the current version (not for production) here:
June 18th, 2010 by Tobias Zimmergren
Our good friend Mike Morton over at Microsoft just announced the official release of some great extensions to Visual Studio 2010, called SharePoint Power Tools.
These tools will extend Visual Studio 2010 to give your these additional features:
- Sandboxed Visual Web Part
- Compile-time warnings on Sandboxed solutions when trying to use disallowed code
June 10th, 2010 by Tobias Zimmergren
In this article I will guide your through the process of uploading a document to any chosen document library in SharePoint 2010 through the Client Object Model.
This application has a very simple usage scenario:
- Type in the URL to your site where you want to upload your file
- Choose one of the available Document Libraries
- Click Upload a Document and you’ll get a browse-dialog to choose the file
How to utilize the Client Object Model in SharePoint 2010 to upload files
The most important thing to learn about when it comes to uploading files with the Client OM is to master the FileCreationInformation class that comes with the Client OM.
Take a look at this complete snippet to see how you can upload a file:
Things to note here is that I’m currently not changing the authentication for this application. That means it’ll be using your Windows/Domain Credentials.
Learn more about the authentication options here:
Summary, References & Download
With this sample application you can easily upload any file to any of your SharePoint 2010 document libraries by first entering the URL to the site, then selecting your library and finally browsing for a file and click OK.
Easily enough, you can change or extend this project the way you want it to work if you’ve got specific requirements to upload files using the Client OM.
You can download this sample project here.
Enjoy this piece of awesomeness :-)
June 9th, 2010 by Tobias Zimmergren
http://www.zimmergren.net | http://www.tozit.com | @zimmergren
I bumped into an issue the other week where I was creating a new BCS External Content Type and was hoping to hook up some new connections on a couple of demo farms I’ve created.
While most of these things were working like a charm, I bumped into an odd error message that basically told me that the elevation of privileges isn’t enabled on my BCS Service Application.
Problem, a short story told even shorter
You might receive an error message like this when trying to hook up a new External Data Source depending on your configuration:
The metadata object that has Name ‘yourName‘ has a Property with name ‘AuthenticationMode‘ and value ‘RevertToSelf‘. This value indicates that the runtime should revert to the identity of the application pool, but reverting to the application pool must be explicitly enabled for the service application by a farm administrator.
While digging around for a couple of minutes I couldn’t really find a suitable UI option for changing this behavior, so I dug into the power of PowerShell instead – which probably saved me quite some troubleshooting.
First you need to check the name of your Business Data Connectivity Service Application – a quick way is to check the UI, or you could use a PowerShell Cmdlet or use the API. I’m just using the UI for easy access:
Next, launch a new SharePoint 2010 Management Shell console and type in the following lines of code. Note that the name of the Service App below, is a copy of the name you took above:
This should now execute nicely (if you’ve got the appropriate permissions) and you should be able to see the RevertToSelfAllowed property be changed to true:
If you now would try to hook up your connections again, you should hopefully not see this message again.
Quick fix, done. Enjoy.
June 8th, 2010 by Tobias Zimmergren
In my previous article (How to create a PowerShell Snapin – Part 1) I talked about the general approach to create a custom PowerShell Cmdlet. However, in Part 1 I did not talk about how you create SharePoint 2010 specific Cmdlets. That’s what this article is all about.
So without further ado, I will quickly brief you on how you can create a custom PowerShell Cmdlet for SharePoint 2010 using the SPCmdlet base class.
In my example I will create a very simple Cmdlet you can use to automatically create demo-sites for use in demo-purposes or development scenarios so you don’t have to go about creating all the different sites by hand, and without a need to create scripts to do the same.
Creating a custom PowerShell Cmdlet that talks with SharePoint 2010
I will add some functionality to my previous project (found in my previous article) and extend that project with some custom SharePoint 2010 specific Cmdlets to get your started with writing PowerShell cmdlets for SP 2010.
In order to do this, we should derive from a subclass of the type SPCmdletBase. The following base classes deriving from SPCmdletBase are available:
1. Create a new Cmdlet (SPNewCmdletBase)
- Create a new Class and name it something of your own preference (I chose this silly name: SPAwesomeness.cs)
- Add a reference to the following two namespaces:
- Add the following base code to your class:
As you can see in the code above I’ve got a class called SPAwesomeness which derives from the SPNewCmdletBase class which in turn derives from the SPCmdletBase. SPNewCmdletBase should be derived from when you create a Cmdlet that should create and save data to SharePoint.
Also note that we’re using the Attribute [Cmdlet] to set a name for our command, in this case SPCreateDemoSites.
When deriving from this class, you need to implement at least one method override, in this case CreateDataObject. This is where our magic will take place!
2. Add some logic to your custom SharePoint Cmdlet
Now that we’ve got the basic code up and out of the way, we need to add some logic to actually make something happen.
I’ve added some very simplistic code to create some Demo-sites based on the available templates in your installation. It looks like this:
3. Test your custom SharePoint 2010 cmdlet
In order to test it, follow along with the steps I mentioned in my previous article (here) to deploy it – then call the new command you’ve created called New-SPCreateDemoSites like this:
It will ask you to supply the mandatory property (SiteUrl), so type in an existing url to an existing site collection and execute like this:
Now you’ll need to wait for a few minutes. What’s happening now is that your Cmdlet is creating a site called "Demo Sites" and will add a whole bunch of sub-sites to that new site.
Navigate to your new site called "Demo Sites" and you should see something like the following sub-sites created:
Summary & Download
Quite easily you’ve created your first SharePoint 2010 Cmdlet extension to operate with the SPCmdletBase classes. In this case we’ve created a new site called Demo Sites and added a bunch of sites to that new site, as per the available templates on your server.
You can download my sample project here
Enjoy this awesomeness!
June 7th, 2010 by Tobias Zimmergren
You will see how easy it actually is to build a custom class library that in turn is an extension to the PowerShell console and will add a couple of extra commands according to your preference.
The reasons for wanting to do this is an endless list, but as an example if you’ve got repeated tasks you’ll need to perform that are not available out of the box, you can create them yourself and then use normal PowerShell scripts to execute your code. That way you can easily build your own custom commands (CmdLet) for PowerShell which basically extends the functionality to support whatever scenario you’ve got.
You might remember that in SharePoint 2007 you could extend the STSADM.EXE command with something called STSADM Extensions. The approach I’m talking about in this article is pretty much the same concept – extending the build-in commands of your PowerShell console by adding custom code.
How to create a PowerShell Snapin
Download the Windows SDK in order to get the
System.Management.Automation.dll file for PowerShell easily accessible.
1. Create a new Class Library project
Start out by creating a new Visual Studio 2010 Class Library project and give it a proper name.
I’ve named mine Zimmergren.SP2010.PowerShell.
Add assembly references
- Add a reference to System.Management.Automation
- This DLL is located in:
C:Program FilesReference AssembliesMicrosoftWindowsPowerShellv1.0
(if you installed the Windows SDK as I told you earlier on in this article)
- Add a reference to System.Configuration.Installation
2. Create a PowerShell Installer class
In order for our PowerShell Cmdlet to work, we need to create an installer-class. This class is called when you install the SnapIn/Cmdlet and will provide the system with some information like where it comes from and what it’s supposed to do.
Start out by creating a new class in your project, I named mine PowerShellInstallerClass.cs. Next, add the following code to that class:
This essentially provides some information to the system upon installation of your SnapIn.
3. Create a PowerShell Cmdlet class
Now you need to continue this venture by creating a new class in your project. I named mine TestCmdlet1.cs.
Use the [Cmdlet()] attribute on your class to tell the system that it’s going to be a Cmdlet for PowerShell like this:
Next, you should override the methods you want to execute your code and add some dummy-code. There’s a couple of different methods to use here:
You should make sure your class looks like this so we can test the first part out:
4. Deploy the new PowerShell Snap-ins
Since this is a generic Class Library-project, we need to create some kind of deployment script to make sure that our Cmdlet gets deployed when we build our project.
There are two requirements for deploying and installing our PowerShell Cmdlet:
- Deployed to the server (Using GACUTIL)
- Installed on the server (using INSTALLUTIL)
In this sample project I’m simply adding two lined in the Post-Build actions like this::
You’ll find the post-build events if you click project properties and go to this box:
5. Project overview
Your project should look something like this:
6. Test your PowerShell Snapin
In order to test our project, we now just need to build the Visual Studio project and the post build scripts will automatically hook up our assembly in the GAC and use INSTALLUTIL to install the Cmdlet.
To try the commands out, you need to launch a powershell console and type in the following command:
Now you should be able to just call your command (in my case, it’s called TestCmdlet1) like this:
This should bring your the following output in your PowerShell console window:
Great, our very first PowerShell cmdlet is created – and we have validated that it works!
Summary & Download
In this article we talked about how you create a general PowerShell Cmdlet in order to extend the capabilities in your PowerShell consoles. There’s no business logic incorporated in this sample, that’s up to you to implement in your projects. You’ve got the starting point to get sailing on the great PowerShell seas right here!
In my next article (Part 2) I will talk about the SharePoint 2010 specific details for creating a custom Cmdlet for your SharePoint installations. It will cover how you create custom Cmdlets to interact with the SharePoint 2010 object model in a nice way.
June 2nd, 2010 by Tobias Zimmergren
On May 26th we had our season-finale of the SSUG (Sweden SharePoint User Group) meeting at Scandic Anglais in Stockholm.
It was a great event with three speakers that we had organized:
- Case: Handelshögskolan, Externwebb på SharePoint 2007
- Offlinehantering i SharePoint 2010 och Office 2010
- SharePoint 2010 Licensiering
The sponsors for this event was Sogeti (courtesy of Christoffer von Sabsay), and we thank them for making it possible to host this event at Scandic Anglais in the heart of Stockholm just next to Stureplan.
For our upcoming events we have a list of interested sponsors, and if you’re one of those who would like to sponsor an event in the future – please don’t hesitate to contact anyone of us in the crew. Ping me on email@example.com, Wictor or Göran and we’ll sort it out!
International speakers, we welcome thee!
I’ve been contacted a few times about bringing in some international speakers to the SSUG events. If you’re interested in speaking about something at one of our meetings, ping me and we’ll make some great plans. Awesome!
Plans for the future
There will be some more frequent meetings in Malmö coming up as well when we get back – so if you’re interested in hosting a meeting in Malmö, please don’t hesitate to contact me on via email.
I’m also making some nice plans and designs for the future platform for SSUG, which of course will be SharePoint 2010. I’ve purchased a bunch of new servers and I’ll be working with this project during your vacation to give you all a nice platform to enjoy when we’re back in action after the summer.
We’ll be back!
With that said, thank you for joining us on our meetings