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

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;
                            }
                        }
                    }
                }
            }

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.

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".

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..

Using PowerPivot with Excel 2010

http://blogs.office.com/b/microsoft-excel/archive/2009/10/23/using-powerpivot-with-excel-2010.aspx