The discussion revolves around migrating content from a Discourse site to a WordPress blog. deb_mitchell is looking for the fastest and best way to transfer content, including posts with text, photos, and embedded YouTube links.
jericson suggests using a Data Explorer query to extract the content from Discourse, specifically recommending a query to get the first post in each topic. Alternatively, they propose using the Discourse API to grab the posts. The extracted content can then be imported into WordPress using a Markdown import plugin or by directly importing HTML content.
I need to move some content out of my Discourse site. We are working on an additional WordPress blog site where the info will be duplicated. What’s the fastest, best way to do this?
The content consists of posts with words, photos and sometimes embedded YouTube links.
Open to content going directly to Wordpress or even another location where we can then create specific Wordpress posts.
Thanks for any direction
I did it manually, but I didn’t have much content. But instead, wordpress chose drupal as a more advanced CMS that supports custom fields in the core
Seems like importing Markdown files into WordPress would be key. I see there is a plugin that claims to do that.
From the Discourse side, I’d use a Data Explorer query that looks something like:
select title, p.user_id, p.created_at, raw
from posts p
join topics t on t.id = topic_id
where post_number = 1
This gets the first post in each topic. You might need to limit it to a different subset.
Alternatively you could get the cooked post which is HTML. On second thought that might be easier to import into WordPress.
Another option might be to use the API to grab the posts.