説明
- 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
- Go to
Events->Exportevents as CSV - Choose your delimiter
- 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.
- Upload the plugin files to the
/wp-content/plugins/export-em-events-to-csvdirectory, or install the plugin through the WordPress plugins screen directly. - Activate the plugin in WordPress backend, make sure you have installed and activated Events Manager first.
評価
2017年8月8日
VERY useful add on.
2016年10月11日
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