Monday, October 13, 2014

Selecting and grouping multiple layers and creating a clipping mask in photoshop.

In the previous posts we read about some operations like duplicating , deleting andmerging layers in photoshop , in this section we will be knowing about some more operations that can be performed on layers like grouping and clipping mask. Let us go about these operations one by one.

  1. How to select and move one or more layers together at the same time-

  1. One way to select two or more layers is to keep the CTRL key pressed and selecting the layers one by one.
  2. OR the second way to select multiple layers is to keep the shift key pressed and selecting the lower most layer and the uppermost layer, by doing this all the layers between these two layers , including these two will be selected, but this way is only applicable if the layers you want to select are placed in a row or a sequence, one on top of other and not scattered in the layers menu.
  3. After you have selected multiple layers you can very easily drag them in the layers panel to place them where ever you desire and order them accordingly.
  4. You can even delete multiple layers by selecting them all at once.
  1. Grouping multiple layers in photoshop-

  1. Grouping the layers gives you a chance to separate out the related layers and keep them in one separate group, it makes your work much easier when you have more number of layers in one image.
  2. You can always hide and show the group and even drag the group from one place to another without getting into the hassle of selecting the same bunch of layers every time.
  3. All you have to do is select the layers you want to put in one group by using any one of the above described ways .
  4. Then just create a group by clicking on the group icon in the bottom of the layers panel.
  5. Drag the layers that you have selected into the group . and your group Is created.
  6. You can also expand and minimize and rename your group , according to your work.
  7. You can also add any layer to the group and also delete a layer from your group by dragging layers in and out of your group.
  8. To un group the layers in a group, right click on the group and select the ungroup layers option.

  1. Creating a clipping mask in photoshop-

  1. This is a very interesting feature that photoshop provides us.
  2. By creating a clipping mask we mean that we are keeping an image on top of other and covering the underlying layer with the layer on the top . an example can better explain what a clipping mask does, suppose you have two layers , one is a blue cloud shape , and another is simple red rectangle , now if you place the red rectangle on top of the blue cloud in the layers panel, and right click on the red rectangle , and select create clipping mask option, what it will do is, it will overlap the blue cloud shape and cut itself into the cloud shape .
  3. Create two different shapes of different colors.
  4. Now keep one shape on top of other.
  5. Right click on the shape on the top .
  6. Select the create clipping mask option from the options and see the effect.


Different operations (deleting ,hiding, merging and duplicating layers)that you can perform on layers in photoshop.

1 comment
In the previous posts we learnt about how to give emboss effect to layers and layer transforming tricks , in this post we will be focusing on operations like deleting, merging ,hiding and duplicating layers. Lets go about learning the process to perform these operations one by one with the help of the following screen shots.
  1. How to duplicate an existing layer in Photoshop –

  1. First create any shape using the shape tool .
  2. Right click on the shape from the layers menu, an options menu opens up which gives you list of options .

  3. Select the duplicate layer option from this menu.
  4. A dialog box opens up which allows you to rename this duplicated shape .

  1. How to delete a layer in photoshop-

  1. Right click on the existing layer from the layers menu.
  2. Select the delete layer option from the options menu.

  3. OR you can simply select the layer you want to delete and press the delete button in the bottom of the layers menu.
  4. A dialog box opens , select yes to delete .

  1. How to hide and show a layer in an image in Photoshop-

  1. See the eye icon on the left of every layer in the layers menu.

  2. This is the key that lets you make the layer invisible and visible again.

  1. How to merge two or more layers in photoshop-

  1. Press the CTRL key and select the layers that you wish to merge, one by one.
  2. After you have selected ,right click on the layers and select the merge layers/merge shapes option from the options.Now all the merged layers become one single layer.


Sunday, October 5, 2014

First Adsense payment received via Wire Transfer/EFT- Review

AdSense payment via cheque for Indian publishers was a minimum of 45 day waiting process from the day AdSense threshold amount reached $100 (only for those who achieved AdSense $100 threshold near to month end). However it was even more longer journey for those who achieved $100 AdSense threshold  at beginning of any month. They would have to wait for almost two and half months to get paid for their efforts.

Recently, when Google Adsense came up with option of Wire Transfer/EFT for Indian publishers, I followed the process and changed my form of payment from Cheque mode to Wire Transfer/EFT mode. Initially, I was a bit doubtful whether it would work or not as I could not find any reviews of successful payment via wire transfer by any Indian publisher.

On Aug 31, 2014 my Adsense threshold crossed $100 and payment was released on 23 Sep-2014. I was counting on the days when the amount will be credited to my account.

 I was lucky that I received my Adsense payment within 48 hours and it was a complete hassle-free transaction. As compared to cheque which took almost 15 days, I received my payment in just 2 days via Adsense wire transfer.

Benefits of AdSense Wire Transfer/EFT over Cheque Payment

1. Cheque gets delivered after 15 days of payment released by Google whereas  AdSense Wire Transfer credits the amount in 1-3 business days.

2. Free from depositing cheque at bank and waiting for it to get processed.

3. If your amount is relatively good, wire transfer provides you your payment early. Saving it can incur good interest on it. Whereas cheque delays your amount by 15 days which results in loss of interest for those 15 days.

Drawbacks of AdSense Wire Transfer/EFT

1. Though Adsense wire transfer provides you quick payment but your banks cuts a lot on currency conversion rate. The day my payment was processed, dollar to rupee was 1$ : 61 Rupee but my amount was converted at 1$ : 59.38 Rupee rate. So approximately I was paid almost Rs. 200 less to my actual amount.


Use of Row_Number function in PL/SQL

1 comment
Row_Number is an analytical function which assigns a unique number to the rows defined in the Partition by clause. These rows are ordered in the sequence of the column mentioned in the order by clause.

Syntax of Row_Number():
Row_number() over(partition by col1, col2, .. order by col3 desc)

Suppose you have a product table as:
create table product(
product_name varchar2(20),
product_type varchar2(20),
mfg_date date

Insert values in the table:

insert into product values('Soap', 'Homecare', '01-Jul-2014');
insert into product values('Soap', 'Homecare', '02-Jul-2014');
insert into product values('Soap', 'Homecare', '03-Jul-2014');
insert into product values('Maggi', 'Snacks', '04-Jul-2014');
insert into product values('Maggi', 'Snacks', '05-Jul-2014');
insert into product values('Shampoo', 'Homecare', '06-Jul-2014');

Suppose we want to pick up same product with same product type with latest manufacturing date.
 We can query the table using row_number and get assign number to each row as follows:

SELECT product_name,
  row_number() over (partition by product_name, product_type order by mfg_date DESC)
FROM product;

Now we can see that all the rows with row_number values as 1 are the ones with latest manufacturing dates. Using this value we can pick up the latest manufactured products.

Wednesday, September 24, 2014

Push or Commit code to BitBucket Repository Using Git

This tutorial list all the steps to push the code from your local directory to BitBucket using git bash. Before committing you first clone BitBucket Repository on Local System

Steps to Push or Commit code First Time to BitBucket using Git Bash from Local System:

Step 1: After cloning git repository add a new file to it as shown in diagram below:

Git Repo push

Step 2: Now open Git Bash UI and then change to the directory which you have cloned on the system using cd command as shown below:

cd command in git bash

Step 3: Use git init command to initialize the directory as shown in the diagram below:

git init command

Step 4: Login to your bit bucket account . Open the repository and then expand the command line I have an existing project or I am starting from scratch and then copy the command as shown in the picture below:

command line in bit bucket

Step 5: Right click on git bash and then paste as shown in diagram below:

how to paste in git bash

Step 6: To add the file for commit use command git add * as shown in diagram below:

git add command

Step 7: To check which files are added to commit write command git status as shown below . It will show the file name for commit.

git status

Step 8: Now execute command git commit -m "your comment" as shown below:

git commit

Step 9: Finally write command git push origin master as shown below and then git will ask for your bit bucket account password as shown below:

git push origin master

Git will take some time to push code to bit bucket.

Login to your bit bucket account and then open the repository click on Commits in left to check your commit as shown below in the diagram:

check commit in git bash


Saturday, September 20, 2014

How to Clone Git Repository on Local System from BitBucket

1 comment
In this tutorial we will find out the procedure to download code from Git Repository on local system from your bitbucket account. If you are trying to create new bitbucket repository then you can check this post: How to Create BitBucket Repository

Steps to Clone Repository from BitBucket Using GitBash on localhost:

Step 1: First create a new folder on your local system in which you want to clone git repository from bitbucket. I have create folder with the name PincodeProject inside d drive.

Step 2: Open GitBash as shown in diagram below:

Git Bash on local system

Step 3: In gitbash change the drive to d which contain the folder for cloning the repo as shown in the diagram  below:

change drive in gitbash

Step 4: Now change to folder in which you want to clone the git repository. In this example I have created PincodeProject folder as shown in the picture below:

Clone to folder using GitBash

Step 5: Now use git init command to initialize folder as shown below in picture:

git init command in gitbash

Step 6: Now login to your bitbucket account. If you don't have bitbucket account then follow this link create bitbucket account. Open the repository whose clone you want to take as shown in the diargram below:

Git Bash dashboard

Step 7: Click on Clone after opening the repository and then copy the clone url as shown in the diagram below:

clone url gitbash

Step 8: Now paste the copied url in Git Bash Command line by right clicking on to top of GitBash command line window as shown in the picture below:

Paste clone url in GitBash

Step 9: Now enter bitbucket account login password to complete the clone process as shown in the diagram below:

BitBucket Password for cloning

Finally the project will be cloned on your local system from bitbucket using GitBash as you can see below:

gitbash cloned on system


Sunday, September 14, 2014

How to Install Git Bash on Local System

In previous articles we discussed about steps of creating bitbucket repository. To manage repository on bitbucket i.e. code check in , check out etc. from local system you can use git bash. Git Bash is command line tool by using which you can clone repository from bitbucket, work on the code and then commit the code back to bitbucket repostiroy etc.

Steps to Install Git Locally:

Step 1: Download git from this link: Download Git. You can download for Linux, Window, Mac or Solaries operating system as shown in the diagram below:

Download git for windows

Step 2: After downloading the git according to your operating system, run the exe file as shown in the picture below:

Install git bash on windows

Step 3: In select component window select Windows Explorer integration as shown in the diagram below:

Git Bash option

Step 4: In Adjusting your PATH environment select Use Git from Git Bash Only as shown in the picture below:

Use git from git bash only

Step 5: In configuring the line ending conversion window select the option Checkout windows-style , commit Unix-style line ending conversions:

configuring the line ending conversion in git

Finally click on Finish to complete the installation as shown below:

Git finish installation

You can use Git GUI for UI interface or Git Bash for using git commands as shown in the diagram below:

Git bash


How to add new user to Bitbucket Repository

In bitbucket you can share the repository with another user, so they can also work on that. In this tutorial let us look at how to add new user into your team on bitbucket and give read, write or admin permission based on your project requirement.

Steps to add new user to BitBucket Repository :

Step 1: Login to your bitbucket account and then inside dashboard select Repositories and Name of the Repository in which you want to add new user as shown in the picture below:

Select Repository in bitbucket

Step 2: After selecting repository click on Settings in the left side as shown in diagram below:

Repository settings in bitbucket

Step 3: Click on Access management as shown in the picture below:

access management in bitbucket

Step 4: In Access Management enter name of the user if already registered with bitbucket or enter email address if you not sure about user name . Select the type of permission for this new user and then click on Add button as shown in the diagram below:

Add new user to git repository
confirmation mail will be sent on email address as shown below:

bitbucket confirmation email