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

berkux

<p>The simplest method to link WordPress with external APIs</p>
<p>JCI simplifies the task of retrieving data from a third-party REST API. The returned JSON-, XML, CSV, TXT-data can be neatly arranged and showcased on your WordPress site via a shortcode, a JCI Block or PHP. The plugin can generate a template for the data display.</p>
<p>20 seconds: Load API and display data</p>
<p><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/RBlrAUVywAk?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>
<p>7 minutes: Basic intro to JCI free</p>
<p><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/SDUj1teNG2s?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>
<h3>Examples, Preview</h3>
<p>Check out the live demonstration to explore how we’re interfacing with various APIs<br />
<a href="https://api.json-content-importer.com/free-jci-plugin-example/wetter/" rel="nofollow ugc">LIVE PREVIEW – WordPress and a external API</a></p>
<p><a href="https://www.youtube.com/watch?v=GJGBPvaKZsk" rel="nofollow ugc">Video: How to use the Wikipedia API</a></p>
<h3>Main Plugin Features</h3>
<ul>
<li>Low code usage: Save time and avoid coding using an API</li>
<li>Insert an API-URL into Step 1: Data is loaded, and and displayed. Save it as API-Access-Set.</li>
<li>Use the API-Access-Set in Step 2 to create a Shortcode</li>
<li>Optional for maximum flexibility: Use the API-Access-Set n PHP code</li>
<li>Insert an API-URL into the JCI Block: Data is loaded, and a template can be generated to display the data.</li>
<li>Easy to start: Check Installation – Is your WordPress ready for JCI? Most probably!</li>
<li>Basic Settings: Check SSL, Cacher, Gutenberg and Authentication</li>
<li>ContactForm7 Integration: Populate CF7 forms with JSON data and forward CF7-submitted data to an API.</li>
<li>Use the JCI cacher to avoid many API requests</li>
<li>JCI-Block :  Use the simple JCI Block interface to get data! Query the API and check the response. Then utilize the simple template generator inside the JCI Block to use the data!</li>
<li>Contact Form 7 Integration: Fill form and submit to API</li>
</ul>
<h3>Important Note Starting with Version 2.0.11</h3>
<p>Starting with version 2.0.11, any HTML code present in the shortcode or block is filtered to prevent dangerous code (e.g. JavaScript) from being output.<br />
However, if you want to allow certain tags or attributes as a deliberate choice:<br />
In the plugin’s “Basic Settings” there is a field called “Allow additional HTML tags (advanced)”.<br />
There you can enter comma-separated tags that should not be filtered out. For example, “iframe,script” would preserve these two tags in the HTML output.<br />
“tr#onclick” would preserve the “onclick” attribute in ”, which would otherwise be removed.</p>
<h3>Documentation</h3>
<p>There’s a wealth of resources and support at your fingertips. Explore the articles listed below to begin your journey:</p>
<ul>
<li><a href="https://doc.json-content-importer.com/" rel="nofollow ugc">JCI Manual</a></li>
<li><a href="https://doc.json-content-importer.com/json-content-importer/step-1-data-access/" rel="nofollow ugc">Step 1: Access the Data</a></li>
<li><a href="https://doc.json-content-importer.com/json-content-importer/step-2-data-usage/" rel="nofollow ugc">Step 2: Using the Data</a></li>
<li><a href="https://doc.json-content-importer.com/json-content-importer/shortcode-basic-structure/" rel="nofollow ugc">Shortcode – Basic structure</a></li>
<li><a href="https://doc.json-content-importer.com/json-content-importer/pro-contactform7/" rel="nofollow ugc">Contact Form 7 Integration</a></li>
<li><a href="https://doc.json-content-importer.com/json-content-importer/free-overview-videos/" rel="nofollow ugc">Free JCI Plugin: Overview Videos</a></li>
<li><a href="https://doc.json-content-importer.com/json-content-importer/basic-start/" rel="nofollow ugc">Free JCI Plugin: Getting Started</a></li>
</ul>
<h3>You need more?</h3>
<h4>JSON Content Importer PRO</h4>
<p>Both the free and PRO JCI Plugins serve the same purpose: retrieving data, transforming it, and publishing the results.<br />
However, while the free Plugin can only handle basic challenges, the PRO JCI Plugin offers nearly full control over WordPress, the database, and applications.<br />
<a href="https://json-content-importer.com/compare/" rel="nofollow ugc">Compare: Free vs. JCI PRO Plugin</a></p>
<p>PRO features:<br />
* application building by creating a searchform and connect it to a JSON-API in the background: pass GET-Variables to use a dynamic JSON-Feed-URL (“talk to API / webservice”)<br />
* much better and more flexible templateengine: twig<br />
* create and use Custom Post Types<br />
* store Templates independent of pages<br />
* more Shortcode-Parameters<br />
* executing Shortcodes inside a template<br />
* more features…</p>


Get Use APIs – JSON Content Importer


All I wanted to do is display the latest version number of my own plugin on my site.  I could have spent hours coding it myself, instead I spent 5 minutes installing and working out this plugin.  Great work Bernhard


Easy Peasy


learning curve is very steep with the plugin but it simply works and i fell in love with it! i use it for everything: fetching flight prices, weather data, syncing wordpress blocks / content across different sites / domain through wp rest api to name a few!


such a clever plugin

Connects an API to WordPress: Get API-data (JSON, XML, CSV...), show it with a Shortcode, a JCI Block or PHP. Generate a template with the JCI Block

Event Organiser CSV vs Get Use APIs – JSON Content Importer