WPExperts.io

myCRED

<p>📢🚨 <strong>Important Notice: myCred for Events Manager Pro is now part of the <a href="https://wordpress.org/plugins/mycred-toolkit/" rel="ugc">myCred Toolkit</a> and will no longer receive updates here. Only security fixes will be provided.</strong></p>
<p>This free plugin connects myCred with Events Manager Pro. While myCred has built-in support for the free version, this plugin is required as of version 1.7.9.1 to support the PRO version.</p>
<h4>Built-in Support</h4>
<p>Here are the most notable features of myCred for Events Manager Pro plugin.</p>
<ul>
<li>Allow users to pay for tickets using points.</li>
<li>Setup your event booking to only accept points as payment.</li>
<li>Supports Multibookings.</li>
<li>Supports Manual Approvals of bookings.</li>
<li>If users can cancel bookings, you can select to refund their point payment.</li>
<li>Supports profit sharing with event owners.</li>
</ul>
<h4>Plugin Requirements</h4>
<ul>
<li><a href="https://wordpress.org/plugins/mycred/" rel="ugc">myCred 1.8+</a></li>
<li><a href="http://wp-events-plugin.com/" rel="nofollow ugc">Events Manager Pro</a></li>
<li>WordPress 5.0+</li>
<li>PHP 5.3+</li>
</ul>
<h4>More myCred Freebies Integrations</h4>
<ul>
<li><a href="https://mycred.me/store/mycred-h5p" rel="nofollow ugc">myCred H5P</a></li>
<li><a href="https://mycred.me/store/mycred-credly" rel="nofollow ugc">myCred Credly</a></li>
<li><a href="https://www.mycred.me/store/mycred-learndash/" rel="nofollow ugc">myCred – Learndash</a></li>
<li><a href="https://www.mycred.me/store/mycred-lifterlms-integration" rel="nofollow ugc">LifterLMS Plugin Integration with myCred </a></li>
<li><a href="https://www.mycred.me/store/mycred-bp-group-leaderboards" rel="nofollow ugc">myCred BP Group Leaderboards</a></li>
<li><a href="https://www.mycred.me/store/mycred-for-event-espresso-4" rel="nofollow ugc">myCred for Event Espresso 4.6+</a></li>
<li><a href="https://mycred.me/store/mycred-for-wp-pro-quiz/" rel="nofollow ugc">myCred for Wp-Pro-Quiz</a></li>
<li><a href="https://www.mycred.me/store/mycred-for-rating-form" rel="nofollow ugc">myCred for Rating Form</a></li>
<li><a href="https://www.mycred.me/store/mycred-birthdays" rel="nofollow ugc">myCred Birthdays</a></li>
<li><a href="https://www.mycred.me/store/mycred-for-wp-postviews" rel="nofollow ugc">myCred for WP-PostViews</a></li>
<li><a href="https://mycred.me/store/mycred-for-totalpoll" rel="nofollow ugc">myCred for TotalPoll</a></li>
<li><a href="https://www.mycred.me/store/mycred-gutenberg" rel="nofollow ugc">myCred Gutenberg</a></li>
<li><a href="https://www.mycred.me/store/mycred-for-buddypress-compliments" rel="nofollow ugc">myCred for BuddyPress Compliments</a></li>
<li><a href="https://www.mycred.me/store/mycred-retro" rel="nofollow ugc">myCred Retro</a></li>
<li><a href="https://www.mycred.me/store/mycred-for-courseware" rel="nofollow ugc">myCred for Courseware</a></li>
<li><a href="https://www.mycred.me/store/mycred-for-gd-star-rating" rel="nofollow ugc">myCred for GD Star Rating</a></li>
<li><a href="https://mycred.me/store/mycred-for-buddypress-links" rel="nofollow ugc">myCred for BuddyPress Links</a></li>
<li><a href="https://mycred.me/store/mycred-for-bp-album-bp-gallery" rel="nofollow ugc">myCred for BP Album and BP Gallery</a></li>
<li><a href="https://mycred.me/store/mycred-elementor/" rel="nofollow ugc">myCred Elementor</a></li>
</ul>
<h4>DOCUMENTATION AND SUPPORT</h4>
<p>For more information visit our <strong><a href="https://www.mycred.me/store/mycred-for-events-manager-pro/" rel="nofollow ugc">Documentation Page</a></strong>.</p>


myCred for Events Manager Pro

📢🚨 Important Notice: myCred for Events Manager Pro is now part of the myCred Toolkit and will no longer receive updates here.

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 )

myCred for Events Manager Pro vs Export events to CSV (Addon for Events Manager)