Stephen Harris

This plug-in allows to import events from a CSV file into Event Organiser. You can also export events from 
Event Organiser into a CSV file.
Please note that this plug-in still in beta. I welcome feedback, issues and pull-requests.
<h4>Aim</h4>
To allow users to export / import events in CSV format between various calendar applications, and to do this flexiably 
so as to limit the number of requirements on the CSV file before it can be read correctly. To allow users to move events 
between installations of Event Organiser while preserving data that is not suported by iCal.
In the vein of flexibility columns do not have to be in any prescribed order: you tell the plug-in which columns pertain to what (start date, end date etc) 
after importing the file.
<h4>How to use this plug-in</h4>
Once installed, go to Tools > Import Events. Here you can export a CSV file or select a file to import one. To import an file:
<ul>
<li>Select browse and select the file, click “Upload file and import”</li>
<li>All being well you should now see a preview of the CSV file, along with a drop-down option at the base of each column. If the preview looks wrong, try 
selecting a different delimiter type (comma, tab, space) at the top.</li>
<li>If the first row of the CSV file is a header, select the option indicating this. The first row will then be ignored.</li>
<li>At the bottom of each column select what the column represents. The options are (not all are required):
<ul>
<li>Title</li>
<li>Start (formatted in Y-m-d format, and also indicating time only if the event is not all-day) </li>
<li>End (formatted as above)</li>
<li>Recur until (if the event recurs, the date of its last occurrence)</li>
<li>Recurrence Schedule (if the event recurs, how it repeats: once|daily|weekly|monthly|yearly|custom).</li>
<li>Recurrence Frequency (if the event recurs, an integer indicating with what frequency)</li>
<li>Schedule Meta (See documentation for <a href="http://codex.wp-event-organiser.com/function-eo_insert_event.html" rel="nofollow ugc">eo_insert_post()</a>, e.g. “MO,TU,THR” (weekly), “BYDAY=2MO” or “BYMONTHDAY=16” (monthly)</li>
<li>Content (HTML post content)</li>
<li>Venue (Venue slug)</li>
<li>Categories (comma seperated list of category slugs) </li>
<li>Tags (comma seperated list of tag slugs)</li>
<li>[Any custom event taxonomies registered] (comma seperated list of slugs)</li>
<li>Include dates (comma seperated list of Y-m-d dates to include from the event’s schedule)</li>
<li>Exclude dates (as above, but added to the event’s schedule)</li>
<li>Post Meta (an option will appear to provide the meta-key)</li>
<li>Click import.</li>
</ul>
</li>
</ul>
<h4>Importing new venues, categories and tags</h4>
By default the plug-in will only import venues, categories and tags that already exist. 
To allow the plug-in to create new venues, categories and tags you can add the following 
code (to a seperate plug-in or your theme’s <code>functions.php</code>).
<pre><code> function my_set_import_imports( $args, $file ){
 $args['import_new_event-category'] = true; //create category if it doesn't exist
 $args['import_new_event-venue'] = true; //create venue if it doesn't exist.
 $args['import_new_event-tag'] = true; //create tag if it doesn't exist. 

 return $args;
 }
 add_filter( 'eventorganiser_csv_import_args', 'my_set_import_imports', 10, 2 );
</code></pre>
Please note the limitations on importing venues discussed below.
<h4>Limitations</h4>
Current limitations apply. See the examples folder for an archetypal CSV file
<ul>
<li>All dates are read using PHP’s DateTime. While various formats are supported, Y-m-d (e.g. 2013-12-31) formats are strongly recommended</li>
<li>Starts dates must be provided in Y-m-d (e.g. 2013-12-31) for all day events and also include a time-component (e.g. 2013-12-31 11:30pm) for non-all-day events. There is no 
prescribed format for the time but 24-hour time is recommended. You do not need to specify seconds.</li>
<li>Include/exclude dates should be given as comma-seperated list of dates in Y-m-d format.</li>
<li>Categories and tags must be given as comma-seperated list of names</li>
<li>It does not support venue meta-data (yet)</li>
</ul>
Please note that in theory all dates (other than the start date) can be given in any format, however, to 
ensure dates are interpreted correctly it is strongly recommended to give dates in Y-m-d (or Y-m-d H:i for non-all day events) format. The start 
date must be in that format so that the importer can differentriate between all-day and non-all-day events.
<h4>Future Features</h4>
<ul>
<li>An “import preview” or “dry-run” so users can view how events will be imported.</li>
<li>Support venue meta data</li>
<li>Support category colours</li>
<li>Add filters for developers</li>
<li>Add support for UID to prevent importing an event twice (perhaps, update the event?)</li>
<li>Add support ‘maps’ for importing from other applications (where format of exported CSV file is prescribed).</li>
<li>Support generic date formatting (try to ‘guess’ / ask for format )</li>
</ul>

Event Organiser CSV

Import & export events from/to CSV format

WebToffee

Import and export WordPress users and WooCommerce customers using CSV. Migrate to your new site without any data loss.
<h3>Top-Rated WordPress User Import Export Plugin</h3>
The most-rated WordPress User Import Export plugin ever! Easily import and export WordPress users and WooCommerce customers with this powerful plugin. Whether you’re moving users between websites or backing up customer data, it ensures a smooth, hassle-free migration without any data loss. Ideal for quick and reliable site transfers.
You can import or export user/customer data using CSV files. This helps effortlessly migrate or update user data on your website. No more manually adding each user or customer one by one. Just migrate or update everything in one go!
<h3>Key Features of WordPress User Import Export Plugin</h3>
🔸 Filter by User Roles, Email, and Date Range – Import or export user/customer data based on user roles, user email, and date range of when the users were added to the system. 
🔸 Batch Export/Import – Process large amounts of user data efficiently in batches. 
🔸 Retain User Passwords – Preserve existing user passwords when migrating to a new website. 
🔸 Field Mapping & Transformation – <a href="https://www.webtoffee.com/update-user-field-values-in-bulk-during-woocommerce-import/" rel="nofollow ugc"> Map and transform fields while you import WooCommerce customers or user data. </a> 
🔸 Bulk Data Modification – Modify user data in bulk using Evaluation Fields during user import. 
🔸 Export Guest Users – Include data of WooCommerce guest customers (users who bought products from the site without creating an account) 
🔸 Export Specific Users – Search by username or email while exporting with auto-suggestions of email addresses and names in user export data fields for quick filtering.
✅ Tested OK with WordPress 6.9 
✅ Tested OK with WooCommerce 10.3 
✅ Tested OK with PHP 8.3
<h3>How Does WordPress User Import Export Plugin Work?</h3>
This WordPress user import export plugin uses CSV (Comma-Separated Values) files as input. You must create a import user CSV file and enter the user details in a structured format. (refer to this <a href="https://www.webtoffee.com/wp-content/uploads/2021/03/Users_SampleCSV.csv" rel="nofollow ugc"> sample CSV)</a> This is to match each field of the user CSV import file to the appropriate user fields in WordPress.
For example, the user_email field gets mapped to the User Email. Otherwise, the admin needs to manually map the user CSV import fields.
📌 Note – For the WordPress user import and export plugin to work correctly, you must map the headers of all the columns correctly and ensure that all of the fields you enter are in the correct format.
You can create the import user CSV from scratch or export the user CSV using the same plugin. Use any spreadsheet program, such as Microsoft Excel, OpenOffice, LibreOffice, or Google Spreadsheets, to create and edit your CSV file. <a href="https://www.webtoffee.com/how-to-save-csv-excel-file-as-utf-8-encoded/" rel="nofollow ugc"> Save this file in UTF-8 encoding with extension .csv. </a>
After entering all details about users in a spreadsheet, you can bulk import users to WordPress. With this user export plugin, you can also export and download user details as a CSV file.
Need Help?
🟢 Check out our <a href="https://www.webtoffee.com/user-import-export-plugin-wordpress-user-guide/" rel="nofollow ugc">WordPress Users & WooCommerce Customers Import Export Plugin – User Guide.</a>
✅ Contact our <a href="https://www.webtoffee.com/support/Support/" rel="nofollow ugc">support.</a>
Watch the video to get started with the WordPress user export and import plugin.
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/N-wvAtnjjpg?version=3&rel=0&showsearch=0&showinfo=0&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe>
<h3>Why Choose WebToffee User Export Import Plugin?</h3>
<a href="https://www.webtoffee.com/" rel="nofollow ugc">WebToffee</a> creates quality WordPress/WooCommerce plugins that are easy to use and customize. We are proud to have millions of customers actively using our plugins across the globe.
Hear It From Our Users
<blockquote>
danielepais (@danielepais) ⭐⭐⭐⭐⭐ 
 Great tool, especially if you need to select a batch of users and some account details but not all; with this plugin, you can filter what to output on your comma-separated CSV file.
Allan Klinbail (@aklinbai) ⭐⭐⭐⭐⭐ 
 After working for a couple of months on a new site from scratch, I didn’t want to have to issue password resets for all users. 
 This allowed me to move them all easily and simply.
benlumi (@benlumi) ⭐⭐⭐⭐⭐ 
 I transferred all my customers to my new website in no time and without any stress. Many options are available to do the job. 
 Perfect! Thank you 😀
</blockquote>
<h3>Import Export WordPress Users & WooCommerce Customers Hassle-free: Go Premium for Advanced Features</h3>
<blockquote>
✅ Import/Export WordPress Users & WooCommerce Customers – Quickly move or back up users and customers between websites without losing any data. Every transfer is smooth and secure. 
✅ Supports multiple file formats like CSV, XML, and Excel (XLS, XLSX) – Choose from various file formats for maximum flexibility. Import or export users data in the format that suits your workflow. 
✅ Export by User Roles or Multiple Roles – Select specific roles or multiple roles to filter which users are exported. Tailor your export files to include only what you need. 
✅ Advanced User Export Filters – Use filters like user role, email, date range, offset/limit, guest users and ascending/descending sort order. Quickly narrow down and control your exported data set. 
✅ Map & Transform Fields on User Import – Match incoming fields with WordPress user fields and modify values as needed. Ensures correct data structure when you import WooCommerce customers. 
✅ Map & Transform Fields on Export – Customize how fields appear while you export WooCommerce customers. Add flexibility and relevance to your exported data format. 
✅ Dynamic Field Updates via Evaluation Fields – Apply conditions to change values of the fields when you import WooCommerce customers using Evaluation Fields. Automate complex data transformations on the fly. 
✅ Export Custom & Hidden User Meta – Include hidden fields and user meta along with standard user data. No need for additional tools to extract custom user export data. 
✅ Update or Skip Existing Customers – Choose whether to update existing users or skip them during user import. Prevents duplication and ensures clean migrations. 
✅ Bulk Update User Data – Quickly modify existing user or customer data in bulk. Perfect for bulk edits, corrections, or role changes. 
✅ Send or Skip Import Emails – Send email notifications to users automatically during data migration to keep them informed. A great way to maintain transparency and build trust during large user imports. 
✅ WPML Compatible – Supports multilingual stores with full WPML integration. Import/export user data in multiple languages with ease. 
✅ Scheduled FTP Import/Export via Cron – Import and export users/customers to/from a remote server via FTP in scheduled time intervals with Cron Job. Perfect for automated, recurring import/export tasks. 
✅ Import from URL or Google Sheets – Import user data directly from public URLs and Google Sheets. Simplifies remote user import management without file uploads. 
✅ Seamless Compatibility with Third-Party Plugins – Fully supports major third-party WordPress plugins like BuddyPress, ACF, Ultimate Member, and more ensuring smooth data handling and integrity across your plugin ecosystem. 
✅ 99% Customer Satisfaction Rate – Backed by a responsive, expert support team users love. Get timely help whenever you need it. 
✅ 30-Day Money-Back Guarantee – Try the WordPress user import plugin risk-free with our 30-day refund policy. Your satisfaction is always our priority.
Please visit <a href="https://www.webtoffee.com/product/wordpress-users-woocommerce-customers-import-export/?utm_source=free_plugin_readme&utm_medium=user_import_export&utm_campaign=User_Import_Export" rel="nofollow ugc">Import Export WordPress Users & WooCommerce Customers</a> for more details.
</blockquote>
<h3>Export WordPress Users and WooCommerce Customers to CSV</h3>
This WordPress user export plugin enables you to export WordPress users and WooCommerce customers to a CSV file. You can use this user export CSV file to migrate users and export WooCommerce customers to another website with the Import users functionality of this plugin.
If you have hundreds, even thousands, of WordPress users, the export users option in this WordPress export user plugin helps to save your effort and time of manually adding the user data.
You can bulk export user data to a user export CSV file with multiple powerful filters such as user roles, date ranges, etc.
<h3>Import WordPress Users and WooCommerce Customers from CSV</h3>
With this WordPress user import plugin, you can easily import hundreds or thousands of WordPress users and WooCommerce customers to your website using a CSV file. The plugin lets you bulk import or merge (update existing users) on your WordPress website, making user and WooCommerce customer import seamless and efficient.
The WordPress import users plugin also has the option to send an email to the users and customers whenever the admin imports/updates users’ details. It will retain the user passwords and securely migrate them to another website.
You can map your import columns to the appropriate WordPress data to import or merge user details. You can also import WordPress users data from a variety of sources, such as an uploaded CSV file on FTP (Premium), a locally saved CSV file on your computer, or from a URL, Google sheet, etc. This flexibility makes it especially useful when you need to import customer CSV files from different platforms.
To import WordPress users and import WooCommerce customers data to your website:
<ul>
<li>Create a CSV file from scratch using any spreadsheet program, such as Microsoft Excel, OpenOffice, LibreOffice, or Google Spreadsheets.</li>
<li>Fill in user details in a tabular format with properly labeled columns.</li>
<li>Save this file with the extension ‘.csv’. </li>
<li>After entering all details about WordPress users in the spreadsheet, you can import users or customers to your website.</li>
</ul>
<h3>☂️ RELATED PLUGINS FROM WEBTOFFEE</h3>
Other useful plugins from WebToffee for migrating WooCommerce/WordPress data:
🔸 <a href="https://wordpress.org/plugins/product-import-export-for-woo/" rel="ugc">WooCommerce Product Import Export Plugin</a>: Easily import and export products to/from your WooCommerce store using a CSV file. 
🔸 <a href="https://wordpress.org/plugins/order-import-export-for-woocommerce/" rel="ugc">Order/Coupon Import-Export for WooCommerce</a>: Import and export orders and/or coupons from your WooCommerce store using CSV with the plugin. 
🔸 <a href="https://wordpress.org/plugins/wp-migration-duplicator/" rel="ugc">WordPress Backup & Migration</a>: Quickly migrate and backup entire WordPress site or selected files from one location to another. Backup to FTP, Google drive, Amazon S3, or local storage and easily restore them back. 
🔸 <a href="https://wordpress.org/plugins/webtoffee-product-feed/" rel="ugc">WebToffee WooCommerce Product Feed & Sync Manager</a>: Generate WooCommerce product feed for Google and Facebook shops and sync WooCommerce products with Facebook catalog. 
🔸 <a href="https://www.webtoffee.com/product/gdpr-cookie-consent/?utm_source=free_plugin_readme&utm_medium=user_import_export&utm_campaign=GDPR" rel="nofollow ugc">GDPR Cookie Consent</a>: This plugin helps websites comply with GDPR, CCPA, and other privacy regulations by displaying a customizable cookie consent banner. Manage cookie categories, log consents, and implement prior consent for cookies.
<h3>Plugin Updates</h3>
For every update of the plugin, you will be notified of the installed plugins page. You can directly update the plugin from your dashboard. We recommend that you keep the latest version of the plugin so that you can avail of the new functionalities and security features.

Export and Import Users and Customers

worked great :)


...but wish it didn't create a top-level navigation menu.


Works perfectly...

Import and export WordPress users and WooCommerce customers using CSV. Migrate to your new site without any data loss.

Event Organiser CSV vs Export and Import Users and Customers