#1418 (ok 4.2) Support more than one separating character on CSV import

[Z0l0ft]

CSV Import of CVS file; typically having format:

0, "a", "b", "c", 33
1, "x", "d", "f", 23

Using ', ' as value for "Columns separated with" gives error:

***Invalid parameter for CSV import: Columns terminated by***

Same in 3.5.5, upgraded to 3.5.7, and no better.

Similar query in mysql cli:

mysql> LOAD DATA INFILE '/res/base/csv/sysfs_pt.csv' 
    INTO TABLE sysfs_pt 
    COLUMNS TERMINATED BY ', ' 
    OPTIONALLY ENCLOSED BY '"' 
    LINES TERMINATED BY '\n';
Query OK, 256 rows affected (0.10 sec)
Records: 256  Deleted: 0  Skipped: 0  Warnings: 0

Haven't had the time to look into what is causing it, so post with no more

[Kshitij Awadhiya]

Okay . I am a new member Kshitij Awadhiya. Please assign this bug to me. i want to solve it.

Temporary Solution : Just put a blank space character in 'Columns escaped with:' . It works fine that way.

Thank You

[Kshitij Awadhiya]

By the way , I fixed it. Atleast the above problem is solved. I welcome changes/edits/suggestions or other testcases where this may fail.
This patch is working for version 3.5.7 successfully.

What is the correct way to submit a patch ?

[Marc Delisle]

To submit a patch, see http://www.phpmyadmin.net/home_page/devel.php

[Marc Delisle]

With the patch 3867.txt, I still have the problem.

[Marc Delisle]

phpMyAdmin supports just one character as the delimiter, even if LOAD DATA INFILE seems to support more than one.

Moving to feature requests.

[Marc Delisle]

Ticket moved from /p/phpmyadmin/bugs/3867/

[Smita Kumari]

Hey,
I have tried fixing it , I have modified the inmportCsv plugin to use string for column_Seperated_With parameter as MySql support string for the same. Working fine me, Here is the commit. https://github.com/smita786/phpmyadmin/commit/843e5680865d68c4120ea667a6f45ea4a01abd5e
Please review if it'll work, waiting for your feedback!
Thanks