WordPress.org

Ready to get started?Download WordPress

Forums

Email Before Download
Email Before Download CSV file error (8 posts)

  1. kostaspngs
    Member
    Posted 9 months ago #

    My site is Spoken English Books.I have problem with CSV file. Open the file and all data is in mess. For example
    For every email items are on A cell and appear:
    3,χχχχχχχ@gmail.com,ΧΧΧΧΧΧ,110,0,,grammar-excercises-present-tenses1.pdf,2013-09-20 23:58,<?xml version="1.0"?> <posted_data><_wpcf7>56</_wpcf7><_wpcf7_version>3.5.2</_wpcf7_version><_wpcf7_locale>en_US</_wpcf7_locale><_wpcf7_unit_tag>wpcf7-f56-p104-o1</_wpcf7_unit_tag><_wpnonce>7fb3ad1f6b</_wpnonce><your-name>XXXXXX</your-name><your-email>XXXXXXX@gmail.com</your-email><_wpcf7_download_id>3</_wpcf7_download_id><_wpcf7_is_ajax_call>1</_wpcf7_is_ajax_call><your-message>The downloaded file name(s): grammar-excercises-present-tenses1.pdf</your-message></posted_data> ,Inline Link

    I don 't know what i can do. Any ideas please?

    http://wordpress.org/plugins/email-before-download/

  2. mandsconsulting
    Member
    Plugin Author

    Posted 9 months ago #

    Hi kostaspngs,

    Thank you for the interest in our plugin. We are not sure what is your issue. From the snip-it you sent we can see a piece of generated csv file.
    This is the column we store everything sent by Contact Form packed as XML.
    You can ignore this field for now.

  3. kostaspngs
    Member
    Posted 9 months ago #

    Thank for your response to my post!

    My problem is: How to collect emails from this CSV file?? All data is in mess!
    For example, if i have 100 emails per day, how to collect them form csv file which is in mess. All data is on A cell as α result i can 't seperate emails from other data in the same cell.

    A above piece of generated csv file is one email on A cell. Thinking that I must separate one by one all of the remaining 100 emails.

    Do you understand what i mean?

  4. mandsconsulting
    Member
    Plugin Author

    Posted 9 months ago #

    Hi kostaspngs,
    When it is saved the csv file has the following fields(columns):
    item_id,email,download_id,filename,item_title,time_requested,posted_data,delivered_as
    As we understand what you actually need is the "email" field. So you can just get it and ignore the rest.
    One question, what program you use to read this file?

  5. kostaspngs
    Member
    Posted 9 months ago #

    item_id,email,download_id,filename,item_title,time_requested,posted_data,delivered_as
    All of these are in the same column. I can 't mark the email field and get all the emails together.

    Does not display the data in different columns. For example item_id to column A, email to column B, download_id to column C, etc.

    I used microsoft excel.

  6. mandsconsulting
    Member
    Plugin Author

    Posted 9 months ago #

    Hello kostapngs,

    The way out csv generation works, it only can see fields when they are left at the default name. If you have more fields to capture or their names have been changed, it puts them all in that XML format for parsing. Since you are getting everything in cone column, I'm going to assume that a field name has been changed. Unfortunately that is the way that the csv file will appear, though XML documents can be fairly easily parsed.

    This is a feature we are looking to add in the near future however.

  7. emiliegiraudet
    Member
    Posted 8 months ago #

    Hello,

    I have the same problem and I use Contact From DB plugin to solve it.

    With this plugin you can download clean CSV export and many other format.

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

    Hope it will help you.

  8. kostaspngs
    Member
    Posted 8 months ago #

    Thank you! This plugin solve this problem somehow!

Reply

You must log in to post.

About this Plugin

About this Topic