Sunday, October 19, 2008

Service Tax India New St3 Form

I put New ST3 Form which you can export from (as per Notification 31 dt 2 sep 2008.)
http://spreadsheets.google.com/ccc?key=p-c57rjQBhZx_KMcV3yGTIw

I am very sorry to say that government only collects tax from tax payers and not giving facility of just one fill able form! Hon.Finance Minister Pl look into the matter for small service provider who can not file return online.

Pl copy first page from government website http://servicetax.gov.in/forms/form_st3_new.htm into your Word Doc. Other page I publish in google doc.

Save your time, and Build strengthen India.
Jay Hind.

Edit php.ini file will not reflect changes

php.ini reside at c:\windows and if you edit it in c:\php or c:\php523 it will not reflect changes you made. Pl make sure which php.ini you are changing.

MySql LOAD DATA LOCAL INFILE Problem

If you upload data without line terminator in the file, Data will upload perfectly but you compare field with query will not give result. particularly with last field and local file created with Excel->CSV. Data in the Mysql Table shows exact but \r\n not there so it will not compare and you will not get result of sql query.

If you have generated the text file on a Windows system, you might have to use LINES TERMINATED BY '\r\n' to read the file properly, because Windows programs typically use two characters as a line terminator. Some programs, such as WordPad, might use \r as a line terminator when writing files. To read such files, use LINES TERMINATED BY '\r'.

Php Example:
$sql = "LOAD DATA LOCAL INFILE '".@mysql_escape_string($this->file_name).
"' INTO TABLE `".$this->table_name.
"` FIELDS TERMINATED BY '".",' LINES TERMINATED BY "."'"."\\r\\n"."' IGNORE 3 LINES";