V talks tech … well, a bit!

V talks tech … well, a bit! Never thought I’d write a tech post but here goes! Brian Inkster and Gavin Ward have both asked how I get all the tweets with the hashtag #cclivechat out of my stream and on my blog. It requires a few free tools and it is easy. I’ll try to explain this as good as I can. However, if it is not clear do not worry! My tech man, Jacques Soudan, is on stand-by!

Step 1:

To make sure that I can concentrate on only those tweets that carry the hashtag #cclivechat I use Tweetchat and allow them access to my Twitter account. I revoke that access immediately after the chat is over. Sign in,  allow access and then fill in the desired hashtag at the top. You can follow Tweetchat on Twitter as well!

Step 2:

Photograph by AdS

After the chat I open SearchHash. This program does not need you to sign in or access to your Twitter account. Just fill in the desired hashtag and the dates. See picture. SearchHash is from Dave Briggs and Steph Gray. Follow them on Twitter!

Photograph by AdS

SearchHash will start to check Twitter in the time frame you indicated and search for tweets with the indicated hashtag. Just wait a bit and it will show you the search results. See picture.

Step 3:

Now that you have all your tweets with the desired hashtag you need to click on “download these results in CSV format (opens in Excel, OpenOffice, etc).” Be patient.

Spreadsheet & Photograph by AdS

On my computer, I can see that downloading has started and when it is complete. Since I have Excel installed, I get an Excel alert that my downloaded file has arrived.

Step 4:

Open your Excel program and the downloaded file. As you can see then, the first column shows people’s Twitter ID. I always delete that first column and only post people’s Twitter handle.

Step 5:

Photograph by AdS

After that, you need to make sure that columns B and C with the tweet and the time get “wrapped” so you can keep the columns narrow.

Select column B, click on format, go to cells, click alignment and then wrap text.

Photograph by AdS

Do the same for column C that has the time stamp for each tweet. See pictures.

Step 6:

Now that you’ve done that you need to sort all the tweets by time. This way, your readers can follow the verbatim thread from the top down instead of having to scroll down and then slowly back up.

Photograph by AdS

Select all three columns and go to date. Click on sort. If you kept the header row, select it so it remains on top. Then sort by column. We want to sort by time so here it would be column C. We need ascending as we want the first tweet on top. See pictures.

After that is done, save everything. Now we go to WordPress!

Step 7:

Log in and go to your dashboard. In the left-hand margin you should find tools. Now in my version, I have “WP Table Re-Loaded” already installed. I am not sure whether it comes with basic WordPress or whether my tech man put it there for me.

Jacques? Your comments on this?

WP Table Reloaded was made by Tobias Bg. His Twitter account is here.

Step 8:

After you open this, you see at the top “import a table.” Select and start browsing your computer for the exact file you wish to insert here. Be patient. Depending on how many tweets there were this can take some time. Also, I found that when you have a lot of tweets in the Excel spreadsheet it imports, the side bar gives off  a “false alert.” It jumps back to the top making you think it is done but it isn’t. I just give it a few minutes.

Step 9:

You will now see your Excel spreadsheet in the WP Table! Depending on whether you kept your header row in Excel or not, scroll down to uncheck the box “table head.” It says “The first row of your table is the table head (HTML tags <thead> and <th>).” I do not use header rows so I uncheck that box. Click and save all changes.

Step 10:

At the top of the table you should see in bold a short-code. This is the table-‘placeholder’ to be used in your post. You need to copy that and paste it into the corresponding place in the editor where you are typing your blog post. I undo the bold but that is personal. Now save your post as a draft. Click on preview and see whether you like it. Is the table nicely positioned within the columns of your theme?

If not, ask Jacques what to do! Ha! You didn’t really expect me to know that, did you?

TheTimeBlawgRT @vidocq_cc: Recap #cclivechat with @GavWard on DCC http://t.co/QqvrA4PSSat, 28 Apr 2012 11:27:53 +0000
TheTimeBlawg@vidocq_cc Is there an App to capture and install the #cclivechat verbatim thread in Wordpress? cc @GavWardSat, 28 Apr 2012 11:30:28 +0000
WardBlawgRT @thetimeblawg: RT @Vidocq_CC: Recap #cclivechat with @GavWard on DCC http://t.co/rztstB4sSat, 28 Apr 2012 13:07:47 +0000

Anyway, this is how I have made the recaps of #cclivechat and how they have appeared so neatly within the columns of my WordPress theme.

I hope this made sense.

Cheers, V







  1. […] different manner. Spreadsheets are not just for accounting. You can use them for time-lines and to recap chats on Twitter. Lengthy blog posts such as a cold case analysis can be divided in shorter pieces. You […]