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.

09 October, 2009

Risk-List Uniqueness !!

This is regarding with one of the unique Sharepoint issues that we successfully resolved today. By using out-of-settings, it is not possible to resolve this issue and anybody can consider that it a SharePoint By-Default behaviour.

ISSUE:

-In a Project Tracking Workspace Template, there is one list which comes by default named "Risk List".

-If we want to create one more same list then you will not find the option under View All Site Content->Create-> Custom List

-If we try to save the Risk List as Template then it will successfully saved in the List Gallery but you will not find that list under the Create List Section (Path mentioned above)

STEPS TAKEN FOR RESOLUTION:

-Taken backup of all the folders for the below mentioned steps in which i have made modification !!

-Checked C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\FEATURES

-Inside the Features Folders->PWSRISKS Folder(Which is part of Project Tracking Workspace Template)

-Inside the PWSRISKS Folder->List Templates->pwsrisk.xml

-Opened the XML file in notepad->Made Modification as -> DontSaveInTemplate="FALSE" (It was True before)

-Opened Feature.XML for the Risk List-> made Modification as -> Hidden="FALSE" (It was true Before)

-That's it..Issue resolved !!