Thanks for putting in the effort

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

• This topic was modified 8 years, 1 month ago by Richard K.