Fanzhh's Blog
0%

Export wordpress posts to markdown file

Posted on Edited on In

Export wordpress posts to markdown file

wordpress2markdown

Export wordpress’s posts to markdown files contain images.

A few years ago, I once built my blog use wordpress. Later I learned markdown and enjoy it, now I built blog use grav, a cms system based markdown file. I want to export my old blogs in wordpress into grav system, so I write this python code.

This file supposed you have copy your entire wordpress direcotry to local, and import the wordpress mysql database to your local mysql.

Generally speaking, the path of images in a post in wordpress should in direcotry like this:

1
(wordpress root direcotry)/wp-content/uploads/(year)/(month)/

This python file’s job is to read posts in wordpress and write it into a markdown file, at the same time copy the images in the posts into the markdown same direcotry and update links in markdown file.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
#!/usr/bin/python
# -*- coding:utf-8 -*-
import sys
import MySQLdb
import os
import re
from shutil import copyfile
from os.path import basename
from bs4 import BeautifulSoup

reload(sys)
sys.setdefaultencoding('utf8')

db = MySQLdb.connect(host="localhost", # your host, usually localhost
                    user="username",       # your username
                    passwd="passwd", # your passwd
                    db="dbname",        # name of the data base
                    charset="utf8",    # set charset
                    use_unicode=True)

cur = db.cursor()

# The wordpress's posts in'wp_posts' table, so we just get it.
sql_string = """select post_title, post_name, post_date, 
post_content,ID from wp_posts 
where post_status = 'publish' and post_type = 'post'"""

cur.execute(sql_string)

for row in cur.fetchall():
    title = row[0]      # post's title
    post_date = row[2]  # post's publish date
    folder_name = post_date.strftime("%Y%m%d%H%M%S")    #we use each post's publish data as markdown file's dicrecotry name
    folder_name = 'blogs/' + folder_name    # put all exported posts in 'blogs' dicrecotry
    if not os.path.exists(folder_name):
        os.makedirs(folder_name)
    f = open(folder_name+'/item.md','w')    # we set all posts name as item.md
    f.write('---\n')    # write markdown file header information
    f.write('title: '+title+'\n')
    f.write('date: '+post_date.strftime("%m/%d/%Y %H:%M:%S")+'\n')
    f.write('---\n')
    post_content = row[3]
    lst = post_content.splitlines() # split post content as a list
    for str in lst:
        caption = ''
        if str.startswith('[caption'): # get image's caption information
            caption = re.search('caption="(.*)"]',str).group(1)
        if ('<img ' in str) and ('/wp-content/uploads/' in str):
            start = 'wp-content/'       
            end = '.jpg'
            img_path = str.split(start)[1].split(end)[0] # get image path
            if img_path:
                img_path = img_path + '.jpg'            
            filename = basename(img_path)
            copyfile('wp-content/'+img_path,folder_name+'/'+filename)   # copy image to the same direcotry of markdown file 
            f.write('!['+caption+']('+filename+'"'+caption+'")\n')      # insert image mark into markdown file
        else:
            soup = BeautifulSoup(str)   # if image or cation not in line, then just write text into markdown file
            f.write(soup.get_text()+'\n')
    f.close()
    
db.close()

I’ve put this file on github, click this.