Distorted Toolbar or No Toolbar in Document Library

Issue:

Sometimes back I have found very interesting issue on one of my document library.

Even if I login through system account, not getting menu bars icons.

This is only with a specific document library, if I create a new document library all menu icons were available.

Resolution:

• As per the missing list toolbar, please go to SharePoint Designer 2007
• Open the view page includes this list view web partRight click that web part > Convert to XSLT List View Web Part
• Right click the web part again > Data View Properties > General Tab > enable "Show List Toolbar"
• Verify "SharePoint List Toolbar" must be checked.

 And here is the toolbar

If all these don't work replace working Allitems.aspx page with faulty one.

In addition you can customize toolbar using above steps.

Change Calendar Item appearance in MOSS 2007

By default when we create any item in MOSS 2007 calendar we only get Start Time in Calendar View.

To display the End Time of an event follow below steps

·        Create a new column with Calculated type.

·        Enter a name, as data type choose date & time.

·        And enter below formula

=Title&" from "&TEXT([Start Time],"hh:mm AM/PM")&" to "&TEXT([End Time];"hh:mm AM/PM")

·        After you have successfully created this column you have to modify the Calendar View.

·        So go back to the Calendar and click on Modify View. You will see an area called 'Calendar Columns’; there you can specify which column should be shown.

·        Change the Views Month, Week and Day. Here you have to choose newly created Column.

·        Click Ok and have a look at the result

MySite Search issue with Access Denied error

Each time the crawling on MySite site collection would generate numerous errors in event log as below

Error:

System.UnauthorizedAccessException: Access denied.
   at Microsoft.SharePoint.Utilities.SPUtility.HandleAccessDenied(Exception ex)
   at Microsoft.SharePoint.SPGlobal.HandleUnauthorizedAccessException(UnauthorizedAccessException ex)
   at Microsoft.SharePoint.Library.SPRequest.CheckOutFile(String bstrUrl, String bstrWebRelativeUrl, Boolean bCheckoutToLocal, String bstrLastModified)
   at Microsoft.SharePoint.SPFile.CheckOut(Boolean bCheckoutToLocal, String lastModifiedDate)
   at Microsoft.SharePoint.SPFile.CheckOut()
   at ABC.Intranet.Web.UI.WebControls.MySiteModifier.b__0()Additional Information:
  Site Collection URL - http://xyz.abc.com/personal/user |
  Web Site URL - http://xyz.abc.com/personal/user |
  HttpRequest URL - http://xyz.abc.com/personal/user/Personal Documents/Forms/AllItems.aspx |
  HttpContext User  - abc\Crawl_Acct |
  SPWeb User - abc\ Crawl_Acct |

The crawling account has READ permission over My Site collection and this account does have NO access to the specific URL in error below –

http://xyz.abc.com/personal/user/Personal Documents/Forms/AllItems.aspx  

Resolution:

This issue is resolved after adding Content Access Account under

 Central Administration > SSP > User Profiles and properties > Personalization services permissions
with "Manage user profiles" permission

Intermittent Authentication Error: 403 Forbidden

Some days back I have faced an Intermittent Authentication Error issue.

Issue:

Several users received a 403 Forbidden error when they try accessing the SharePoint site.  If they clear all IE cookies, they were able to log in one time but if they close and reopen the browser, they receive the 403 error again until they clear their IE cookies once more.  

After clearing the cookies, they were prompted for re authentication when attempting to open any MS Word documents as well and the document fails to open

Resolution:

Finally I have got below articles to get rid of this issue.

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

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

Import / Export data from a SharePoint page (which is not a List / Library) to Excel

To export a data from a page (not Document Library / List) to Excel

• Open MS Excel 2007
• Go to Data Tab
  
• Select From Web option

• Put in the URL with http://URL/_layouts/storman.aspx > Click GO

• It will display the Storage Space Allocation page in the pop up window
• Select the area which you want to import
• Click on import button
• It will import the data from Storage Space Allocation page to Excel

Please let me know in case of any queries.

Thank you.