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

Takuro Hishikawa

<p>Alternative CSV Importer plugin. Simple and powerful, best for geeks.</p>
<ul>
<li>Category support</li>
<li>Tag support</li>
<li>Custom field support</li>
<li><a href="https://wordpress.org/plugins/smart-custom-fields/" rel="ugc">Smart Custom Fields</a> support</li>
<li><a href="http://customfieldsuite.com/" rel="nofollow ugc">Custom Field Suite</a> support</li>
<li><a href="http://www.advancedcustomfields.com/" rel="nofollow ugc">Advanced Custom Fields</a> support</li>
<li>Custom Taxonomy support</li>
<li>Custom Post Type support</li>
<li>Filter hook for dry-run-testing</li>
<li>Filter hooks for customize csv data before importing to database</li>
<li>Action hook for update post data after importing to database</li>
</ul>
<p>You can get example CSV files in <code>/wp-content/plugins/really-simple-csv-importer/sample</code> directory.</p>
<h4>Available column names and values:</h4>
<ul>
<li><code>ID</code> or <code>post_id</code>: (int) post id.<br />
This value is not required. The post ID is already exists in your blog, importer will update that post data. If the ID is not exists, importer will trying to create a new post with suggested ID.</li>
<li><code>post_author</code>: (login or ID) The user name or user ID number of the author.</li>
<li><code>post_date</code>: (string) The time of publish date.</li>
<li><code>post_content</code>: (string) The full text of the post.</li>
<li><code>post_title</code>: (string) The title of the post.</li>
<li><code>post_excerpt</code>: (string) For all your post excerpt needs.</li>
<li><code>post_status</code>: (‘draft’ or ‘publish’ or ‘pending’ or ‘future’ or ‘private’ or custom registered status) The status of the post. ‘draft’ is default.</li>
<li><code>post_password</code>: (string) The password to protect the post. The password is limited to 20 characters.</li>
<li><code>post_name</code>: (string) The slug of the post.</li>
<li><code>post_parent</code>: (int) The post parent id. Used for page or hierarchical post type.</li>
<li><code>menu_order</code>: (int)</li>
<li><code>post_type</code>: (‘post’ or ‘page’ or any other post type name) <em>(required)</em> The post type slug, not labels.</li>
<li><code>post_thumbnail</code>: (string) The uri or path of the post thumbnail.<br />
E.g. http://example.com/example.jpg or /path/to/example.jpg</li>
<li><code>post_category</code>: (string, comma separated) slug of post categories</li>
<li><code>post_tags</code>: (string, comma separated) name of post tags</li>
<li><code>tax_{taxonomy}</code>: (string, comma separated) Any field prefixed with <code>tax_</code> will be used as a custom taxonomy. Taxonomy must already exist. Entries are names or slugs of terms.</li>
<li><code>{custom_field_key}</code>: (string) Any other column labels used as custom field</li>
<li><code>cfs_{field_name}</code>: (string) If you would like to import data to custom fields set by Custom Field Suite, please add prefix <code>cfs_</code> to column header name.</li>
<li><code>scf_{field_name}</code>: (string) If you would like to import data to custom fields set by Smart Custom Fields, please add prefix <code>scf_</code> to column header name.</li>
<li><code>comment_status</code>: (‘closed’ or ‘open’) Default is the option ‘default_comment_status’, or ‘closed’.</li>
</ul>
<p>Note: Empty cells in the csv file means “keep it”, not “delete it”.<br />
Note: To set the page template of a page, use custom field key of <code>_wp_page_template</code>.<br />
Note: If providing a post_status of ‘future’ you must specify the post_date in order for WordPress to know when to publish your post.<br />
Note: If the post_type value is <code>attachment</code>, you can use <code>post_thumbnail</code> field to define media URL or path.</p>
<h4>Advanced Custom Fields plugin integrate</h4>
<p>If advanced custom field key is exists, importer will trying to use <a href="http://www.advancedcustomfields.com/resources/functions/update_field/" rel="nofollow ugc">update_field</a> function instead of built-in add_post_meta function.<br />
How to find advanced custom field key: <a href="http://www.advancedcustomfields.com/resources/functions/update_field/#finding-the%20field%20key" rel="nofollow ugc">Finding the field key</a></p>
<h4>Official public repository</h4>
<p>Add star and read future issues about rs-csv-importer on <a href="https://github.com/hissy/rs-csv-importer" rel="nofollow ugc">GitHub</a>!</p>
<h4>Thanks</h4>
<p>Cover banner designed by @<a href="http://uwasora.com/" rel="nofollow ugc">luchino__</a></p>
<h3>How to debug import data</h3>
<p><em>Really Simple CSV Importer Debugger add-on</em> enables you to dry-run-testing and show more detailed post, meta, taxonomy data of each csv row.<br />
Download from <a href="https://gist.github.com/hissy/7175656" rel="nofollow ugc">gist</a>.</p>
<h3>How to customize import post data</h3>
<p>There are three filters available in the importer.</p>
<h4>really_simple_csv_importer_save_post</h4>
<p>This filter is applied to post data.</p>
<p>Parameters:</p>
<ul>
<li><code>$post</code> – (array)(required) post data</li>
<li><code>$is_update</code> – (bool) update existing post data, or insert new post data</li>
</ul>
<p>Example:</p>
<pre><code>function really_simple_csv_importer_save_post_filter( $post, $is_update ) {

    // remove specific tag from import data
    if (isset($post['post_tags'])) {
        $_tags = array();
        foreach ($post['post_tags'] as $tag) {
            if ($tag != 'Apple') {
                $_tags[] = $tag;
            }
        }
        $post['post_tags'] = $_tags;
    }

    return $post;
}
add_filter( 'really_simple_csv_importer_save_post', 'really_simple_csv_importer_save_post_filter', 10, 2 );
</code></pre>
<h4>really_simple_csv_importer_save_meta</h4>
<p>This filter is applied to post meta data.</p>
<p>Parameters:</p>
<ul>
<li><code>$meta</code> – (array)(required) post meta data</li>
<li><code>$post</code> – (array) post data</li>
<li><code>$is_update</code> – (bool)</li>
</ul>
<p>Example:</p>
<pre><code>function really_simple_csv_importer_save_meta_filter( $meta, $post, $is_update ) {

    // serialize metadata
    $meta_array = array();
    if (isset($meta['meta_key_1'])) $meta_array[] = $meta['meta_key_1'];
    if (isset($meta['meta_key_2'])) $meta_array[] = $meta['meta_key_2'];
    $meta = array( 'meta_key' => $meta_array );

    return $meta;
}
add_filter( 'really_simple_csv_importer_save_meta', 'really_simple_csv_importer_save_meta_filter', 10, 3 );
</code></pre>
<h4>really_simple_csv_importer_save_tax</h4>
<p>This filter is applied to post taxonomy data (categories and tags are not included, these are post data).</p>
<p>Parameters:</p>
<ul>
<li><code>$tax</code> – (array)(required) post taxonomy data</li>
<li><code>$post</code> – (array) post data</li>
<li><code>$is_update</code> – (bool)</li>
</ul>
<p>Example:</p>
<pre><code>function really_simple_csv_importer_save_tax_filter( $tax, $post, $is_update ) {

    // Fix misspelled taxonomy
    if (isset($tax['actors'])) {
        $_actors = array();
        foreach ($tax['actors'] as $actor) {
            if ($actor == 'Johnny Dep') {
                $actor = 'Johnny Depp';
            }
            $_actors[] = $actor;
        }
        $tax['actors'] = $_actors;
    }

    return $tax;
}
add_filter( 'really_simple_csv_importer_save_tax', 'really_simple_csv_importer_save_tax_filter', 10, 3 );
</code></pre>
<h4>really_simple_csv_importer_save_thumbnail</h4>
<p>This filter is applied to thumbnail data.</p>
<p>Parameters:</p>
<ul>
<li><code>$post_thumbnail</code> – (string)(required) the thumbnail file path or distant URL</li>
<li><code>$post</code> – (array) post data</li>
<li><code>$is_update</code> – (bool)</li>
</ul>
<p>Example:</p>
<pre><code>function really_simple_csv_importer_save_thumbnail_filter( $post_thumbnail, $post, $is_update ) {

    // Import a local file from an FTP directory
    if (!empty($post_thumbnail) && file_exists($post_thumbnail)) {
        $upload_dir   = wp_upload_dir();
        $target_path  = $upload_dir['path'] . DIRECTORY_SEPARATOR . basename($post_thumbnail);
        if (copy($post_thumbnail, $target_path)) {
            $post_thumbnail = $target_path;
        }
    }

    return $post_thumbnail;
}
add_filter( 'really_simple_csv_importer_save_thumbnail', 'really_simple_csv_importer_save_thumbnail_filter', 10, 3 );
</code></pre>
<h3>How to customize the post data after importing to database</h3>
<h4>really_simple_csv_importer_post_saved</h4>
<p>This action provides availability to run some tasks after importing.</p>
<p>Example: Download image from remote url to custom field (Download from <a href="https://gist.github.com/hissy/0973a6a9977129a6ebd0" rel="nofollow ugc">gist</a>)</p>
<h3>How to customize the importing process entirely</h3>
<h4>really_simple_csv_importer_class</h4>
<p>This filter provides availability to completely replace the <code>RS_CSV_Importer#save_post</code> method.</p>
<p>Example: Update row based on a custom field ID/key match (Download from <a href="https://gist.github.com/hissy/199ad9be855ec9be1e54" rel="nofollow ugc">gist</a>)</p>


Really Simple CSV Importer

Perfect. Worked at first try using CPT and Advanced Custom Fields. Thanks, Takuro, you rock!

The force is with this one

This is a good plugin save me hours in insert Posts, and ACF fields

Amazing plugin!! to upload acf contents

Alternative CSV Importer plugin. Simple and powerful, best for geeks.

Event Organiser CSV vs Really Simple CSV Importer