Working with List Items MOSS 2007

Very good tool if you want to work with list items without using the web UI .

http://splistitemeditor.codeplex.com/

Content Query Web Part : Master of all OOB webpart

If you are looking for formatting sharepoint content as far as your imagination goes , you have to explore master of all OOB webpart "Content Query Web Part"

Customization Sample :
http://msdn.microsoft.com/en-us/library/bb447557.aspx

This is one of the most powerful webpart but still SharePointers avoid it's usage due to its complex looking .xsl language . Fact is that once you understand XSL then this webpart will become common in your websites.

The site collection could not be restored. Please make sure the content databases are available and have sufficient free space

"The site collection could not be restored. Please make sure the content databases are available and have sufficient free space "
Follow this article in case you bump on to above error :
http://support.microsoft.com/kb/926061

Customize application pages in the Layouts folder

http://support.microsoft.com/kb/944105

Error in PortalCrawl Web Service.

People search was not working even after crawl and i saw this error message in error log.
To get it working i had to create a dummy root site collection at http://servername

Auditing SharePoint 2007 List/ Library

Auditing documents/ list items in SharePoint 2007 is a 3 step process :


1) Create Site Collection Policy
- Go to Site Actions ->Modify all Site Settings - >Site Collection Policies
- Create new policy -> Provide Name and Enable Auditing
- Select Events you would like to audit -> Click OK


2) Set up the Document Library / List which requires auditing
- Go to List Settings of Document Library you would like to audit
- Click on Information Management Policy Settings
- Under use site collection policy , select the policy you had defined in first step
- Click Ok

At this point you library / list is set for auditing and any action will be logged .

3) Viewing the results
- Go to Site Actions ->Modify all Site Settings - >Audit log Reports
- Under Custom Reports click on "Run a custom report "
- Select checkbox "Restrict this Report to " and select corresponding web application and list name
- You can select various filters (start date , end date , users ), though these are optional but its better to use them as they improve the report performance
- Select the events you would like to see the report for and click ok
- Voila ! you have the details reports with worksheet displaying the activity and usernames ,you have to use the filter to zero down to required data. UserNames can be accessed worksheet named"Report Data". Event column will display the action performed on a particular item

Enjoy !

Another user has changed the structure of this list .

ERROR :
Another user has changed the structure of this list . All your pending changes to this list will be discarded . To retrieve the latest copy of the list , click refresh

Suggested Resolution : Removing comma in hyperlinks
Reference URL : http://bmerri19.wordpress.com/

Feature '7a8b11f4-38b2-402b-ad94-1213e25150ca' for list template '1102' is not installed in this farm. The operation could not be completed.

I got this error while performing export of SharePoint site with stsadm and sharepoint designer.
It was happening because ShaerPoint Site was searching for the following feature "PWAProposals" which was present in my dev machine and not in my production . I was able to move it successsfully before as i used stsadm-backup but it started failing with stsadm -export.

Resolution :
Just copy the feature from your source server ---> destination server and install the feature. This will resolve the issue . Well this is not ideal solution . I am still in process of figuring out the reference to the feature in order to remove it from list template.

Sharepoint Config DB Size Grown too large

In my case the SharePoint Config DB log size became 35 GB which ate up all the disk space nearly crashing the system . This is a development machine so disk space was limited to 50 GB .

Did some search and the below steps solved the issue. The steps given below is not recommended to be implemeted in production , only in development / QA machine in order to save some resource .

1) Right click on you DB -> Properties
2)Select Options
3) Change the Recovery Model to SIMPLE and Click Ok

Once that is done ,
-Right click on DB -> Tasks - > Shrink -> Files
- In File type select log and click OK

My Config DB Log files were reduced from 35 GB - > 504 KB

Note : Simple recovery model is not suggested for Production Systems

Free Tools from Metalogix

http://www.metalogix.net/Free-Tools/

Just tried SWAT tool till now, pretty impressive.

Exception from HRESULT: 0x80040E14 STSADM ERROR

In my case this error was purely due to lack of disk space in DB server.

ERROR:
Exception from HRESULT: 0x80040E14

Clearing hard disk space in DB server resolved the issue.

Unable to Delete SSP (unprovisioning)

If you are stuck with SSP and have no clue how to get rid of it then you are at right place.

Use the SharePoint Master Tool (STSADM), nobody says "no" to Master ;-)

stsadm -o deletessp -title [-deletedatabases] -[force]
http://technet.microsoft.com/en-us/library/cc263248.aspx

Caching in MOSS 2007

http://msdn.microsoft.com/en-us/library/aa661294.aspx

Cannot connect to the configuration database.

This might happen due to various reasons . Below are the most common reasons :
1) Check SQL DB exist and enabled
2) Application pool Identity has been added to SQL DB

Save as Site Template Missing

Are you trying to save a publishing site as site template and are still wondering where the "Save as Site Template " is?

Well It's hidden . Here is a nice article for you.

http://www.kwizcom.com/ContentPage.asp?PageId=1165

Cheers!!!

SharePoint 2007 Scalability and Performance White Paper

http://blogs.technet.com/gurmeets/archive/2008/06/18/sharepoint-server-2007-scalability-and-performance-whitepaper-now-available.aspx

GetListItems SharePoint WebService

http://www.sharepoint-tips.com/2007/02/how-to-use-getlistitems-web-service.html

The template you have chosen is invalid or cannot be found. SharePoint Template Error

It's pretty hard to find the actual reason of these kind of error . But one thing is sure that template is causing issue.
The most common reason for this error is missing of dependency . for e.g. missing feature.
Best solution is to run the STPInspector tool . It will help to diagnose whether all the dependency are present in server or missing something .
You can get tool from STPINSPECTOR

ENJOY!!!

FIELD CONTROLS VS WEB PARTS

Lot of people had question surrounding this including me .Thanks toAndrew Connell for sharing the fundamental aspect of the differences put forward in the simplest way :

Article by Andrew Connell

Enjoy!!!!

Create new Content DB

Well it's a generic case where in we end up creating large number of site collections and then realize that DB size is too big to manage.

Well to take care of such situation, it's a good practice to create new content DB and move existing site collection new DB.

How to do it ?Here you go.

http://technet.microsoft.com/en-us/library/cc825327.aspx