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

Tobias Bäthge

Boost your website with feature-rich tables that your visitors will love!
TablePress is the most popular and highest-rated WordPress table plugin.
<ul>
<li>Easily create, edit, and manage beautiful and modern data tables, from simple price lists to searchable directories, product and model tables, inventories, schedules, and research datasets.</li>
<li>Add live sorting, pagination, searching, and other interactive features that help visitors find what they’re looking for on any device.</li>
<li>Use any type of data and enrich your tables with images, links, and even math formulas.</li>
<li>Import and export tables from/to Excel, CSV, HTML, and JSON files or URLs, including spreadsheet data from Google Sheets, Excel Online, and files stored on Dropbox or OneDrive.</li>
<li>Embed tables into posts, pages, or other site areas using the block editor, an Elementor widget, or Shortcodes.</li>
<li>All with no coding knowledge needed!</li>
</ul>
Even more great features for you and your site’s visitors and priority email support are available with a Premium license plan of TablePress. <a href="https://tablepress.org/premium/?utm_source=wordpress.org&utm_medium=textlink&utm_content=readme" rel="nofollow ugc">Go check them out!</a>
<h4>Common use cases</h4>
TablePress will handle a wide range of tables, from simple price lists to searchable directories and large datasets. Popular examples include:
<ul>
<li>Product and model tables</li>
<li>Service and price lists</li>
<li>Directories and listings</li>
<li>Schedules and timetables</li>
<li>Participant and member lists</li>
<li>Inventories and collections</li>
<li>Comparison tables</li>
<li>Research and statistical data</li>
</ul>
<h4>Accessible and SEO-friendly tables</h4>
TablePress creates accessible HTML tables whose content can be searched by visitors, WordPress search, and search engines alike. Interactive features like sorting, filtering, and pagination include accessibility enhancements for screen readers and other assistive technologies. 
This makes it easy for visitors to find relevant information, whether they are browsing a large directory, searching a product table, or using your site’s search function.
<h4>More information</h4>
Visit <a href="https://tablepress.org/" rel="nofollow ugc">tablepress.org</a> for more information, take a look at <a href="https://tablepress.org/demo/" rel="nofollow ugc">example tables</a>, or <a href="https://tablepress.org/demo/#try" rel="nofollow ugc">try TablePress on a free test site</a>. For latest news, <a href="https://twitter.com/TablePress" rel="nofollow ugc">follow @TablePress</a> on Twitter/X or subscribe to the <a href="https://tablepress.org/#newsletter" rel="nofollow ugc">TablePress Newsletter</a>.
<h3>How to use TablePress</h3>
After installing the plugin, you can create and manage tables on the “TablePress” screen in the WordPress Dashboard.
To insert a table into a post or page, add a “TablePress table” block in the block editor or a widget in the Elementor page builder and select the desired table or use Shortcodes with other page builders.
Beginner-friendly step-by-step <a href="https://tablepress.org/tutorials/" rel="nofollow ugc">tutorials, guides, and how-tos</a> show how to achieve common and popular tasks with TablePress. 
You can find examples for common styling changes via “Custom CSS” code on the <a href="https://tablepress.org/faq/" rel="nofollow ugc">TablePress FAQ page</a>. 
You may also add features like sorting, pagination, searching, filtering, alternating row colors, row highlighting, and more by enabling the corresponding options on a table’s “Edit” screen.
<h3>Premium features</h3>
Need additional functionality for larger tables or advanced use cases? Premium license plans for TablePress add features such as:
<ul>
<li>Options for responsive tables</li>
<li>Advanced filtering and search</li>
<li>Fixed table headers and columns</li>
<li>Automatic periodic imports</li>
<li>Custom styling options</li>
<li>And much more</li>
</ul>
Priority email support is also included. <a href="https://tablepress.org/premium/?utm_source=wordpress.org&utm_medium=textlink&utm_content=readme" rel="nofollow ugc">Check out the details on the TablePress website.</a>

TablePress – Tables in WordPress made easy


Ich nutze das Plugin nun schon eine ganze Weil und bin immer wieder begeistert, wie einfach man damit Tabellen erstellen und einbetten kann. Dazu kommt, dass der Autor immer wieder neue Funktionen einbaut und das Plugin weiterhin kostenfrei bleibt.



I've been using the plugin for a while now and I'm still amazed at how easy it is to create and embed tables. In addition, the author keeps adding new features while the plugin remains free.






Best Plugin when it comes to tables


Working with TablePress has made it easier to manage data especially when working with hundreds of cells.



No way should one ever work with "plain HTML tables" again! :-)


Intuitive!


Developer solved all my problems, created individual code for my needs and explained everything thoroughly. Great job!


GREAT SUPPORT!!


TablePress 3.0 removed backward compatibility with free extensions. Now you need to use paid version in order for things to work. Someone skilled should fork this. 


Backward compatibility removed in favor of paid version

Embed beautiful, accessible, and interactive tables into your WordPress website’s posts and pages, without having to write code!

Event Organiser CSV vs TablePress – Tables in WordPress made easy