WordPress

Publish blog posts from R + knitr to WordPress

2013-02-10

The RWordPress package allows one to publish blog posts from R to WordPress (but please note that this package has not been updated for many years, which is not a good sign). A blog post is essentially an HTML fragment, and knitr can create such a fragment from R Markdown with the markdown package. Below is how to do this with the function knit2wp() in knitr:

if (!require('RWordPress')) {
  remotes::install_github(c("duncantl/XMLRPC", "duncantl/RWordPress"))
}
library(RWordPress)
options(WordpressLogin = c(user = 'password'),
        WordpressURL = 'https://user.wordpress.com/xmlrpc.php')
library(knitr)
knit2wp('yourfile.Rmd', title = 'Your post title')

Basically you set your login name and password as well as the url of the WordPress server (path to xmlrpc.php), so that RWordPress can send the post to the server. If you are a WordPress.com user, you may want to use the shortcode option, i.e. knit2wp(..., shortcode = TRUE). See ?knit2wp for details.

How to upload images? There are a few possibilities. One is to upload images to Imgur, and another is to save images to your Dropbox folder, e.g.

opts_knit$set(base.url = 'https://dl.dropbox.com/u/15335397/wp/',
              base.dir = 'path/to/Dropbox/Public/wp/')

I created a folder named wp under the Public folder, and the above code tells knitr to add a prefix to the image URL’s, and generate images in the Dropbox folder. To get the URL of a file in the Public folder, just right-click on it and copy the link from the menu.

Note you can write and preview the draft in RStudio until you are comfortable to publish it. Once it is published, it is not straightforward to modify it (although you can), and that is why you, as a cool hacker, should blog with Jekyll instead of WordPress. It is always easy to deal with plain text files. Once you have got PHP, MySQL, password, plugins, … things get complicated quickly.

If you have your own server, I recommend you not to use the shortcode option, and you should consider much nicer alternative options for syntax highlighting such as highlight.js, e.g. you can add this to your WordPress template:

<link rel="stylesheet" href="http://yandex.st/highlightjs/7.3/styles/default.min.css">
<script src="http://yandex.st/highlightjs/7.3/highlight.min.js"></script>
<script src="http://yandex.st/highlightjs/7.3/languages/r.min.js"></script>
<script>hljs.initHighlightingOnLoad();</script>

I thank William K. Morris for his early experiment with knitr and WordPress. The knit2wp() function was based on his blog post. I also tested it here.