Stephen Harris

<p>This plug-in allows to import events from a CSV file into Event Organiser. You can also export events from<br />
Event Organiser into a CSV file.</p>
<p>Please note that this plug-in still in <strong>beta</strong>. I welcome feedback, issues and pull-requests.</p>
<h4>Aim</h4>
<p>To allow users to export / import events in CSV format between various calendar applications, and to do this flexiably<br />
so as to limit the number of requirements on the CSV file before it can be read correctly. To allow users to move events<br />
between installations of Event Organiser while preserving data that is not suported by iCal.</p>
<p>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)<br />
after importing the file.</p>
<h4>How to use this plug-in</h4>
<p>Once installed, go to <em>Tools > Import Events</em>. Here you can export a CSV file or select a file to import one. To import an file:</p>
<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<br />
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 <strong>only</strong> 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>
<p>By default the plug-in will only import venues, categories and tags that already exist.<br />
To allow the plug-in to create new venues, categories and tags you can add the following<br />
code (to a seperate plug-in or your theme’s <code>functions.php</code>).</p>
<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>
<p>Please note the limitations on importing venues discussed below.</p>
<h4>Limitations</h4>
<p>Current limitations apply. See the examples folder for an archetypal CSV file</p>
<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 <strong>strongly</strong> 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<br />
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>
<p><em>Please note that in theory all dates (other than the start date) can be given in any format, however, to<br />
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<br />
date must be in that format so that the importer can differentriate between all-day and non-all-day events.</em></p>
<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

Soflyy

WP All Import

<h4>WP All Import – Simple & Powerful XML, CSV, Google Sheets, and Excel Importer Plugin</h4>
<p><em>“It’s a wonderful plugin that does so much, so well that it’s hard to list all of the features. But I’ll tell you this, I was able to import the content of a pair of websites running the ModX CMS into a WordPress install in less than 30 minutes. No joke!”</em><br />
<strong>Alex Vasquez</strong> – DigiSavvy Co-Founder & WordCamp Los Angeles Organizer</p>
<p>WP All Import has a four-step import process and an intuitive drag-and-drop interface that makes complicated import tasks simple and fast.</p>
<p>There are no special requirements that the elements in your file must be laid out in a certain way. WP All Import can import any XML, CSV, Excel spreadsheet, or Google Sheets file into WordPress.</p>
<p>WP All Import can be used for everything from migrating content from a legacy CMS to WordPress to building a store with affiliate datafeed to displaying live stock quotes or sports scores to building a real estate portal.</p>
<p>Check out our <a href="http://www.wpallimport.com/documentation/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=docs" rel="nofollow ugc">documentation and video tutorials</a> to make the most of WP All Import.</p>
<p>WP All Import integrates with our companion plugin, <a href="https://wordpress.org/plugins/wp-all-export/" rel="ugc">WP All Export</a>. You can export posts, WooCommerce products, orders, users, or anything else with WP All Export. Then you can edit the WordPress data with Microsoft Excel, Numbers, or maybe something else, and re-import to the same site or migrate the data to another site with WP All Import.</p>
<p>For technical support from the developers, please consider purchasing WP All Import Pro.</p>
<h4>WP All Import Pro Version</h4>
<span class="embed-youtube" style="text-align:center; display: block;"><iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/pD6WQANJcJY?version=3&rel=1&showsearch=0&showinfo=1&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></span>
<p><em>WP All Import Pro</em> is a paid upgrade that includes premium support and adds the following features:</p>
<ul>
<li>
<p>Import data to Custom Fields – used by many themes, especially those using Custom Post Types – to store data associated with the posts.</p>
</li>
<li>
<p>Import images to the post media gallery – WP All Import can download images from URLs in an XML or CSV file and put them in the media gallery.</p>
</li>
<li>
<p>Import files from a URL – Download and import CSV, XML, or Excel WordPress data files from external websites, even if they are password-protected with HTTP authentication.</p>
</li>
<li>
<p>Cron Job/Recurring Imports from external URLs – WP All Import Pro can periodically check a file for updates, and add, edit, and delete the imported posts accordingly.</p>
</li>
<li>
<p>Execution of Custom PHP Functions on data, i.e., use something like [my_function({xpath/to/a/field[1]})] in your template, to pass the value of {xpath/to/a/field[1]} to my_function and display whatever it returns.</p>
</li>
<li>
<p>Guaranteed technical support via e-mail.</p>
</li>
</ul>
<p><a href="http://www.wpallimport.com/wordpress-xml-csv-import/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=upgrade-to-pro" rel="nofollow ugc">Upgrade to the Pro edition of WP All Import.</a></p>
<p>Need to <a href="http://www.wpallimport.com/woocommerce-product-import/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=upgrade-to-pro" rel="nofollow ugc">import XML and CSV to WooCommerce?</a> Check out our WooCommerce add-on.</p>
<h4>WordPress CSV Imports</h4>
<p>Read on to learn more about the CSV importer functionality of WP All Import. Importing CSVs with WP All Import is exactly the same as importing XML files because internally, WP All Import actually converts your CSV file to an XML file on the fly. You can use the same XPath filtering options and all the same features you have when importing XML files.</p>
<p>CSV imports, including those exported from Excel and Google Sheets, don’t require your file to have a specific structure. Your CSV file can use any column names/headings. You can map the columns in your CSV file to the appropriate places in WordPress during the import process.</p>
<p>When importing CSV files, your CSV should have UTF-8 encoding if you are having trouble importing special characters.</p>
<p>In step 2 of a CSV import, you can specify an alternative delimiter if you aren’t using a comma. WP All Import can import CSVs that are pipe-delimited, # delimited, or delimited/separated by any other character.</p>
<p>For CSV import tutorials and example files, visit our <a href="http://www.wpallimport.com/documentation/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=docs" rel="nofollow ugc">documentation</a>. Please keep in mind CSV imports with WP All Import are just like XML imports – you have all the same functionality, and the process is exactly the same. Any of our tutorial videos that apply to XML files also apply to importing CSV files, so if you see a tutorial with us importing an XML file, know that you can follow the exact same steps for a CSV import.</p>
<h4>WordPress Excel Import / Google Sheets Import</h4>
<p>Don’t want to convert your Excel or Google Sheets data to CSV? WP All Import also works as a Google Sheets and Excel importer for WordPress. Simply upload your Excel file as you would for CSV and WP All Import will automatically detect the columns in your file.</p>
<p>For Google Sheets, use the ‘Download a file’ option and paste your sheet’s public URL to import data to WordPress.</p>
<h4>Add-Ons</h4>
<p>A number of premium add-ons are available to add functionality to the importer and make XML, CSV, Google Sheets, and Excel import tasks to complex plugins simple.</p>
<ul>
<li>Advanced Custom Fields Add-On – <a href="http://www.advancedcustomfields.com/" rel="nofollow ugc">ACF</a> XML & CSV importer</li>
<li>WooCommerce Add-On – XML & CSV importer for all <a href="https://wordpress.org/plugins/woocommerce" rel="ugc">WooCommerce</a> product types</li>
<li>User Import Add-On – XML & CSV importer for users, including user_meta</li>
<li>Link Cloak Add-On – Auto-create redirects for links present during an XML or CSV import</li>
</ul>
<p>Learn more about our add-ons at <a href="http://www.wpallimport.com/add-ons/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=add-ons" rel="nofollow ugc">http://www.wpallimport.com/add-ons</a></p>
<p>A <a href="http://www.wpallimport.com/documentation/developers/action-reference/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=docs" rel="nofollow ugc">developer API</a> (action hooks) is also available.</p>
<h4>Related Plugins</h4>
<p><a href="https://wordpress.org/plugins/wp-all-export/" rel="ugc">Export any WordPress data to XML/CSV</a><br />
<a href="https://wordpress.org/plugins/woocommerce-xml-csv-product-import/" rel="ugc">Import Products from any XML or CSV to WooCommerce</a><br />
<a href="https://wordpress.org/plugins/product-export-for-woocommerce/" rel="ugc">Export Products to CSV/XML for WooCommerce</a><br />
<a href="https://wordpress.org/plugins/custom-product-tabs-wp-all-import-add-on/" rel="ugc">Custom Product Tabs for WooCommerce WP All Import Add-on</a><br />
<a href="https://wordpress.org/plugins/order-export-for-woocommerce/" rel="ugc">Export Orders to CSV/XML for WooCommerce</a><br />
<a href="https://wordpress.org/plugins/export-wp-users-xml-csv/" rel="ugc">Export WordPress Users to CSV/XML</a></p>
<h3>Premium Support</h3>
<p>You can submit the <a href="https://www.wpallimport.com/support/" rel="nofollow ugc">support form on our website</a> or email us at <a href="mailto:support@wpallimport.com" rel="nofollow ugc">support@wpallimport.com</a>. While we try to assist users of our free version, please note that support is not guaranteed and will depend on our capacity. For premium support, purchase <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=5839966&edd_options%5Bprice_id%5D=1&discount=welcome-upgrade-99&utm_source=import-plugin-free&utm_medium=readme&utm_campaign=premium-support" rel="nofollow ugc">WP All Import Pro</a>.</p>
<h3>Import To WooCommerce</h3>
<p>Need to <a href="https://wordpress.org/plugins/woocommerce-xml-csv-product-import/" rel="ugc">import Excel, XML and CSV to WooCommerce?</a> Check out our WooCommerce add-on.</p>
<p><a href="http://www.wpallimport.com/woocommerce-product-import/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=import-wooco-products" rel="nofollow ugc">WooCommerce Excel, XML & CSV Import Pro Version</a></p>


Import any XML, CSV or Excel File to WordPress

The plugin is very powerful, almost everything is possible if you are a developer.

The support team is also a great resource if you get stuck.

Powerfull plugin


Been using it for years, and without a doubt, it is unparalleled in its category.


The BEST!!


I am really happy with this plugin, with a little knowledge of PHP and little help from support, you can achieve whatever you want to. Thank you


Awesome plugin


Importing data is always challenging but this plugin makes life WAY easier, especially when it comes to dealing with commerce data imports.  The ability to use my own PHP functions to format or adjust data at runtime is a life saver. 



I'll be honest: Even when using this plugin, it sometimes takes me several tries to get things just right but 95% of the time, the problem is my data, not the plugin.  I have had to reach out to support a few times and they are responsive.  


THE Import Plugin

WP All Import is an extremely powerful importer that makes it easy to import any XML, CSV or Excel file to WordPress.

Event Organiser CSV vs Import any XML, CSV or Excel File to WordPress