So once again I am back with a blog post… Today we will see that how to import a spreadsheet inside a custom list with defined columns. We are ready for production deployment for an application. This application contains the master data for cities all over the world. Client provided us the list of 9000 … Exports excel data to SharePoint custom list with desired column names!
I have a solution that contains SharePoint dll’s reference. Whenever I run the solution, start page get crash and show me this error. “Could not load file or assembly ‘Microsoft.SharePoint.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’ or one of its dependencies. An attempt was made to load a program with an incorrect format.” Well every time I run … Resolved: Could not load file or assembly ‘Microsoft.SharePoint.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’ or one of its dependencies…
During my SharePoint project i need to clean up the site for better performance. So first thing i started to delete the closed web parts from web part pages. As there were so many web part pages in the application so i decide to write a web application that can delete the closed web parts … Resolved: The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again.
Well as we know that we can extend a SharePoint site for different zone other than default with different port number and host header. In extended site creation, a new site creates on IIS pointing to a new virtual directory on server. This new virtual directory has its own web.config file for extended site. But … How to remove/delete SharePoint extended site placed in different zones
When we create a new web application in SharePoint using central administration, we get a section of “Reset Internet Information Services“ and by default its set to “Restart IIS Manually”. Many times we keep this option by default and create the application but even after successful web application creation we don’t reset IIS and go … Reset Internet Information Services for SharePoint In Depth
When we use variations with MOSS 2007 site, by default we get a drop down kind of control in the master page of site for language selection. But there is a major disadvantage of this control I found while working with a publishing site. Well the problem is if you are using some custom web … Disable Language Selection of MOSS 2007 Site : Resolved
By Default SharePoint search made up of two controls. First is a search drop down box that contains scopes.Second control is a serach box in which we type the keywords for search. Scopes can be classified in two 2 categories. 1. Custom scope 2. Contextual scope By default there are two custom scopes present in … Resolved: Remove Contextual Search Scope from Search Dropdown in SharePoint
SPSite site = new SPSite(“http://localhost:3001”); SPWeb web = site.OpenWeb(“MyWeb”); SPList list = web.Lists[“MyList”]; //RequestStartDate & RequestEndDate will be passed in mm/DD/yyyy format. //They can extend to work with time also. string startDate = (SPUtility.CreateISO8601DateTimeFromSystemDateTime(Convert.ToDateTime(this.RequestStartDate))); string endDate = (SPUtility.CreateISO8601DateTimeFromSystemDateTime(Convert.ToDateTime(this.RequestEndDate))); SPQuery query=new SPQuery(); query.Query = “<Where><And><Geq><FieldRef Name=’Date_x0020_of_x0020_Meeting’ /><Value Type=’DateTime’>” + startDate + “</Value></Geq><Leq><FieldRef Name=’Date_x0020_of_x0020_Meeting’ /><Value Type=’DateTime’>” + … CAML Query Search Between Two Date Ranges : SharePoint
I was writing the code for downloading a file from a SharePoint document library using Forms Based Authentication. Every time file was getting downloaded with 8kb of size when i was opening them they were showing that file is not supported. I opened one of downloaded files that was actually a word file, in notepad … File Download from SharePoint Document Library in Forms Based Authentication Scenario
Today i restored a moss site backup on a new port at my server. This site had Forms based authentication, after implementing all the settings i logged in as a site collection administrator in to the site. When i click Site Actions links, i found some options are missing in the menu e.g. “Edit Page”, … Resolved: Site Collection Administrator has limited permission to site.