FAIR

Federated and Independent Repositories

Export events to CSV (Addon for Events Manager)

Plugin Banner

Export events to CSV (Addon for Events Manager)

by s-hinse

Download
Description
  • Addon for the Events Manager Plugin. https://wordpress.org/plugins/events-manager/
    • Exports all events and their locations into a csv file.
    • Choose comma or semicolon as CSV delimiter

Usage

  1. Go to Events->Export events as CSV
  2. Choose your delimiter
  3. Click the “Download”-button to get your CSV file.

Excluding fields from the CSV export

By default, the plugin does not export the following fields:
‘event_id’,
‘post_id’,
‘event_owner’,
‘event_status’,
‘blog_id’,
‘group_id’

If you want to add or remove fields from the selection, you can use the filter ’em_events_csv_export_unwanted_keys’ to modify it.

This section describes how to install the plugin and get it working.

  1. Upload the plugin files to the /wp-content/plugins/export-em-events-to-csv directory, or install the plugin through the WordPress plugins screen directly.
  2. Activate the plugin in WordPress backend, make sure you have installed and activated Events Manager first.

Thank you!

By zzkamikazezz on August 8, 2017

VERY useful add on.

Thanks for putting in the effort

By Richard K (rkorebrits) on October 11, 2016

Thanks for the effort and for publishing your plugin! 🙂 It would have been nice to be able to select the fields that are sent to the files. I ended up amending the plugin on www/wp-content/plugins/export-em-events-to-csv/inc/Exporter.php 

		$query  = sprintf( '
			SELECT e.event_id
			     , e.post_id
			     , e.event_name
			     , e.event_start_date
			     , l.location_name
			     , l.location_country
			     , pm1.meta_value host_name
			     , pm2.meta_value host_email
			FROM %1$s
			INNER JOIN %2$s ON (e.location_id=l.location_id) 
			LEFT JOIN %3$s pm1 ON (e.post_id=pm1.post_id AND pm1.meta_key = "_event_owner_name") 
			LEFT JOIN %3$s pm2 ON (e.post_id=pm2.post_id AND pm2.meta_key = "_event_owner_email") 
			',
			$prefix . 'em_events e',
			$prefix . 'em_locations l',
			$prefix . 'postmeta'
		);

1.3

  • add export of event tags and event categories (props to @nbwpuk) *
  • add current time to date in export file name (props to @nbwpuk) *

1.2.1

  • run in backend only
  • remove blank space in filename that causes errors in some configurations
  • set minimum required PHP version to 5.6.
  • display errors as admin notice

1.2

  • adapt to fit database structure of current events manager plugin for custom attributes
  • add filter to remove unwanted fields from the CSV
  • add option to remember the last used delimiter
  • fixed bug that caused a php warning

1.1.1

  • fixed bug where csv output is messed up if first event has no custom attributes

1.1

  • added choice of delimiter

1.0

  • first version
Back to top