Being the master of data that I am, I have decided to embark on a project.
My project is - programmatically transfer the entire contents (including comments) of my journal to Wordpress.
I'll be honest - the weekly e-mails from LJ chronicalling the escapades of "Frank and Meme" genuinely persuade me that LJ and I are no longer compatible. I can't explain it in any more detail than to say that I find the whole vibe weird and alienating, and I object to having my content stored in a place that I no longer feel comfortable with.
So the mission is to grab all 7,000 entries, and 20,000 or so comments, and forcibly inject them into a Wordpress blog.
So the wp_posts table is easy enough, need to give it an ID (which auto0-increments anyway), some date bits (which I can easily grab from each LJ entry), content, title, an appropriate status, a name (which I can randomly generate), modification timestamp, a permalink URL (which can be derived from the autonumber ID), and a type. Plus a few other bits and bobs.
Then I'll chuck a load of stuff into a reference data table that maps from the autonumber ID to the LJ ID, which then makes it easier to track between everything. Simple...
Tags can be brought across using the wp_terms table and associated stuff, as far as I can tell...
Then to comments, where I can map names, URLs back to that person's LJ, their IP, timestamp, content, parent IDs, and so on. Again, it's going to take reference data tables to map everything in properly, but it's simple enough once those are in place..
I understand that something sort of like this exists already, taking LJ export XML files and doing this, but when last I checked (half a decade ago probably), that involved exporting stuff month by month. And I've been here for 128 months or thereabouts, so that's impractical. It also wouldn't cover comments, so why bother with that? More fun to build something myself :o)
- (no subject)