How to install plugin for Joomla? (JOOMLA)

Joomla is one of the best CMS tool and the reason is that because there is a big community making lots of plugins that make your website look great with just a few clicks.

To install plugins, basically you have to download the plugin first, save it on your computer and install it.

Step 1: Go to Extension -> Extension Manager:

Step 2: locate your plugin file:

Step 3: Click "Unload & Install"

You have just installed the plugin!

Enjoy!

How to turn off caching in Joomla? (JOOMLA)

For some of the plugins you have to turn off caching in order to make it work perfectly, ie: Facebook Like and Share.  To turn off caching in joomla, you have to follow the below steps:

Step 1: Go to System and select Global Configuration:

Step 2: Go to System Tab on the right hand side screen, scroll down and you will see "Cache *", choose "OFF- Caching disabled".

There you go!  You have just disabled caching of your Joomla website!!

Enjoy!

How to clear cache? (Joomla)

How to clear cache? And what does cache do?

Cache is actually the data files that are retrieved from either database or anywhere else and store it on the server so that when users want to retrieve it again the server will just give them the cache and hence it will save the traffic time from server to database.

Then we we need to clear cache?  Sometimes we have modified something from the source and would like to check if the content is updated.  In this moment we have to clear cache in order to see the updated content.

Step to clear cache in Joomla:

Step 1:
Click System from menu.

Step 2:
Select the type of cache that you want to delete and click on the delete button as highlighted.

You have just cleared cache!

Enjoy!

SVN diff two tags (SVN)

svn diff --summarize FILE1 FILE2

Enjoy!

Look up table with column name (SQL)

select a.name
from sysobjects a, syscolumns b
where a.id = b.id
and b.name = 'CFRMN_IND'

Look up table with partial table name (SQL)

select top 50 * from GTDMAST1..sysobjects
where type = 'U'
and name like "%SCA%"

How to get disk space in UNIX? (UNIX)

Usage:
df -k | grep local

Enjoy!

How to find a specific string in UNIX? (UNIX)

find . -type f -exec grep -l "STRING_YOU_ARE_LOOKING" {} \; >> /var/tmp/user_temp/tracersearch/tracer_base_profl_search.log &

Enjoy!

Clearcase how to draw a merge line? (CLEARCASE)

Usage:
cleartool mkhlink -unidir Merge FILE1 FILE2

Enjoy!

Clearcase how to tag/mark label? (CLEARCASE)

Usage:

cleartool mklabel -rep LABEL_NAME FILE_PATH

Enjoy!

Clearcase how to create label? (CLEARCASE)

Usage:

cleartool mklbtype -nc LABEL_NAME

Enjoy!

Clearcase how to lock/unlock label? (CLEARCASE)

Usage (lock):
cleartool lock lbtype:LABEL_NAME

(Unlock)
cleartool unlock lbtype:LABEL_NAME

Enjoy!

Clearcase how to change owner? (CLEARCASE)

Usage:
cleartool protect -chown v439333 -chgrp feaccusr lbtype:LABEL_NAME

v439333 => user id
feaccusr => group name

Enjoy!

Clearcase how to lock label but only specific person are allowed to use the label? (CLEARCASE)

Usage:
cleartool lock -nusers r339347,v439333 lbtype:LABEL_NAME

r339347,v439333 => userid

Enjoy!

Clearcase check any file which is not yet checked in (CLEARCASE)

Usage:
cleartool lsprivate -tag TAG_NAME -long > c:\viewspec\Private_APBAU_20110708.log

c:\viewspec\Private_APBAU_20110708.log => logpath.

Enjoy.

How to remove clearcase branch by command? (CLEARCASE)

cleartool rmbranch -force branchpath

Enjoy.

How to use BCP in & out? (BCP)

To bcp out (get data from DB), please use the below command.

Explanation
GTDMAST1..DISCREPANCY_CD_DTL -> where you want to get the data from
DISCREPANCY_CD_DTL-> the name of the file where you want it to output to
SGTSCOR_UAT510-> server name
UU649121-> username
Pabc123 -> password
-c -t'~^' -r'AAAAABBBBBCCCCC' -b500-> this is the part to separate the data 

Command (OUT):
bcp GTDMAST1..DISCREPANCY_CD_DTL out DISCREPANCY_CD_DTL -SGTSCOR_UAT510 -UU649121 -Pabc123 -c -t'~^' -r'AAAAABBBBBCCCCC' -b500



Explanation
tempdb..DISCREPANCY_CD_DTL -> where you want the data to insert into 
DISCREPANCY_CD_DTL -> the source file
SGTSCOR_DEV510 -> the db server
Usa1 -> username
Pabcd7890 -> passowrd
-c -t'~^' -r'AAAAABBBBBCCCCC' -b500 -> this is the separator and has to be the same with the output command.

Command (IN):
bcp tempdb..DISCREPANCY_CD_DTL in DISCREPANCY_CD_DTL -SGTSCOR_DEV510 -Usa1 -Pabcd7890 -c -t'~^' -r'AAAAABBBBBCCCCC' -b500

How to look up file in UNIX? (UNIX)

If you know the file name, the below command will help you to find out a file.

Please notice that the "." means look through everything in the location where you are.

find . -type f -print | grep 'actionfile_inq.xml'

Enjoy.

How to look up a file in a directory? (UNIX)

In the below example:
CCY_EMU_EXT = filename (it will look up files CCY_EMU_EXT and more CCY_EMU_EXTx, where x can be anything with unlimited number of characters)

After the ">" symbol is the path where you want the result to print it to.  CCY_EMU_EXT_1.log is the result file.

find /gtsallsrv/gts/ -name "*" | xargs grep -l CCY_EMU_EXT  > /var/tmp/v439333/CCY_EMU_EXT_1.log &

How do you look up a process in UNIX? (UNIX)

How do you grep a process?  And what is grep?  grep is actually a function to "grab" the process of a specific name in unix.  It helps you to identify which process is actually running on background.

/usr/ucb/ps -auxww | grep -i qm | grep -i GTSD25QM

-i = ignore letter case

Enjoy.

What is sp_lock & sp_who (SQL)

sp_lock (Reports information about processes that currently hold locks.)
sp_who (Run sp_who to get the spid of the locking process.)

How to set thousands separator in Java?

The following will work:

int no = 124750;
String str = String.format("%,d", no);

ENJOY!

How to convert from int to String? (Java)

Integer.toString(i) or String.valueOf(i) will work.

Enjoy!



How to convert string to int in Java?

int foo = Integer.parseInt("1234");

How do you pause in android (Java)?

First you have to create a Handler();, then you have to use the postDelayed function to pause the code.

public class MyActivity extends Activity {
    private Handler mHandler = new Handler();

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        mHandler.postDelayed(new Runnable() {
            public void run() {
                doStuff();
            }
        }, 5000);
    }

    private void doStuff() {
        System.out.println("Hellow World After 5 seconds!");
    }
}