Bill Erickson

<p>More formal documentation is coming, <a href="https://wordpress.org/support/topic/plugin-interstrategy-events-manager-documentation?replies=5#post-2393218" rel="ugc">but here’s a start</a></p>


Interstrategy Events Manager

s-hinse

<ul>
<li>Addon for the Events Manager Plugin. https://wordpress.org/plugins/events-manager/
<ul>
<li>Exports all events and their locations into a csv file.</li>
<li>Choose comma or semicolon as CSV delimiter</li>
</ul>
</li>
</ul>
<h3>Usage</h3>
<ol>
<li>Go to <code>Events->Export</code> events as CSV</li>
<li>Choose your delimiter</li>
<li>Click the “Download”-button to get your CSV file.</li>
</ol>
<h3>Excluding fields from the CSV export</h3>
<p>By default, the plugin does not export the following fields:<br />
            ‘event_id’,<br />
            ‘post_id’,<br />
            ‘event_owner’,<br />
            ‘event_status’,<br />
            ‘blog_id’,<br />
            ‘group_id’</p>
<p>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.</p>


Export events to CSV (Addon for Events Manager)

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'
		);



Thanks for putting in the effort

Export events to CSV (Addon for Events Manager Plugin )

Interstrategy Events Manager vs Export events to CSV (Addon for Events Manager)