Convert Blog Post to Page

[Kathy Landon]

Is there any way to convert an existing Blog post to a Page?

[Avni Barman]

Hey @Kathy Landon, this feature is now available! Check out this article I wrote to learn more about how it works.

Cheers,

Avni Barman

Product Manager, Confluence Cloud

[goncalo_ferraz]

She's asking the opposite, Avni.

[Srikanth Ganipisetty]

Do you have the article about Existing BLOG Post --> Page? 

[kennyngkk]

Hi Kathy,

Before we begin, I would like to welcome you to our community. We hope that you are able to belong to our awesome community. 

Currently, Confluence does not have such a feature. :( 

 It looks like the Developer have marked this feature as not fix. 

• https://jira.atlassian.com/browse/CONFSERVER-16142

However, we do have third party option that has this feature. 

• https://marketplace.atlassian.com/apps/1213130/blog-tools-for-confluence?hosting=server&tab=overview

If you are feeling adventures. You can modify the SQL below to make it work for you. Do make sure you backup your database before proceeding.

update CONTENT
set CONTENTTYPE = 'PAGE',
CHILD_POSITION = null, 
PARENTID = null, 
PREVVER = null
where CONTENTTYPE = 'BLOGPOST'
and SPACEID = 12345678
AND CONTENTID NOT IN (1, 2)

[barronkid]

Could you please verify the SQL command for converting a particular page
from page to blogpost? 

I'm thinking it has to go something like this ... 

update content 
set contenttype = 'BLOGPOST', 
CHILD_POSITION = ??, 
PARENTID = null, 
PREVVER = null
where CONTENTTYPE = 'BLOGPOST'
and SPACEID = 12345678
AND CONTENTID = ##

Just wanting to make certain there isn't any other field that needs to be set when going this direction.  

Also, is there a link to a documentation of the database structure I might access without going to examine the db itself?  

Thanks for your post!

I look forward to your reply.