How to import content to wordpress : Simple Steps Tutorial (WordPress Ultimate CSV Importer Plugin) Part II

February 5, 2014

Simple Steps Tutorial (WordPress Ultimate CSV Importer Plugin) Part I

How to import content to wordpress with advanced features? What is advanced mapping?

Even it is simple to go with normal post properties, there are more advanced mapping features available in Wordpress Ultimate CSV Importer Plugin. You control each and every field, property of a post just like while creating it manually in wp admin. You need prepare you csv slightly to make these features available to you.

How to use advance mapping feature?

For a simple import post title and content is sufficient to create a successful import. All other fields are optional that set to default as in wordpress. To have more control over it, as in above image you can add more fields in CSV as prescribed for Wordpress Ultimate CSV Importer Plugin. You can add post_excerpt, post_status, post_author etc as below lsited format

post_excerpt – text max. characters is wp default

How to import content to wordpress WordPress Ultimate CSV Importer Plugin field tags part 1
How to import content to wordpress WordPress Ultimate CSV Importer Plugin field tags part 1

post_date – any date format and should be future date to get scheduled for publishing.

post_category – can be | separated for mutiple categories and case sensitive

post_tag – can be comma separated for mutiple tags and case sensitive

post_author – as user id or name and case sensitive. Mismatches are set to Admin

How to import content to wordpress WordPress Ultimate CSV Importer Plugin field tags featured image
How to import content to wordpress WordPress Ultimate CSV Importer Plugin field tags featured image

featured_image – should be a full valid url path and image must exist

How to import content to wordpress WordPress Ultimate CSV Importer Plugin field tags part 2
How to import content to wordpress WordPress Ultimate CSV Importer Plugin field tags part 2

post_slug – wordpress default (small letters, spaces replaced by hyphens)

post_parent – assign a post imported as child to a post id

CF : {custom_field} – existing Custom fields with their label (WP Custom Fields only)

Add Custom Fields – to add a new custom field and import with a label

post_status – You can choose from drop down to set a overall status for the whole import

To set status for each data you import, mention the values as below

Publish (default)

Sticky

Pending

Private

{your_password}

Draft

The missing fields like Post format, Send Trackbacks and Discussion will be adde in upcoming versions.

What is auto mapping in WordPress Ultimate CSV Importer Plugin? 

Auto mapping is hands free mapping feature introduced from version 3.0.0. Just replace the CSV headers with relevant auto map headers and save it to use as a template csv file. Wordpress Ultimate CSV Importer Plugin can identify these headers and automatically map your fields with relevant wordpress fields. This feature will almost eliminates the pain of mapping each and every time, in particular with many no. of fields.

Where to get the sample csv files for Wordpress Ultimate CSV Importer Plugin?

You can view this post thread for regularly updated sample csv files and news. Also you can browse this download folder directly

This part II of the tutorial. Click Here to read the Part I of How to import content to wordpress : Simple Steps Tutorial (WordPress Ultimate CSV Importer Plugin)

2 Comments
  1. Hi Stefan,

    With Ultimate CSV Importer, you can have the date mentioned in CSV and relate them to be updated. If the date is not mentioned, then the importer will assign the current date. But, it is not possible to define date randomly. Can you give more details on how you want the date to be specified? You can write to us at [email protected]kcoders.com for quick help.

Leave a Reply

Your email address will not be published.