CAML Designer

Liking or not, CAML is still out there and in several cases we must use it.
This CAML designer makes the task of doing CAML less traumatic for people not very familiar with the syntax or to those like me who don’t really care a lot about spending time learning CAML.

The application can be downloaded at: http://sharepoint.biwug.be/CamlDesigner/CamlDesigner.zip

The tool was created using WPF so it has a fancy UI. Very cool! Even though it is still in Beta, it worked fine form me.

Some of advantages are:

  • Options to connect using the regular API, Client Object Model and the Web Services.
  • Authenticate as the current user or providing custom credentials.
  • Nice UI with filters and view fields to generate the CAML for you.
  • Code snippets with the query you’ve built.
  • It also supports SharePoint 15 (this option I couldn’t test yet).

Code snippet from a CAML query:

It is worth to take a closer look on the tool and have it on your SharePoint utility belt! Congratulations Karine Bosch and Andy Van Steenbergen!

See you,

Amadeu.

SharePoint Farm Solution Extractor

When you are migrating SharePoint 2007 to 2010 you might realize that you don’t have a copy of all the solution packages you installed on your farm. If that is your case, the SharePoint Farm Solution Extractor is an awesome tool to help you get the current deployed solution packages on your farm:
http://archive.msdn.microsoft.com/SPSolutionExtractor

You can use it with the following parameters to save all deployed packages to the specified folder:

SharePointFarmSolutionExtractor.exe -extractAll e:\FarmSolutions

A few notes:
-the extractAll parameter is case sensitive.
-the folder must exist before you run the command.

It helped me to get all the solution packages from the 2007 environment to install on the 2010 environment.

Hope this helps you as well.

Amadeu.

SharePoint Feature Administration and Clean Up Tool

The Feature Administration and Clean Up Tool (http://featureadmin.codeplex.com/) helps you find all the installed features on your farm, web application, site collection and site. It also has the ability to find and remove faulty features from the farm. The author provides versions for SharePoint 2007 and 2010.

It is very useful tool when maintaining SharePoint farms and it was even more useful for me when I started migrating my farm from SharePoint 2007 to 2010. I used it to double check the features on the SharePoint farm and remove the faulty ones (yes, be sure you take a look at faulty features, you might not know but it can be there).

See you,

Amadeu.