15 May, 2011

How to open a list in Edit Mode



To open a List in edit mode and add the new Web Parts you usually need a SharePoint Desinger. 


But there is a trick, how to open a List in Edit Mode and have the “Add Web parts” window is displayed. 


Everything you need to do is to add  "&ToolPaneView=2" parameter to the List URL.


By means of this, you have the ability to add web parts and edit a List’s Form pages in the browser. It will look like:


http://SharePoint2007/Lists/ListName/ListFormView.aspx?&toolpaneview=2


Where ListFormView.aspx is either AllItems.aspx, NewForm.aspx, DispForm.aspx, or EditForm.aspx using the default names.


There is no SharePoint Designer used and no customisations to the page that require unghosting from the site definition.
Note:
ToolPaneView=2 -Shows the "Add Web Parts" toolpane, allowing you to drag and drop web parts onto a "Web Part Page".
ToolPaneView=3 -Shows the "Search" toolpane, letting you search through the web part galleries before adding a web part to the page.


Some useful info regarding the same:
1. Add “?contents=1″ behind the URL and you can delete any webpart from your page.


2. Find List Guid or view Guid:
In the list view – right click and view source. Then search for “ctx.Listname”.
The Guid looks like this:
{DEF643C7-CF80-4DF8-866F-C16DC017DFC0}.


The view Guid is found by searching for “ctx.view” and looks similar to the list Guid above.


If you have any information that you find valuable regarding the same then please share it by means of comments so that it will be useful for everybody.

Your Feedbacks/Suggestions/Comments are very important for me...If you have any Doubts/Queries/Confusion then please let me know...

I would be more than HAPPY to help you as well as RESOLVES your issues, Thanks

Hardware and software requirements (SharePoint Foundation 2010)

This article lists the minimum hardware and software requirements to install and run Microsoft SharePoint Foundation 2010.
http://technet.microsoft.com/en-us/library/cc288751.aspx  

Hardware requirements—Database servers  
http://technet.microsoft.com/en-us/library/cc288751.aspx#section3 

Software requirements
http://technet.microsoft.com/en-us/library/cc288751.aspx#section4 

Hardware and software requirements (SharePoint Foundation 2010)
http://technet.microsoft.com/en-us/library/cc288751.aspx#section2

Capacity management and sizing for SharePoint Server 2010.
http://technet.microsoft.com/en-us/library/cc261700.aspx

URL path length restrictions (SharePoint Foundation 2010)
http://technet.microsoft.com/en-us/library/ff919562.aspx

Demos and training for Office SharePoint Server 2007

I love to learn by watching videos, seeing how someone else accomplishes a task so that I can replicate that in my own environment.

In this post, you’ll find a plenty of material including free online videos to help you learn how to developing using SharePoint.

If you have any information that you find valuable regarding the same then please share it by means of comments so that it will be useful for everybody.

Your Feedbacks/Suggestions/Comments are very important for me...If you have any Doubts/Queries/Confusion then please let me know...I would be more than HAPPY to help you as well as RESOLVE your issues, Thanks

Training videos for SharePoint Enterprise search
The presentations provide details about key enterprise search capabilities in Microsoft Office SharePoint Server 2007: http://blogs.msdn.com/b/dhirajm/archive/2010/05/31/training-videos-for-sharepoint-enterprise-search.aspx

 Here is another set of videos and training material for Office SharePoint Server 2007:
http://blogs.msdn.com/b/dhirajm/archive/2010/05/31/demos-and-training-for-office-sharepoint-server-2007.aspx

Video demos and training for Office SharePoint Server 2007

A six-part series on getting the most out of SharePoint Designer 2007

Video demos and training for SharePoint Server 2010


SharePoint Guidance – November 2008
This guidance helps architects and developers design, build, test, deploy, and upgrade SharePoint intranet applications. A reference implementation demonstrates solutions to common architectural, development, and application lifecycle management challenges: http://www.microsoft.com/downloads/details.aspx?FamilyId=C3722DBA-6EE7-4E0E-82B5-FDAF3C5EC927&displaylang=en 

SharePoint Designer 2007 Visual How-Tos

 WSS 3.0 Visual How-Tos – Developer

SharePoint Server 2007 SDK Online

Video Demos and Training for Office SharePoint Server 2007 – End User Contains links to many Microsoft Office SharePoint Server 2007 video demos that are intended for IT professionals.

SharePoint Developer Center
Find information about planning, coding, building, deploying, and migrating solutions for Microsoft Office SharePoint Server 2007: http://msdn.microsoft.com/en-us/office/aa905503.aspx

Icons in Datasheet view for lists in SharePoint does not display correctly with office 2003

Office 2003 has so many limitations as compare to advanced version i.e. Office 2007. Microsoft recommended that if we want to use SharePoint 2007 in feasible manner then the best version is Office 2007.

I have two Virtual machines for testing from the client perspectives: One with Office 2003 and second with office 2007.

Issue is: When i tried to open a sharepoint list in datasheet view then the icons didn't render properly
Note: This is my Office 2003 with SP3 machine

Standard view is working correctly, problem is only with Datasheet view

Troubleshooting Did:
-Installed the windows sharepoint services support component by means of Office options
-checked the number of characters in the URL & that's fine (256 character limitation)
-checked with Office 2007, works perfectly

Now the questions arises: what is the problem with Office 2003. Not able to find out the root cause behind this but seems to be a Design Limitation with Office 2003.

Conclusion:
This issue is a design limitation for integration between Microsoft Office 2003 and SharePoint, and is only present for List's Datasheet view.
As a result, you cannot browse the folders from this view.

If you open a Document Library in Datasheet View, the Icons are rendered correctly.
If you open a List in Datasheet View with Microsoft Office 2007 the Icons are rendered correctly.

Upgrade to Office 2007 or later in order to avoid this behavior with SharePoint.



If you have any queries/questions regarding the above mentioned information then please let me know... I would be more than happy to help you as well as resolves your issues...

11 May, 2011

This file is not in a recognizable format


Excel files are the most commomly used in day-to-day office works.. 
There are so many complex functions, Daily/Monthly Reports, Graphs,pie diagrams etc..that can be easily managed by Excel.. But what you will do if this excel stopped functioning ?? Big Question-RIGHT !! 


While working on the excel, I have encountered some messages which took some time to resolve but finally heaved a sighed of Relief :-)

When you start Microsoft Excel, Excel attempts to open multiple documents and you may receive one or more of the following error messages. 
OR
If the computer is not updated and you did not install the Office Compatibility Pack, you will receive one of the following error messages when you try to open the file, depending on the program that you are using.

This file is not in a recognizable format /


Windows cannot open this file


PowerPoint can't open the type of file represented by filename
What you have 2 do? Don't Worry here are the steps to resolve this above mentioned error messages.

Resolution:
To resolve this issue, install the Office Compatibility Pack and each update for your version of the Office program.

One more thing that i would like to mention some differences that i found out while researching on this issue..

If you are using office 2003 and using SharePoint Server 2007 then some functionalities will not going to work.
Now the questions arises which are going 2 work and which are not !!

Please refer the following information regarding the same:
Application / FeatureOffice 2003Office 2007
Saving and editing Office 2003 files from SharePoint sitessupportedsupported
Viewing Office 2007 files from SharePoint sitesupportedsupported
Editing Office 2007 files from SharePoint sitesnot supportedsupported
Check-out/in, version historysupportedsupported
Start a workflownot supportedsupported
Publishing Excel files as web pagesnot supportedsupported
Working with Slide Librarynot supportedsupported
Synchronize document libraries to Outlooknot supportedsupported
Inserting document properties for (DOC/DOCX)not supportedsupported
Updating propertiessupportedsupported
Write a blog postnot supportedsupported
Synchronize tasks/discussion boards to Outlooknot supportedsupported
Synchronizing calendars to OutlookOnw Way Sync Onlysupported
Synchronizing contacts to OutlookOnw Way Sync Onlysupported
Compare versions of a SharePoint documentnot supportedsupported

Please let me know in case of any queries/questions/confusion regarding the above mentioned steps.. 
I would be more than happy to help you as well as resolves your issues..