Tuesday, February 7, 2012

SharePoint Site Error: Service Unavailable HTTP Error 503. The service is unavailable

When opening My SharePoint site it giving me the error ‘Service Unavailable HTTP Error 503. The service is unavailable’ and I was not able to access either of them.

It was stopped at the IIS when i'm start manually i got the same error. I realized that I had just changed the password of my account. So here is share what I did to solve the problem.

1. Open up IIS Manager and click on 'Application Pools'.

2. Locate your App Pool account and right-click on it and select 'Advanced Settings'.

3. Under the Process model Group click on 'Identity' then Application Pool Identity Pop up is opened Click on 'Set' and re-enter My User Name, Password and Confirm Password then click on 'OK'.

Error is cleared...

Hope it will help you...

Thursday, February 2, 2012

Using PowerPoint 2010 themes in SharePoint 2010 In 6 Easy Steps

Creating your own theme for SharePoint 2010 used to be similar to dark alchemy, so one of the things that I thought I would share with you is how easy it is to create your own theme for SharePoint 2010 just using PowerPoint 2010.

1. Choose which theme to apply to your PowerPoint presentation


2. Save as a .thmx file



3. In SharePoint navigate to Site Settings -> Site Theme and then at the top of the page choose Theme Gallery


4. Click ‘Add New Item’ and then browse to where you saved your theme



5. Now Click OK and Save

6. Then navigate back to Site Settings -> Site Theme and your new theme will be available to choose and apply


You can from here apply more tweaks until you are happy with your new colour scheme.

Sharepoint Error Message: Your client does not support opening this list with Windows Explorer

http://tihomirignatov.blogspot.in/2009/08/sharepoint-error-message-your-client.html

Tuesday, January 24, 2012

Programmatically reading the contents from an InfoPath form

            using (SPSite oSite = new SPSite(SPContext.Current.Site.ID))
            {
                using (SPWeb oWeb = oSite.OpenWeb())
                {
                    SPList formsLib = oWeb.Lists["My Forms"];
                    if (formsLib != null)
                    {
                        foreach (SPListItem item in formsLib.Items)
                        {
                            MemoryStream stream = new MemoryStream(item.File.OpenBinary());
                            XmlDocument doc = new XmlDocument();
                            doc.Load(stream);
                            XmlNamespaceManager nameSpaceManager = new XmlNamespaceManager(doc.NameTable);
                            nameSpaceManager.AddNamespace("my", doc.DocumentElement.NamespaceURI);
                            XmlNodeList nodeList;
                            XmlElement root = doc.DocumentElement;
                            string username = root.SelectSingleNode("/my:myFields/my:userName", nameSpaceManager).InnerText;
                            nodeList = root.SelectNodes("/my:myFields/my:prjdetails/my:group", nameSpaceManager);
                            foreach (XmlNode node in nodeList)
                            {
                                projName = node.SelectSingleNode("my:project", nameSpaceManager).InnerText;
                                projID = node.SelectSingleNode("my:projID", nameSpaceManager).InnerText;
                            }
                        }
                    }
                }
            }

Monday, January 23, 2012

New Web Application is disabled in SharePoint 2010 for Windows 7 & Vista

I installed SharePoint2010 in the windows 7 machine for development environment. Installation as well as product configuration completed successfully. But I am not able to create a new web application in the Application Management area.

New option is disabled


To enable the new option in Cental Administration àApplication Management àManage Web Application, the below steps to be followed.

Step 1: Open the Internet Explorer àTools à Internet Options



Step 2: Open the Security tab à select the Local Intranet zone à then click the sites button

Step 3: Confirm whether automatically detect intranet network is checked and then Click the Advanced button

Step 4: Now add your central administration site address (eg: http://contoso(system name):100000/ ) in the Add this website to this zone text box.

Step 5: Click Add button to include above Central Administration site address in the websites list.


The following message will be displayed and click yes

Now Central Administration site address added in the websites list.


Step 6: Close the window and click consecutive ok buttons

Step 7: Now Open the Central Administration with Administrator rights (Right click à Run as Administrator)


Step 8: Open Central Administration à Application Management à Manage web Application to confirm new option is enabled.


Saturday, January 21, 2012

convert a date(dd/mm/yy) to a month in MS Excel

  • Select cell
  • On Formula bar enter the below formula
=CHOOSE(TEXT(A2,Month(A2)),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")

if A2 contains 11/12/2012 means that formula returns "Nov".



Thursday, January 19, 2012

Changing the alert mail footer content

Go to SharePoint 14 HIVE\Resources\core.en-US.resx... Edit the mail footer to change the contents of the default mail alert..

How to launch a document by clicking a link to the file?

Word: <a href='ms-word:ofe|u|path/to/web/word/document.docx'>Link to document</a> Excel: <a href='ms-excel:o...