Archive for category Other

Single Sign on in Firefox

Posted by allenkwc in Other on January 13, 2015

 

  • In the address bar of Firefox, type about:config to display the list of current configuration options.
  • In the Filter field, type negotiate to restrict the list of options.
  • Double-click the network.negotiate-auth.trusted-uris entry to display the Enter string value dialog box.
  • Enter the name of the domain against which you want to authenticate, for example, .example.com.
  • Repeat the above procedure for the network.negotiate-auth.delegation-uris entry, using the same domain.

 

No Comments

Count Distinct in Excel 2010 or earlier

Posted by allenkwc in Other on May 30, 2014

=IF(COUNTIFS($A$4:A41,A41,$B$4:B41,B41)>1,0,1)

 

Where $A$4 is the first row of the value, A41 is the current row of record…

 

There is already a count distinct function built in Excel 2013

No Comments

Good Web Downloader

Posted by allenkwc in Other on May 25, 2011

http://www.mipony.net/

No Comments

Batch script for converting files using FFMpeg

Posted by allenkwc in Other on May 18, 2010

for /f %%f in (‘dir /b input’) do ffmpeg -i “./input/%%f” -vcodec libx264 -vpre “./ffpresets/libx264-max.ffpreset” “./output/%%f.mp4”
pause

No Comments

Check what port an application is using

Posted by allenkwc in Other, Technology on January 19, 2009

There are a couple of applications that may fail to start and complaint because its port is being used by a different application. This is a quick and dirty way of knowing which application is responsible for tying up a port on a Windows box.

Open up a command prompt:

  1. Start | Run | type cmd | Enter
  2. Type netstat -aon | findstr “[port number]“
  3. Take note of the numbers on the last line. This is the PID or Process ID.
  4. Type tasklist | findstr “[PID]“ and this will return the application corresponding to that PID.
  5. Once PID is determined, you can now kill it in Task Manager or kill it typing tskill at the command prompt.

ports1.JPG

For example:

  1. I type netstat -aon | findstr “8080″ at command prompt (I’m on a proxy by the way)
  2. I see that the PID is 3624
  3. I type tasklist | findstr “3624″ to find what PID 3624 is and it points to msnmsgr.exe which is MSN/Live Messenger.
  4. I can now kill MSN Messenger from Task Manager or type tskill 3624

No Comments

Restore the deleted files in SubVersion

Posted by allenkwc in Other, Technology on November 19, 2008

Suppose the folder URL was:

url://server/repos/project/folder

And it was deleted in r100. Then to get it back, run this command:

svn copy -r99 -m “Restore folder” url://server/repos/project/folder url://server/repos/project/folder

If you get an error, add “@99” to the end of the first URL.

,

No Comments

Self Signing SSL for IIS

Posted by allenkwc in Other, Technology on September 9, 2008

http://geekswithblogs.net/jimiz/archive/2007/02/11/106006.aspx

self-signing-ssl-for-iis

No Comments

Auto Logon to Windows XP

Posted by allenkwc in Other on August 31, 2008

Auto Logon to Windows XP

Published: March 18, 2002

Submitted by Doug Knox, Microsoft MVP, Tewksbury, Massachusetts

You can configure Windows XP to automate the logon process if your computer is not part of a domain.

1. Click Start, click Run, and type control userpasswords2.
2. Clear the Users must enter a username and password to use this computer check box.
3. Click Apply.
4. Enter the user name and password you wish to automatically log on with, and then click OK.
5. Click OK again and you’re all done.

This feature allows other users to start your computer and use the account that you establish to automatically log on. Enabling auto logon makes your computer more convenient to use, but can pose a security risk.

No Comments