• 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.
  • The topic ‘Thanks for putting in the effort’ is closed to new replies.