Support

Home Forums Event Espresso Premium Exporting Archived Events

Exporting Archived Events

Posted: July 15, 2016 at 1:12 pm


Aneleise Ruggles

July 15, 2016 at 1:12 pm

I am trying to export event data for analysis purposes, but it appears I am only able to exports events that have not been archived/”deleted.” Is there a way to export all event data history, besides going in to each archived event and reactivating it? When I export attendee data, I don’t seem to have this problem and the files contain the full registration history including records associated with archived /deleted events. Thanks.


Josh

  • Support Staff

July 18, 2016 at 10:07 am

When you mention that the event has been archived/deleted, what’s the status of that event? Is it a “deleted” event? It sounds like the events were deleted, and EE3 does not query the data from deleted events when it runs the reports. Your way forward is to not delete the events.


Aneleise Ruggles

July 18, 2016 at 10:39 am

Does EE4 support this function? Is there any way to export information from deleted events with our current version? If not, is there an efficient way to reactivate deleted classes?


Josh

  • Support Staff

July 18, 2016 at 12:25 pm

EE4 works much the same way, when you delete an event, the data for that event isn’t queried.

While Event Espresso 3 doesn’t have a way to bulk un-delete your deleted events, there’s a way to edit the event status directly using phpmyadmin, which could be run as a query using that same tool.


Aneleise Ruggles

July 19, 2016 at 6:28 am

I think my solution will be to work within the attendee export, because that includes all event data just in a different format.

Moving forward, I am wondering if you could recommend a solution for organizing completed events so they don’t appear on the front end of our website. We use this system as a class registration database and typically people are using the search bar tool to access classes and we reuse class names and codes yearly. The problem with this is that when you search for an event, it populates with all possible options including past offerings, which can be bulky and confusing.

Is there a status we can set old classes to that will allow them to be extracted but also will eliminate their visibility from our website completely?


Josh

  • Support Staff

July 19, 2016 at 9:15 am

Does your site’s event search function use the [EVENT_SEARCH] short code?


Aneleise Ruggles

July 19, 2016 at 1:28 pm

Yes it does.


Josh

  • Support Staff

July 20, 2016 at 10:06 am

The results from the search bar that’s output by the [EVENT_SEARCH] short code should only show events that have open registration. Do your past events have Registration End dates in the future or the past? Maybe you can post a link to the page that has the search bar and let us know what to search for so we can investigate further.


Aneleise Ruggles

July 20, 2016 at 10:46 am

Past events typically have a Registration End date that coincides with the Event Start Date (same day or day before), so all past events have Registration End dates in the past.

Here is our search page: http://arsenalarts.org/search-classes/

An example of something to search: If you search “Comic & Cartoon Characters” or course code “C33” it will populate with all offerings of that class during our summer session, including weeks that have already passed. Even simply using the keyword “Comic” will populate a list that includes past events that are not yet deleted that occurred in the past as well.

Thanks for checking this out!


Josh

  • Support Staff

July 20, 2016 at 11:11 am

I’m getting different results where it’s only showing events in the future. Here’s an example of the results of a search for “Comic & Cartoon”:

https://slack-files.com/T02SY781D-F1TGSKUM6-7e45936b17


Aneleise Ruggles

July 20, 2016 at 11:56 am

The drop-down menu that appears when you begin typing is where that past events are appearing (see attached image). I’m not sure if there is in fact a remedy for this.

It is good to know that it isn’t appearing when it brings you to the results page. We may just have to resolve to live with this quirk in the drop down results.

Thanks very much for taking the time to review all of this.


Aneleise Ruggles

July 20, 2016 at 12:11 pm

In case that link didn’t work –


Josh

  • Support Staff

July 20, 2016 at 1:36 pm

There’s a way to not show any old events in the autocomplete options. You install a custom short code plugin to your site, and you replace the [EVENT_SEARCH] short code with [UPCOMING_EVENT_SEARCH].

Here’s a direct link to that custom short code plugin that can be used with Event Espresso 3:

https://gist.github.com/joshfeck/97cde63b2919ee671797fbbed8f1dba1/archive/f34014e435359e07074eea02986d31ae66bfe849.zip


Aneleise Ruggles

July 21, 2016 at 9:39 am

Thanks. The file you sent is a .php file – should I upload that to a certain directory? Or is there a page for the plugin where I can initiate an installation via the wordpress?


Josh

  • Support Staff

July 21, 2016 at 9:58 am

If you leave the file unzipped (you’ll note that there’s a .zip at the end of the URL) you can install it via the WordPress > Plugins > Add new page.


Aneleise Ruggles

July 21, 2016 at 10:19 am

I installed the plugin and activated it. The Upcoming Events shortcode doesn’t seem to be working… It just shows up as text on the site.


Josh

  • Support Staff

July 21, 2016 at 10:35 am

I checked on this, and it’s because your site is running Event Espresso 3.1.36.4. There’s a minimum version check in the plugin I sent you. You could either update to the current version of Event Espresso 3 or at the very bottom of the plugin file change this:

function espresso_shortcode_init() {
  if ( function_exists( 'espresso3_duplicate_plugin_error' ) ) {
    add_shortcode('UPCOMING_EVENT_SEARCH', 'ee_create_autocomplete_search_upcoming_events');
	}
}

to be this instead:

function espresso_shortcode_init() {
  add_shortcode('UPCOMING_EVENT_SEARCH', 'ee_create_autocomplete_search_upcoming_events');	
}


Aneleise Ruggles

July 21, 2016 at 12:06 pm

That fixed the problem and everything seems to be working now. Thanks very much for your help with all of this.

The support post ‘Exporting Archived Events’ 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.

Event Espresso