How to configure PDF iFilter for SharePoint Server 2010 or Search Server 2010

For one of my requirement used the below url for configuring iFilter for SharePoint 2010.

Search / Find using Excel formulas

There are couple of functions (Search and Find) which we can use to search the string in a Excel cell.

The main difference between Search and Find is Search is  not a case sensitive.

If the Find/Search fails to find the given input string  it will update with an error #VALUE other wise it returns the index of the string.



=ISERR(FIND("Find String","Its there in this Find String",1))
=ISERR(SEARCH("Find String","Its there in this Find String",1)) 

Debugging the Network traffic(Testing whether the HTTP headers going fine or not?)

I was trying to debug the outgoing request headers whether the Accept-Encoding flag is set or not. One way to do that is setting up a proxy server and diverting all the web traffic through that proxy channel. But i don't want to set a proxy server.

After searching in google I found the following tool, its called fiddler, which will display all the web trafic in a details format.

I found it very helpful.

Video: http://www.fiddler2.com/fiddler/help/video/FiddlerQuickStart.wmv
Download link: http://www.fiddler2.com/fiddler2/version.asp

Simple command to move all the out put dlls to a specific target

I have been trying to automate the process 'Build sln file and copy all the latest dlls to a specific output folder other than /bin/Debug or /bin/Relase' (Similar to RiskSpan N:\ContinuousBuild). But the problem there was we need the CrusiseControl running continously.

The following command made my life easy to recompile all the projects associated with the sln file and copy to specified output folder (in this case  C:\Users\Anumolu\Desktop\ContinousBuild\).

use VS cmd prompt and goto the project folder where the .sln file is located and run the following command with modified out put folder path.

msbuild   /property:WarningLevel=2;OutDir=C:\Users\Anumolu\Desktop\ContinousBuild\

Editing Page in SharePoint Designer 2010 with Advance Mode

I have tried to edit a page and got a code that was marked in yellow. In addition, the Ribbon was missing some of the tabs. I was unable to edit the code on the page.

Solution:Click on “Advance Mode” button that is located on the Ribbon.
Once you have clicked it, you’ll see the other tabs and you will be able to edit the page.

Yeshwant kanetkar articles

Wn ever i need C# fundamentals i would prefer Yeshwant kanetkar's C# Fundas book. The following link has few articles published by Yeshwant kanetkar.

Yeshwant kanetkar C# Articles

EXCEL- INDIRECT() function

INDIRECT() saves my time, particularly when we want to pull some data from dynamic sheets(Sheet names are defined in a cell value).

I was trying to VLOOKUP some data from a dynamic sheet (sheet name was defined in column A).
In the following eg A2592 has the sheet name and A7:I413 is the vlookup range in the dynamic range.

=VLOOKUP(C2592,INDIRECT("'"&$A2592&"'!$A$7:$I$413"),2)


More details about INDIRECT -

 In Microsoft Excel, the INDIRECT worksheet function returns the contents of the specified reference and displays its contents. You can use the INDIRECT worksheet function to create linked references to other workbooks. You can reference each attribute of the reference (workbook name, worksheet name, and cell reference) individually by using the INDIRECT function to create a user-defined dynamic reference with worksheet cell references as inputs.

 Note The INDIRECT function only returns the result of a reference to an open file. If a workbook that the INDIRECT function is indirectly referencing is closed, the function returns a #REF! error.

To create a reference to a workbook using three different cell inputs as references for the workbook, worksheet, and cell link, follow the steps in the following examples.

Example 1

1. Start Excel.
2. In Book1, Sheet1, cell A1 type This is a test.
3. In Microsoft Office Excel 2003 and in earlier versions of Excel, click New on the File menu, click Workbook, and then click OK.
   
   In Microsoft Office Excel 2007, click the Microsoft Office Button, click New, and then click Create.
4. In Book2, Sheet1, cell A1 type Book1.
5. In Book2, Sheet1, cell A2 type Sheet1.
6. In Book2, Sheet1, cell A3 type A1.
7. Save both workbooks.
8. In Excel 2003 and in earlier versions of Excel, type the following formula in Book2, Sheet1, cell B1:
   =INDIRECT("'["&A1&".xls]"&A2&"'!"&A3)
   In Excel 2007, type the following formula:
   =INDIRECT("'["&A1&".xlsx]"&A2&"'!"&A3)
   The formula returns "This is a test."

Example 2

In Excel 2003 and in earlier versions of Excel, you can replace the formula in Example 1 with multiple INDIRECT statements, as in the following formula:

=INDIRECT("'["&INDIRECT("A1")&".xls]"&INDIRECT("A2")&"'!"&INDIRECT("A3"))

 In Excel 2007 and Excel 2010, type the following formula:

=INDIRECT("'["&INDIRECT("A1")&".xlsx]"&INDIRECT("A2")&"'!"&INDIRECT("A3"))

Note the difference in how Excel references the cells. Example 1 references cells A1, A2, and A3 without using quotation marks, while Example 2 references the cells using quotation marks around the references.

The INDIRECT function references cells without using quotation marks. This function evaluates the result of the cell reference. For example, if cell A1 contains the text "B1," and B1 contains the word "TEST," the formula =INDIRECT(A1) returns the result "TEST."

However, referencing a cell with quotation marks returns the result of the cell contents. In the example in the previous sentence, the formula returns the text string "B1" instead of the contents of cell B1.