Exporting By Date – help :(

  • mccintranet

    (@mccintranet)


    9 years, 10 months ago

    Hi Michael,

    I am trying to figure out how to export my form data with Contact Form DB by date? So if I just want to pull all of the data for June, for example. Otherwise, it is a huge file I’m pulling each time, and will continue to get bigger each month it builds up.
    I’ve figured out how to pull all of my forms data at once, by using the “*”, and export. But not sure how to do it by date.
    Can someone walk me through it, if its possible? I need it to export ALL forms data, not just one form, so need to use the “*” piece as well.

    Thanks so much,

    Trevor

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    9 years, 10 months ago

    Shortcode builder page, create an Export link, filter rows by submit_time
    http://cfdbplugin.com/?page_id=553

    Thread Starter mccintranet

    (@mccintranet)

    9 years, 10 months ago

    Thank you Michael. But how do I choose to export ALL the forms for that time period? The first box has a drop down to choose a specific form, but I have MANY that I want to export all at once (would take forever to do them individually)
    I’ve never used the short code builder so I don’t know what I’m supposed to put in each of the field/boxes it’s requesting (a step by step for what I should ente in each section would be great 🙂
    For example when it asks which fields I want to display or what rows I want to display, etc …. If I want ALL of them for that time period, do I just leave them blank and it defaults to all?
    And then once I fill everything in … I don’t see a Submit button to activate the export.

    Sorry, I’m definitely in the learning phase for this, though I have loved that I’ve been able to export using this plugin up to this point! Just haven’t mastered how to choose specific time frame 🙂

    Thanks for your guidance,

    Plugin Author Michael Simpson

    (@msimpson)

    9 years, 10 months ago

    Be sure you have updated to the latest version of CFDB.

    1. Go to the CFDB Shortcode page
    2. Select Export tab
    3. Select from Export File
    4. Go to From tab
    5. Select the last in the list, * All Forms *
    6. Go to Rows tab
    7. In the filter expression field, you can just type in something like:
      submit_time>June 1, 2016&&submit_time<July 1, 2016 which would give you entries for June.
    8. click the link that is generated for you in yellow under Generated Export Link
      . An export file should download.
    9. Copy the link and save it somewhere for future use.
    10. You can also: Switch to Shortcode tab
    11. Select Shortcode [cfdb-export-link]
    12. Copy that shortcode and put it on a private page or post where you would like to go to click the link and create a download in the future
Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Exporting By Date – help :(’ is closed to new replies.