Forum Moderators: open

Message Too Old, No Replies

phpmyadmin csv Fields terminated by

         

dtest

11:03 pm on Oct 29, 2007 (gmt 0)

10+ Year Member



where in the phpMyAdmin code can I change the default csv Fields terminated by value?

every time I want to import a .csv file I have to change ";" to "," and would like this to be permanently ","

Discovery

8:42 am on Oct 30, 2007 (gmt 0)

10+ Year Member



I am not sure, but you can take just as hint, there is file called "export.php" most probably in this file only. Just debug this file , hope you will find sol.

dtest

11:58 am on Oct 30, 2007 (gmt 0)

10+ Year Member



I already looked there and also in import.php and in libraries/import/csv.php but I haven't been able to find it

dtest

12:33 pm on Nov 7, 2007 (gmt 0)

10+ Year Member



anyone?

coopster

11:36 pm on Nov 8, 2007 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



Welcome to WebmasterWorld, dtest.

config.inc.php looks like the place to make the adjustment.

dtest

8:41 am on Nov 9, 2007 (gmt 0)

10+ Year Member



I finally found it in libraries/config.default.php

the line to change was $cfg['Import']['csv_terminated'] = ';';