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

Next_release
fixed
None
1
2015-02-13
2013-04-03
Z0l0ft
No

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

Discussion

  • 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

     
    Last edit: Kshitij Awadhiya 2013-04-06
  • 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

    Marc Delisle - 2013-04-08
    • assigned_to: Marc Delisle
     
  • Marc Delisle

    Marc Delisle - 2013-04-08

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

     
  • Marc Delisle

    Marc Delisle - 2013-04-08

    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

    Marc Delisle - 2013-04-08

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

     
  • Marc Delisle

    Marc Delisle - 2013-04-08
    • assigned_to: Marc Delisle --> nobody
    • milestone: 3.3.7 --> Needs_decision
     
  • Marc Delisle

    Marc Delisle - 2014-02-25
    • summary: CSV Import fails with tailing space on "Columns separated with". --> (ok 4.2) Support more than one separating character on CSV import
    • status: open --> resolved
    • assigned_to: Marc Delisle
    • Group: Needs_decision --> Next_release
    • Priority: 5 --> 1
     
  • Marc Delisle

    Marc Delisle - 2014-05-21
    • Status: resolved --> fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks