Payment Gateway Basics

Hello all ,
Below are the basics which I learn while integrating different payment gateways in web site,

You need a register company or register domain with government to get Payment Gateway integration account from Payment gateway provider and then get API of that payment gateway as per you programming language Like Net,Java,Php...etc 

Carefully read the steps to implement API. 

Payment Gateway have 2 mode of transaction 1. LIVE ,2. TEST 

You can do test mode for testing and finally Live also test mode used for localhost request. 

2. What a payment gateway actually is? 

A payment gateway is one type of third party tool which will connect website to bank using credit card,debit card ,net banking ...etc 

Website -> Third Party Web -> Bank 

3. If I sign up for a payment gateway, what stuffs they provide to connect to my payment page? And how to do it? 

If you register to any payment gateway they will provide some credential like Secret Key,account key, ...etc Which is use full for requesting to payment gateway for your account. 

For registration each and every payment gateway required some document prof... 

4. How a payment is made through internet banking facility by the user and how the payment is received by the merchant? 

This process is done by payment gateway so not required to think about that. 

But in practical the payment gateway connected with bank using Bank API(with registration) and that bank provide all bank details and payment verification and payment confirmation to payment gateway and payment gateway to user.. 

This is all like we are using Service in Net... 

Note : You can directly connect with bank and create your own payment gateway but that required some long process stuff . 

If you have payment gateway integration for Big website to you can go throw it other wise I prefer go and connect with any service provider which have Less charge on transaction like 2.5% in india by most of payment gateway.... 

Example : EBS,ccavenue...etc 

Some Important queries regarding SQL Log File backup

Hello all ,
While working today , I got one error saying log file for my Database is full..

so for this i did some R&D and come with following queries
Hope they will help you all


1) How to check DB details

--check DB details
SELECT DB_NAME(database_id) AS DatabaseName,
Name AS Logical_Name,
Physical_Name, (size*8)/1024 SizeMB
FROM sys.master_files
WHERE DB_NAME(database_id) = 'yourDatabaseName'

--here  yourDatabaseName is the name of your database

2)  check the size for specific DB
select * from sys.databases where name = 'yourDatabaseName'

--here  yourDatabaseName is the name of your database

3)  shrink the file (any log or MDF)

DBCC SHRINKFILE(yourDatabaseLogFileName, 1)

--here  yourDatabaseLogFileName is the name of  log file of your database

4) Displaying log space information for all databases

DBCC SQLPERF(LOGSPACE);

5) Check the recovery model of the Database to full or simple

SELECT name, recovery_model_desc

   FROM sys.databases

      WHERE name = 'yourDatabaseName' 

--here  yourDatabaseName is the name of your database

6) change the recovery model of the Database to full or simple
GO
ALTER DATABASE yourDatabaseName
SET RECOVERY FULL

--here  yourDatabaseName is the name of your database


ALSO below are some important links which helps me to find the solutions

http://blog.sqlauthority.com/2010/09/20/sql-server-how-to-stop-growing-log-file-too-big/

http://www.sqlskills.com/blogs/kimberly/8-steps-to-better-transaction-log-throughput/

http://mstech.inapp.com/?q=delete-sql-server-database-transaction-log-file



Hope it will help you and save your time ..

How to Check if Cell value exists in Column, and then get the value of the NEXT Cell

Hello Friends, I am back with new trick with excel ..
This week I am  playing with excel and in today's task , I need to check

Check if Cell value exists in Column, and then get the value of the NEXT Cell.

I search pretty much, and finally got this solution which is exactly as per my requirement.

The link is http://stackoverflow.com/questions/12915215/excel-check-if-cell-value-exists-in-column-and-then-get-the-value-of-the-next

Question :  

After checking if a cell value exists in a column, I need to get the value of the cell next to the matching cell. For instance, I check if the value in cell A1 exists in column B, and assuming it matches B5, then I want the value in cell C5.

Answer : 

=IF(ISERROR(MATCH(A1,B:B, 0)), "No Match", INDIRECT(ADDRESS(MATCH(A1,B:B, 0), 3)))

The "3" at the end means for column C.

Hope this help you people and save your time to search things 

Enjoy the day with lots of smile and happiness.....

How to Find Items in one column that are not in another column

Hi In my today task I need to search specific item from one column which are not present in other column

and while googling , I got below link
http://superuser.com/questions/81498/excel-find-items-in-one-column-that-are-not-in-another-column

1. Select the list in column A
2. Right-Click and select Name a Range...
3. Enter "ColumnToSearch"
4. Click cell C1
5. Enter this formula: =MATCH(B1,ColumnToSearch,0)
6. Drag the formula down for all items in B

If the formula fails to find a match, it will be marked #N/A, otherwise it will be a number.

If you'd like it to be TRUE for match and FALSE for no match, use this formula instead:

=IF(ISNA(MATCH(B1,ColumnToSearch,0)),FALSE,TRUE)

Hope it will help you people and save time...

Regards

Enjoy the day with lots of smile and happiness

How to Compare cell contents in Excel

Hello friends,

Again I got data from client in excel sheet :) and This time I need to compare data from cell content .
and again I google for this and found one function
EXACT.

At official website I got below details, 

Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document.

Syntax

EXACT(text1,text2)

Text1     is the first text string.

Text2     is the second text string.

We can check this with below example

A
Data
BD122
BD123
BD123
Formula	Description (Result)
=EXACT(A2,A3)	Compare contents of A2 and A3 (FALSE)
=EXACT(A3,A4)	Compare contents of A3 and A4 (TRUE)

Hope it will be useful  and save your time 

Enjoy the day with lots of smile and happiness.......

How to remove all text before/after a specific character?

During my daily work , I got some data from client in Excel sheet and I need to work with that data.

My requirement was like I need to remove all the data before specific character for all the rows in the sheet.

I try to google for any specific formula ,and I found one very good link that matches exactly to my requirement and thought to share the same with you. 

hers the link http://www.asap-utilities.com/blog/index.php/2011/10/14/how-do-i-remove-all-text-beforeafter-a-specific-character/.

what all we need to do is  select all the rows where you want to remove the text and replace it with space :)

Its so simple :)

Hope you like it..

Enjoy the day with lots of smile and happiness..