外掛說明
- 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