Recently, I passed the 700 tweet mark and decided to archive what I had. But how? I gleaned the following tidbits from "Twitter Tips, Tricks, and Tweets" by Paul McFedries - founder and CEO of Mashable. You can save a local copy of your tweets by entering the following URL in your browser:
http://twitter.com/statuses/user_timeline/account.xml?count=n
where account = your account name, and
n = number of tweets
where account = your account name, and
n = number of tweets
This will open n number of your tweets to date in XML in your browser. From here, you can import your saved XML file into Excel 2007 as follows:
1) In Excel, click on the Data tab
2) Data -> From Other Data Sources - From XML Data Import
3) Click a cell where you want to import the data to
4) Save as, using the id of the last tweet
The reason I include the last Tweet id# is to make it easy to archive next time, starting where I left off and using the following syntax:
http://twitter.com/statuses/user_timeline/account.xml?since_id=6839319097
If you look at the Excel sheet you will see that the last tweet had an ID of 6839319097. This will download an XML version of all my tweets since then. Now I have a proper archive of my tweets that I can search on :-)
From here, you might want to take a look at the TweetSharp API - a complete .NET library allowing you to build Twitter applications in C# and .NET 3.5. I've started reading a great book on the topic: "Professional Twitter Development with Examples in .NET 3.5" by Daniel Crenna.
0 Comments Received
Leave A Reply