PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Export all entries at once

  1. This feature would be incredible for those with multiple forms. In the export entries option, the ability to export all entries from all forms in a certain date range... but in 1 CSV file.

    It would also be a HUGE time saver!

    Posted 13 years ago on Thursday December 1, 2011 | Permalink
  2. All entries across all forms in a single CSV? Can you give me an example use case?

    I ask because every form can be different so the CSV data for each would involve different delimited content and headers. so it's a bit strange to export all of them in a single CSV file.

    Posted 13 years ago on Thursday December 1, 2011 | Permalink
  3. I would like this feature but not all in one CSV because I have too many different forms. I would just like an export all so I can put it in google docs. So actually if there was a way to export the entries into google docs that would be even better...

    Posted 13 years ago on Friday December 16, 2011 | Permalink
  4. I would love this feature as well...I have a client who recently got over 500 responses to a single form (within a week's time), and they need a quick way to export and manipulate that data all at once.

    Posted 13 years ago on Wednesday December 21, 2011 | Permalink
  5. Kristel, you can export all entries for one form now. These individuals are asking for a way to export all entries across all forms. What you want to do is currently possible. Are you having trouble with that?

    Posted 13 years ago on Wednesday December 21, 2011 | Permalink
  6. Oh, whoops, so sorry! Yes, this is what I'm looking for, but can't seem to figure it out. Is there a link to instructions?

    Posted 13 years ago on Wednesday December 21, 2011 | Permalink
  7. ookay...never mind. This idiot figured it out. Not only was it easy to find, but I was also looking in Forums instead of Documentation to figure out how (insert embarrassed icon here).

    Posted 13 years ago on Wednesday December 21, 2011 | Permalink
  8. No problem Kristel. Happy Holidays!

    Posted 13 years ago on Wednesday December 21, 2011 | Permalink
  9. Use case: Having multiple quizzes (each its' own form) that all have fields for name and email of person taking the quiz. Being able to extract all forms at once (with common fields) would let me see how students are progressing across the total course range w/o having to extract each form manually.

    Or an automated way to extract a set number of forms.
    This thread - http://www.gravityhelp.com/forums/topic/how-to-set-up-scheduled-export-with-a-cron-job - teases at some partial answers.

    Posted 11 years ago on Tuesday April 30, 2013 | Permalink
  10. David Peralty

    Thanks Jamie. I'll remind the team to take a look at this.

    Posted 11 years ago on Tuesday April 30, 2013 | Permalink
  11. A short-term solution I am close to being satisfied with is to record a Selenium IDE script of moving through the steps required on your browser. This will at least get you all of the desired files onto your PC which can then be merged into a single .xls or other format file.

    A couple of important notes that relate to my example script image

    1. Uses Firefox Selenium IDE
    2. Assumes you have username stored in browser and logs in/out at start / end of each run. Quite possible to automate from the starting point of being logged into dashboard too
    3. Selenium > Options > Locator Builders - Move ID and CSS above UI. Makes your recordings a LOT easier to read and tweak by hand.
    4. The biggest challenge with Selenium is that it doesn't deal with file download prompts (at all). There's lots of support questions about this but gist is that it is an OS integration thing. In Firefox I selected the auto save dialog prompt. Lose control over location files are saved to your last download location, but gain the ability to execute multiple test cases without user interaction.
    5. If you're careful about column selection - you should be able to do a merge of .csv files in the path via "copy *.csv newfile.csv" and have one file to work with - except with a repeated number of header rows. At this point though you've got local file options to handle batch / parse / trim activities.

    From reading many other threads, the idea of scheduled jobs seems to be far off on the feature horizon, might an interim step of being able to do an export of multiple forms at same time be possible? Few ideas towards that:

    • Only show common field names for export
    • One header row in result
    • Optional new field that identifies which form generated the result
    Posted 11 years ago on Wednesday May 1, 2013 | Permalink