kwizcom banner advertisement

Fix "One or more field types are not installed properly. Go to the list settings page to delete these fields." Error in SharePoint CAML Query

December 23, 2009    , , ,
Problem: I got this error when trying to retrieve list items using CAML SPQuery. Root Cause: There was a field "Artifact ID" in the list, but the internal name was "Artifact",  so it resulted error! Adjusting the internal name in the Query XML fixed the problem. In an another case,  Got this error: "The following exception was thrown when trying to enumerate the collection: "One or more field  types are not installed properly. Go to the list settings page to delete these fields." This is because: XML is case sensitive, Field name was entered as "NotificationTo " instead of "NotificationTo" (Note the extra space!) So the catch is: Always use Internal Name of the field and bear in mind, its case sensitive (E.g. NotificationTo and notificationto are not same! )
Fix "One or more field types are not installed properly. Go to the list settings page to delete these fields." Error in SharePoint CAML Query Fix "One or more field types are not installed properly. Go to the list settings page to delete these fields." Error in SharePoint CAML Query Reviewed by Salaudeen Rajack on December 23, 2009 Rating: 5

Run STSADM from anywhere by changing "Path" Environment Variable

December 09, 2009    , , ,
Getting "'stsadm' is not recognized as an internal or external command, operable program or batch file." when trying to run stsadm command line tool? This is because stsadm tool is located at: C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN folder and when you try to access it from other folder (typically, command line opens in "C:\Users\Your-User-Name") , command shell may not be knowing where exactly stsadm.exe is located. So, How to run stsadm from any directory from your SharePoint servers? Simple. Just add the stsadm's location to the "Path" Environment variable. here is how: Start > All Programs > Control Panel > System. Select Advanced System Settings, click the Environment Variables button. Under System Variables, Scroll to Path and click the Edit button. Add the following to the end of the Variable value field:       ;C:\Program Files\Common Files\Microsoft Shared\web server extensions\1
Run STSADM from anywhere by changing "Path" Environment Variable Run STSADM from anywhere by changing "Path" Environment Variable Reviewed by Salaudeen Rajack on December 09, 2009 Rating: 5
Migrated SPS 2003 Sites still has Old Look and Feel? Migrated SPS 2003 Sites still has Old Look and Feel? Reviewed by Salaudeen Rajack on October 30, 2009 Rating: 5

Hide Title Column in SharePoint List

September 27, 2009    , , ,
Often, SharePoint users wants to remove(or hide at-least) 'Title' column from the lists and document libraries. We can hide title column in SharePoint 2007 by enabling content types. How to hide title column in SharePoint list ? Follow these steps to hide the title column in SharePoint List or Library:    Navigate to the List setting >> Advance setting check Yes radio button for "Allow Management of Content Types"        3. Now in List Setting again >> Select Content Type "Item"        4. Then Select Title >> Select Hidden  Finally, you can remove the Title field from views (But you can't delete the Title column!). Same steps applies to both SharePoint 2010 and SharePoint 2007 list to hide title column. If you want, You can Rename the Title column even.     Go to the List settings     Click on the Title field     Rename it, Save your changes by clicking "Ok" button Disadvantages When You Hide Title column f
Hide Title Column in SharePoint List Hide Title Column in SharePoint List Reviewed by Salaudeen Rajack on September 27, 2009 Rating: 5

Move SharePoint Search Index Files Location to Another Drive

September 25, 2009    , ,
Again C:\ is running out of disk space in a SharePoint Farm, due to the fact Search index files are growing! Huh.. So this time I decided to move  move SharePoint 2007 index files from  C:\Program Files\Microsoft Office Servers\12.0\Data\Office Server\Applications to E:\.  Here are the steps to move SharePoint search index to another drive: Its a good idea to pause the crawling schedules before we proceed moving SharePoint index location. After the index has been moved to the new location we have to resume the crawl that we have paused. Run the below stsadm in Index Server: stsadm -o editssp -title sharedservices1 -indexlocation e:\SharePointIndex or you can run: stsadm -o osearch -indexlocation "E:\SharePointIndex" This will reset the index and create new location. In each query server, run the below command: stsadm -o osearch -propagationlocation e:\SharePointIndex If its a SharePoint Services (WSS), in Index server, you can run: stsadm -o spsearch -indexl
Move SharePoint Search Index Files Location to Another Drive Move SharePoint Search Index Files Location to Another Drive Reviewed by Salaudeen Rajack on September 25, 2009 Rating: 5

Expand-Collapse for Multiline Text columns in Sharepoint

July 09, 2009    , , , , ,
Some times, when working with the Multiline fields, they may occupy the whole page :-). We can solve this issue by introducing Expand-Collapse Trick with jQuery. On clicking on the little Arrow that row will be expanded, then again clicking will collapse. Here is How: Add the CEWP webpart and place the below code, then hide the webpart. <script type="text/javascript"> if(typeof jQuery=='undefined'){ var jQPath = 'https://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js' document.write('<script src="',jQPath,'" type="text/javascript"><\/script>'); } </script> <style type="text/css"> .expandText {height:auto;} .collapseText {height:28px;overflow:hidden} </style> <script type="text/javascript"> function ExpGroupRenderData(htmlToRender, groupName, isLoaded) { $("#tbod"+groupName+"_").attr("isloaded",isLoaded) .html(htmlToRe
Expand-Collapse for Multiline Text columns in Sharepoint Expand-Collapse for Multiline Text columns in Sharepoint Reviewed by Salaudeen Rajack on July 09, 2009 Rating: 5

Server error: http://go.microsoft.com/fwlink?LinkID=96177

June 24, 2009    , , ,
SharePoint Central Administration displayed just "Server error: http://go.microsoft.com/fwlink?LinkID=96177" error message on a SharePoint Farm. After little research, Found Hot fixes are installed, but Products and Technologies wizard has not Run! After running "SharePoint Products and Technologies Configuration Wizard" everything turned up. In case psconfig fails, try:  stsadm –o upgrade –inplace -url <URL-Of-the-Web-app> -forceupgrade If you still get issues after upgrade, You can follow the Microsoft KB: http://support.microsoft.com/kb/944267
Server error: http://go.microsoft.com/fwlink?LinkID=96177 Server error: http://go.microsoft.com/fwlink?LinkID=96177 Reviewed by Salaudeen Rajack on June 24, 2009 Rating: 5

Web Part Maintenance Page in SharePoint

May 13, 2009    , ,
Once, I ran across the issue where a web part is dropped on to a page, and then SharePoint errors out for one reason or the other. I had to use the Web Part Maintenance Page to fix the problem. However, there is no way to get to this page from any easily available link. Where is SharePoint link to web part maintenance page? Resolution: To get to the Web Part Maintenance page, I appended the query string ?contents=1 to the URL in the browser. say for e.g. SharePoint web part maintenance page URL would be: http://crescent.com/test/default.aspx?contents=1 Web Part Maintenance Page could be a real saver when faulty web parts crashing SharePoint. Open web part maintenance page and Remove the faulty web part to get the sites back.
Web Part Maintenance Page in SharePoint Web Part Maintenance Page in SharePoint Reviewed by Salaudeen Rajack on May 13, 2009 Rating: 5

SharePoint 2003 to SharePoint 2007 Migration using Database Attach Method: Step by Step

February 14, 2009    , , ,
In this article, I'm walking through the complete step by step procedures on Migrating from SharePoint 2003 to MOSS 2007 using database attach method. Overview How to migrate SharePoint 2003 to SharePoint 2007? Migrating from SPS2003 to SharePoint 2007 on Database attachment method involves the below 4 tasks. Run PreScan.exe in SPS 2003 server. Take the back up of content database of SharePoint Portal Server 2003. Restore the content databases back up on SQL Server of MOSS 2007. Create web application in MOSS 2007. Attach the SPS 2003 databases to MOSS 2007. 1.      Run Prescan.exe in SPS 2003 Server Download & Run the prescan.exe as below in command prompt: prescan.exe /c preupgradescanconfig.xml /all Download URL: http://www.microsoft.com/download/en/details.aspx?DisplayLang=en&id=22806 To resolve issues follow the reference: http://blogs.technet.com/b/wbaer/archive/2006/12/22/prescan-errors-what-they-mean.aspx 2.      Take the Content Dat
SharePoint 2003 to SharePoint 2007 Migration using Database Attach Method: Step by Step SharePoint 2003 to SharePoint 2007 Migration using Database Attach Method: Step by Step Reviewed by Salaudeen Rajack on February 14, 2009 Rating: 5

How to Adjust Column Width in SharePoint List View?

January 01, 2009    , , , , ,
Requirement: Adjust SharePoint column width in list view. To change column width in SharePoint, There are two options: Set column width using SharePoint Designer Change SharePoint column width using jQuery, as below: To set width of column in SharePoint 2007, place the below code in CEWP, place it below list view web part and hide it! <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" type="text/javascript"></script> <script type="text/javascript"> $(function(){ $("TH.ms-vh2-nograd:contains('Reason')").css("width", "150px"); }); </script>
How to Adjust Column Width in SharePoint List View? How to Adjust Column Width in SharePoint List View? Reviewed by Salaudeen Rajack on January 01, 2009 Rating: 5
Powered by Blogger.