04 December, 2009

no Next in list of users and groups

Groups.aspx will not display more than 100 groups !!

We have a site collection with many users and groups. It consist of approximately 745 groups created with different depts. When I go to see a list of users and groups, I only see the first page i.e. 100 groups only !! this is actually very strange as i compared with other site collections that are running in our farm, those sites are not facing this wierd issue... The next arrows are gone, we can't advance through the list.

After digging a lot, we were able to resolve this issue and i would like share this resolution with all of u !!!!
--The page on which we can see all the created groups is called as "User Information List"
--or we can add that one as a User Information List web part.
--Every List has the option of "Modify this View" but for this list i.e. "User Information List", this view is hidden (by default).. Microsoft hide this view from the consideration, just to avoid messing !! i can guess :-)
--When we will go inside that view then we have enable these following options:-

1. User Information List.
2. Click Edit > Modify this view
3. Count section
4. Make sure the Item Limit is set to 100 and Display items in batches of the specified size is checked.


Now the question arises as How to go inside that list ?? Dont Worry, Please follow these steps:

-> That page is called as ViewEdit.aspx

->You need to pass the Guid for both the list and view to this page, like this:
->http://MOSS2007.com/_layouts/ViewEdit.aspx?List={00000000-0000-0000-0000-000000000000}&View={00000000-0000-0000-0000-000000000000}

-> You can get the Guid for the User Information List using the GetListCollection web method on /_vti_bin/Lists.asmx.

-> You can get the Guid for the View by passing the Guid for the list to the GetViewCollection web method on /_vti_bin/Views.asmx

I hope the above information will helps u to resolve this issue..Thanks !!

03 December, 2009

File Conversion in Process, Converter Failed To Save File

On some machines, when a user opens an Excel file from SharePoint and checks out for edit and -does not- use the local drafts folder, yousee a dialog with "File Conversion In Progress", then "ConverterFailed To Save File" message, but the file is checked out to the user and will not open in the Excel. It never opens the application and I'm returned to the document library. If I already have the application it doesn't generate the error.

The fix is to do the following:

- Open Word
- Click the Office button (Top-left in the window)
- Click Word Options
- Click Resources
- Click the Diagnose button
- Click through the wizard until it’s finished
- Close all browser windows

That’s fixed all of our issues…

I hope the above information will helps u to resolve the issue !! Thanks !!

02 December, 2009

Error: Library Not Registered

On our main Sharepoint page, we've got this drop-down-button in our main navigation that shows other sites and lets you click on them to access them. I believe it uses ActiveX controls. We've got one user (that we know of) who when she loads up the main page, that drop-down won't work for it...it just does nothing. At the bottom-left of the page, IE shows an "error on page." When I double click on it to get the error, it says the following:

Line: 1936
Char: 4
Error: Library not registered.
Code: 0
URL: (the url of the page)

The fix is to do the following:

- Open Word
- Click the Office button (Top-left in the window)
- Click Word Options
- Click Resources
- Click the Diagnose button
- Click through the wizard until it’s finished
- Close all browser windows

That’s fixed all of our issues…

If you are using Office-2003 then please follow the below mentioned steps:

-Word 2003
- Help
-detect and repair
- check discard my customized settings and restore default settings

I hope the above information will helps u to resolve the issue !! Thanks !!

26 November, 2009

How to find out the List GUID in sharepoint !!

As the document libraries and lists are the most commonly used entities in sharepoint, or we can say sharepoint starts with list and libraries !! So, there are so many problems or issues we face on day to day basis...Among all these problems, some required list id's.

Please follow these as how to find out the list guid:
1.Navigate to the SharePoint list using the browser.

2.Select the Settings + List Settings menu command.

3.Copy the Url from the browser address bar into Notepad.

It will look something like: http://moss2007/adminX/_layouts/listedit.aspx?List=%7B26534EF9%2DAB3A%2D46E0%2DAE56%2DEFF168BE562F%7D

4.Delete everying before and including “List=”.

5.Change “%7B” to “{”

6.Change all “%2D” to “-“

7.Chnage “%7D” to “}”

8.You are now left with the Id:{26534EF9-AB3A-46E0-AE56-EFF168BE562F}

That's it-issue resolved !!!!!!

I hope the above information will helps you to find the list guid..thanks !!

13 November, 2009

Uploading Spreadsheets into SharePoint Lists

By having the data from the spreadsheet in a SharePoint list it makes it easier to filter the data, display the data to the right audiences, search the data, add new records to the list and most importantly it is easier for people to have access to the data. so what is the right process to upload spreadsheets into sharepoint list ????

1. Open up the SharePoint site where you want to create the new SharePoint list that will contain the data from your spreadsheet.

2.Click Site Actions – Create.

3.Then from the column Custom List you will find Import Spreadsheet .

4.Enter a ‘Name’ for the List and a Description.

5.Then in the ‘Import from Spreadsheet’ section browse to your spreadsheet.

6.Next click the ‘Import’ button.

7.You will now get the ‘Import Windows SharePoint List’ screen as well as your Excel spreadsheet.

8.Cell A1 is highlighted but you can’t select all the cells until you change the dropdown ‘Range of Cells’ and then click in the bottom box ‘Select Range’.

9.Now you can click on cell A1 hold the mouse button down and drag to the last cell in your spreadsheet so that all cells including the column titles are selected.

10.Now click the ‘Import’ button and after a few seconds you will have a neatly presented SharePoint list with all the columns and data from your spreadsheet now displaying.