Get Data from a Forum / Discussion Board in SharePoint

======================FORUM, TITLE column==============

SPQuery query = new SPQuery();
query.Query = string.Concat(
    "<Where>",
        "<Eq>",
            "<FieldRef Name='IsRootPost'/>",
            "<Value Type='Number'>1</Value>",
        "</Eq>",
    "</Where>",
    "<OrderBy>",
        "<FieldRef Name='DiscussionTitle' Ascending='TRUE' />",
    "</OrderBy>");
query.ViewFields = "<FieldRef Name='DiscussionTitle' />";
query.ViewFieldsOnly = true;

SPListItemCollection _items = [MyList].GetItems(query);'

Add a FBA User to a SharePoint Group Programatically

SPSecurity.RunWithElevatedPrivileges(delegate

                               {

                                   using (SPSite site = new SPSite(SPContext.Current.Web.Url))

                                   {

                                       using (SPWeb web = site.OpenWeb())

                                       {

                                           //adding user to the contributor group

                                           web.AllowUnsafeUpdates = true;

                                           //i:0#.f|sql-membershipprovider|chana

                                           string usernameWithProvider = "i:0#.f|sql-membershipprovider|" + usr.UserName;

                                          

                                           web.AllUsers.Add(usernameWithProvider, txtUserName.Text, txtUserName.Text, "");

                                           try

                                           {

                                               SPUser spuser = web.AllUsers[usernameWithProvider];

                                               if (spuser != null)

                                               {

                                                   SPGroup spGroup = web.Groups["Dev Members"];

                                                   if (spGroup != null)

                                                       spGroup.AddUser(spuser);

                                                   web.Update();

                                                   web.AllowUnsafeUpdates = false;

                                               }

                                           }

                                           catch { }

                                           web.Update();

                                           web.AllowUnsafeUpdates = false;

                                       }

                                   }

                               });

SharePoint User Token Code

try

            {

                SPSite tempSite = new SPSite(siteURL);

                string loginNameInFull = @"i:0#.w|" + username;

                SPUserToken userToken = tempSite.OpenWeb().AllUsers[loginNameInFull].UserToken;

                using (SPSite site = new SPSite(siteURL, userToken))

                {

                    using (SPWeb web = site.OpenWeb())

                    {

                        SPList olist = web.Lists[listName];

                        SPListItemCollection ocol = olist.Items;

                        return ocol;

                    }

                }

            }

This is passing credentials to Windows Authentication

UserName append with "i:0#w|" 

Convert EXCEL file to Project Plan

When we have data in an EXCEL with number of dates, we can convert that data to Project Plan without any other software.

Got the excel magic from

http://chandoo.org/wp/2008/05/20/gantt-in-60-seconds-churn-out-an-excel-project-plan-in-no-time/

SharePoint 2013 Enterprise Search With Custom Refiners

The Best Article for SharePoint 2013 Enterprise Search (Advance)

http://blogs.technet.com/b/tothesharepoint/archive/2013/11/06/how-to-configure-the-search-results-web-part-to-use-a-new-result-source-in-sharepoint-2013.aspx

Configure Office Web Apps For SharePoint 2013

The best Tech-Net article that I ever Read,
http://technet.microsoft.com/en-us/library/ff431687.aspx

The only thing is, we have to wait few minutes after each configuration change that we doing using Power-Shell command.

Schedule Task for SharePoint Site Backup

1) Open notepad
2) Create a command using STSADM

3) Set the path to store BACKUP

4) Go to TASK SCHEDULEr in server

5) Set the Schedule and account with elevated priviledges

6) Verify the backup and the location

COMMAND

@echo off

echo ===============================================================

echo Back up the farm to E:\CSKH_Backups

echo ===============================================================

cd %COMMONPROGRAMFILES%\Microsoft Shared\web server extensions\15\BIN

@echo off

stsadm.exe -o backup -url http://myportal -filename \\NASFSVS\KMSadmin_share\portalSP%date:~-2%%date:~4,2%%date:~7,2%.bak -overwrite -nositelock

echo completed

*** One Important Thing when creating TASK

How the file name set:

portalSP%date:~-2%%date:~3,2%%date:~0,2%.bak

if date is 29 - 09  - 15 ==> portalSP150929.bak

               01 2 34 5 67

Enable Sign in as Different User Option in SharePoint 2013

1) Locate and then open the following file in a text editor:
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\ TEMPLATE\CONTROLTEMPLATES\Welcome.ascx

2) Add the following element before the existing "ID_RequestAccess" element:

<SharePoint:MenuItemTemplate runat="server" ID="ID_LoginAsDifferentUser" Text="<%$Resources:wss,personalactions_loginasdifferentuser%>" Description="<%$Resources:wss,personalactions_loginasdifferentuserdescription%>" MenuGroupId="100" Sequence="100" UseShortId="true" />

3) Save the file

Alternative Access Mapping for a SharePoint Farm

We have to add Alternative Access Mapping for all application severs.

Then we have add Alternative Access Mapping for Intranet zone.

Other wise users getting FILE NOT FOUND ERROR.

Save SharePoint List as a Template giving an error

When we are going to save a SharePoint List with huge data, it gives an error.

Simply because of Data size.

So we have to increase template size using STSADM

It is easy.