Upgrade issue from SPS2003 to MOSS2007

When you upgrade your SharePoint environment from SPS2003 to MOSS 2007 and if you have a “General Discussion” list, you will get “null” in the “Last updated” field because is SPS2003 there is no such field named “Last Updated” exists.  You will get “Modified” in field “General Discussion” List of the older version of SharePoint. …

1

Exporting Excel data to SharePoint 64 bit’s List environment.

If you are creating the windows application to export the data from Excel 2003 files to MOSS 64 bit environment, the following solution will help to achieve this functionality. we have to adopt this approach because till now there is no 64 bit version of the Microsoft.JET.OLEDB.4.0 driver available. So If you compile you assembly…

1

Duplicate InternalName of the Site column

A duplicate name "<string>" was found. at Microsoft.SharePoint.SPFieldCollection.AddFieldToWeb(String strXml, Boolean checkDisplayName) at Microsoft.SharePoint.SPFieldCollection.AddFieldAsXmlInternal(String schemaXml, Boolean addToDefaultView, SPAddFieldOptions op) at Microsoft.SharePoint.Deployment.FieldTemplateSerializer.CreateField(SPWeb web, SerializationInfoHelper infoHelper) at Microsoft.SharePoint.Deployment.FieldTemplateSerializer.SetObjectData(Object obj, SerializationInfo info, StreamingContext context, ISurrogateSelector selector) at Microsoft.SharePoint.Deployment.XmlFormatter.ParseObject(Type objectType, Boolean isChildObject) at Microsoft.SharePoint.Deployment.XmlFormatter.DeserializeObject(Type objectType, Boolean isChildObject, DeploymentObject envelope) at Microsoft.SharePoint.Deployment.XmlFormatter.Deserialize(Stream serializationStream) at Microsoft.SharePoint.Deployment.ObjectSerializer.Deserialize(Stream serializationStream) at Microsoft.SharePoint.Deployment.ImportObjectManager.ProcessObject(XmlReader xmlReader) at Microsoft.SharePoint.Deployment.SPImport.DeserializeObjects()…

1

How to connect BDC with Sybase Database

Using BDC Editor Tool we can generate metadata xml file for connecting BDC with Sybase database. For this we can either use ODBC or OLEDB connection type. To use ODBC we need to first create DSN. The DSN name along with login credentials needs to be used in the connection string. Once this is done…

6

MOSS : How to pass the FBA authenticated user to a PageViewer Web Part?

If you creates a Form based authenticated site and you were not able to get the authenticated login user token at client site. You can use the following resolution when you are working with PageViwer Web Part. using System; using System.Runtime.InteropServices; using System.Web.UI; using System.Web.UI.WebControls.WebParts; using System.Xml.Serialization; using System.Xml; using Microsoft.SharePoint; using Microsoft.SharePoint.WebControls; using Microsoft.SharePoint.WebPartPages;…

1

MOSS : How to get the credentails management URL

SingleSignonLocator.GetCredentialEntryUrl Method (Microsoft.SharePoint.Portal) is reserved method. You can verify at link <http://msdn2.microsoft.com/en-us/library/microsoft.sharepoint.portal.singlesignonlocator.getcredentialentryurl.aspx> . To Get the Credentials entry URL following resolution is available. Code Snippet ============ using Microsoft.SharePoint.Portal; using Microsoft.SharePoint.Portal.SingleSignon; SpsSsoProvider sso = new SpsSsoProvider(); Application.ApplicationInfo MyApp = null; //Change the “TestingSSO” to your Application Name. Application.GetApplication(“TestingSSO”, ref MyApp); Uri returnValue = sso.GetCredentialManagementURL(MyApp.ApplicationName); writer.Write(returnValue.OriginalString); writer.Write(“<a…

1

Changing MasterPage programmatically for site collection and sub-sites

using System; using System.Collections.Generic; using System.Text; using Microsoft.SharePoint; namespace CustomMaster { public class ChangeMaster : Microsoft.SharePoint.SPFeatureReceiver {   public override void FeatureActivated(SPFeatureReceiverProperties properties) { SPWeb CurrentWeb = properties.Feature.Parent as SPWeb; CurrentWeb.MasterUrl = CurrentWeb.Site.RootWeb.ServerRelativeUrl + “/_catalogs/masterpage/MyDefault.master”; CurrentWeb.CustomMasterUrl = CurrentWeb.Site.RootWeb.ServerRelativeUrl + “/_catalogs/masterpage/custom.master”; CurrentWeb.Update(); foreach (SPWeb subweb in Web.GetSubwebsForCurrentUser()) { ChangeMasterPage(subweb, pstrMasterURL, pstrCustomURL); } CurrentWeb.Dispose(); } void ChangeMasterPage(SPWeb…

1

By default, In the installation of WSS3.0 setup, you didn’t get the Audit logs reports option. if you enable the logs using event handler , you will not get the view logs of items.

Create an HttpHandler using the ClassLibraryTemplate in the visual Studio 2005. using System; using System.Web; using System.Collections.Generic; using System.Text; using Microsoft.SharePoint; using Microsoft.SharePoint.ApplicationRuntime; using Microsoft.SharePoint.Utilities; using System.IO; namespace [NameSpaceName] { public class [ClassName] :IHttpHandler { public [ClassName]() { } public void ProcessRequest(HttpContext context) { SPFile myFile = null; SPSite siteCollection = SPContext.Current.Site; SPWeb web =…

1

How To : Set calculated field to read-only using Object Model

(A) Create an EventHandler using the ClassLibraryTemplate in the visual Studio 2005. using Microsoft.SharePoint; public class [ClassName] : SPListEventReceiver { public override void FieldUpdating(SPListEventProperties properties) { properties.ErrorMessage = “You can’t changed the column.”; properties.Cancel = true; } } (B) Register the Event Handler using the following Code. // http://tangov39:47242/sites/TestCase/ is the site URL. SPSite collection…

1