Productivity Tool - PowerPro

The PowerPro software provides the user with a launch bar that is both compact and powerful. It also includes a menu and tray icon functionality. The program integrates three functionalities. It can run commands such as tool bars, tray icons, scheduler, menus, timer, mouse and hot keys. The PowerPro software can also be used by the user to close, maximize, minimize, position, roll-up to caption and tray minimize other program's windows. The program also provides utility functions. It can send keystrokes to programs, provide virtual desktops, run commands when Windows first opens, serve as a clipboard extender, can shutdown, enable keyboard macros, show all folder files in a menu, enable sounds, wallpaper and screensaver activation as well as randomization.

In practical scenarios, software professionals can use this to :

·         Add List of putties to connect to various servers and get rid of typing username password each time.
Command is as follows:
putty.exe -ssh <UserName>@<ServerIP> -pw <Password>
·         Create shortcuts to various software.
·         Create shortcuts to documentation page(so no need to open browser and then search for bookmark if done).

You can more explore about this software using following link:

·         Home Page: http://powerpro.webeddie.com/index.html
·         Feature & Configuration Demo: http://powerpro.webeddie.com/tour/index.htm

So after exploring this, you can save time and concentrate on other work :)

Cheers!!!

Keynote NF : Handy and productive tool to manage notes.

I would like to let you know about a good lightweight tool : Keynote NF

As we use notepad to save various important notes or mark some to-dos.

Due to this desktop gets messy and its trouble to find things which we have written for our simplicity :)

Using keynote one can save the important notes or any under process notes in single file.

It is having various features, I have found few of it while its usage:

• Simple to use and Lightweight – When not in use keeps running in background.
• Freeware – No licenses.
• Supports Rich Text and various feature like MS Word.
• Alarm / Reminders.
• Tree based to arrangements of notes and multiple tabs.
• Good search capabilities.
• No need to install – Unzip and start using it.

You can explore it more and I am sure you may find it handy as compared to using notepad.

Here are details about Keynote NF:

http://code.google.com/p/keynote-nf/

Keynote NF Downloads (No need to install – Unzip and Use it):

Release_1.7.8.1 (true version).rar – Size 1.76 MB

Cheers!

Use Productivity Tool : StrokeIt !!!

While working on various windows tired of minimizing, opening, doing various operations.
Now time to move on to StrokeIt - Mouse Gestures for Windows. : http://www.tcbmi.com/strokeit/

Want to download StrokeIt, use the following link:
http://www.tcbmi.com/strokeit/downloads.shtml

It is also FUN to use this tool using your mouse :)

To get more information about how to use and other details, check out following link:
http://www.tcbmi.com/strokeit/wiki/index.php?title=Help:Getting_started

Replacing carriage-returns & line-feeds from a string/column in Oracle/Database.

To replace the carriage-returns & line-feeds from a string in Oracle or database, replace() does not work properly.

There is a special handling required to replace new line or carriage-returns.


If the data in your database is POSTED from HTML form TextArea controls, different browsers use different New Line characters:

• Firefox separates lines with CHR(10) only
• Internet Explorer separates lines with CHR(13) + CHR(10)
• Apple (pre-OSX) separates lines with CHR(13) only

So you may need something like:

• update table_name set col_name = replace(replace(col_name, CHR(13), ''), CHR(10), '') ;

- Cheers!!!

message from server: "Host is not allowed to connect to this MySQL server"

Today I came across the problem for remotely connecting to MYSQL database from an application hosted on different machine.

Solution for this issue is to run the following query for granting privileges  to desired user:

GRANT ALL PRIVILEGES ON *.* TO '<USER_NAME>'@'%' IDENTIFIED BY '<PASSWORD>' WITH GRANT OPTION;

Enjoy!!!

Productive Eclipse Plug-Ins : Easy Explorer !!!

Easy Explorer is a very useful plug in, which helps you to browse resources with the native Operating system explorer.
In the Eclipse, select a file, right-mouse click, and select the 'Easy Explore'.
This way explorer will be opened and you desired file will be highlighted.

Direct Download link for this file : Easy Explorer for Eclipse(easy-explore-1.0.4)

Likewise there is also another plug-in : StartExplorer
StartExplorer is also having lots of options, but I feel Easy Explorer is more friendly as it can be used in the tree browser as well as in editor as well.

How to call my own JavaScript functions on onLoad or onUnLoad event???

While working on the JSP or HTML pages, we are having some requirement to call our own JavaScript functions after execution of existing onLoad functions.

Also most of the time scenario is like - we are including different files & loading JavaScript files(may be 3^rd party). Due to this we are not able to know JavaScript function is getting called on the onLoad or onUnload event for the browser window.

And QUESTION arises : “How to call our own JavaScript functions on onLoad or onUnLoad event?”

Here is the ANSWER for that:

Just add the following JavaScript functions to your own file(JSP/ASP/PHP/JS).

1.       addLoadEvent() : This function will append call of your function to existing queue for onLoad event of browser window.

2.       addUnLoadEvent() : This function will append call of your function to existing queue for onUnload event of browser window.

 

function addLoadEvent(func) {

  var oldonload = window.onload;

  if (typeof window.onload != 'function') {

    window.onload = func;

  } else {

    window.onload = function() {

      if (oldonload) {

        oldonload();

      }

      func();

    }

  }

}

 

function addUnLoadEvent(func){

      var oldOnUnLoad = window.onbeforeunload;

      if (typeof window.onbeforeunload != 'function') {

                window.onbeforeunload = func;

      } else {

      window.onbeforeunload = function() {

      if (oldOnUnLoad) {

            oldOnUnLoad();

            }

            func();

         }

      }

}

 

How to call these functions:

 

In your files make a call to these functions as –

 

addLoadEvent(function(){

                alert(‘Calling myFunction...’);

                myFunction();

                alert(‘ Hurray, myFunction gets called!’);

});

 

addOnLoadEvent(function(){

                alert(‘Calling myFunction...’);

                myFunction();

                alert(‘ Hurray, myFunction gets called!’);

});

 

You can copy & paste these functions to your files & use in the similar way.

Also you can modify the logic of function gets called.