SharePoint:filtered lookup field

I have done some investigation for doing a filterd lookup field for SharePoint list/libraries
got some references check this out hope this will help you....

Links:

http://filteredlookup.codeplex.com/
http://dattard.blogspot.com/2007/04/sharepoint-2007-filtered-lookups.html
http://sanjayapdl.wordpress.com/2008/02/21/filtered-lookup-field-in-sharepoint-list/

SharePoint:Exception from HRESULT: 0x80040E14

Issue:

I got this error when i am updating the item in the list and when i create a new item in the list
Error:Exception from HRESULT: 0x80040E14,0x80004004

Resolution:

I have done some investigation and found that the above error message might occur because of SQL transaction logs were full and needed to be truncated. It seems that the SQL Server is running out of the log space.
so clear the log file you will be out of this error!!!!!!! so simple right.

SharePoint:The workbook that you selected cannot be opened.

Issue:

When you open document in the document library if you get this error message "The workbook that you selected cannot be opened.

The workbook may be in an unsupported file format, or it may be corrupt.
Would you like to try and open this file in Excel? "

Resolution:

1. From Administrative Tools, open the SharePoint Central Administration Web application.
2. On the Central Administration home page, click Application Management.
3. On the Application Management page, in the Office SharePoint Server 2007 Shared Services section, click Create or Configure this Farm's Shared Services.
4. On the Manage this Farm's Shared Services page, click SharedServices1 (Default). This is the Shared Services Provider (SSP) that you will configure.
5. On the Shared Services home page, in the Excel Services Settings section, click Trusted file locations.
6. On the Excel Services Trusted File Locations page, click Add Trusted File Location.
7. In the Address section, type the location and name of the SharePoint Office SharePoint Server 2007 document library that you want to add as a trusted file location in Excel Services. If the document library is stored in the Windows SharePoint Services 3.0 content database, ensure that Windows SharePoint Services 3.0 is selected as the Location Type.
8. In the External Data section, select the type of data connections that you will allow workbooks in this trusted file location to contain and click OK.

SharePoint:Editing Profile in SharePoint Site

Issue:

Unable to edit SharePoint Profile

Resolution:

_layouts/editprofile.aspx add this at the end of the url...

SharePoint:object not set to an instance of an object with the webpart

Issue:

This issue is raised by one of the user who is unable to see a particular webpart in Sharepoint he is getting an error message "object not set to an instance of an object". and this is only happening for a particular users....hmmm god dam..

Deploying webpart to SharePoint 2007 using  Visual Studio Extensions for Windows SharePoint Services (VSE WSS) and getting error message “Object reference not set to an instance of an object”.

Resolution:

You need to add the user to the any of the people and groups...simple right.

This is for the second one:

1] Copy the built webpart.dll to c:\windows\assembly (GAC)

2]  In the folder location where webpart VSE solution was created found setup.bat file in bin\Debug, and this is the file which VSE calls when deploying the solution and has instructions to run it. Ran the setup.bat from command prompt as “setup /uninstall” this ran ok, then ran setup /install this ran ok too. Modified the setup.bat file and add the line to remove the webpart.dll from the GAC and add the webpart.dll assembly to GAC as under:

under :LDeploy section before goto :EOF added the following line:

===========================================================

"%programfiles%\Microsoft Visual Studio 8\SDK\v2.0\Bin\gacutil.exe" -if webpartTest.dll

"%programfiles%\Microsoft Visual Studio 8\SDK\v2.0\Bin\gacutil.exe" -uf webpartTest

Thanks for your time and patience in this matter. 

Thank You,

SharePoint:Unable to open doc files from document library

Issue:

When i am trying to open a document from document library  i got an error message like a popup showing "Some files can harm your computer, If the file information below looks suspicious, or you do not fully trust the source, do not open the file".

Resolution:

      Follow the steps to rectifiy this issue, add your site to the trusted location in browser

 

1)      Open Internet Explorer Options à From your browser Go to “Tools” à then select “Internet Options” àthis will popups Internet Options window

2)      From the Internet Options window àSelect Security Tab àHere select “Trusted Sites” Icon àClick “Sites” button

3)      Again Trusted sites window will pop up àHere uncheck

4)      And add http://yoursitename/  to the web sites list.

5)      Now try to open the file and let us know the result.

 

SharePoint:Outlook sync With Sharepoint calender

Issue:

This is one of the major issue i had and striggugeled for long time....here it goes

When i connect SharePoint calender to outlook i am able to get the events/tasks/items from Sharepoint to Outlook Calender but its not happening viceversa..such an idiatic issue we got ever..

Resolution:

This is a very simple solution you jus need to remove the redirects from the IIS i.e. you just need to uncheck the redirects from the IIS

Steps:

Window(button)+Run-->type inetmgr-->go to redirected site-->check the redirects icons-->uncheck if any redirects are given if so remove them.

Sarath.