Export Excel CSVs with Double Quotes

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!

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

-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

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

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

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

Fatal error: Cannot redeclare _pear_call_destructors()

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.