Twitter Search Term Extraction

PingBack from http://realurl.org/twitted.php?id=5952509952

PingBack from http://topsy.com/tb/bit.ly/4SdLHx

Thanks for this - and for the great presentation at SQLBits. And apologies for asking the question about searching using this package - hope it wasn't too much work!

Jamie,

This is an awesome. Glad to see you figured it out, and that I have finally come top at something. Ha!

I wonder how long until it is incorporated into the TwitterTaskSuite?

Hi,

Thanks for posting this I found it very interesting. I had trouble getting it working owing to my companies web proxy. May I suggest the following amendment to the CreateNewOutputRows method which uses an HTTPWebRequest as the input to the XMLReader to allow for the provision of web proxy credentials.

   public override void CreateNewOutputRows()

   {

       try

       {

           //var input = "semantic";

           var input = this.Variables.SearchTerm;

           var scrubbed = HttpUtility.UrlEncode(input);

           var wrq = HttpWebRequest.Create(string.Format("http://search.twitter.com/search.atom?rpp=100&lang=en&q={0}", input));

           wrq.Proxy = WebProxy.GetDefaultProxy();

           wrq.Proxy.Credentials = CredentialCache.DefaultCredentials;

           var reader = XmlReader.Create(wrq.GetResponse().GetResponseStream());

                //string.Format("http://search.twitter.com/search.atom?rpp=100&lang=en&q={0}", input));

           var feed = SyndicationFeed.Load(reader);

           foreach (SyndicationItem item in feed.Items)

           {

               Output0Buffer.AddRow();

               Output0Buffer.tweet = item.Title.Text;

               Output0Buffer.tweeter = item.Authors[0].Name;

               Console.WriteLine("\t{0} - {1}", item.Authors[0].Name, item.Title.Text);

           }

       }

This is awesome, you enabled me to get up archiving and analyzing my companies tweets in less than 2h. Thanks a ton!

Jan

This was great! Super easy to impliment. Within one day I was able to add twitter data to our ODS. Thanks! Does anyone know if it is possible - or what is the best way - to retrive status posts from facebook and myspace?