• Resolved 247web

    (@247web)


    How do I delete over 70 screenloads of submission data at once? I can only select the first 10 or so that are showing – no other way to select all the rest. Filtering date ranges also does not allow for Bulk delete of entries.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Imran – WPMU DEV Support

    (@wpmudev-support9)

    Hello @247web !

    Hope you’re having a good day!

    At the moment the only way to do this form the plugin itself is to delete them page by page.

    There is a way to do that from the database as the submissions are stored in separate tables.

    The general entries are being stored in the _frmt_form_entry table.

    The data specific to each entry is stored in the _frmt_form_entry_meta table.

    Please make sure to take a backup before proceeding further.

    For example, on my test site if I want to delete all submissions for form with ID 81, I would run the following queries from PHPMyAdmin:

    DELETE FROM wp_wl_frmt_form_entry_meta WHERE entry_id IN (SELECT entry_id FROM wp_wl_frmt_form_entry WHERE form_id = '81')

    This gets rid of all the metadata for that form and then we can delete the general entries:

    DELETE FROM wp_wl_frmt_form_entry WHERE form_id = '81'

    You’ll need to adjust the form ID and also the database table prefix which will likely be different than the wp_wl_ that’s on my test site.

    It doesn’t seem like we’ve had many requests for this feature as I can’t find any relevant task. I’ll create one based on your case.

    Kind regards,
    Pawel

    Plugin Support Amin – WPMU DEV Support

    (@wpmudev-support2)

    Hello @247web ,

    We haven’t heard from you for over 2 weeks now, so it looks like you don’t need our assistance anymore.

    Feel free to re-open this ticket if needed.

    Kind regards
    Kasia

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Bulk Delete 70 screens of Submissions data’ is closed to new replies.