Importing Wordpress to Banjo
Posted on | October 22, 2007 | 5 Comments
Thanks to Andy C I’ve finished the Wordpress import script for Banjo.
That article gives instructions for direct SQL loading of a somewhat different blog database. I couldn’t use it directly for Banjo, partially because I’m through with using MySQL. I just can’t take all the UTF problems any more. I’ve gone all PostgreSQL all the time.
So my solution needed to speak MySQL and then directly create objects in Django. That way it could be used for any target database.
Loading A Wordpress database into Banjo/Django
What I did was to load my Wordpress 2.3 database into a local MySQL server. Then I wrote a script which splits the import into three stages. 1) Create Post entries, 2) add categories to them, and 3) attach comments.
First, I get all the entries, then make and save Posts for them.
entries = {}
querydict = {'prefix' : prefix}
sql = """select id, post_name, post_title, post_date_gmt, post_modified_gmt,
post_content, post_excerpt, post_status, ping_status, comment_status
from %(prefix)sposts where post_type='post'""" % querydict
c = conn.cursor()
c.execute(sql)
entries = {}
for post_id, name, title, date_gmt, modified_gmt, content, excerpt, wp_status, wp_comment, wp_ping in c.fetchall():
e = Entry(
# details here - skipped
)
e.save()
entries[post_id] = e
Then, I calc all the tags, and build as a space delimited list and assign to my Entry object. The Entry object uses the django-tagging app to handle parsing these tags in a convenient manner.
sql = """select %(prefix)sterm_relationships.object_id, %(prefix)sterms.slug
from %(prefix)sterm_relationships, %(prefix)sterm_taxonomy, %(prefix)sterms
where %(prefix)sterm_relationships.term_taxonomy_id = %(prefix)sterm_taxonomy.term_taxonomy_id
and %(prefix)sterm_taxonomy.term_id = %(prefix)sterms.term_id""" % querydict
c.execute(sql)
cats = []
curr = -1
for post_id, cat in c.fetchall():
if post_id != curr:
if cats:
try:
e = entries[post_id]
e.tags = " ".join(cats)
e.save()
except KeyError:
pass
curr = post_id
cats = []
cats.append(cat)
if cats:
try:
e = entries[post_id]
e.tags = " ".join(cats)
e.save()
except KeyError:
pass
Last, I build the comments. The only trick here is that due to “auto_now_add” on the comment object, I need to set the date on it again after it is initially created, and save again. Silly, but effective.
entrytype = ContentType.objects.get_for_model(Entry)
sql = """select comment_content, comment_post_id, comment_author,
comment_date_gmt, comment_author_ip, comment_approved
from %(prefix)scomments where comment_approved = '1'
""" % querydict
c.execute(sql)
for content, post_id, comment_author, comment_date, author_ip, approved in c.fetchall():
try:
e = entries[post_id]
comment = FreeComment(
content_type=entrytype,
object_id = e.id,
comment = force_unicode(content, errors='replace'),
person_name = force_unicode(comment_author[:50], errors='replace'),
submit_date = comment_date,
is_public = True,
ip_address = author_ip,
approved = True,
site = blog.site
)
comment.save()
comment.submit_date = comment_date
comment.save()
except KeyError, ke:
pass
Technorati Tags: django, banjo, blog, wordpress
Comments
5 Responses to “Importing Wordpress to Banjo”
Leave a Reply
February 6th, 2008 @ 7:04 pm
Nice site keep it up!
————————————–
http://www.dasofte.com
February 8th, 2008 @ 6:43 am
Does it do “related fields”? I know they’re going to bite me in the bum when I finally ditch wordpress (hopefully for Banjo).
December 11th, 2008 @ 7:57 am
You know I have to ask… Why is this still on site on Wordpress then?
December 11th, 2008 @ 4:44 pm
Haha. I was wondering when someone would call me on it. The truth is that it was a combination of laziness and an incredible overload of client work.
However, since I have a little breather for a few days, I’ve been working on getting things ready for the big switch. The biggest hassle is making sure not to change all the urls.
?December 12th, 2008 @ 12:11 pm
I am thinking about moving off of Blogger and think that I can easily use WordPress as an intermediary. I will be checking out Banjo as an option.