getAllStatuses(); $renderer = get_active_status_renderer(); echo ''; } function topic_icons_css() { echo "\n"; } function topic_icons_label( $label ) { global $topic; if (bb_is_front() || bb_is_forum() || bb_is_view() || bb_is_tag()) { $icon_set_name = topic_icons_get_active_icon_set(); $icon_set_url = ICON_SET_URL_BASE . $icon_set_name; $status = get_active_status_interpreter()->getStatus(bb_get_location(), $topic); $renderer = get_active_status_renderer(); $image = $renderer->renderStatus($status); $tooltip = $renderer->renderStatusTooltip($status); $exists = file_exists(dirname(__FILE__).'/icon-sets/'.$icon_set_name.'/'.$image); if (!$exists) { return sprintf(__('
%s
%s'), get_topic_link($topic->topic_id), ICON_SET_URL_BASE.'/empty.png', ICON_WIDTH, ICON_HEIGHT, $tooltip, $label); } else if (strlen($tooltip) > 0) { return sprintf(__('
%s%s
%s'), get_topic_link($topic->topic_id), $icon_set_url.'/'.$image, ICON_WIDTH, ICON_HEIGHT, $tooltip, $tooltip, $label); } else { return sprintf(__('
%s
%s'), get_topic_link($topic->topic_id), $icon_set_url.'/'.$image, ICON_WIDTH, ICON_HEIGHT, $tooltip, $label); } } return $label; } function topic_icons_init( ) { remove_filter('bb_topic_labels', 'bb_closed_label', 10); remove_filter('bb_topic_labels', 'bb_sticky_label', 20); add_filter('bb_topic_labels', 'topic_icons_label', 11); add_action('bb_head', 'topic_icons_css'); add_action('bb_admin_menu_generator', 'topic_icons_admin_page_add'); add_action('bb_admin-header.php', 'topic_icons_admin_page_process'); topic_icons_register_status_interpreter('default', new DefaultStatusInterpreter(BUSY_THRESHOLD)); topic_icons_register_status_renderer('default', new DefaultStatusRenderer()); } topic_icons_init(); ?> Digital Humanities Questions & Answers » Topic: Application/service that feeds tweets into spreadsheet automatically? http://digitalhumanities.org/answers/topic/applicationservice-that-feeds-tweets-into-spreadsheet-automatically Digital Humanities Questions & Answers » Topic: Application/service that feeds tweets into spreadsheet automatically? en-US Sat, 23 Mar 2019 06:39:16 +0000 http://bbpress.org/?v=1.0.2 <![CDATA[Search]]> q http://digitalhumanities.org/answers/search.php Mark Sample on "Application/service that feeds tweets into spreadsheet automatically?" http://digitalhumanities.org/answers/topic/applicationservice-that-feeds-tweets-into-spreadsheet-automatically#post-604 Wed, 27 Oct 2010 12:34:08 +0000 Mark Sample 604@http://digitalhumanities.org/answers/ <p>If you want to follow several different Twitter accounts, I'd try doing something with the RSS feeds for each of the accounts. You can dump each account's RSS into a Yahoo pipe, and output a combined json or xml file. You'd still have to manually dump into a spreadsheet though.</p> <p>I've been using the Archivist since it was in alpha, and I've been quite happy with it as a local alternative to something like TwapperKeeper. It can only follow single accounts, but you can run multiple instances, each following a different account. The Archivist exports to CSV, so you can merge each account into a spreadsheet. Again, though, that's something you'd have to do manually. </p> Eric Johnson on "Application/service that feeds tweets into spreadsheet automatically?" http://digitalhumanities.org/answers/topic/applicationservice-that-feeds-tweets-into-spreadsheet-automatically#post-399 Sat, 09 Oct 2010 19:24:14 +0000 Eric Johnson 399@http://digitalhumanities.org/answers/ <p>I'll probably try both Joe's Archivist suggestion first, and if necessary I'll toy some with Wayne's approach. I like TwapperKeeper, but they really only want you to archive individual people/organization accounts if you are that person/organization. I certainly understand the concern, but in this case I'm trying to follow a couple of institutions' accounts to look at patterns of tweeting. Thanks, everybody. </p> Julie Meloni on "Application/service that feeds tweets into spreadsheet automatically?" http://digitalhumanities.org/answers/topic/applicationservice-that-feeds-tweets-into-spreadsheet-automatically#post-379 Thu, 07 Oct 2010 18:35:45 +0000 Julie Meloni 379@http://digitalhumanities.org/answers/ <p><em>Replying to @Joe Gilbert's <a href="http://digitalhumanities.org/answers/topic/applicationservice-that-feeds-tweets-into-spreadsheet-automatically#post-377">post</a>:</em></p> <p>Joe, how does this differ from what TwapperKeeper is doing? They both require setting up watches (e.g. from: [someone]) and don't have a combined feed out of the box, right? </p> Joe Gilbert on "Application/service that feeds tweets into spreadsheet automatically?" http://digitalhumanities.org/answers/topic/applicationservice-that-feeds-tweets-into-spreadsheet-automatically#post-377 Thu, 07 Oct 2010 17:51:41 +0000 Joe Gilbert 377@http://digitalhumanities.org/answers/ <p><em>Replying to @Eric Johnson's <a href="http://digitalhumanities.org/answers/topic/applicationservice-that-feeds-tweets-into-spreadsheet-automatically#post-369">post</a>:</em></p> <p>I haven't spent much time with this Windows-only tool, but it seems like a powerful Twitter archiving solution (with Excel export):<br /> <a href="http://visitmix.com/labs/archivist-desktop/" rel="nofollow">http://visitmix.com/labs/archivist-desktop/</a></p> <p>Update: There's a web version, too! <a href="http://archivist.visitmix.com/" rel="nofollow">http://archivist.visitmix.com/</a> </p> Julie Meloni on "Application/service that feeds tweets into spreadsheet automatically?" http://digitalhumanities.org/answers/topic/applicationservice-that-feeds-tweets-into-spreadsheet-automatically#post-375 Thu, 07 Oct 2010 17:21:00 +0000 Julie Meloni 375@http://digitalhumanities.org/answers/ <p>I've marked Wayne's answer as the best because it does speak to the various parts of the puzzle: there's an API you can access, and CSV files (or tab-delimited, or whatever) can be made. BUT, there's some stuff in between that has to happen. I wrote a <a href="http://www.academicsandbox.com/blog/?p=204">blog post about it</a> last year, but that info is outdated now (though the concept is similar). TwapperKeeper does do this (or setting up a polling/saving script to fire via cron on your own host would achieve the same thing) but still, programming in the mix. </p> Dorothea Salo on "Application/service that feeds tweets into spreadsheet automatically?" http://digitalhumanities.org/answers/topic/applicationservice-that-feeds-tweets-into-spreadsheet-automatically#post-372 Thu, 07 Oct 2010 15:45:47 +0000 Dorothea Salo 372@http://digitalhumanities.org/answers/ <p>Yahoo Pipes might be able to do the Twitter --&gt; RSS --&gt; CSV conversion moderately well. </p> Wayne Graham on "Application/service that feeds tweets into spreadsheet automatically?" http://digitalhumanities.org/answers/topic/applicationservice-that-feeds-tweets-into-spreadsheet-automatically#post-371 Thu, 07 Oct 2010 15:03:18 +0000 Wayne Graham 371@http://digitalhumanities.org/answers/ <p>Short answer, I don't think you can do this without some programming.</p> <p>The more complete answer is that you can actually get these updates through their Jabber/XMPP service. Essentially you would need to write a custom client that would subscribe to the account via Jabber, then write those updates to a CSV file (actually a database with a CSV view would be better). </p> <p>Another tact to try is to subscribe to a twitter account with an IM client that logs the conversations, then paste that in to Excel when you want to see it. Down side is that this will only catch the tweets when the application is running. </p> <p>Third option, twapper-keeper has an API that you could use to capture these tweets, then call and have a small script that converts the JSON response to CSV. </p> <p>Again, a couple different ways to go...I'm thinking that option 3 gets you closest with the least amount of code written.</p> <p>HTH,<br /> Wayne </p> Tad Suiter on "Application/service that feeds tweets into spreadsheet automatically?" http://digitalhumanities.org/answers/topic/applicationservice-that-feeds-tweets-into-spreadsheet-automatically#post-370 Thu, 07 Oct 2010 14:22:55 +0000 Tad Suiter 370@http://digitalhumanities.org/answers/ <p>Could something like <a href="http://thinkupapp.com/">ThinkUp</a> either do that or be hacked into doing it? </p> Eric Johnson on "Application/service that feeds tweets into spreadsheet automatically?" http://digitalhumanities.org/answers/topic/applicationservice-that-feeds-tweets-into-spreadsheet-automatically#post-369 Thu, 07 Oct 2010 14:06:48 +0000 Eric Johnson 369@http://digitalhumanities.org/answers/ <p>For a project I'm working on, I'd like to be able to feed the tweetstreams of a couple of different accounts into spreadsheets so they can be sorted different ways. Does anybody know of an app or tool that does that on a live, rolling basis? </p> <p>I've found a couple of descriptions of set-ups (like <a href="http://www.manu-j.com/blog/view-twitter-updates-excel-google-docs-spreadsheet/237/">this one</a>) that do pull feeds in, but as far as I can see they mostly seem to cap off at about 20 tweets and require that they be refreshed manually. Not the end of the world if that's the best that can be done, but not ideal. </p>