Sharepoint swiss army knife tools

PROBLEM:

Building CAML query for Sharepoint list is something that you will need for any basic solutions you might build in Sharepoint but that does not mean that is simple and painless especially if you create sharepoint lists that use fields that have longer names or use spaces in naming. Also there are a lot of tools and solutions for sharepoint build by sharepoint community that helped me in building business solutions and saved me from inventing warm water.

SOLUTION:

This are some of the tools that helped me a lot in building sharepoint solutions

U2U Caml Query Builder
http://www.u2u.be/Downloads/U2U.SharePoint.CQB2010.zip

SLAM! SharePoint List Association Manager
http://slam.codeplex.com/

SharePoint Content Deployment Wizard (if you have to move entire site collection with content)
http://spdeploymentwizard.codeplex.com/

Sandboxed SharePoint Workflow Actions
http://ilovesharepoint.codeplex.com/releases/view/89201

Lookup Field with Picker 2010
http://ilovesharepoint.codeplex.com/releases/view/44989

Advanced Workflow Actions for SharePoint Designer 2010
http://ilovesharepoint.codeplex.com/releases/view/60840

SharePoint Power WebPart 2010
http://ilovesharepoint.codeplex.com/releases/view/55735

SharePoint Power EventReceiver 2010
http://ilovesharepoint.codeplex.com/releases/view/55733

SharePoint Feature Administration and Clean Up Tool
http://featureadmin.codeplex.com/

To be continued.....

How to move Sharepoint 2010 site collection

If you have to move  site collections,webs,lists,folders,list items (including files/documents) from one place to another especially for site collections the best way to do it is by using SharePoint Content Deployment Wizard to export the content using the Content Migration API as a .cmp file and then importing back again by using the same tool.

 

You can download this tool on the folowing link http://spdeploymentwizard.codeplex.com/

What is new in SharePoint 2013

Follow this link to download free ebook from Microsoft

Free eBook to learn more about what's new in SharePoint 2013.

How to find real error in Sharepoint 2010 based on Correlation ID of the error

PROBLEM:

If you get error in SharePoint 2010 most of them are generic like this one, where only thing we can see is Correlation ID.

SOLUTION:

To see the real error and pin point the real problem you have to

- Copy the Correlation ID from the error message

- Run SharePoint 2010 Management Shell

- Run the following command with your Correlation ID



get-splogevent | ?{$_.Correlation -eq "CORRELATION ID"} | select Area, Category, Level, EventID, Message |Format-List

All Data View Web Parts stopped working Share Point 2010

PROBLEM:
It seems that all of our (customized) DVWP stopped working this morning. It doesn't seem to depend if the datasource is a list or database. If I open the page with the DVWP in Sharepoint Designer 2010, it opens just fine with data. We get the message,

"Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Windows SharePoint Services-compatible HTML editor such as FrontPage. If the problem persists, contact your Web server administrator."

These are pages on a SP 2010 server, to be more precize SP 2007 updated to SP2010  , but until this morning, they were just fine. This only happens when Data View Web Part are modified to do some conditional formatting or are inter connected with each other. My only lead is that some automatic updates happened over night.

 SOLUTION:

Just Uninstall Windows Update KB2844286

PS:

There are very similar error to this one but this error is specificcaly connected with Windows update.

If you read the following error from sharepoint log NOT WINDOWS LOG then this solution should work.

Area     : SharePoint Foundation
Category : Web Parts
Level    : High
EventID  : 89a1
Message  : Error while executing web part: System.NullReferenceException: Objec
           t reference not set to an instance of an object.     at System.Xml.X
           sl.XslCompiledTransform.Load(MethodInfo executeMethod, Byte[] queryD
           ata, Type[] earlyBoundTypes)     at Microsoft.Xslt.STransform.GetCom
           piledTransform()     at Microsoft.SharePoint.WebPartPages.BaseXsltLi
           stWebPart.LoadXslCompiledTransform(WSSXmlUrlResolver someXmlResolver
           )     at Microsoft.SharePoint.WebPartPages.DataFormWebPart.GetXslCom
           piledTransform()     at Microsoft.SharePoint.WebPartPages.DataFormWe
           bPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform)


Info How to read sharepoint error log please check this post http://ittechnotebook.blogspot.com/2013/07/how-to-find-real-error-in-sharepoint.html