Friday, July 14, 2017

GST Submit with DSC Error [SOLVED]

Unable to connect to the installed EMSigner. Please close any other application running on following ports 8080, 1645, 1812, 2083 and restart your system, and try again.

Unable to connect to the installed EMSigner. Please close any other application running on following ports 8080, 1585, 1812, 2083 and restart your system, and try again.

If you are getting above error while submitting / verifying your GST application using DSC
then you are at right place.

I tried submitting using google chrome, Mozilla firefox even Internet Explorer but it failed.
Many blog posts suggests changing java settings, port settings even hosts settings.

But for layman and CA's the best possible way is to download and install UC Browser.
When I used this browser it worked like Charm.

Link - https://uc-browser.en.softonic.com/

ITS a FREE Browser.

Happy GST submitting.

Tuesday, December 29, 2009

Thursday, October 22, 2009

PHP Regular expressions tool

Regular expressions can be a pain. This tool is designed to help developers learn, practice, and compose regular expressions.


http://gethifi.com/regexp/

http://gethifi.com/regexp/

http://gethifi.com/regexp/

Thursday, July 30, 2009

Wednesday, July 29, 2009

Twitter extensions

Twitter is on rage these days.
Twitters apps as firefox extensions just keeps on increasing

https://addons.mozilla.org/en-US/firefox/search?q=twitter&cat=all

Friday, June 5, 2009

MySql GROUP_CONCAT() tip

Recently I found myself into a silly problem because of misunderstaning / confusion relating to data type of variable set in SELECT commmand using GROUP_CONCAT()

I wanted to get all integer ids as comma separated string to be used in other update query

my query:

SELECT GROUP_CONCAT(spm_ids) INTO @csvIds FROM someTable WHERE is_active = 1;

Whenever my select executed correctly it gave e.g. '2,5,6' as a string and when it failed it gave me '0' as a string.

before updating I checked

IF @csvIds <> 0 THEN
// perform some update on some other table
END IF;


I changed to below and my Stored procedure worked perfectly fine.

IF @csvIds <> '0' THEN
// perform some update on some other table
END IF;

Some of mysql String comparison
> select if('2' <> 0, 1, 0)
> 1

> select if('0,2' <> 0, 1, 0) //my problematic condition
> 0

> select if('0' <> 0, 1, 0)
> 0

> select if('2,5,6' <> 0, 1, 0)
> 1





MySql tip 2:
If you are writing too many Stored Procedures(SP) and also including below code in your SPs

DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
SELECT 2 AS `error_code`, 'Fail to update ' AS `error_message` ;
END;

Then I would suggest that you first create your SP entirely run it many times under different conditions, if all working fine than include above code and test it again for failure.
This is because you will save some of your precious time by knowing exactly where the query failed.

Wednesday, February 11, 2009

Python Type Conversions


FunctionDescription
int(x [,base])converts x
to an integer
long(x [,base])converts x
to a long integer
float(x)converts x
to a floating-point number
complex(real [,imag])creates a complex number
str(x)converts x
to a string representation
repr(x)converts x
to an expression string
eval(str)evaluates str and returns an object
tuple(s)converts a sequence object to a tuple
list(s)converts a sequence object to a list
chr(x)converts an integer to a character
unichr(x)converts an integer to a Unicode character
ord(c)converts a character to its integer value
hex(x)converts an integer to a hexadecimal string
oct(x)converts an integer to an octal string


Use:
totalRings = int(userInput)
//where totalRings and userInput are variables