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.

The support post ‘Large amount of older student registrations. Should I delete them?’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

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: closed

Updated by  Tony 5 months, 1 week ago ago

Topic Tags

Notifications

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