WordPress.org

Ready to get started?Download WordPress

Forums

Contact Form DB
[resolved] Export CSV and break return (6 posts)

  1. fyoo
    Member
    Posted 1 year ago #

    When i export a csv of my submit table, there are some break return from textarea.
    And when i want import my csv in another table the cell are not ordered.

    How can i fix this ? knowing i have almost 40 forms on my website.

    http://wordpress.org/extend/plugins/contact-form-7-to-database-extension/

  2. Michael Simpson
    Member
    Plugin Author

    Posted 1 year ago #

    The CSV export is coded to faithfully export what is in the fields including newline characters. The TSV format does not permit newlines in a field, therefore its export converts them to a space. Perhaps TSV will be a better choice for you.

    To order your rows the way you want, go to the Database Short Code page in the WP administration area. Instead of creating a short code, choose an "Export File" to create an export link. Further down the page set "orderby" to set your desired order.

  3. fyoo
    Member
    Posted 1 year ago #

    When i export with TSV and try to re-import in phpmyadmin, it creates only 2 columns, and not one for each of my fields :(
    http://img51.imageshack.us/img51/5020/capturedecran20121114a1.png
    Thx for help ;)

  4. Michael Simpson
    Member
    Plugin Author

    Posted 1 year ago #

    The CSV and TSV export is not intended to allow you to import the information back into the plugin's DB. The exported data is not in the same format as the database table.

    If you want to export then import back into the DB then use PHPMyAdmin's export and import.

  5. fyoo
    Member
    Posted 1 year ago #

    I don't try to import data in the plugin DB but in another table of another base.
    I clearly can't ask to my users to export from phpmyadmin.

  6. fyoo
    Member
    Posted 1 year ago #

    Ok Michael, the TSV seems to be a good solution :)
    Thanks for your help !

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic