Importing Blog Posts

Locating the Import Template

  1. Navigate to the Control Panel
  2. Click on Site Content
  3. Click on Import
  4. Choose the type of content you want to Import from the enabled App list. Learn how to Enable an App

Content that can be imported will have a link to a downloadable excel spreadsheet template. (see image below)

import template

Importing Blogs - Navigating the Downloadable Template

Blog Template Site View
Blog Import Site View

Note: The first row is reserved for the field titles and optional taxonomy vocabulary fields. Do not remove or alter text in the first row from the template.

COLUMN A: Blog Title
blog title


COLUMN B: Blog Body (Text Content)
Note: It is recommended to add the HTML version of your text in this field.

Please be aware if you are inserting a large amount of text here, the import might result in missing content because it will not be able to handle large amounts of text. Please avoid using ASCII characters in your text as this will result in import errors.
blog body excel spreadsheet


COLUMN C: Blog Files (Images or documents)
Note: This field is optional. Files added here will import over as attached downloadable files.

Files should be entered here as URL paths.These files should already exist either on your site or on an external site. You cannot upload a local file from your computer here. To learn how to add files to your site prior to import, see Adding Files.
blog files excel spreadsheet


COLUMN D: Blog Created Date
Note: This field is optional.

It is best to fill on this field if your blogs require a set date, otherwise leaving this field blank will result in all imported blogs having the same date (date of import).
blog created date excel spreadsheet


COLUMN E: Blog Path (URL Path)
Add the URL path ending here. For example, instead of adding help.theopenscholar.com/blogs/my-blog, you'll just need to add my-blog.
blog URL path excel spreadsheet

Importing more than 50 Blog Posts at one time is not permitted. If your CSV file is over 50 rows, you will receive an error.

Saving your CSV File

Make sure to save your CSV file using the UTF-8 file format to ensure that your contents are imported without issue.

The Import Process

  1. Navigate to the control panel
  2. Select Site Content
  3. Click Import
  4. Select Blog Entry
  5. Upload the Blog.csv file
    blog csv upload
  6. Click Submit
  7. Navigate to Site Content > Browse > Content > Type: Blog Entry to view blog entries.

Updated: 11Oct18