Chanaka's Blog

Disable SharePoint Dialog Box PopUp and Redirect to a page

2012-02-08T16:59:00.000-08:00

In SharePoint 2010 we are getting dialog box popup when we want to add / edit list item. But if we want to disable it, then

Create SharePoint Site using site template

2012-02-02T03:32:00.000-08:00

Add Chart WebPart In SharePoint 2010

2012-01-10T10:58:00.000-08:00

1.Add a webpart

2.Giving error

3. Run Farm Wizard

4. Create "Managed Metadata Service"

5.Skip creating first site for the web application

6. Getting the Chart WebPart with basic sketch

SharePoint 2010 Change Default Search Service

2012-01-05T01:27:00.000-08:00

If we have created a separate search service application for our client, we need to set customized search service as default search service. We can do it through Central Administration.

we can select the customized "Search Service" for each and every web application.

SharePoint 2010 Resource Throttling

2011-12-21T00:01:00.000-08:00

When we are heavily using SharePoint we need to increase default resources.
If any LIST is going to exceed 20,000 item limit we have to increase the default count.
1. go to "Central administration "
2. Go to web applications list
3. Select the needed web application
4. go to "General settings" on the menu bar
5. select "Resource settings"

6. Set the maximum items count (List View Threshold) or maximum number of lookup fields

SharePoint 2010 Search return no results

2011-12-20T03:24:00.000-08:00

1. Do a "Crawl"

2. Go to "Crawl Log"

3. Have a look on the "SharePoint Log"

4. It is because of "Alternative Access Mapping", SharePoint Application server can't get data from itself when ACM is enabled.

Solution
So you need to disable the LoopBackRequest in registry. To do this, just follow my instructions:

1. Go to command window and type regedit.exe
2. Once opened the registry editor, just navigate to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa"
3. Right click on "Lsa" and create a new 32bit DWORD value
4. Rename it as "DisableLoopbackCheck" (Note: you cannot rename it actually. so, once created the DWORD value, directly paste/type as "DisableLoopbackCheck".
5. Then again modify the value of "DisableLoopbackCheck" as "1"
6. Close the registry editor.
7. Now start to crawl the content.

5. Do a Re-Crawl

SharePoint 2010 Search Advanced

2011-12-20T02:40:00.000-08:00

1. Create a separate "Search Service Application"

2. Add SharePoint account in to "Administrator"group

3. Click on the service application

4. Go to "Content Sources"

5. Type the URLs (eg:- http://Intranet)

6. Go to "Scopes" and then Click "Edit"

7. Set the web address or content source

8. Set "Scopes"

9.Set "Scope rules"

10.Set the "Crawl Rules"

11. Crawling Full

12. Crawling Incremental

13. Go to "Crawl Log" and see the "Statistics"

14. "Crawl" success with green color icon

15. Filter "Crawl Items" if you have 1000+ items

SharePoint 2010 User Profile Sync

2011-12-06T00:21:00.000-08:00

1. We have to create user profile connection in central administration

2.Populate data from AD

3.Restart User Profile Synchronization service

4. Edit User Property (Picture property)

5. Map with AD property (ThumbnailPhoto)

6. Start the User Profile SYNC

7.Run the powershell command

"Update-SPProfilePhotoStore -CreateThumbnailsForImportedPhotos 1 -MySiteHostLocation http://SharePoint-T02/my"

8.Verify Images in "http://Intranet/my/User Photos/"

DONE :)

Now AD user images should display in Mysite of all users.

NB:- SharePoint 2010 should be updated with SP1 to get the images from to SharePoint

SharePoint 2010 User Profile Sync filtration

2011-11-27T05:04:00.000-08:00

We can have a filtration to user profile sync in SharePoint 2010.
If we don't need to sync deactivated user accounts we can have a "Exclusion Filter".
We can use any attribute to reduce the load of sync.

Can't see Manage Services in SharePoint 2010

2011-11-27T04:51:00.000-08:00

Sometimes we can't see the "Manage Services in Server"

are you puzzled???
*** Start the browser with "administrator privileges" :)

Find SharePoint 2010 Version and status of updates

2011-11-27T04:40:00.000-08:00

Get SharePoint Webapplication port number in 2010

2011-10-22T00:47:00.000-07:00

1. Open a text document
2. Type the following lines

"echo Getting all SharePoint ports
pushd C:\Windows\System32\inetsrv
appcmd list wp
cd C:\Windows\System32\inetsrv
pause"

3. save as "myApps.cmd"
4. Run as Administrator

SharePoint 2010 close the popup and redirect parent

2011-10-21T22:14:00.000-07:00

In SharePoint 2010 we have popup windows in many places.

If we need to close the PopUp and redirect the parent to a new page or reload the PopUp we can use simple code :)

Server side Code In the POPUP page
string redirectUrl = ResourceWrapper.GetAAFResource("PopupMyApprovalsLink");
Response.Write("script type='text/javascript'>window.frameElement.navigateParent('"+ redirectUrl +"'));
also we can use,
Response.Write("script type='text/javascript'>window.frameElement.commitPopup()");
to close the PopUp

Excel Macro To Send Emails Automatically

2011-10-06T03:20:00.000-07:00

Option Explicit

Private Sub Worksheet_Calculate()
    Dim FormulaRange As Range
    Dim NotSentMsg As String
    Dim MyMsg As String
    Dim SentMsg As String
    Dim MyLimit As Date

    NotSentMsg = "Not Sent"
    SentMsg = "Sent"

    'Above the MyLimit value it will run the macro
    MyLimit = Date   //Set The Current Date

    'Set the range with Formulas that you want to check
    Set FormulaRange = Me.Range("J6:J60") //Date Range

    On Error GoTo EndMacro:
    For Each FormulaCell In FormulaRange.Cells
        With FormulaCell
            If IsDate(.Value) = False Then
                MyMsg = "Not a date"
            Else
                If .Value < MyLimit Then
                    MyMsg = SentMsg
                    If .Offset(0, 1).Value = NotSentMsg Then
                        Call Mail_with_outlook2 //Call To Send Emails
                    End If
                Else
                    MyMsg = NotSentMsg
                End If
            End If
            Application.EnableEvents = False
            .Offset(0, 1).Value = MyMsg
            Application.EnableEvents = True
        End With
    Next FormulaCell

ExitMacro:
    Exit Sub

EndMacro:
    Application.EnableEvents = True

    MsgBox "Some Error occurred." _
         & vbLf & Err.Number _
         & vbLf & Err.Description

End Sub
=================================================
Email Sending Part
=================================================
Sub Mail_with_outlook2()

    Dim OutApp As Object
    Dim OutMail As Object
    Dim strto As String, strcc As String, strbcc As String
    Dim strsub As String, strbody As String

    Set OutApp = CreateObject("Outlook.Application")
    Set OutMail = OutApp.CreateItem(0)

    strto = Cells(FormulaCell.Row, "P").Value
    strcc = ""
    strbcc = ""
    strsub = "Do an update"
    strbody = "Hi " & Cells(FormulaCell.Row, "L").Value & vbNewLine & vbNewLine & _
              "Your expiry date is: " & Cells(FormulaCell.Row, "J").Value & vbNewLine & _
              "for the task of : " & Cells(FormulaCell.Row, "C").Value & _
              vbNewLine & vbNewLine & "Do an update" & _
              vbNewLine & vbNewLine & "Thanks." & _
              vbNewLine & vbNewLine & "Regards," & _
              vbNewLine & vbNewLine & "Marina Samaratunge"

    With OutMail
        .To = strto
        .CC = strcc
        .BCC = strbcc
        .Subject = strsub
        .Body = strbody
        'You can add a file to the mail like this
        '.Attachments.Add ("C:\test.txt")
        .Display    ' or use .Send
    End With

    Set OutMail = Nothing
    Set OutApp = Nothing
End Sub

SharePoint 2010 permission levels

2011-09-14T23:16:00.000-07:00

Permission Levels

1. Full

2. High

3. WSS_Medium

4. Medium

5. Low

6. WSS_Minimal (Default security level that comes with SharePoint)

7. Minimal

Things that we can do when do custom development

1. Raise the trust level of the application

2. GAC your assemblies (so that they run in full trust and get the permissions needed)

3. Put the assemblies in to ‘Bin’ folder and create a custom policy file, refer it in web.config file

Create SharePoint search results using FullTextSqlQuery

2011-09-14T02:32:00.000-07:00

            DataTable search = new DataTable();
            using (SPSite site = new SPSite(SPContext.Current.Web.Site.Url))
            {
                SearchQueryAndSiteSettingsServiceProxy settingsProxy = SPFarm.Local.ServiceProxies.GetValue();
                SearchServiceApplicationProxy searchProxy = settingsProxy.ApplicationProxies.GetValue("Search Service Application");

                FullTextSqlQuery query = new FullTextSqlQuery(searchProxy);
                query.QueryText = "SELECT FirstName,LastName ,AccountName,WorkPhone,UserName,PreferredName,AboutMe,NationalityP,NationalityS FROM SCOPE() WHERE \"Scope\"='People' ";
                query.ResultTypes = ResultType.RelevantResults;
                query.ResultsProvider = Microsoft.Office.Server.Search.Query.SearchProvider.Default;
                query.KeywordInclusion = KeywordInclusion.AllKeywords;

                ResultTableCollection results = query.Execute();
                if (results.Count > 0)
                {
                    ResultTable relevant = results[ResultType.RelevantResults];
                    search.Load(relevant);

                    // serialize DataTable to XML
                    StringBuilder resultsXml = new StringBuilder();
                    using (StringWriter sw = new StringWriter(resultsXml))
                    {
                        search.WriteXml(sw);
                        sw.Flush();
                    }

                    // move XML to the XmlDataSource
                    XmlDataSource xds = new XmlDataSource();
                    xds.EnableCaching = false;
                    xds.Data = resultsXml.ToString();
                }
            }

Create SharePoint search results programatically

2011-09-14T02:11:00.000-07:00

private void ComplexSearch()
        {
            SearchQueryAndSiteSettingsServiceProxy settingsProxy = SPFarm.Local.ServiceProxies.GetValue();
            SearchServiceApplicationProxy searchProxy = settingsProxy.ApplicationProxies.GetValue("Search_Service_CUSTOM");
            KeywordQuery keywordQuery = new KeywordQuery(searchProxy);
            string SearchScope = "PEOPLE";
            keywordQuery.HiddenConstraints = "scope:" + "\"" + SearchScope + "\"";

            keywordQuery.TrimDuplicates = true;
            keywordQuery.EnableStemming = true;
            keywordQuery.IgnoreAllNoiseQuery = true;
            keywordQuery.QueryText = "SELECT AccountName,PreferredName,PictureUrl,WorkEmail,JobTitle,Department,InternalNumber,OfficeNumber,AboutMe,Responsibility,Skills,HitHighlightedSummary,InternalTelephone,OfficeNumber,AboutMe,Responsibility,Skills,HitHighlightedSummary,HitHighlightedProperties,CollapsingStatus,Path,FirstName,LastName FROM Scope() WHERE ('scope'='People')";

            keywordQuery.EnablePhonetic = true;
            keywordQuery.ResultsProvider = SearchProvider.Default;
            keywordQuery.ResultTypes = ResultType.RelevantResults | ResultType.SpecialTermResults ;
            ResultTableCollection resultsTableCollection = keywordQuery.Execute();
            ResultTable searchResultsTable = resultsTableCollection[ResultType.RelevantResults];
            DataTable resultsDataTable = new DataTable();
            resultsDataTable.TableName = "Results";
            resultsDataTable.Load(searchResultsTable, LoadOption.OverwriteChanges);

            DataView view = new DataView(resultsDataTable);
            SearchGrid.DataSource = resultsDataTable;
            SearchGrid.DataBind();
        }

SharePoint Credential Popup disabling

2011-08-31T03:00:00.000-07:00

It was a so much trouble to me when working SharePoint to give "Credentials" always. Even we are not thinking about it, it takes considerable amount of time. So i have decided to avoid from it.

Internet Explorer --> Internet Options --> Security --> Trusted Sites --> User authentication

How to Open a DataSet using Microsoft Excel in a web application

2011-08-17T01:25:00.000-07:00

protected void btnExportExcel_Click(object sender, EventArgs e)
        {
            DataSet ds = CurrentApproverService.GetReportData(depID, UserID);

            DataGrid dg = new DataGrid();
            dg.DataSource = ds;
            dg.DataBind();

            Response.ClearContent();
            Response.AddHeader("content-disposition", "attachment; filename=" + "ReportData.xls");
            Response.ContentType = "application/excel";
            System.IO.StringWriter sw = new System.IO.StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter(sw);
            dg.RenderControl(htw);
            Response.Write(sw.ToString());
            Response.End();

            dg = null;
            dg.Dispose();
        }

How SharePoint 2010 Installation creates SQL Sever DataBases

2011-08-08T02:18:00.000-07:00

I was able to get step by step screen shots of,
SharePoint 2010 installation Vs. SQL Server DB creation

(1) Initial DB structure

(2) While SharePoint 2010 Installing

(3) Step 3 of "SharePoint 2010 product configuration" is the main step that creates "Config" database

(4) When "Configure SharePoint Farm" using Central Administration

(5) SQL DB structure while running wizard

(6) After Configured All Services in "SharePoint 2010"

It is Easy And Structured :)

Localization in SharePoint

2011-08-08T01:44:00.000-07:00

It was a horrible week for me, because of a too critical task, i.e.LOCALIZATION

Finally i was able to do it :) :) :)

*** Added "ChanaApp.resx" to App_GlobalResources folder in [Port] folder
*** Added "ChanaApp.nl.resx" to same folder
*** Added a label to .ASPX page
*** Set the Expression of the label, set the TEXT property using "Resources"

*** If only one page we can use
protected override void InitializeCulture()
        {
            string[] languages = HttpContext.Current.Request.UserLanguages;
            string language = languages[0].ToLowerInvariant().Trim();

            string selectedLanguage = language;
            Thread.CurrentThread.CurrentCulture =
                CultureInfo.CreateSpecificCulture(selectedLanguage);
            Thread.CurrentThread.CurrentUICulture = new
                CultureInfo(selectedLanguage);
            base.InitializeCulture();
        }

*** If for total web application then we have to use
protected void Application_BeginRequest(object sender, EventArgs e)
        {
            string[] languages = HttpContext.Current.Request.UserLanguages;
            string language = languages[0].ToLowerInvariant().Trim();
            string selectedLanguage = language;
            Thread.CurrentThread.CurrentCulture =
                CultureInfo.CreateSpecificCulture(selectedLanguage);
            Thread.CurrentThread.CurrentUICulture = new
                CultureInfo(selectedLanguage);
        }
in GLOBAL.ASAX file.
*** Change the Culture of browser will change the TEXT in the label

Enable "Master Page" in a team site

2011-07-09T21:02:00.000-07:00

We cant see "Master Page" in Look and Feel section

Enable "Site Collection" feature

Enable "Site" feature

Now we can see "Master Page" under "Look and Feel" section

Download SharePoint 2010 Pre-Requisites

2011-06-27T02:24:00.000-07:00

Microsoft SQL Server 2008 Native Client	Download Here
Hotfix for Microsoft Windows (KB976462)	Download Here
Windows Identity Foundation (KB974405)	Download Here
Microsoft Sync Framework Runtime v1.0 (x64)	Download Here
Microsoft Chart Controls for Microsoft .NET Framework 3.5	Download Here
Microsoft Filter Pack 2.0	Download Here
Microsoft SQL Server 2008 Analysis Services ADOMD.NET	Download Here
Microsoft Server Speech Platform Runtime (x64)	Download Here
Microsoft Server Speech Recognition Language – TELE(en-US)	Download Here
SQL 2008 R2 Reporting Services SharePoint 2010 Add-in	Download Here

Microsoft Office 2010 Filter Packs for SharePoint

2011-06-27T02:21:00.000-07:00

The Microsoft Filter Pack is a single point-of-distribution for Office IFilters. IFilters are components that allow search services to index content of specific file types, letting you search for content in those files. They are intended for use with Microsoft Search Services (Sharepoint, SQL, Exchange, Windows Search).

The Filter Pack includes:

* Legacy Office Filter (97-2003; .doc, .ppt, .xls)
* Metro Office Filter (2007; .docx, .pptx, .xlsx)
* Zip Filter
* OneNote filter
* Visio Filter
* Publisher Filter
* Open Document Format Filter

SharePoint 2010 People Picker Programatically

2011-06-23T09:19:00.000-07:00

PeopleEditor peoplePick = new PeopleEditor();

        protected override void CreateChildControls()
        {

            peoplePick.AllowEmpty = false;
            peoplePick.AllowTypeIn = true;
            peoplePick.BrowseButtonImageName = "Search";
            peoplePick.CheckButtonImageName = "Validate User";
            peoplePick.ErrorMessage = "No Names Found";
            tdPeoplePicker.Controls.Add(peoplePick);
            //this.Controls.Add(peoplePick);
            base.CreateChildControls();
        }

    protected void btnSave_Click(object sender, EventArgs e)
        {
            foreach (string ent in peoplePick.CommaSeparatedAccounts.Split(','))
            {
                if (ent.Length > 0)
                {
                    PeerReviewGroup_Employee objPeerEmp = new PeerReviewGroup_Employee();
                    objPeerEmp.EmpID = Utility.GetNullableInt(GetSelectedUserIDsByName(ent));
                    objPeerEmp.GroupID = int.Parse(ddlPeerGroup.SelectedValue);

                    PeerReviewGroup_EmployeeService.Save(objPeerEmp);
                }
            }

        }

How to kill a remote session using command

2011-04-25T01:37:00.000-07:00

Step 1. Gain enough privilege to kill RDP connection on the server.
net use \\servername_or_IP /USER:username “password“

Step 2. List the connection to a particular server and get session ID.
query session /server: servername_or_IP

Step 3. Reset the session which you don’t need using ID of the session got from previous step

reset session [sessionID] /server:servername_or_IP

Configure Drop-off Library in SharePoint 2010

2011-04-11T04:37:00.000-07:00

Sometimes we need to have a common place to upload documents by a clerk & store data in correct data repository without his/her intervention. we can have a "Drop Off Library" and created "Rule", then documents will be stored relevant document library. we don't have to give permission for different users to upload documents to different libraries. It is with SharePoint 2010 :)

Finally we can see, the uploaded document is stored in "SDB Quotations" library. No copy is maintained in "Drop Off Library" . It is simple :)

SharePoint 2010 Recycle bin settings

2011-04-06T23:43:00.000-07:00

There are 2 types of recycle bin in SharePoint. Even user deletes an item it will be stored in "Recycle Bin" of admin's. We can set a time period to keep those files in Admin's recycle bin. We can give a quota to recycle bin of normal users as well as admins.

It is also possible to set maximum file size that can be stored in SharePoint. Since all data stored in DB, it is recommended to store medium size files in SharePoint.

Configuring SharePoint 2010 in a Farm environment for Development

2011-03-16T23:56:00.000-07:00

(1) Creating hyper-v machines

a. Create a hyper-V machine with Windows server 2008 R2

b. After installation is completed install service pack(s) if any

c. Go to à /Windows/System32 àSearch “sysprep.exe”

d. Run it and select “Shutdown options” in the dropdown

e. Get a copy of .vhd file & save it for future use as a BASE DISK

(2) Configure a new “AD server” using BASE DISK

(3) Create a new “SQL server” using BASE DISK

(4) Add “SQL server” to AD

(5) Configure SQL server 2008 R2 64 bit

a. Install it with native mode

b. Add “AD admin” user group when installing SQL

(6) Install latest service pack (if any)

(7) Create “SharePoint server” using BASE DISK

(8) Adding server to AD

(9) Check network configuration of ALL servers

a. All servers in 1 domain

b. IP address in static mode

c. DNS of servers match with IP of AD server IP

(10)Disable firewall in all servers before link each servers

(11)Install SharePoint foundation 2010 pre-requisites

a. Web Server (IIS) role

b. Application Server role

c. Microsoft .NET Framework version 3.5 SP1

d. SQL Server 2008 Express with SP1

e. Microsoft Sync Framework Runtime v1.0 (x64)

f. Microsoft Filter Pack 2.0

g. Microsoft Chart Controls for the Microsoft .NET Framework 3.5

h. Windows PowerShell 2.0

i. SQL Server 2008 Native Client

j. Microsoft SQL Server 2008 Analysis Services ADOMD.NET

k. ADO.NET Data Services Update for .NET Framework 3.5 SP1

l. A hotfix for the .NET Framework 3.5 SP1 that provides a method to support token authentication without transport security or message encryption in WCF.

m. Windows Identity Foundation (WIF)

(12)Run 10 step SharePoint technology wizard

(13)Install TFS

a. Use a domain admin account to install TFS

b. Use “Network Service” as service account when configure TFS

c. RAM in TFS server should be > 2 GB

d. Firewall should be disabled

(14)Accounts that used

a. SQL == ESPMS\admin

b. SharePoint install = ESPMS\administrator

c. SharePoint wizard == ESPMS\spfarmadmin

Complex LINQ query with outer joins and customized columns

2011-02-24T01:20:00.001-08:00

using (VonQuestDBDataContext context = new VonQuestDBDataContext())

{

var lines =

from P in context.VQPlayers

join T in context.VQPlayerTippings on P.VQPlayerID equals T.VQPlayerID into T_t

from T in T_t.DefaultIfEmpty()

join MT in context.MatchTeams on T.MatchTeamID equals MT.MatchTeamID into T_mt

from MT in T_mt.DefaultIfEmpty()

join G in context.VQGames on P.VQGameID equals G.VQGameID into T_g

from G in T_g.DefaultIfEmpty()

join Te in context.Teams on MT.TeamID equals Te.TeamID into T_te

from Te in T_te.DefaultIfEmpty()

join U in context.Users on P.UserID equals U.UserID into T_u

from U in T_u.DefaultIfEmpty()

join Mate in context.Matches on MT.MatchID equals Mate.MatchID into T_Mate

from Mate in T_Mate.DefaultIfEmpty()

join R in context.Rounds on Mate.RoundID equals R.RoundID into T_r

from R in T_r.DefaultIfEmpty()

where (G.VQGameID == vqGameID && R.RoundID==roundID

orderby P.VQPlayerID

select new { User = U.UserName, MatchID = Mate.MatchID == null ? "" : Mate.MatchID.ToString(), ChosenTeam = Te.TeamName == null ? "(NONE)" : Te.TeamName, };

dgvTippings.DataSource = lines;

dgvTippings.Columns[0].HeaderText = "User Name";

dgvTippings.Columns[1].HeaderText = "Match ID";

dgvTippings.Columns[2].HeaderText = "Chosen Team";

}

Change the query string values in C#

2011-02-21T00:21:00.000-08:00

// reflect to readonly property

PropertyInfo isreadonly = typeof(System.Collections.Specialized.NameValueCollection).GetProperty("IsReadOnly", BindingFlags.Instance | BindingFlags.NonPublic);

// make collection editable

isreadonly.SetValue(this.Request.QueryString, false, null);

this.Request.QueryString.Remove("playermode");

this.Request.QueryString.Add("playermode", "editinitialselection");

// make collection readonly again
isreadonly.SetValue(this.Request.QueryString, true, null);

Services in SharePoint 2010

2011-01-29T09:11:00.001-08:00

(1) Access services

(2) Business data connectivity

(3) Excel services application

(4) Search service application

(5) State service

(6) Usage & health data collection

(7) User profile service application

(8) Visio graphics service

(9) Web analytics service application

(10) Word automation service
The new services are in GREEN

Best Practices in SharePoint Development

2011-01-16T07:42:00.001-08:00

When user creates a Webpart the UserControl should be placed in ~/ControlTeamplates folder

To identify SharePoint content within VS 2010

Server Explorer à SharePoint Data Connections à Lists, Tasks, Calendar

To add a workflow feature

Template/1033/Workflows (can do using VS 2010 navigation)

After create a feature

Rename chanaka.wsp as chanaka.wsp.cab
Open as zip file
Check about automatically created,
1. Public key
2. Solution id
3. Feature id

When want to add Images to SharePoint portal

Right click on solution VS 2010 server explorer
Add à Sharepoint "Images" Mapped Folder
It will be placed in (14 hive) SharePoint root à TemplateàImages

When we add a SPI (SharePoint Project Item) it will creates (Eg:- A Webpart name as chanaka)

Element.xml (List ID, URL, Property Name, Webpart group)
Chanaka.webpart (Name / Description)
Chanaka.feature (Better to set Scope = "Site" )
1. New UI in VS 2010 to work with
  1. Manifest.xml
  2. Dependencies
  3. SPI View
2. Connect as a Event Receiver
  1. Right click on feature name in VS
  2. Add a Event Receiver
  3. Write the logic in one of event (Eg:- Feature Activated)

Visual Studio 2010 with SharePoint Development

2011-01-09T08:37:00.001-08:00

When talking about SharePoint 2007 with Visual Studio 2008 we had tedious process to do development in sharepoint.

No direct way to do "Debugging"

Had to attach W3WP.exe process manually

Had to copy images / usercontrols to 12 hive manually

Had to add safe control entries in web.config manually

But all & all now we have marriage of SharePoint 2010 with Visual studio 2010.

Specific SharePoint templates & SharePoint items
1. Project includes separate properties & assemblies sections same as normal VS project

Migration tools

SharePoint explorer (Also we can use "Mapped Folder" concept directly with 12 hive)

Direct debugging

One click deployment

Default (have to activate manually)
No activation

What it does when we press F5 (in a SharePoint project)

Builds a new assembly

Packages project into .WSP file

Deactivate/ Uninstall feature (if installed before)

Delete old .WSP file

IIS Reset

Deploy new .WSP file

Activate feature (Using site URL that we given when creating SharePoint project)

Attach debugger to W3WP.exe

Happy New Year 2011

2010-12-31T10:24:00.001-08:00

TFS build configuration

2010-12-14T23:08:00.000-08:00

First we have to install TFS build definition from TFS 2010 installer.
then,
If we try to create a new build using VS we will get following error since we have not configured it.

So, we have to log in to the TFS system
Then open TFS administration console

Stop TFS BUILD service

Set build service properties

Set Build service for TFS Project collection

New controller and new Agent

Create new build definition using VS

Configure Trigger time

Set build output location

If try to have a build, we will get following error,

We should give write permission for that folder in server.

Finally it Succeed.

Sharepoint Central administration 2010

2010-12-10T03:50:00.000-08:00

Central administration 2010 has been changed significantly. I got this image from one of main sharepoint site.

Create a textbox watermark using JQuery

2010-12-06T01:51:00.001-08:00

Importance of Web.Config file

2010-12-04T06:30:00.001-08:00

<?xml
version="1.0"?>

<configuration>

<appSettings>



<add
key="LogFilePath"
value="c:\logs\vonquest.web.log"/>

</appSettings>

<connectionStrings>



<add
name="ConnectionString"

connectionString="Data Source=88.88.88.888,555;Integrated Security=True;user=abc;password=abc123;Database=MyDatabase; Trusted_Connection=no"

providerName="System.Data.SqlClient" />

</connectionStrings>

<system.web>





<globalization
uiCulture="en"
culture="en-AU"/>

<compilation
debug="true"
targetFramework="4.0" />

<pages
theme="Default"
enableEventValidation="false"/>



<sessionState
mode="InProc"
timeout="20" />



<customErrors
mode="RemoteOnly"
defaultRedirect="~/Errors/GeneralError.aspx" ></customErrors>



<authentication
mode="Forms">

<forms
loginUrl="~/Default.aspx"
defaultUrl="~/Default.aspx" />

</authentication>



<authorization>

<deny
users="?"/>

</authorization>

</system.web>

<location
path="App_Themes">

<system.web>

<authorization>

<allow
users="*"/>

</authorization>

</system.web>

</location>

<location
path="Images">

<system.web>

<authorization>

<allow
users="*"/>

</authorization>

</system.web>

</location>

<location
path="Scripts">

<system.web>

<authorization>

<allow
users="*"/>

</authorization>

</system.web>

</location>

<location
path="favicon.ico">

<system.web>

<authorization>

<allow
users="*"/>

</authorization>

</system.web>

</location>



<location
path="Account/Register.aspx">

<system.web>

<authorization>

<allow
users="*"/>

</authorization>

</system.web>

</location>

<location
path="Errors/GeneralError.aspx">

<system.web>

<authorization>

<allow
users="*"/>

</authorization>

</system.web>

</location>

<location
path="ContactUs.aspx">

<system.web>

<authorization>

<allow
users="*"/>

</authorization>

</system.web>

</location>

<location
path="News.aspx">

<system.web>

<authorization>

<allow
users="*"/>

</authorization>

</system.web>

</location>



<system.serviceModel>

<bindings>

<netTcpBinding>

<binding
name="vqNetTcpBinding"
transferMode="Buffered"
listenBacklog="500"
maxBufferPoolSize="30000000"
maxBufferSize="30000000"
maxConnections="500"
maxReceivedMessageSize="30000000">

<readerQuotas
maxDepth="32"
maxStringContentLength="30000000"
maxArrayLength="30000000"
maxBytesPerRead="30000000"
maxNameTableCharCount="30000000" />

<reliableSession
inactivityTimeout="00:01:00"
enabled="true" />

<security
mode="None">

<transport
clientCredentialType="None">

</transport>

</security>

</binding>

</netTcpBinding>

</bindings>

<client>



<endpoint
name="NetTcpBinding_IUser"
address="net.tcp://localhost:6000/UserSvc"
binding="netTcpBinding"
bindingConfiguration="vqNetTcpBinding"
contract="VonQuest.Interface.IUser" />

<endpoint
name="NetTcpBinding_IGame"
address="net.tcp://localhost:6001/GameSvc"
binding="netTcpBinding"
bindingConfiguration="vqNetTcpBinding"
contract="VonQuest.Interface.IGame" />

<endpoint
name="NetTcpBinding_IUtility"
address="net.tcp://localhost:6002/UtilitySvc"
binding="netTcpBinding"
bindingConfiguration="vqNetTcpBinding"
contract="VonQuest.Interface.IUtility" />

</client>

</system.serviceModel>

<system.webServer>

<modules
runAllManagedModulesForAllRequests="true"/>

</system.webServer>

</configuration>

Usefull .NET code stuff

2010-11-11T21:23:00.000-08:00

Show only the short time in a grid
<%# String.Format("{0:g}", Eval("ShuffleTime")) %> eg:- 22/11/2010 3:39 PM

There are so many useful formats
<%# String.Format("{0:d}", Eval("ShuffleTime")) %> eg:- 22/11/2010

<%# String.Format("{0:G}", Eval("ShuffleTime")) %> eg:- 22/11/2010 3:39:55 PM

<%# String.Format("{0:M}", Eval("ShuffleTime")) %> eg:- November 22

<%# String.Format("{0:t}", Eval("ShuffleTime")) %> eg:- 11:05 AM

Bind a DataSet/DataTable directly to a DropDown

            DataSet dsUnitTypes = ((PageBase)(this.Page)).Services.Game.GetCodeValuesForCodeHeaderName("UnitType");
            ddlGameTypes.DataSource = dsUnitTypes.Tables[0];
            ddlGameTypes.DataTextField = "Description";
            ddlGameTypes.DataValueField = "CodeID";
            ddlGameTypes.DataBind();

Stored Procedure with two EXEC commands, row filtration & order with dynamic parameter

2010-10-06T23:40:00.001-07:00

ALTER
PROCEDURE [dbo].[ip_ListingSearch]

@State varchar(200),

@SalesRegionID int ,

@DistrictID int ,

@SuburbID varchar(200),

@bedrooms varchar(20),

@bathrooms varchar(20),

@carspaces varchar(20),

@EER decimal ,

@PropertyType varchar(200) ,

@DevelopmentName varchar(200),

@LandSize int ,

@HouseSize int ,

@ListingCategoryCodeID int ,

@ListingTypeCodeID int ,

@MinPrice int ,

@MaxPrice int ,

@ListingStartDate datetime ,

@ListingEndDate datetime ,

@OrderBy varchar(50)
,

@StartRow int
,

@EndRow int
,

@AdvanceQuery varchar(max)

SET
NOCOUNT
ON

DECLARE @rowTotal INT

--bedrooms

DECLARE @bedroomsSign varchar(1)

DECLARE @bedroomCount int

SET @bedroomsSign =
'='

SET @bedroomCount = 0

IF @bedrooms <>
''

BEGIN

SET @bedroomsSign =
SUBSTRING(@bedrooms,0,2)

SET @bedroomCount =
CAST(REPLACE(@bedrooms,'+','')
AS
INT)

END

--bathrooms

DECLARE @bathroomsSign varchar(1)

DECLARE @bathroomCount int

SET @bathroomsSign =
'='

SET @bathroomCount = 0

IF @bathrooms <>
''

BEGIN

SET @bathroomsSign =
SUBSTRING(@bathrooms,0,2)

SET @bathroomCount =
CAST(REPLACE(@bathrooms,'+','')
AS
INT)

END

--carspaces

DECLARE @carspacesSign varchar(1)

DECLARE @carspaceCount int

SET @carspacesSign =
'='

SET @carspaceCount = 0

IF @carspaces <>''

BEGIN

SET @carspacesSign =
SUBSTRING(@carspaces,0,2)

SET @carspaceCount =
CAST(REPLACE(@carspaces,'+','')
AS
INT)

END

DECLARE @AddressType int

SELECT @AddressType = tblCode.CodeID FROM tblCodeHeader INNER
JOIN

dbo.tblCode ON dbo.tblCode.CodeHeaderID = dbo.tblCodeHeader.CodeHeaderID

WHERE
(dbo.tblCodeHeader.CodeTable =
'AddressTypeProperty')
AND
(dbo.tblCode.CodeValue =
'Location')

DECLARE @ListingParticipantTyepe int

SELECT @ListingParticipantTyepe = dbo.tblCode.CodeID

FROM dbo.tblCodeHeader INNER
JOIN

dbo.tblCode ON dbo.tblCode.CodeHeaderID = dbo.tblCodeHeader.CodeHeaderID

WHERE
(dbo.tblCodeHeader.CodeTable =
'ListingParticipantType')
AND
(dbo.tblCode.CodeValue =
'LISTAGENT')

SELECT
DISTINCT

dbo.tblSLListing.ListingID, dbo.tblProperty.PropertyID, dbo.tblProperty.PropertyState, dbo.tblSLDistrict.SalesRegionID, dbo.tblSLDistrict.DistrictID,

dbo.tblSuburb.SuburbID, dbo.tblSuburb.PostCode, dbo.tblSLListing.Price, dbo.tblSLListing.ListingDate, dbo.tblSLListing.roomCount, dbo.tblSLListing.bathRoomCount,

dbo.tblSLListing.carSpaceCount, dbo.tblProperty.PropertyTypeCodeID AS PropertyType, dbo.tblSLListing.ObjectStateID, dbo.tblProperty.BlockNumber,

dbo.tblProperty.SectionNumber, dbo.tblProperty.UnitNumber,
ISNULL(dbo.tblAddress.StreetName,
'Address not found')
AS
Address, dbo.tblAddress.Suburb,

dbo.tblProperty.BlockSize, dbo.tblSLListing.EER, dbo.tblSLListing.Size AS HouseSize, dbo.tblSLListingLegalentity.LegalEntityID AS PrimarySalesPersonLLE,

dbo.tblPerson.PersonID AS PrimarySalesPersonID,
ISNULL(dbo.tblSLListing.EstablishedFlag, 0)
AS EstablishedFlag, tblListingCategory.CodeValue AS listingCategory,

dbo.tblSLListing.ListingCategoryCodeID,
ISNULL(dbo.tblPerson.FirstName,
'')
+
' '
+
ISNULL(dbo.tblPerson.LastName,
'')
AS ListingAgent,

COALESCE
(SettlementState.Description, SaleState.Description, dbo.tblSLObjectState.Description)
AS CurrentState, dbo.tblSLObjectState.Description AS ListingState,

dbo.tblSLObjectState.ObjectStateID AS ListingObjectStateID, SaleState.Description AS SaleState, SaleState.ObjectStateID AS SaleObjectStateID,

SettlementState.Description AS SettlementState, SettlementState.ObjectStateID AS SettlementObjectStateID, dbo.tblProperty.PropertyState AS
State,

ISNULL(dbo.tblBodyCorporate.Name, dbo.tblDevelopment.DevelopmentName)
AS DevelopmentName, dbo.tblSLListing.PriceRangeFrom,

dbo.tblSLListing.PriceRangeTo, dbo.tblSLListing.AuctionLocation, dbo.tblSLListing.AuctionTime, dbo.tblSLListing.TenderClosingDate,

dbo.tblSLListing.TenderDeliveryLocation, dbo.tblSLListing.ListingTypeCodeID, dbo.tblSLSale.SaleID

,tblSLListingAttribute.AttributeID,tblPropertyLegalEntity.LegalEntityID as vendor_LEID

into #tempListing

FROM dbo.tblSLListing INNER
JOIN

dbo.tblProperty ON dbo.tblProperty.PropertyID = dbo.tblSLListing.PropertyID

LEFT
OUTER
JOIN tblPropertyLegalEntity ON tblPropertyLegalEntity.PropertyID = tblSLListing.PropertyID

INNER
JOIN dbo.tblSLObjectState ON dbo.tblSLObjectState.ObjectStateID = dbo.tblSLListing.ObjectStateID INNER
JOIN

dbo.tblCode AS tblListingCategory ON tblListingCategory.CodeID = dbo.tblSLListing.ListingCategoryCodeID LEFT
OUTER
JOIN

dbo.tblDevelopment ON dbo.tblProperty.DevelopmentID = dbo.tblDevelopment.DevelopmentID LEFT
OUTER
JOIN

dbo.tblBodyCorporate ON dbo.tblBodyCorporate.BodyCorporateID = dbo.tblProperty.BodyCorporateID LEFT
OUTER
JOIN

dbo.tblAddress ON dbo.tblAddress.RelatedTable =
'tblProperty'
AND dbo.tblAddress.RelatedID = dbo.tblProperty.PropertyID AND

dbo.tblAddress.AddressTypeCodeID = @AddressType LEFT
OUTER
JOIN

dbo.tblSuburb ON dbo.tblSuburb.SuburbID = dbo.tblAddress.SuburbID LEFT
OUTER
JOIN

dbo.tblSLDistrict ON dbo.tblSLDistrict.DistrictID = dbo.tblSuburb.DistrictID LEFT
OUTER
JOIN

dbo.tblSLListingLegalentity ON dbo.tblSLListingLegalentity.ListingID = dbo.tblSLListing.ListingID AND

dbo.tblSLListingLegalentity.ListingParticipantTypeCodeID = @ListingParticipantTyepe

LEFT
OUTER
JOIN

dbo.tblPerson ON dbo.tblPerson.LegalEntityID = dbo.tblSLListingLegalentity.LegalEntityID LEFT
OUTER
JOIN

dbo.tblSLSale ON dbo.tblSLSale.ListingID = dbo.tblSLListing.ListingID LEFT
OUTER
JOIN

dbo.tblSLObjectState AS SaleState ON SaleState.ObjectStateID = dbo.tblSLSale.objectStateID LEFT
OUTER
JOIN

dbo.tblSLSettlement ON dbo.tblSLSettlement.SaleID = dbo.tblSLSale.SaleID LEFT
OUTER
JOIN

dbo.tblSLObjectState AS SettlementState ON SettlementState.ObjectStateID = dbo.tblSLSettlement.objectStateID

LEFT
OUTER
JOIN tblSLListingAttribute ON tblSLListingAttribute.RelatedObjectID = tblsllisting.ListingID

WHERE

tblProperty.PropertyState = @State

AND
(@SalesRegionID = 0 or tblSLDistrict.SalesRegionID = @SalesRegionID)

AND
(@districtID = 0 or tblSLDistrict.DistrictID = @DistrictID)

AND
(@SuburbID =
''
or tblSuburb.SuburbID in
(select orderID from splitCommaIDs(@SuburbID)))

AND
( @bedrooms =
''
OR
(@bedroomsSign ='+'
AND tblSLListing.roomCount >= @bedroomCount)
OR
(@bedroomsSign='='
AND tblSLListing.roomCount = @bedroomCount))

AND
( @bathrooms =
''
OR
(@bathroomsSign ='+'
AND tblSLListing.bathRoomCount >= @bathroomCount)
OR
(@bathroomsSign ='='
AND tblSLListing.bathRoomCount = @bathroomCount)
)

AND
( @carspaces =
''
OR
(@carspacesSign ='+'
AND tblSLListing.carSpaceCount >= @carspaceCount)
OR
(@carspacesSign ='='
AND tblSLListing.carSpaceCount = @carspaceCount))

AND
( @EER = 0 or tblSLListing.EER = @EER )

AND
(@PropertyType = 0 or tblProperty.PropertyTypeCodeID in
(select orderID from splitCommaIDs(@PropertyType)))

AND
(@HouseSize = 0 or tblSLListing.Size >= @HouseSize)

AND
(@LandSize = 0 or tblProperty.BlockSize >= @LandSize)

AND
(@MinPrice = 0 or tblSLListing.Price >
= @MinPrice)

AND
(@MaxPrice = 0 or tblSLListing.Price <= @MaxPrice)

AND
(@ListingStartDate =
''
or tblSLListing.ListingDate >= @ListingStartDate)

AND
(@ListingEndDate =
''
or tblSLListing.ListingDate <= @ListingEndDate)

AND
(@ListingCategoryCodeID = 0 or tblSLListing.ListingCategoryCodeID = @ListingCategoryCodeID )

DECLARE @RowCount as
int

select @RowCount =
count(ListingID)
from #tempListing

DECLARE @sQuery as
varchar(1000)

DECLARE @RowBeforeFilter as
int

--hack to find the row count------------------------------------

SET @sQuery =
'select listingid from #tempListing '
+ @AdvanceQuery

Create
table #test

(

listingid int

)

insert #test

exec(@sQuery)

select @rowTotal=count(*)
from #test

--------------------------------------------------------

SET @sQuery =
'select *,Row_Number() over (order by '
+@orderby +') as rowNumber from #tempListing '
+ @AdvanceQuery

declare @pagingQuery as
varchar(2000);

set @pagingQuery =
'with tblResult as ('
+ @sQuery +
') select tblResult.*, '+
convert(varchar(10),@rowTotal)+' as TotalRows from tblResult where tblResult.rowNumber > '
+
convert(varchar(10), @StartRow)
+
' and tblResult.rowNumber <= '
+
convert(varchar(10), @EndRow)
+
';'

exec(@pagingQuery)

drop
table #tempListing

drop
table #test

SQL Update query with inner join, Script to add table columns

2010-10-06T23:29:00.000-07:00

update tbladdress

set tbladdress.state=p.propertystate

from tbladdress as a

inner join tblproperty as p on a.relatedid=p.propertyid

where (a.state is null or a.state='')

and a.relatedtable='tblProperty'

and (p.propertystate is not null and p.propertystate <> '')

================================================================

ALTER TABLE SPORT
ADD CreatedDate     datetime,
CreateBy        int,
ModifiedDate     datetime,
Modifiedby      int

================================================================

Sharepoint 2010 New Features / Enhancements

2010-08-18T03:05:00.000-07:00

With Sharepoint 2010 we are getting few new features as well as many enhancements.
(1) Development & deployement enhancements
          Creation of Webparts using VS 2010
          Easy deployment of features

(2) Administration interface & user experience
          User friendly Central Admin Interface
          Ajax enabled pages
Modal Popup & less postbacks
Ribbon interface

(3) Performance management
          More templates
          Easy Search
          Easy SSP (Shared Services Providers)
          Database backup & restore
          Performance analyzing

Also we are getting new features in differen layers

Data Modules                 -- Data fetch from External Lists
Server API's                     -- LING
Connected Client API's   -- REST
Pages & UI              -- Silverlight

SQL Server Reporting Services Expressions

2010-08-12T03:18:00.000-07:00

Table Row Visibility by value
=iif(Fields!PctQuota.Value>.9, False, True)

Field Visibility when data is null
=iif(Fields!vendorSolicitor.Value Is Nothing, True, False)

Set Data Field Values
=iif(Fields!ExchangeDate.Value Is Nothing,"",FormatDateTime(Fields!ExchangeDate.Value ,2))

SWITCH
=Switch
(
Fields!PropertyCategory.Value="N" and sum(Fields!newHouseCount.Value) > 0, sum(Fields!newHouseCount.Value),
Fields!PropertyCategory.Value="E" and sum(Fields!estHouseCount.Value) > 0, sum(Fields!estHouseCount.Value)
)

Format date
=iif(Fields!ExchangeDate.Value Is Nothing,"",FormatDateTime(Fields!ExchangeDate.Value ,2))

Format Decimal values(Drop decimal places than rounding)
=FormatCurrency(Floor(Sum(Fields!ExpectedAgencyCommission.Value)),0)

Site Navigation using Tree View

2010-08-03T22:48:00.000-07:00

Drop Tree View Control Form Navigation Tab

Bind Data Source Type to Tree View (Add "Site Map" source)

Add New Item --> Add "SiteMap" from VS templates (extension will be test.sitemap)

Add pages and title of pages to show on Tree View in "test.sitemap"

Sharepoint 2010 Web Analytics

2010-07-14T03:52:00.001-07:00

Site settings--> Site Actions--> Site Web Analytics reports

Top bar --> Change Settings

Analyze --> Preceding 7 /30 days

Left panel --> Top Pages

Left panel --> Top visitors

Left panel --> Top Browsers

TFS Burndown report does not show data - Solution

2010-07-08T02:00:00.001-07:00

Burndown report show empty data

Open Report in Excel in Edit Mode, Allow Data populate set as "trust data connection" in excel

Click on the pivot table data area, then see right side column, see that "Row Labels" box is empty

Drag & drop "Last 4 weeks" from Date--> Sets --> "Last 4 weeks"
Row Labels (This box use to show horizontal bar information in your graph)

Then Save the excel sheet. You will get data in your Burndown report when you refresh your page. J

Sharepoint backup script

2010-06-13T23:57:00.000-07:00

(1) Open notepad

(2) type following command

@echo

echo Back up the farm to "Optimus\Share"

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

For /F "tokens=1,2,3 delims=/ " %%A in ('Date /t') do (

Set Day=%%A

Set Month=%%B

Set Year=%%C

Set todayDate=%%C%%B%%A

)
set WORKINGFOLDER="C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN"
pushd "%WORKINGFOLDER:"=%"

cd C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN

echo Starting Backup ========================

stsadm -o backup -url http://optimus:3333 -filename \\Optimus\Share\SharepointPortalBackup_%todayDate%.bak -overwrite

pause

(3) Save the file as .bat or .cmd
(4) Run & test (This will create a backup with the date (SharepointPortalBackup_1406Mon.bak) )
(5) Add a "Task Scheduler" in server

:) :) :) Simple

Sharepoint Central Administration WebSite Not Working - Solution

2010-06-13T23:30:00.000-07:00

It was a nightmare when we lost central administration website.

All other websites worked fine.
When we click "Central Administration 2010" we got only,

We had to use command to get this up & running
(1) Run Command prompt
(2) cd C:\Program Files\Common Files\Microsoft Shared\W
eb Server Extensions\14\BIN
(3) C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN>
Psconfig -cmd adminvs -provision -port 33633 -windowsauthprovider onlyusentlm
Here 33633 = Port number of central administration website

It takes little time & finally you will get your your central admin site :)

Easy Work now :) :) :)

Search in Sharepoint 2010 - New features

2010-06-08T02:47:00.000-07:00

So it is time to have a look on search function that comes with sharepoint 2010.

With the sharepoint 2007 we had little work to get our search function done. (create a Search site, SSP configuration & crawling rule)

But now it is really simple.
It has additional functions that help user very much.

SEARCH(find_text,within_text,start_num)

Find_text is the text you want to find. You can use the wildcard characters — question mark (?) and asterisk (*) in find_text. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.

Within_text is the text in which you want to search for find_text.

Start_num is the character number in within_text at which you want to start searching. Use start_num to skip a specified number of characters.
For example, suppose you are working with the text string "AYF0093.YoungMensApparel". To find the number of the first "Y" in the descriptive part of the text string, set start_num equal to 8 so that the serial-number portion of the text is not searched. SEARCH begins with character 8, finds find_text at the next character, and returns the number 9. SEARCH always returns the number of characters from the start of within_text, counting the characters you skip if start_num is greater than 1.

Special Points in Search of Sharepoint 2010

1. SEARCH does not distinguish between uppercase and lowercase letters when searching text.
2. SEARCH is similar to FIND except that FIND is case sensitive.
3. If find_text is not found, the #VALUE! error value is returned.
4. If start_num is omitted, it is assumed to be 1.
5. If start_num is not greater than 0 (zero) or is greater than the length of within_text, the #VALUE! error value is returned.

there are 3 types of search on SharePoint 2010
* Boolean Search
you can use AND, NOT and OR in your search queries. Be mindful though that you need to use capitals, otherwise they will considered additional search words.

* Wildcard Search
Search queries can now match a wildcard at the end of a text string.

* Faceted Search
When a search query returns a lot of results the faceted search functionality displays a refinement panel on the left side of the screen. In the panel you can refine the results based on criteria like Result type, Site, Author, Modified Date and Tags. What refinement possibilities are shown depends on the result set. Administrators can also configure other the categories that are used in the refinement panel based on managed properties and enterprise content management taxonomy nodes.

Finally we can add our portal as a "search connector to windows", that means it will search web url when we want to search a document :) :) :) :)

Recover Sharepoint Documents from backedup DB

2010-06-04T03:01:00.000-07:00

We have lost our sharepoint portal + all other data bases.
Then we had to get data from our backup DB.
To get this data i have written a application.
It gets all files other than images (sharepoint) & unwanted files.
This also create folder structure according to portal.

Simple application :) :) :) :)

Download Direct Application

Download App through megashare

Tfs Backup Restore

2010-06-04T02:00:00.000-07:00

(1) Backup all TFS Databases to physical location (D:\TfsBackups)

(2) Restore all the databases to TFS2010’s instance of SQL Server

(3) Run following command in cmd as administrator
C:\Program Files\Microsoft Team Foundation Server 2010\Tools>TFSConfig RemapDBs
/DatabaseName:Testsvr;Tfs_configuration /SQLInstances:testsvr /continue
(Continue is really important, if fails first time then run it again)

(3) Install Team Foundation Server 2010

(4) After the install has completed the Team Foundation Server Configuration Wizard will open
Select Upgrade | Start Wizard

(If you run Basic/Standard/Advance option other than Upgrade, you will get following error)

(5) Now you can go to "team foundation administration console"
You will see all your team collections

(6) Finally connects to the Team Server through Team Explorer

:) :) :) :)

Upgrade from TFS 2010 RC to RTM

2010-05-21T02:16:00.001-07:00

TFS Upgrade Summary Steps

1. Ensure you have a backup of existing SQL databases (TFS, SharePoint and Reporting)
2. Uninstall Team Foundation Server 2010 Beta2/RC components (in-place upgrade)
• Use Add/Remove programs from Control Panel to uninstall TFS Components via "Microsoft Team Foundation Server 2010"
• Select "Uninstall" to remove all TFS components from each server where Beta2/RC is installed
• NOTE: You may see a program in the Control Panel called "Microsoft Team Foundation Server 2010 Object Model". This is an object model used by products connecting to TFS (e.g. Visual Studio and Team Lab). This component will be uninstalled or updated by the installation program for those products. You should not uninstall this component during the TFS 2010 upgrade process.

3. If using a separate SharePoint farm uninstall TFS 2010 Beta2/RC extensions and install TFS 2010 RTM extensions.
4. Run the TFS 2010 setup and select the Upgrade from Previous Version Wizard and complete the wizard.

Celebrating 2 years as a software engineer

2010-05-04T05:14:00.000-07:00

It's the time to celebrate something in this life.
Work on irregular hours, weekends & night time took me to 2 years in this long career life.

When turn back of last 2 years
I was a guru in sharepoint.
Did well in WF,Reporting & TFS.
Touch areas like Infopath,Webservices & Remoting.

Hope to work on WCF,Silverlight in coming year.
It is always good to remind that i helped a lot to others &
make good contact with Gurus like prasanna,joy,dinesh,prabath,buddhima.

Did well in free lance projects on sharepoint & got big reputation.

So it was a hard working 2 years with great commitment.
Hope to do something different in future. :)

"It is better to be the first in the loosing team than the last in the winning team".

How to delete a TFS task

2010-03-25T04:22:00.000-07:00

Sometimes we want to delete task that we have added to TFS
But there is a no way to delete using a UI.

we have to use command promt

cd C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE or
cd C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE
then type follwing command

witadmin.exe destroywi /Collection:http:\\Optimus:8080\tfs\IPG /id:9
Collection == Team Project collection url
Id == ID that is generated by TFS

Simple as a UI click :)

Additional Details
Most of the people are not getting this witadmin.exe
So i have uploaded it. Download WITADMIN.EXE

Get query string parameters using a Java Script

2010-03-24T01:00:00.000-07:00

function getQuerystring(key, default_) {
if (default_ == null) default_ = "";
key = key.replace(/[\[]/, "\\\[").replace(/[\]]/, "\\\]");
var regex = new RegExp("[\\?&]" + key + "=([^&#]*)");
var qs = regex.exec(window.location.href);
if (qs == null)
return default_;
else
return qs[1];
}

//Call the function
var CategoryID = getQuerystring('CategoryIDs');

Change time format inside SharePoint

2010-03-23T03:10:00.000-07:00

When we want to change the time format that display in sharepoint calendar,

We have to go to Site settings --> regional settings

After change the time format we can see our calendar in 24 hour time format.

Why TFS portal webparts throwing an error - [Solution]

2010-03-17T22:27:00.000-07:00

When we have configured sharepoint webportal for TFS, sometimes is throws an error when displaying "Project Dashboard" & "My Dashboard", all webparts displaying as missing components.

This is because, we have lost all webparts (basically dll's that renders webparts).
What we have to do is,
(1) Central administration --> Operations --> Solution management --> tswawebpartcollection.wsp --> DEPLOY

(2) Central administration --> Application Management --> Manage Web Application Features --> Visual Studio Team Foundation Server Configuration --> ACTIVATE

Now refresh your page :)

SQL Inner Query to get data without a cursor

2010-02-24T05:01:00.001-08:00

ProductCode	MinimumLevel	Bonus
1	5	2
1	10	3
1	20	5
2	5	2
3	8	2
3	12	3

SQL Query

select p.ProductCode,

p.MinimumLevel,

(select
top 1 q.MinimumLevel from ProductTable q where q.MinimumLevel > p.MinimumLevel and q.ProductCode = p.ProductCode)
as MaximumLevel,

p.Bonus

from ProductTable p

ProductCode	MinimumLevel	MaximumLevel	Bonus
1	5	10	2
1	10	20	3
1	20	NULL	5
2	5	NULL	2
3	8	12	2
3	12	NULL	3

TFS 2010 error when creating team project

2010-02-17T20:13:00.000-08:00

This error raised, when the TFS versions are mismatch. That is TFS server version & the TFS Client (Team Explorer).

We had to uninstall previous version of "Team Explorer" & install new version.
(In my case had to uninstall TFS 2010 beta & install TFS 2010 RC)
Then it starts work fine.
Cheers...

Tax Calculation In Srilanka

2010-02-15T21:45:00.001-08:00

Summarized Tax Table - Regular Profits from Employment

Monthly remuneration Tax in SriLanka

1. Monthly remuneration up to Rs. 27,184 - Exempt

2. Monthly remuneration exceeding Rs. 27,184 but not exceeding Rs. 63,406

4.6% of monthly remuneration less Rs. 1,250

3. Monthly remuneration exceeding Rs. 63,406 but not exceeding Rs. 78,125

9.2% of monthly remuneration less Rs. 4,167

4. Monthly remuneration exceeding Rs. 78,125 but not exceeding Rs. 97,917
10% of monthly remuneration less Rs. 4,792

5. Monthly remuneration exceeding Rs. 97,917 but not exceeding Rs. 131,250
15% of monthly remuneration less Rs. 9,687

6. Monthly remuneration exceeding Rs. 131,250 but not exceeding Rs. 172,917
20% of monthly remuneration less Rs. 16,250

7. Monthly remuneration exceeding Rs. 172,917 but not exceeding Rs. 214,584
25% of monthly remuneration less Rs. 24,896

8. Monthly remuneration exceeding Rs. 214,584 but not exceeding Rs. 256,250
30% of monthly remuneration less Rs. 35,625

9. Monthly remuneration exceeding Rs. 256,250

35% of monthly remuneration less Rs. 48,437

String Split in SQL

2010-02-02T02:57:00.000-08:00

Declare @checkedItems varchar(20)

SET @checkedItems ='N,L,D,E'

Declare
@ParsedList table
(
OrderID varchar
)

DECLARE @OrderID varchar(10), @Pos int

SET @checkedItems = LTRIM(RTRIM(@checkedItems))+ ','
SET @Pos = CHARINDEX(',', @checkedItems, 1)

IF REPLACE(@checkedItems, ',', '') <> ''
BEGIN
WHILE @Pos > 0
BEGIN
SET @OrderID = LTRIM(RTRIM(LEFT(@checkedItems, @Pos - 1)))
IF @OrderID <> ''
BEGIN
INSERT INTO @ParsedList (OrderID)
VALUES (CAST(@OrderID AS varchar)) --Use Appropriate conversion
END
SET @checkedItems = RIGHT(@checkedItems, LEN(@checkedItems) - @Pos)
SET @Pos = CHARINDEX(',', @checkedItems, 1)

END
END

select * from @ParsedList

====================================
OUTPUT
====================================
OrderID
N
L
D
E

How to work with TFS tools

2010-01-17T22:27:00.000-08:00

With TFS 2010 we are getting some OOB tools.

But if we want
(1) Process Template Editor
(2) Check-In Policy Pack
(3) Work Item Templates we have to install TFS Power Tools.

But with beta 2 of TFS we cant open OOB tools like
(1) TFSConfig
(2) TFSSecurity
(3) TrxUpgrader

Then we have to
(1) Open Command Promt
(2) Cd C:\Program Files\Microsoft Team Foundation Server 2010\Tools
(3) type TFSConfig ConfigureMail /FromEmailAddress:chanaka@abc.com /SmtpHost:smtp.abc.com
(here the TFSConfig is the name of tool, rest is the command to configure email settings)

The following command can be used to identify TFS user information
tfssecurity /server: /i MYDOMAIN\MYNAME

===================================================
Also we can have WSS(Sharepoint) in our machine @any time by clicking

TFS 2010 Build automation (Solve the error)

2010-01-17T21:11:00.000-08:00

(Set the Build Platform)

(1) Change the Platform to X64 (or X86) - Depend on your build server platform
(2) Check the Permission for TFSBuildServiceHost (Don't give network service account, give administrator account )
(3) Start/Restart TFSBuildServiceHost

(4)Set the Share location to get build files @ Server

TFS Configuration Basics

2010-01-11T22:45:00.001-08:00

Installing
- Upgrade Breaks Links on the SharePoint Products and Technology Portal
- Some Visual Studio Team System 2010 Features Not Available After Upgrade
- Initial Configuration of Team Foundation Server Should be Run From MSI Program or by Command Line
Uninstalling
- Need to uninstall TFS Object Model before uninstalling VSTS if installed from the web
Product Issues
- Managing Users on Upgraded Team Projects Might Result in Error TF50620
- Cannot Install Team Foundation Build Service on Windows XP
- Require SSL Option Not Supported
- No Work Item Only View feature in Team System Web Access
- You Can Only Associate a Single URL with a Team Project in Team Explorer
- Team Foundation Server Service Account must be different then the account used for installing Team Foundation Server
- Uninstall Team Explorer Does Not Remove Visual Studio Shell
- Installing Team Foundation Server on a Windows Domain Requires a Live Connection to the Domain Controller
- Team Foundation Server Name May Not Be Over 14 Characters
- Do Not Launch Teamfoundation.msc Directly or Add to Microsoft Management Console (MMC)
- Changes to Lab Management Network Location Tab Requires an IIS Reset
Converters
- VSSConverter.exe Not Supported
Office Integration
- Office Integration Requires Manual Installation of Office Primary Interop Assemblies (PIA) on Windows XP
- Visual Studio Team System 2010 Installation Program Appears After You Launch Microsoft Project
Process Templates and Team Project Portal
- No Process Guidance Updates
- Capability Maturity Model Integration (CMMI) 5.0 Process Template Incomplete
- Remote Portal Running as Network Service Can Cause Broken Dashboards
Reporting
- Team Foundation Server Stops Collecting Reporting Data from the Team Project Collection
- Team Foundation Server Reports Are Out-of-date After Install/Upgrade
- Team Foundation Server Data Warehouse Custom Adapters Do Not Work
Test Integration
- No Test Steps, Repro Steps or Associated Automation Controls in Team System Web Access
Compatibility
- Team Explorer 2008 or older client users can create new build definitions but they will not be able to edit them or to edit other, existing build definitions.
- Team Explorer 2008 or older clients will be able to submit changes that affect gated build definitions, but they will not be prompted with the confirmation dialog and, if their check-in affects multiple gated definitions, it will fail.
- Team Explorer 2008 or older clients will not be able to manage build resources using the "Manage Build Agents" dialog box.
- Microsoft Project plan documents created using a Team Explorer 2010 client, break when opened from a Team Explorer 2008 or older client.
- Navigation to non-default Shared Document, Project Portal and Process Guidance locations is broken for a Team Explorer 2008 SP1 or older clients.
- Navigation to new Reports is not supported for a Team Explorer 2008 SP1 or older clients.
- Work Item Tracking Queries with new functionality are not supported for a Team Explorer 2008 SP1 or older clients.
- Rename in Version Control is not supported for Team Explorer 2008 SP1 or older clients.
- Test Results Publishing is not supported for a Team Explorer 2008 SP1 or older clients.
- How to connect to Team Explorer 2010 to Team Foundation Server 2008
- How to connect a Team Explorer 2008 SP1 to a Team Foundation Server 2010 Server
- Team Foundation Server 2010 administrative functions are only supported using Team Explorer 2010.

Source: - http://blogs.msdn.com/granth

What is Cloaking in TFS

2010-01-08T01:44:00.001-08:00

Cloaking

You can use cloaking as a performance optimization when you want to prevent a part of the source control tree from being retrieved. The following are typical scenarios for using cloaking:

• You want to build the project locally and a folder is not needed for the build, for example a documentation folder.

• You are part of a large team project and you only want to retrieve part of the project.

For either of the above scenarios you can cloak folders to stop the client retrieving those folders. You cloak folders on the client by editing the workspace and changing the status of the working folder from active to cloak.

Recommendations

• Do not cloak individual files. This is likely lead to maintenance problems later in the project.

• For a large project, map out the root folder and cloak sub folders rather than creating multiple workspaces for the project.

Source: - TFSGuide

What we can do using TFS

2010-01-06T03:48:00.000-08:00

We can do all in ALM (Application LifeCycle Management)

1. Source Control
2. Build automation
3. sharepoint integration
4. Process integation (Agile/CMMI)
5. Bug tracking
6. Reporting
7. Testing

TFS include management of
1. Task
2. Bug
3. Issue
4. Change Request
5. Requirement gathering
6. Review
7. Risk
8. Test case

Install TFS 2010

2010-01-06T01:48:00.000-08:00

New Year(2010) starts with a new technology.

Prerequisites
1. IIS 6.0 or above
2. SQL Server
3. Windows Sharepoint Services

Important notes
1. Never use a domain account to install TFS
2. Remeber to run sharepoint technology wizard before all

Installation
Run the "setup.exe"
1. Install TFS
2. Extensions for sharepoint
3. Team foundation server proxy
4. Build service

Install "TeamExplorer" into a client machine that is coming with TFS package
This is where we can do all things related to Application LifeCycle Management (ALM)

BlackBox testing Vs. WhiteBox testing

2009-12-20T20:32:00.001-08:00

White box testing refers to testing that works with the application's internals (or code). White box (or glass box) testing is typically done by developers using the IDE, debugger, and unit tests. This is going into the deep of logic & verifies the function.

Integration testing is considered functional, or black box, testing. Testers write test cases that indicate a given input into the application. Based on this input, they make assumptions about the output of the application. The testers then execute these integration tests as a black box. That is, they do not care about what happens inside the box (the code); they simply care that they get the expected results based on the given input.

Source:- 70-547 training kit book

Testing Our Code (As a Developer I Should)

2009-12-18T03:01:00.001-08:00

Rules

Success baseline Start by defining a unit test that represents a common, successful path through your code. This test should represent the most likely scenario for executing your code.

Parameter mix Create a unit test that provides a varied mixture of parameters for a given method. This will ensure that more than just the success path works effectively. Consider creating this scenario as a data-driven unit test.

Bounds checking Create one or more unit tests that test the upper and lower limits of your code. That is, if your method takes a numeric value, you will want to test that method with values that represent both the upper and lower range of the data type.

Null values Make sure your unit tests measure what happens when null values are passed to a given method or property.

Error conditions Create unit tests that trigger error conditions in your code. You can tell the unit test that you expect a certain error as a result. If that error is not thrown, then the test will fail.

Code coverage scenarios Make sure that all the code in your method is called by one or more unit tests. You do not want untested code sitting inside of conditional statements. If this happens, write tests that hit those conditions inside your application code.

Best Practices

Write one test for each scenario you should test each outcome or scenario independently. If your method has a number of expected outcomes, write a test for each scenario.
Create atomic unit tests your unit tests should not require others tests (or a sequence of tests) to be run prior to their execution or as part of their execution.
Cover all conditions your unit tests should cover all cases. An effective set of unit tests covers every possible condition for a given method, including bounds checks, null values, exceptions, and conditional logic.
Run without configuration your unit tests should be easy to run (and rerun). They should not require setup or configuration. You do not want to define tests that require a specific environment every time you run your tests (or they will not be run). If setup is required, code that into a test-initialize script.
Test a common application state your unit tests should be run against a common, standard, good state. For example, if your application works with data, this data should be set to common state prior to the execution of each unit test. This ensures that one test is not causing an error in another test.

Source:- 70-547 training kit book

Sending Email Using Web.Config Entries in .NET

2009-12-18T00:31:00.001-08:00

// Web.Config sample

<system.net>

</smtp>

</mailSettings>

</system.net>

</configuration>

// Code sample

using System.Net.Mail;

MailSettingsSectionGroup mailSettings = WebConfigurationManager.GetSection("system.net/

mailSettings") as MailSettingsSectionGroup;

protected void SendingEmail()

{

// Sending E-Mail

MailMessage message = new MailMessage(mailSettings.Smtp.From, WebConfigurationManager.AppSettings["RecipientList"], "Sending E-mail using web.config", "");

message.Priority = MailPriority.High;

SmtpClient smtp = new SmtpClient(mailSettings.Smtp.Network.Host);

smtp.Send(message);

}

Multi-tier Architecture in application development

2009-12-07T02:44:00.001-08:00

We can categorize our n- tier architecture into 3 sections

User Interface
Presentation
User interface code
Business logic interaction code
Middle Layer
Business layer
Application layer
Database layer (This layer abstracts the retrieval and storage of data in your database)
Database Layer
Database layer
Stored procedures
Integration services
Database tables, logs & indexes

Reference:-

MCPD (70-547) Designing and Developing Web-Based Applications Using the .NET Framework