Saturday, March 26, 2011

Icons are missing from Project Tracking Workspace Template in SharePoint 2007


 This is a global issue and I am very surprised that do not get any solution on internet.
When we create a site using Project Tracking Workspace template (Fantastic 40), following ICON images are missing from the site

It shows  red cross icon instead of following icons.
.


List Icons:

itpwscom.gif  
itpwsris.gif 

Site Feature Icon:

PwsCollab.gif    


Resolution

Download missing icons from internet and add them into images folder on server

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\IMAGES folder

After which list and feature looks like



Friday, March 25, 2011

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.

Wednesday, March 23, 2011

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 –
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

Tuesday, March 15, 2011

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.

Monday, March 14, 2011

Excel 2003 files try to open in Word 2003 when using SPS 2003


Environment
SPS 2003
Office 2003
Issue
If I click an Excel file in SharePoint, it opens read-only in Excel, as expected.  If I use the drop down and choose Edit in Microsoft Office Excel, then the file tries to open in Word instead of Excel - which does not work, of course.

If I close all instances of Excel before trying to open from SharePoint into Excel, then it does work.  The issue only occurs when I have other instances of Excel open.

Opening Excel files from websites that are not SharePoint works as expected.  This issue only occurs with Excel files stored on SharePoint.

Other office files work as expected, also immediately upon choosing the Edit in Microsoft Office Excel menu item, I get the error below and then the document tries to open in Word.

Error Message -
The document could not be edited. The required application may not be installed properly, or the requested document cannot be opened. Please ensure that the necessary application is installed and that the path to the document is correct. If the application was set to install on first use, run the application and then try editing a document again.

Resolution
Repaired Office 2003 from control panel and everything works fine


Thursday, March 10, 2011

SharePoint 2010 Versions



SharePoint 2010 Version Microsoft Support KB  Version Number 
SharePoint 2010/Foundation December 2010 Cumulative Update 2459257, 2459125 14.0.0.5130
SharePoint 2010/Foundation October 2010 Cumulative Update 2394320, 2394323 14.0.0.5128
Foundation July 2010 Hotfix 2032588 14.0.5050.5001
SharePoint 2010/Foundation June 2010 Cumulative Update 983319, 983497, 2182938 , 2281364, 2124512, 2204024 - / KB 2028568 / TechNet summary 14.0.0.5114
SharePoint 2010 RTM N/A 14.0.0.4762
SharePoint Server 2010 Release Candidate N/A 14.0.0.4730
SharePoint Server 2010 Public Beta N/A 14.0.0.4536
SharePoint Server 2010 SPC2009 Demos N/A 14.0.0.4524
SharePoint Server 2010 Technical Preview “2” [another SPC2009 demo build] N/A 14.0.0.4514
SharePoint Server 2010 Technical Preview N/A 14.0.0.4006

SharePoint 2007 Versions

SharePoint 2007 Version Microsoft Support KB  Version Number 
MOSS 2007 or WSS 3.0 Cumulative Update February 2011 KB2475885/ KB2475886 12.0.0.6554
MOSS 2007 or WSS 3.0 Cumulative Update December 2010 KB2458605/ KB2458606 12.0.0.6550
MOSS 2007 or WSS 3.0 Cumulative Update October 2010 KB2412267/ KB2412268 12.0.0.6548
MOSS 2007 or WSS 3.0 Cumulative Update August 2010 KB2276472/ KB2276474 12.0.0.6545
MOSS 2007 or WSS 3.0 Cumulative Update June 2010 KB983310/ KB983311 12.0.0.6539
MOSS 2007 or WSS 3.0 Cumulative Update April 2010 KB981042/KB981043 12.0.0.6535
MOSS 2007 or WSS 3.0 Cumulative Update February 2010 KB978395/KB978396 12.0.0.6529
MOSS 2007 or WSS 3.0 Cumulative Update December 2009 KB977026/KB977027 12.0.0.6524
MOSS 2007 or WSS 3.0 Cumulative Update October 2009 KB973409/KB973410 12.0.0.6520
MOSS 2007 or WSS 3.0 August 2009 Cumulative Update KB973409/KB973410 12.0.0.6514
MOSS 2007 or WSS 3.0 June 2009 Cumulative Update KB971537/KB971538 12.0.0.6510
MOSS 2007 or WSS 3.0 April 2009 Cumulative Update  KB968851/KB968850 12.0.0.6504
MOSS 2007 or WSS 3.0 SP2 KB953334/KB953338 12.0.0.6421
MOSS 2007 or WSS 3.0 Cumulative update  KB956056/KB956057 12.0.0.6327
MOSS 2007 or WSS 3.0 Infrastructure Update  KB951695/KB951297 12.0.0.6318
MOSS 2007 or WSS 3.0 post-SP1 hotfix KB948945 12.0.0.6303
MOSS 2007 or WSS 3.0 post-SP1 hotfix KB941274 12.0.0.6301
MOSS 2007 or WSS 3.0 post-SP1 hotfix KB941422 12.0.0.6300
MOSS 2007 or WSS 3.0 SP1 KB936984/KB936988 12.0.0.6219
MOSS 2007 or WSS 3.0 Security Bulletin MS07-059 KB942017 12.0.0.6039
MOSS 2007 or WSS 3.0 August 24, 2007 hotfix package KB941422 (updated) 12.0.0.6036
MOSS 2007 or WSS 3.0 RTM [Released To Manufacturing] N/A 12.0.0.4518
MOSS 2007 or WSS 3.0 Beta 2 TR N/A 12.0.0.4407
MOSS 2007 or WSS 3.0 Beta 2 N/A 12.0.0.4017