Blogging Tweets

The process of getting my tweets onto my blog is so ridiculous that I just had to write a post about it.

I essentially took notes using Twitter during the IA Summit, and wanted to post recaps for each session I attended on my blog. Tweets are listed in the archive in reverse chronological order (latest at the top) so copying and pasting them straight would make no sense to anyone if I’m trying to tell a start-to-finish story.

So here’s what I did:

  • Copy all the tweets from a session
  • Paste them in a word doc
  • Convert text to table (separate text at paragraph)
  • Find/Replace for “Whitney Hess whitneyhess #IASummit2008” and “2008 from web Icon_star_empty Icon_trash”
  • Delete the timestamp from the end of each tweet
  • Insert column to the left
  • Number each tweet from 1 to N
  • Sort by Column 1, Number, Descending
  • Clear the numbers in the left column
  • Paste “<li>” in every cell of the left column
  • Insert column to the right of the tweet
  • Paste “</li>” in every cell of the right column
  • Convert table to text (separate text with Other, space)
  • Select all and copy
  • Paste in the HTML view of my blog post
  • Put “<ul> </ul>” around the whole thing
  • Write an intro
  • Publish the post

Ludicrous process, right? Is there something I could have done more easily?

Related Posts:


  1. says

    Live-blogged them instead of live-tweeting them? Call me crazy…

    It seems it would have been fairly easy to start a WordPress blog at each session, fill in the points as you’re sitting there, then hit publish. You could even publish after each point. You could let people who want to follow it as it goes know to check your blog post and hit refresh as much as they want.

    Many bloggers do this when covering MacWorld, for example. I’ve often followed it this way. Hitting refresh to get updates is kind of annoying, but I know I can always check back any time to see what I missed.

  2. Livia Labate says

    I’m sorry it was so painful! I guess there could be a few ways to use the API to spit our only the text coming from you that had the hashtags you used. Probably would have taken longer to make that than what you did though – but you may want to try Yahoo Pipes to try that for your next event?

    Regardless, your live twittering of the Summit was invaluable — live blogging would not have had the same effect. Much appreciated Whitney!

  3. says

    Hi Whitney, Heidi recommended your blog to me as I was following the IA Summit remotely.

    There’s a WordPress plugin called Twitter Tools which will automatically publish your tweets as blog posts but it will only do a daily digest, I think… not exactly what you wanted here, on a per-session basis.

  4. says

    Megan, I was really looking forward to using LoudTwitter but it only works with Atom RSS feeds and I don’t think my WordPress blog has one.

    Jackson and Andy, thanks for the recommendations! Definitely planning to check out Yahoo! Pipes and will see if I have a need for the Twitter Tools plugin in the future.

    And to Livia and Matthew, I can’t thank you enough for your kind words and support. It was never my intention to be a pest. I hoped I was providing value at the conference and I’m glad that it was worth something to you, however small. Thanks again.

Leave a Reply

Your email address will not be published. Required fields are marked *