i want to delete about 80% of the results, going through one by one is tedious...is there functionality to either

view the source table, or download and re-upload the table?

otherwise might be nice to have a 'remove' checkbox by each entry as is common with other modules.

otherwise super module, thanks!

Comments

quicksketch’s picture

quicksketch
he/him
commented

view the source table, or download and re-upload the table?

There's not built-in system for this, though you can remove submissions directly through SQL:

DELETE FROM webform_submissions WHERE sid < XX;
DELETE FROM webform_submission_data WHERE sid < XX;
petergus’s picture

petergus commented

thanks!
how bout the ability to reupload the table....
sorry if this way over my legue, im no sql user, but seems it could be a cool feature to be able to add to a webforms results from the backend.

petergus’s picture

petergus commented
Category: support » feature

change to feature request ;)

quicksketch’s picture

quicksketch
he/him
commented
Status: Active » Closed (won't fix)

sorry if this way over my legue, im no sql user, but seems it could be a cool feature to be able to add to a webforms results from the backend.

We definitely won't be adding any such feature, though I've seen some modules provide this functionality for Webform. See http://drupal.org/project/webform_import

ngreenup’s picture

ngreenup commented

What about mass deleting entries from only one webform? I guess I am looking for restricting the provided SQL to a specific webform nid.

vernond’s picture

vernond commented

You shouldn't be posting to closed issues, it's better to open a new one.

To answer your query in any case, to delete some submissions for a particular form you could use 

DELETE FROM webform_submissions WHERE nid = XX and sid > YY;
DELETE FROM webform_submission_data WHERE nid = XX and sid > YY;

To delete all submissions for a particular Webform you could go to the Results tab and click Clear.