How to specify CSV separation character

  • Resolved ralphhorvath

    (@ralphhorvath)


    12 years ago

    I use the “|” symbol to separate my table columns, but Tablepress wants to use the “/” separator, which I need to use to specify the time signature in a music database. As a result, Tablepress always separates the columns incorrectly and doesn’t seem to recognize the “|” as my separator. Is there any way to specify a particular separator to import a table? I can’t use the other common separators like commas because they have other meanings in the database. My file is saved as UTF-8.

    · Website: http://horvathcampbell.com
    · TablePress: 1.4
    · TablePress (DB): 24
    · TablePress table scheme: 3
    · Plugin installed: 2014/04/13 20:48:30
    · WordPress: 3.9
    · Multisite: no
    · PHP: 5.4.28
    · mysqli Extension: false
    · mySQL (Server): 5.5.33-31.1
    · mySQL (Client): 5.5.33
    · ZIP support: yes
    · UTF-8 conversion: yes
    · WP Memory Limit: 40M
    · Server Memory Limit: 256M
    · Magic Quotes: off
    · WP_DEBUG: false
    · WP_POST_REVISIONS: true

    https://wordpress.org/plugins/tablepress/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    12 years ago

    Hi,

    thanks for your post, and sorry for the trouble.

    The | is indeed not among the list of “preferred” delimiters, so that basically the most common character in a row wins (plus some other checks).
    The fix here might be as easy as extending the list of preferred characters. For that, please change the line 32 in the file “libraries/csv-parser.class.php” from

    protected $preferred_delimiter_chars = ";,\t";

    to

    protected $preferred_delimiter_chars = ";,\t|";

    That should lead to the | being recognized properly.

    Regards,
    Tobias

    Thread Starter ralphhorvath

    (@ralphhorvath)

    12 years ago

    I’m a newbie, so please tell me where I can find the folder “libraries/csv-parser.class.php” on my Mac. I can’t find it using my normal search methods.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    12 years ago

    Hi,

    that file is not on your Mac, but it’s a file that belongs to TablePress, so that you will find it in the folder /wp-content/plugins/tablepress/libraries/ on your server. Thus, you’ll have to use your FTP client to reach it.

    Regards,
    Tobias

    Thread Starter ralphhorvath

    (@ralphhorvath)

    12 years ago

    Thanks for educating me. Your responsiveness has been better than many services I pay for, so I’m going to make a donation to TablePress.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    12 years ago

    Hi,

    no problem, you are very welcome! 🙂 Good to hear that this helped!
    And thanks for the donation, I really appreciate it!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘How to specify CSV separation character’ is closed to new replies.