Monday, November 3, 2014

CruiseControl issue while building with VS 2013 MSBuild

Looks like Microsoft has included MSBuild along with Visual studio 2013, hence building Cruise control with old MSBuild path may not work.

Cruise Control has to point to the following new MSBuild path
New:
C:\Program Files\MSBuild\12.0\Bin\MSBuild.exe
Old:
C:\Windows\Microsoft.NET\Framework\v4.0.30319\MSBuild.exe
 

Otherwise the following errors will thrown when you build from command prompt

CLICK ONCE ERROR: “An error occurred while signing: Failed to sign bin\Debug\app.publish\\setup.exe. SignTool Error”

 error MSB3147: Could not find required file 'setup.bin'
 

Monday, September 9, 2013

Excel Sheet Name inside the Cell

How to get and print the active sheet name inside a cell?

There is no direct way to access the sheet name, but you can get the file name and parse the file name field to get the active sheet.

=RIGHT(CELL("filename"),LEN(CELL("filename"))- FIND("]",CELL("filename"),1))

Monday, October 10, 2011

Wednesday, September 14, 2011

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


Thursday, June 9, 2011

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

Thursday, June 2, 2011

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\

Monday, May 30, 2011

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.