Image from page 981 of “A system of instruction in X-ray methods and medical uses of light, hot-air, vibration and high-frequency currents : a pictorial system of teaching by clinical instruction plates with explanatory text : a series of photographic cli flickr photo by Internet Archive Book Images shared with no copyright restriction (Flickr Commons) This is a bit odd but if you work in education it’s quite possible it’ll come up . . . Sometimes people just want the blog comments in a nice friendly CSV file. That might be for grading, it might be for further analysis in Voyant or something like that. What I need to do is write a little plugin for the export like Alan did for posts but until I get around to that I took advantage of another plugin Alan wrote to expand comments to the 100 most recent comments. So since I have lots of comments available in the feed, I can just use the =IMPORTXML function to port right into Google Sheets. There’s probably a smart way to parse out multiple XML fields at a time but this seems to work ok. All the functions I used are broken down in the sheet embedded below. Most are simply some version of IMPORTXML(b1,”//title”). B1 is the URL for the feed and the […]
Functional is a kind way to describe this . . . but it’s hard to argue with computers doing tedious work that was previously done by hand. The goal here was to automate the collection of the comments on 300 or so posts from the CDC’s Facebook page so they could be analyzed. Ebola is in the mix which leads to some comments that may very well rival YouTube comments in terms of causing me sadness. We did end up with around 34,000 comments which would have been hand copied in the past. So some karma balance was achieved. wTake all this with a grain or two of salt. It works but may very well be illegal in some states or do things in a way that would make real programmers weep. Consider my programming skills to be like a man trying to swat flies with a broomstick- lots of furious action, panting, cursing, and every so often I will kill a fly and celebrate wildly.1 The Facebook This was my first experience trying to do anything with Facebook. The hardest part here for me was just getting the stupid access token needed to get at the JSON feeds. I eventually found the secretly named Facebook Login Example. Part of my issue was that I thought I could skip the […]
flickr photo shared by duncan under a Creative Commons ( BY-NC ) license It’s particularly helpful in a rather specific situation- i.e. one where you’re doing a mother blog and want to see all the student comments (like Allen did with the #thoughtvectors reader) but since we have students using their blogs for more than one class things get messy fast. Enter me asking smarter people on Twitter, almost going to the forsaken land of Yahoo Pipes,1 and being saved by Google liking Mark more than me. So anyway, here’s the structure to get the comments for specific categories/tags. by name – http://bionicteaching.com/comments/feed/?category_name=apple by category ID – http://bionicteaching.com/comments/feed/?cat=18 by tag name – http://bionicteaching.com/comments/feed/?tag=tutorial-2 This is one of those things that barely rates a post but given I didn’t know how to do it maybe it’ll help some other wanderer and for people who want this it’ll be really useful. Thanks to Mark, Alan, and Martin for helping me out. 1 I like Yahoo Pipes but one has to assume Yahoo will kill it dead very soon . . . although I’ve been hearing that for several years.