Kartikeya's Knowledge Resource Center

Export Excel CSVs with Double Quotes

2011-05-26T12:29:00.005+05:30

visit... http://www.markinns.com/articles/full/export_excel_csvs_with_double_quotes

Very useful to transfer data from Excel to CSV. without this VBA code you have to replace all , with space

Use this with CSV using LOAD DATA and use Local LOCAL keyword

Excel adding days to specifc date gives error #VALUE!

2010-12-17T19:45:00.003+05:30

Excel 2000 onward...
Content of B1 Cell : 17/12/2010
Content of A4 Cell : 7
Formula of C5 cell : =B1+A4

Gives error at C5 Cell #VALUE!

Solution:
With WinXp Change setting Date to dd/MM/yyyy ( Control Panel- Regional and Langauge Options - Customized - Date - Short Date )

After resolving problem content of C5 : 24/12/2010

Restrict users to specified programs or applications in WindowsXp

2009-11-08T11:35:00.000+05:30

-Login as an administarator
-Run Policy editor ( start - run - gpedit.msc )
-Navigate following folder...
Local Computer Policy\User Configuration\Administrative Templates\System in the left pane
-Now double click the option Don't Run specified Windows applications in the right pane.
-Now select the Enabled and click Show button
-In the Show Contents dialog box type the name of the application (.exe file name) which you want to allow user not to run under List of Not allowed applications statement.
For eg. type iexplore.exe not to allow Internet Explorer to run.
-If you want to add more applications then type their names under the first one and so on.
-Click OK button.
-Click Apply and then OK button in Run only specified Windows applications window.
-Close Local Group Policy Editor window and you are done.

More on Policy Editor...
How To Use the Group Policy Editor to Manage Local Computer Policy in Windows XP

Re: Divya Bhaskar noted my Open Source efforts

2009-07-02T10:01:00.002+05:30

Divya Bhaskar a leading Gujarati Daily took note of my Open source efforts a part of Social-Eduction Projects.

My FireFox Add-Ons "Income Tax Calculator" now goes to public...

Divya Bhaskar...
http://epaper.divyabhaskar.co.in/bigwin.aspx?url=EpaperImages\01072009\Aa123-large.jpg&eddate=7/1/2009&pageno=3&edition=45&prntid=113913&bxid=966&pgno=3

My Add-on link...
https://addons.mozilla.org/en-US/firefox/addon/10095

I am very much thank full to column writer Mr.Himanshu Kikani for taking my efforts to public and also appreciate his creation http://cybersafar.com/

Re: LOAD DATA INFILE selective column

2009-06-28T18:41:00.003+05:30

I want to import data from Local file(CSV) to Mysql 5.0 table with only selected column.

My PHP code is... as per Mysql5.0 syntax
$query="LOAD DATA LOCAL INFILE '". @mysql_escape_string($tmpupfile) . "' INTO TABLE item_master (item_code,item_desc) FIELDS TERMINATED BY '" . "," ."'";

It gives syntax error.

Following works fine... put column(field) list at the end.

$query="LOAD DATA LOCAL INFILE '". @mysql_escape_string($tmpupfile) . "' INTO TABLE item_master FIELDS TERMINATED BY '" . "," ."' (item_code,item_desc)";

Writing Blog in Hindi

2009-06-18T22:58:00.001+05:30

आप हिंदी, गुजराती, मराठी और अन्य भारतीय भाषा में आसानी से लिख सकते हे|
इसके लिए आप http://www.google.com/transliterate/indic/Hindi की मुलाकात ले |
वहा से कॉपी कर के अपने ब्लॉग में पेस्ट करे और कोई भी UTF-8 एडिटर में एडिट केरे !
धन्यवाद सह,
कार्तिकेय

Fatal error: Cannot redeclare _pear_call_destructors()

2009-06-13T16:06:00.002+05:30

I was using PEAR HTML_Quick_forms and using my ISP PEAR.php and Quickform.php I got following message..

Fatal error: Cannot redeclare _pear_call_destructors() (previously declared in /home/myusername/myuserincludes/PEAR/PEAR.php:765) in /usr/lib/php/PEAR.php on line 796

Solution:
I made following change in Quickform.php...
line
require_once 'PEAR.php';
replace with line
require_once 'PEAR5.php';

just force to use PEAR5

You may also change PEAR.php by adding if (!function_exists("_pear_call_destructors()")){
before line
function _pear_call_destructors(){
also add } after end of Function.

JavaScript Dynamic content Generation Problem

2009-04-21T17:31:00.003+05:30

if you generate dynamic content through JavaScript by
document.write('<html><head><h2>'+ varHeading +'</h2></head><body></body></html>');
this page will works fine but if you generate more dynamic content from this page onward it will not display anything without any error.
Solution:
every phase should end with document.close();

MYSql 5 GROUP BY query not support Field Name "div"

2009-04-21T17:25:00.003+05:30

in MySql 5 query...
SELECT std,div,rollno,marks FROM result_data GROUP BY std,div
gives Error...
Error is due to field name div
Solution: Change Field Name div -> divi or other.

It works fine with MySql 4.

readonly not works in JavaScript DOM

2009-04-01T22:47:00.003+05:30

DOM- Javascript if you are using...
document.getElementById("idTest").readonly=true;
it will not work.
we have to use readOnly instead of readonly
correct is...
document.getElementById("idTest").readOnly=true;

csrcs.exe virus remove manually

2009-03-20T18:07:00.002+05:30

1. Go to Task manager and stop csrcs.exe Process ( csrss.exe is windows Process )
2. Go Command Prompt and go to system32 folder and change attrib -r -s -h csrcs*.*
3. Delete all csrcs*.* including dll and exe
4. run regedit and find entry for csrcs. mostly it will find two entry. delete them.( Pl be careful while edit registry.

local mdb data export to website backend mysql

2009-03-20T17:14:00.004+05:30

Problem: Laboratory Machine connected with rs232 update .mdb file on Local computer. We have to fetch this data from web page (web site running on service provider IIS/Apatche server) and send it to website Back-end MySql Server so everyone can use same data world wide.
Solution: Webpage in native PHP. write Javascript embedded into it with ADODB object...
var obj = new ActiveXObject("ADODB.Connection");
fetch data and assign it through document.getElementById and import to input tag name by same ID.
HTML:
input name=i1 type=text
JS:
document.getElementById("i1").value = jsVar;
PHP:
$PhpVar = $_GET["i1"]

To fetch Data from Local .mdb you can use systemDSN ODBC

var cObj = new ActiveXObject("ADODB.Connection");
var rS = new ActiveXObject("ADODB.Recordset");

rS.CursorLocation = adUseClient;
cObj.CursorLocation = adUseClient;

var iStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/userdata.mdb";
var adOpenKeyset = 1;
var adLockOptimistic = 3;
var adCmdText = 1;
var adUseClient = 3;
cObj.Open(systemDSN_Name) // or use cObj.Open(iStr)
var grStr = "SELECT * FROM table1 WHERE uid=12"



recSet.Open(grStr,cObj,adOpenKeyset,adLockOptimistic,adCmdText)
recSet.AddNew;
var id = rS.Fields("Name").value;

Important:
To Access SystemDSN from another Machine on your Intranet Pl share Folder with FullAceess(Read-Write) on which your .mdb file reside. If this ignore you will get Error: File already in use
Settings for IE:
access Data Source across domain - Prompt/Enable.
ActiveX Control/Script running - Prompt/Enable.

Income Tax Calculator India - FireFox Add-ons

2008-12-22T22:10:00.002+05:30

Launch FireFox Add-ons. on 21 Dec 2008.

Now Individual having Salary Income/Interest/Other Income can Calculate Income Tax Liabilities in India.

There are Deduction of mediclaim (80D) and Other 80C (1,00,000 limit) available.

Educational cess and Surcharge also considered.

Suggestions are most welcome.

Extension Developer zip fail to create xpi

2008-12-13T18:04:00.002+05:30

When You try to build xpi with Extension builder (Firefox 3.0 above) it gives error to create xpi file like zip failed.
Solution:
Please put xpi filename with extension
for example "helloworld.xpi" instead of "helloworld"

DriveGuard.exe Virus removal

2008-11-03T17:02:00.003+05:30

Symptoms:
DriveGuard is Microsoft tool for removal drive protection but if you not installed it and it shows in TaskManager as DriveGuard.exe it should be malware.

How to Remove:
1. Open Task Manager and End process DriveGuard.exe
2. Run regedit and search for "DriveGuard.exe"
3. Delete all entries with "DriveGuard.exe" (be careful while edit registry)
4. Also delete folder C:\Program Files\WinDriveGuard
5. Reboot the machine and check entry in task manager with DriveGurad.exe. It should not appear there.

firefox.exe malware removal

2008-11-03T16:29:00.003+05:30

Symptoms:
If you find firefox.exe process in task manager with around 3100k size than it is malware.
If you run Ccleaner than it gives message of opened firefox although firefox is not running.

To remove from the system(Windows).
1. boot system in safe mode.
2. run regedit
3. search for the "Stubpath" enetry
4. Mostly It shows "SecSecurity.exe"
5. Delete all "Stubpath" entries from registry ( Be Careful while edit Registry)
6. also remove SecSecurity.exe from Windows\System32
7. Boot in Normal mode
8. check in task manager not entry of firefox.exe around 3100k ( real Firefox entry is more in size)

Service Tax India New St3 Form

2008-10-19T17:57:00.005+05:30

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

2008-10-19T17:07:00.002+05:30

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

2008-10-19T16:51:00.003+05:30

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";

Jrun can not start

2008-01-19T20:08:00.000+05:30

after you edit jrun configuration from http://localhost:8000 or services jrun admin/cfusion can not start from anywhere (service mmc/jrun launcher). this issue is mainly related to java/jre home. if you are not updated with Jrun4 with updater7 than you can not use jre 1.5 or higher. to start jrun again edit file jvm.config (c:\jrun4\bin) and edit java.home line and make sure to use jre/jdk 1.4. also edit system variable JAVA_HOME to old version.
You can also update Jrun4 with updater7 to resolve this issue. after update you can use Java 1.5 and above.

Public Address System

2007-12-17T22:43:00.000+05:30

There is no need of very hi-fi sound system for public address. some time people select stereo/surround sound/5.1 for small auditorium which is of no advantage and expensive.
I select following sound system for 50 feet x 50 feet x 15 feet height Hall ( Gypsum celling for acoustic purpose). 120 students sitting Capacity.
1. 120W Amplifier (Ahuja Make) 5 + 2 Aux in.
2. 32W x 4 Nos of speakers.
3. Wireless Microphone.

Speaker should face opposite Microphone direction otherwise echo effect.

JAVA_HOME and JRE PATH

2007-10-08T23:09:00.000+05:30

Install Java2 SDK on linux. extract JDK in folder and edit .bashrc file in your root folder.
add following lines to .bashrc file as per your extracted folder and JDK version.
export JAVA_HOME=/home/download/java/jdk1.6.0_03
export PATH=${JAVA_HOME}/bin:${JAVA_HOME}/jre/bin:${PATH}

synchronizing view error in Eclipse Europa

2007-10-08T23:04:00.000+05:30

You can install plugins from
http://easyeclipse.org/site/plugins/eclipse-webdav-ftp.html
This works fine with eclipse 3.3 (europa). This will add ftp support.

MOZILLA_FIVE_HOME not set

2007-09-27T23:10:00.000+05:30

using Aptana with debian4.0 embedded browser path not set. use command
export MOZILLA_FIVE_HOME=/usr/lib/xulrunner/
do not use FireFox or Mozilla if using Eclipse 3.3 and newer. Xulrunner 1.8.1 and above is fine
details at http://www.aptana.com/docs/index.php/Installing_Aptana_Milestone_7_on_Linux#Other_Linux_Distributions
http://www.eclipse.org/swt/faq.php

Install HP 1020 printer with Linux

2007-09-25T16:16:00.000+05:30

Visit site http://foo2zjs.rkkda.com/ install driver and follow the instruction for different linux packages. do not forget to reboot the machine while your Printer on.

Debain 4.0 boot problem with XP dual boot

2007-09-25T16:00:00.000+05:30

Debain 4.o with Xp dual boot: Sometime after shutdown Xp and than boot with linux give ACPI exception errors like AE_NOT_FOUND or Searching for Mountpoint without activity.

Mostly Linux with DHCP enable trying for IP Address and Latest Motherboard onboard Lan Card can not initialize in Linux. It easily up under Xp. You can see link disconnection in your Lan Switch or onboard Lan LED.Your linux has to take IP from mostly with your ADSL Modem/Router so it fails to get IP and ends with error/loop.

To come out from this problem do not think in a big way just Power off (computer,ADSL Router and switch) from Main and restart everything will work fine.Check lan connectivity on switch before boot.

India Income Tax e-return upload Tips.

2007-09-06T13:02:00.000+05:30

ITR-3 version1.0 pdf utility has following bugs.
1. HUF return can not validate. to solve problem validate as Individual and than edit xml file with Status "H" instead "I".
2. Put 0 in all the fields which is nil otherwise it will validate but gives error at the time of upload.
3. edit xml with Refund = "0" if return has no refund.
4. edit xml for AdvanceTax and Self assessment tax as all advances goes to Advance Tax field.

ITR-5 ver 1.3 Excel utility upload succesfully but at end gives error and dose not shows ITR-V so go to my return and print ITR-V. if you try again to upload it says revised your return.

keep checking new version everyday and file with new version of utility

Sata Hard Drive not detected

2007-09-06T12:54:00.000+05:30

1. Check Power Cable as it is not standard supply. Replace it first.
2. Check Data Cable and try another.
3. Check your BIOS and Enable Serial ATA in the settings. Also keep default settings "AUTO" for the same.
4. Some old mother board requires 1.5 Gb/s transfer rate. Change the jumpers on the Hard drive if necessary.
5. Check for BIOS updates if available.

ccPrxy.exe SPOOLSV.EXE spyware removed

2007-08-16T16:57:00.000+05:30

First run MSCONFIG and go to startup and uncheck ccPrxy and SPOOLSV. Open FileZill or any other file utility and remove ccPrxy.exe(23k) and SPOOLSV.EXE(39k) from windows\system32. be careful and do not remove spoolsv.exe (lowercase), it is useful file for printing. restart the computer.
for any spyware/malware/virus please check windows, windows\system32, windows\system folder/directory for hidden files (on command prompt use dir /od /ah command) for latest hidden files. check dates and names of those file which are not related to windows system files may be virus files. ld.exe and ldu.exe and rm.exe hide in c:\windows folder. which spread through Flash drive on USB ports.
Remove all unnecessary hidden files on your Flash drive like autorun.inf, inform.exe. autorun.inf is most dangerous file for your Flash drive which spreads most of viruses through USB port.

Diwan Ballubhai Network

2007-07-22T11:53:00.000+05:30

Ethernet 10/100 Mbps Campus wide network completed on 12 July 2007 at Diwan Ballubhai School Kankaria. Now school has 24 Hrs unlimited Internet connectivity to all Corners. Network was designed by myself and deploy under my supervision.
5 Nos of 8 port switch, 2 Nos of 16 Port Switch, 1 No of Wire less Router, 700 mts length ethernet cable used. 256Kbps Internet connection with Static IP from Tata Installed
Connectivity to 1) All 4 Computer Labs. 2) Principal Offices (Pri and Main) 3) teacher room 4) New Libarary 5) Administrative office 6) Trust Office.
This gives me great self satisfaction. At least, I could give something back to the school. Nirav Sariya, Rajesh Shah, Anish Gandhi and Nehal from DBAA helped me lot to complete this project. I am also thankful for moral support from DiwanSaheb and PrafulbhaiSaheb who gave me freedom to work. Also Thankful to Principal Kiritbhai Joshi, Pri.Principal Anilbhai Raval, Sejalben, Darshnaben, Nitinbhai Raval, Hareshbhai, Vikrambhai, Jayeshbhai, Deshkarsaheb, Librarian Sunilbhai, Jayshreeben for their support.
Special Thanks to staff Bhuneshwarbhai, Dineshbhai and other staff who stand with us without watching clock.

I dnt hate FireFox

2007-07-14T10:40:00.000+05:30

I dnt hate Mozilla FireFox... message and close firefox after clicking OK button

Remove folder C:\heap41a and it all content. If not removed use FileZilla to remove it.

In registry search "heap41a" and remove all keys related to that.