Support

Home Forums Event Espresso Premium Large amount of older student registrations. Should I delete them?

Large amount of older student registrations. Should I delete them?

Posted: January 4, 2019 at 12:10 pm


Troy

January 4, 2019 at 12:10 pm

When I do a ‘Filtered CSV Report’ of my registrations I have 26366 in total dating to registrations back to Aug-2016. Is there any advantages / disadvantages in eliminating much of this old data? If I were to remove some of these old registrations, how would I remove it.


Tony

  • Support Staff

January 7, 2019 at 4:19 am

Hi there,

When I do a ‘Filtered CSV Report’ of my registrations I have 26366 in total dating to registrations back to Aug-2016.

The ‘Filtered CSV button’ applies any filters you currently have set on the table and exports the registrations, if your getting all of your registrations are you not setting any filters first? If not then its the same as the ‘All Registrations CSV’ button.

Is there any advantages / disadvantages in eliminating much of this old data?

Advantages, not really, a reduced database size maybe. 26,000 entries may seem like a lot but your database is designed to handle millions of rows.

The disadvantage I can think of is the data would no longer be available, but that depends on what data you need.

If I were to remove some of these old registrations, how would I remove it.

At this time EE doesn’t do cascading deletes to remove all of the data, so to remove a registration you first edit the transaction for that registration (Event Espresso -> Registrations -> {registration} -> View Transactions).

Delete any payments within the transaction – https://monosnap.com/file/hqIWRPD4kBoYia9yVlaGxPWFM4tV4P

Then go back to the registration list, select the registration and trash it.

Finally look in the ‘Trash’ view and remove the registrations completely.

You’d need to do that for each individual registration you want to remove.

You must be logged in to reply to this support post. Sign In or Register for an Account

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: publish

Updated by  Tony 1 week, 2 days ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!