Custom Contact Forms
export troubles, newlines and html encodes (1 post)

  1. erikonthenet
    Posted 4 years ago #


    A client of mine uses the custom-contact-form plugin. When exporting the submissions to a csv file, he encountered some troubles lately.

    The troubles are:
    1. multi-lined fields are exported on multiple lines in the csv. This is also interpreted as multiple lines by a spreadsheet program like Excel. This then looks like a mess.
    2. Some characters are encoded when stored the database. For example the &-sign is encoded as & and the quote (') is encoded as ' When exporting the encoding is not translated. Because the delimiter is also a semicolon, Excel interprets this as extra fields. This also messes things up pretty good in Excel.

    How did I solve this? By removing the newline characters, and by decoding the special characters.

    Old code (in file modules/export/custom-contact-forms-export.php):
    $line[] = $data->parseUserData($data_array[$k], true);

    New code:
    $temp = $data->parseUserData($data_array[$k], true);
    $temp = str_replace ( "\r\n", " ", $temp );
    $temp = htmlspecialchars_decode($temp, ENT_QUOTES);
    $line[] = $temp;

    With kind regards,
    Erik Loosman


Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Custom Contact Forms
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic