TextPattern import plugin for Jekyll that uses a YAML dump file of the "Textpattern" table from PHPMyAdmin instead of a local database. It also imports categories in addition to tags.

textpattern.rb

module JekyllImport
  module Importers
    class TextPattern < Importer
      def self.require_deps
        JekyllImport.require_with_fallback(%w[
          rubygems
          fileutils
          safe_yaml
        ])
      end

      def self.specify_options(c)
        c.option 'filename', '--filename FILE', 'YAML database export file name'
      end

      def self.process(options)
        filename = options.fetch('filename')

        db = YAML.load_file(filename)

        FileUtils.mkdir_p "_posts"

        db.each do |post|
          # The only posts selected are those with a status of 4 or 5, which means
          # "live" and "sticky" respectively.
          # Other statuses are 1 => draft, 2 => hidden and 3 => pending.
          next if post['Status'] < 4

          # Get required fields and construct Jekyll compatible name.
          title = post['Title']
          slug = post['url_title']
          date = DateTime.parse(post['Posted']).to_time
          content = post['Body']

          name = [date.strftime("%Y-%m-%d"), slug].join('-') + ".textile"

          # Get the relevant fields as a hash, delete empty fields and convert
          # to YAML for the header.
          data = {
             'layout' => 'post',
             'title' => title.to_s,
             'categories' => post['Category1'],
             'tags' => post['Keywords'].split(','),
             'date' => date
           }.delete_if { |k,v| v.nil? || v == '' || v == [] }.to_yaml

          # Write out the data and content to file.
          File.open("_posts/#{name}", "w") do |f|
            f.puts data
            f.puts "---"
            f.puts content
          end
        end
      end
    end
  end
end