{"id":975,"date":"2012-10-02T11:53:51","date_gmt":"2012-10-02T10:53:51","guid":{"rendered":"http:\/\/forestrowfilmsociety.org\/news\/?p=975"},"modified":"2013-03-21T17:57:27","modified_gmt":"2013-03-21T16:57:27","slug":"creating-the-bffs-twitter-archive","status":"publish","type":"post","link":"https:\/\/forestrowfilmsociety.org\/news\/2012\/10\/creating-the-bffs-twitter-archive\/","title":{"rendered":"Creating the BFFS conference Twitter archive"},"content":{"rendered":"

This is an unusually geeky post for this blog, but several people asked how I’d created the combined page of all the tweets for the BFFS national conference and Film Society of the Year awards<\/a> in a permanent, readable form.<\/p>\n

Twitter makes it easy for developers to do stuff with the data on the Twitter service by publishing its API. This is the reason why there are loads of Twitter applications, visualisation tools and much else, since they\u2019ve invariably been developed by someone outside Twitter, who quite reasonably take the view that you can\u2019t predict what users might want to do with this data, so it makes sense to give users the tools to build what they want.<\/p>\n

There are several useful blog posts about how to download Twitter content, and the most useful for me was that on the IBM site.1<\/sup><\/a> This in turn pointed me to the Twitter API documentation2<\/sup><\/a>, and using the two sources together meant that I could quickly find all of the conference tweets on the two hashtags using:<\/p>\n

http:\/\/search.twitter.com\/search.atom?q=%23BFFSnatconf+OR+%23FSOY2012&page=1&rpp=100<\/pre>\n
This generated a feed in Atom format3<\/sup><\/a>, so I could save the underlying XML data. Now, since the maximum number of results per page (\u201crpp<\/tt>\u201d) this query can return is 100, I needed to change the value of the page<\/tt> parameter several times and re-run the query so I could get all the data. Clearly, this is OK for a few hundred items like we have but not a scalable solution.<\/p>\n
Next, I concatenated the important content of all six XML files together, to create a single well-formed file containing all the tweets. This gave us over 500 items, each of which had this structure:<\/p>\n
<entry>\r\n   <id>tag:search.twitter.com,2005:249906722150424576<\/id>\r\n   <published>2012-09-23T16:23:00Z<\/published>\r\n   <link type=\"text\/html\" href=\"http:\/\/twitter.com\/NewcastleCinema\/statuses\/249906722150424576\"\r\n       rel=\"alternate\"\/>\r\n   <title>Get yourself to the bar!! @MinicineYorks #BFFSnatconf<\/title>\r\n   <content type=\"html\">Get yourself to the bar!! @&lt;a class=\" \"\r\n       href=\"https:\/\/twitter.com\/MinicineYorks\"&gt;MinicineYorks&lt;\/a&gt; &lt;em&gt;&lt;a\r\n       href=\"http:\/\/search.twitter.com\/search?q=%23BFFSnatconf\" title=\"#BFFSnatconf\" class=\"\r\n       \"&gt;#BFFSnatconf&lt;\/a&gt;&lt;\/em&gt;<\/content>\r\n   <updated>2012-09-23T16:23:00Z<\/updated>\r\n   <link type=\"image\/png\"\r\n       href=\"http:\/\/a0.twimg.com\/profile_images\/1640504972\/twitterAvatar_reasonably_small_normal.gif\"\r\n       rel=\"image\"\/>\r\n   <twitter:geo\/>\r\n   <twitter:metadata>\r\n       <twitter:result_type>recent<\/twitter:result_type>\r\n   <\/twitter:metadata>\r\n   <twitter:source>&lt;a href=\"http:\/\/twitter.com\/download\/iphone\"&gt;Twitter for\r\n       iPhone&lt;\/a&gt;<\/twitter:source>\r\n   <twitter:lang>en<\/twitter:lang>\r\n   <author>\r\n       <name>NewcastleCinema (NCC)<\/name>\r\n       <uri>http:\/\/twitter.com\/NewcastleCinema<\/uri>\r\n   <\/author>\r\n<\/entry><\/pre>\n
In addition, some of the tweets reference pictures from the weekend, and it would be nice to include them in the stream, rather than have to follow the links, so those required a bit of hand-editing of the data to insert them, using a @rel=\"enclosure\"<\/tt> to distinguish them in the data:<\/p>\n
<link rel=\"enclosure\" href=\"https:\/\/pbs.twimg.com\/media\/A3i_RJVCYAE-TuT.jpg\"\/><\/pre>\n
Now, there\u2019s lots of stuff in there that we don\u2019t really need, and it would be easier to read them all if they were in chronological order, for instance, so I then sorted them and tidied up the rendering to make a single HTML page using XSLT (see example below). In addition, the default date\/time format that you get back from Twitter is the ISO 8601 standard (\u201c2012-09-24T11:12:30Z<\/tt>\u201d), which isn\u2019t very readable; that can also be modified in the XSLT, for which I used a slightly modified version of code on an Austrian blog4<\/sup><\/a>:<\/p>\n
<xsl:stylesheet version=\"2.0\" xmlns:xsl=\"http:\/\/www.w3.org\/1999\/XSL\/Transform\" xmlns:xs=\"http:\/\/www.w3.org\/2001\/XMLSchema\" xmlns:fn=\"http:\/\/www.w3.org\/2005\/xpath-functions\" xmlns:google=\"http:\/\/base.google.com\/ns\/1.0\" xml:lang=\"en-US\" xmlns:openSearch=\"http:\/\/a9.com\/-\/spec\/opensearch\/1.1\/\" xmlns:atom=\"http:\/\/www.w3.org\/2005\/Atom\" xmlns:twitter=\"http:\/\/api.twitter.com\/\" xmlns:georss=\"http:\/\/www.georss.org\/georss\" exclude-result-prefixes=\"google openSearch twitter georss xs fn atom\" xpath-default-namespace=\"http:\/\/www.w3.org\/2005\/Atom\">\r\n  <xsl:output method=\"xml\" version=\"1.0\" encoding=\"UTF-8\" indent=\"yes\"\/>\r\n  <xsl:template match=\"@*|node()\">\r\n    <xsl:apply-templates select=\"@*|node()\"\/>\r\n  <\/xsl:template>\r\n  <xsl:template match=\"\/\">\r\n    <html>\r\n      <head>\r\n        <title>#BFFSnatconf | #FSOY2012 : A conference in tweets<\/title>\r\n      <\/head>\r\n      <body>\r\n        <h1>#BFFSnatconf | #FSOY2012<\/h1>\r\n        <h2>A conference in tweets<\/h2>\r\n        <h3>BFFS National Conference and Film Society of the Year awards, 2012<\/h3>\r\n        <xsl:for-each select=\"atom:feed\/atom:entry\">\r\n<!-- Sort the items in chronological order -->\r\n          <xsl:sort select=\"atom:published\" order=\"ascending\"\/>\r\n          <div>\r\n            <p class=\"dateline\">On <a>\r\n                <xsl:attribute name=\"href\"><xsl:value-of select=\"atom:link[@rel='alternate']\/@href\"\/><\/xsl:attribute>\r\n                <span class=\"date\">\r\n                  <xsl:call-template name=\"FormatDate\">\r\n                    <xsl:with-param name=\"DateTime\" select=\"atom:published\"\/>\r\n                  <\/xsl:call-template>\r\n                <\/span><\/a>, <a>\r\n                <xsl:attribute name=\"href\"><xsl:value-of select=\"atom:author\/atom:uri\"\/><\/xsl:attribute>\r\n                <span class=\"author\"><xsl:value-of select=\"atom:author\/atom:name\"\/><\/span>\r\n              <\/a> wrote:<\/p>\r\n            <p class=\"content\">\r\n              <xsl:value-of select=\"atom:content\" disable-output-escaping=\"yes\"\/>\r\n              <xsl:if test=\"atom:link[@rel='enclosure']\"><xsl:apply-templates select=\"atom:link[@rel='enclosure']\" \/><\/xsl:if>\r\n            <\/p>\r\n          <\/div>\r\n        <\/xsl:for-each>\r\n      <\/body>\r\n    <\/html>\r\n  <\/xsl:template>\r\n    <xsl:template name=\"FormatDate\">\r\n        <xsl:param name=\"DateTime\" \/>\r\n        <xsl:variable name=\"mo\">\r\n           <xsl:value-of select=\"substring($DateTime,6,2)\" \/>\r\n        <\/xsl:variable>\r\n        <xsl:variable name=\"day\">\r\n           <xsl:value-of select=\"substring($DateTime,9,2)\" \/>\r\n        <\/xsl:variable>\r\n        <xsl:variable name=\"year\">\r\n           <xsl:value-of select=\"substring($DateTime,1,4)\" \/>\r\n        <\/xsl:variable>\r\n        <xsl:variable name=\"time\">\r\n           <xsl:value-of select=\"substring($DateTime,12,8)\" \/>\r\n        <\/xsl:variable>\r\n        <xsl:variable name=\"hh\">\r\n           <xsl:value-of select=\"substring($time,1,2)\" \/>\r\n        <\/xsl:variable>\r\n        <xsl:variable name=\"mm\">\r\n           <xsl:value-of select=\"substring($time,4,2)\" \/>\r\n        <\/xsl:variable>\r\n        <xsl:variable name=\"ss\">\r\n           <xsl:value-of select=\"substring($time,7,2)\" \/>\r\n        <\/xsl:variable>\r\n           <xsl:value-of select=\"$day\"\/><xsl:text> <\/xsl:text>\r\n                <xsl:choose>\r\n          <xsl:when test=\"$mo=1\">January<\/xsl:when>\r\n          <xsl:when test=\"$mo=2\">February<\/xsl:when>\r\n          <xsl:when test=\"$mo=3\">March<\/xsl:when>\r\n          <xsl:when test=\"$mo=4\">April<\/xsl:when>\r\n          <xsl:when test=\"$mo=5\">May<\/xsl:when>\r\n          <xsl:when test=\"$mo=6\">June<\/xsl:when>\r\n          <xsl:when test=\"$mo=7\">July<\/xsl:when>\r\n          <xsl:when test=\"$mo=8\">August<\/xsl:when>\r\n          <xsl:when test=\"$mo=9\">September<\/xsl:when>\r\n          <xsl:when test=\"$mo=10\">October<\/xsl:when>\r\n          <xsl:when test=\"$mo=11\">November<\/xsl:when>\r\n          <xsl:when test=\"$mo=12\">December<\/xsl:when>\r\n        <\/xsl:choose><xsl:text> <\/xsl:text>\r\n                <xsl:value-of select=\"$year\"\/><xsl:text>, <\/xsl:text>\r\n                <xsl:value-of select=\"$hh\"\/><xsl:text>.<\/xsl:text>\r\n                <xsl:value-of select=\"$mm\"\/><xsl:text>:<\/xsl:text>\r\n                <xsl:value-of select=\"$ss\"\/>\r\n    <\/xsl:template>\r\n<!-- Handle the manually-added pictures -->\r\n    <xsl:template match=\"atom:link[@rel='enclosure']\">\r\n    <div class=\"image\"><img alt=\"Image referenced in the post\" ><xsl:attribute name=\"src\"><xsl:value-of select=\"@href\"\/><\/xsl:attribute><\/img><\/div>\r\n    <\/xsl:template>\r\n<\/xsl:stylesheet><\/pre>\n
So, creating the Twitter stream for a single event was actually quite quick, though did require some knowledge of XML and XSLT. Now what else can we do with it? Well, it wouldn’t be hard now to create the book of the conference, using a tool like Blurb<\/a> or Lulu<\/a>, though you’d obviously lose all the benefit of the links. That can be something for the future….<\/p>\n
Notes<\/h4>\n
1. Carey, Brian M. \u2018Using the Twitter Search API: Create automated tweet searches.\u2019 4 Aug 2009. IBM developerWorks<\/em>. 24 Sep 2012 <http:\/\/www.ibm.com\/developerworks\/xml\/library\/x-twitsrchapi\/<\/a>><\/p>\n
2. \u2018REST API v.1.1 Resources.\u2019 Twitter Developers<\/em>. 24 Sep 2012 <https:\/\/dev.twitter.com\/docs\/api\/1.1<\/a>>.<\/p>\n
3. Nottingham, M. and Sayre, R. \u2018The Atom Syndication Format.\u2019 RFC4287. Dec 2005. 24 Sep 2012. <http:\/\/tools.ietf.org\/html\/rfc4287<\/a>><\/p>\n
4. Beer, Florian. \u201cXSLT: convert ISO 8601 DateTime format.\u201d 10 Apr 2008. Blog.No-Panic.At<\/em>. 24 Sep 2012. <http:\/\/blog.no-panic.at\/2008\/04\/10\/xslt-convert-iso-8601-datetime-format\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
This is an unusually geeky post for this blog, but several people asked how I’d created the combined page of all the tweets for the…<\/p>\n","protected":false},"author":1,"featured_media":992,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[23],"tags":[],"_links":{"self":[{"href":"https:\/\/forestrowfilmsociety.org\/news\/wp-json\/wp\/v2\/posts\/975"}],"collection":[{"href":"https:\/\/forestrowfilmsociety.org\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/forestrowfilmsociety.org\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/forestrowfilmsociety.org\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/forestrowfilmsociety.org\/news\/wp-json\/wp\/v2\/comments?post=975"}],"version-history":[{"count":23,"href":"https:\/\/forestrowfilmsociety.org\/news\/wp-json\/wp\/v2\/posts\/975\/revisions"}],"predecessor-version":[{"id":1634,"href":"https:\/\/forestrowfilmsociety.org\/news\/wp-json\/wp\/v2\/posts\/975\/revisions\/1634"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/forestrowfilmsociety.org\/news\/wp-json\/wp\/v2\/media\/992"}],"wp:attachment":[{"href":"https:\/\/forestrowfilmsociety.org\/news\/wp-json\/wp\/v2\/media?parent=975"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/forestrowfilmsociety.org\/news\/wp-json\/wp\/v2\/categories?post=975"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/forestrowfilmsociety.org\/news\/wp-json\/wp\/v2\/tags?post=975"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}