07 September, 2010

Dataview does not work work in SP 2010

Hey Guys, 

This is another post based on Office 2010 issue in combination with SharePoint.

Error Message:

The list cannot be displayed in Datasheet view for one or more of the following reasons:
-A datasheet component compatible with Microsoft SharePoint Foundation is not installed.
-Your Web browser does not support ActiveX controls.
-A component is not properly configured for 32-bit or 64-bit support.

What happens exactly:
I have Office 2010 installed but when I tried to open a list in Sharepoint Server 2010 in dataview I get the "datasheet component combatible with SharePoint Foundation is not installed" error.

Resolution:

after lots of research n troubleshooting, i found out this great article which is published from Microsoft:

If your business needs justify using the 64-bit version of Office 2010, you can install the 2007 Office System Driver: Data Connectivity Components to enable the Datasheet component. These components are available from the 


Microsoft download center:http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

Office 2007: Microsoft Office Diagnostics

This is one of the vital feature which is enclosed by Microsoft in Office 2007.

Microsoft Office Diagnostics in the 2007 Microsoft Office system is a series of diagnostic tests that can help you discover why your computer is crashing (closing abnormally). The diagnostic tests can inform you about problems and might identify ways that you can solve other problems.
When Office Diagnostics determines that the data might help diagnose and fix a problem.

The Office Diagnostics are:

Setup Diagnostic:
This test checks for corruption in the files and registry settings in your 2007 Microsoft Office system installation. Files and settings can be corrupted by malicious viruses or by hardware that is faulty or incorrectly configured.

Disk Diagnostic:
This test looks for evidence of problems with your hard disk. Specifically this test checks for errors logged by the following:

-The Windows system event log.

-The Self-Monitoring, Analysis and Reporting Technology (SMART) feature of your hard disk. SMART is a feature that some disk drive manufacturers provide to give users advance notice of potential hard disk failure.

Memory Diagnostic:
This test verifies the integrity of your computer's random access memory (RAM).

Check for known solutions:
This test reviews the data on crashes of the 2007 Office release that have recently occurred on your system. The test then connects to a server to look for any solutions that might be available for the problems that caused these crashes.

How to run Office Diagnostics:

Click the Microsoft Office Button, and then click Excel Options.
Click Resources.
Click Diagnose, click Continue, and then click Start Diagnostics.


If you face any issues/queries regarding the above information then please let me know,Thanks.

29 August, 2010

Change the Site Logo in SharePoint 2010

One of the most important section of SharePoint site is a LOGO (A name, symbol, or trademark designed for easy and definite recognition)

Please refer the following steps as How to change the site logo on your SharePoint site:

One of the most vital thing is logo location.URL location- Upload a logo to a document library/“14 hive” (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES).

1. Click on Site Actions from the top left of the site and select Site Settings.

2. Click “Title, description, and icon” under the Look and Feel section on the Site Settings page.

3.Enter your logo URL location and a description

For 12 hive image location: the URL location would be /_layouts/images/yourlogo.gif

4.Click Ok and Site logo has been successfully applied on your site...

If you face any issues regarding the above information then please let me know, Thanks..

SP 2010: Certification exam details for SharePoint 2010 published

SharePoint 2010 certifications are mainly classified into two main sections:

1. For IT Professionals: SharePoint 2010 drives productivity and offers a scalable unified infrastructure and flexible deployment.

2. For developers, SharePoint 2010 provides a business collaboration platform you can use to rapidly build solutions for your business needs.



For the IT Pros

New on for IT Pros are 2 certifications. MCTS SharePoint 2010 Configuring and MCITP SharePoint 2010.

•70-667 TS: Microsoft SharePoint 2010, Configuring
Microsoft Official Curriculum: Will cover configuration of SharePoint 2010 including deployment, upgrade, management, and operation on a server farm.

•70-668 PRO: SharePoint 2010, Administrator
Microsoft Official Curriculum: Will cover advanced SharePoint 2010 topics including capacity planning, topology designing, and performance tuning.

For developers

Also for developers there will be 2 new certifications. MCTS SharePoint 2010 Application Development and MCPD SharePoint 2010.

•70-573 TS: Microsoft SharePoint 2010, Application Development
Microsoft Official Curriculum: Five-day instructor-led course designed for developers with six months or more of .NET development experience. Course covers what you need to know to be an effective member of a SharePoint development team using Visual Studio 2010.

•70-576 PRO: Designing and Developing Microsoft SharePoint 2010 Applications
Microsoft Official Curriculum: Five-day instructor-led training course designed for development team leads who have already passed the Developing on SharePoint 2010 technical specialist exam. The course covers choosing technologies for and scoping a SharePoint project, best practices for SharePoint development, configuring a SharePoint development environment, advanced use of SharePoint developer features, and debugging of code in a SharePoint project.

For more information, Please refer this site:
https://partner.microsoft.com/40121316?msp_id=sharepoint2010ready

Please let me know in case of any doubts/queries, I would be more than happy to help you as well as resolves your issues,Thanks...

09 July, 2010

Site Prompts for Credentials + How to add your sharepoint site in trusted file location zone - SharePoint 2007 and SharePoint 2010

This is a very common issue in which the SharePoint site prompts for credentials i.e. username and password. By default, SharePoint sites should automatically log you in via your existing Windows credentials without ever asking any identity.

Yesterday, one of my user faced the same problem n would like to share the resolution with all of u.

Internet Explorer Security Settings: How to add your SharePoint site in trusted file location zone

Open the Internet Explorer/Browser

1.   Tools

2.   Internet Options

3.   Select Security Tab

4.   Sites Button

5.   Enter the website name (URL) in Add this website to the zone.

6.   If your SharePoint site is NOT using SSL, make sure you uncheck the box require server verification (https :) for all sites in this zone prior to adding it.

7.   Click Ok once and you will be redirected to following window:

8.   Click on Custom Level Tab now

Note: If you are getting the above tab greyed out then it means that you don’t have admin rights on your machine.

9.   Scrolls towards the bottom and select the option that says
"AUTOMATIC LOGON WITH CURRENT USERNAME AND PASSWORD"

Click OK Everything

Open your SharePoint site in a new browser and check the results

The above steps will resolves your login prompts issue and you should be able to access the SharePoint without any problems!!!

If you face any issue then please let me know... I would be more than happy to help you and resolves your queries as soon as possible. Thanks you.