Image taken from page 12 of ‘Guide to Cambridge: the town, university and colleges … To which are added, notes upon the villages within ten miles, a map, etc’ flickr photo by The British Library shared with no copyright restriction (Flickr Commons) This is more playing with Martin‘s TAGs in Google Script and then moving it into Google Maps for visuals . . . the TAGS related functions will only work in that context but the purse Google stuff should work in any spreadsheet. Get Twitter Location by Account This function will get the user’s location as defined by their profile. So =getLoc(“twoodwar”) would return Richmond VA. This function will get the lat/long via Google Script. So =getLl(“Richmond, VA”) would return 37.5407246, -77.4360481. Keep in mind if it’s trying to get the lat/lng for someone who put “the Interwebz” as their location like OnlineCrsLady then your lat/lng may not work out that well. So that’ll let us take a chunk of TAGs data.1 and do something like this with Google Maps. I’m not going to break this chunk down quite yet. I did it at very odd hours and it works but it’s not very clean and I know there are ways to do it better.There is no shame in my game but there is some bashfulness. Pretend I’m an […]
Joaquin Baldwin on Twitter: “I lined up the Getty Images source file to the White House print. It’s a warp deformer, look at the helicopter behind it. https://t.co/kJB2T8U5yh” What a world. What a world. Why I’m Leaving New York to Live in a Large Pile of Garbage That’s On Fire – McSweeney’s Internet Tendency We have a saying down at the garbage fire, “AAAAAAHHHH! NO!! It burns!!!!” Watchdog: Attkisson wasn’t hacked, had ‘delete’ key stuck | TheHill An inspector general report concluded that Sharyl Attkisson’s merely had her “delete” key stuck when text disappeared from her computer, and said there’s no evidence that government officials erased stories. 2017 week 3 in review – D’Arcy Norman dot net I was surprised, again, that none of the students had edited a web page outside of Facebook. A handful had heard of wordpress, but nobody had every used it. So many things I have taken for granted, absorbed by the modern social web. This is going to take a long time to repair. We’ve lost a lot as a society when our brightest minds have no personal knowledge of publishing and sharing knowledge beyond Facebook posts.
Image from page 60 of “Children’s ballads from history and folklore” (1886) flickr photo by Internet Archive Book Images shared with no copyright restriction (Flickr Commons) Driven mad by curiousity after this Matthew Baldwin tweet, I built this little thing. It uses the amazing Martin Hawksey’s TAGS for gathering the Tweets in Google Sheets and then displays it with Vue.js (which I’m sort of learning). It led me to realize that I could extend TAGS without much effort. My first attempt was to write two custom functions to get favorites and retweets. Turns out that was pretty straight forward given all Martin’s work. The TAGS element (TAGS.get) links me into Martin’s library and that’s that. So very easy once you know and then you’re just navigating the Twitter API. Turns out I can do something similar to get the Twitter bio. Initially, I just stuck these in like you’d do normal functions … =getRT(A1) or whatever and it soon ate up all the processing time allowed for my Google Scripts. That caused other things to break. Lesson learned. I then opted to set the value in the script and write that value to the cell. This little script runs on the spreadsheet change trigger and checks to see if there are any blank cells in the Favorites column (column U) […]
Image from page 93 of “Elementary and dental radiography” (1813) flickr photo by Internet Archive Book Images shared with no copyright restriction (Flickr Commons) This is the blow-by-blow documentation of a failure of sorts. Nothing makes me angrier than failing to deliver on something I said I could/would do. I ended up delivering what was needed but the way I had to do it was ugly and time-intensive. All of this happened because of two things- insufficient initial testing and not enough knowledge on my end at a couple of key steps. I’ve got lots of ideas I need to test out now that I’ve learned a few things the hard way but I thought it’d be beneficial to see how I tried to think through this thing when various paths failed . . . and with that welcome to my postmortem. I thought we had the Social Work Google Docs Digital Portfolio thing figured out. I even wrote a blog post. Events coalesced to remind me that I do not know enough stuff. However, I do intend to learn from painful mistakes like this and give you my tears and frustration for you free of charge.1 Initial tests felt a bit slow but nothing too bad. Google Scripts will timeout after 6 minutes but I thought we’d be ok […]
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 […]
I’ve missed a few weeks. No guilt. I am playing around with more phone photography. I doing some stuff on Instagram but have mixed feelings there. Lots of ‘likes’ and what not but I’m not sure what else. Given a chunk of the missed time was over break you’ll see a lot more nature shots in here. I’m also drawing more with the kids. Using only the finest Bic pens . . .
Rogue Scientists Race to Save Climate Data from Trump | WIRED At Penn, a group of coders that called themselves “baggers” set upon these tougher sets immediately, writing scripts to scrape the data and collect them in data bundles to be uploaded to DataRefuge.org, an Amazon Web Services-hosted site which will serve as an alternate repository for government climate and environmental research during the Trump administration. (A digital “bag” is like a safe, which would alert the user if anything within it is changed.) It’s more than just the words Personal sites, our blogs, these were once our playgrounds. My own site was the first place I added rollover images, CSS for fonts, tried out a “table free” design. I wrote about the web, surrounded by my own experiments with the web. We all did, and it was only in reading those words from 1999 that I realised there was more to owning your own content than simply not publishing your words elsewhere.
Image from page 589 of “Modern magic. : A practical treatise on the art of conjuring.” (1885) flickr photo by Internet Archive Book Images shared with no copyright restriction (Flickr Commons) Our Social Work program has traditionally done large paper-based student portfolios. They wanted to move to something digital. That led to some conversations about Google Docs and our options there. They needed the ability to- provision a set of folders and documents to individual students allow the students to edit/add to the folders stop editing rights at a certain date make the student folder anonymous for faculty reviewers The solution I ended up coming up with uses a Google Spreadsheet with some custom Google Script. It’s based on a spreadsheet with column A being the student email and column B being the anonymous number or name. You make a parent folder (Social Work 2017) and put the spreadsheet and the folder (student portfolio) you want to copy in the folder. You add the student emails and secret IDs to the spreadsheet. The script is activated via custom-menu element imaginatively entitled ‘Share Files’ and it copies the student portfolio for each student email listed, names it with the addition of the secret ID, and gives the student editor rights to their particular folder and its contents. It also writes the […]
Peace sign selfies could let hackers copy your fingerprints Posing for a picture while holding your hands up in a peace sign could pose a security threat, with hackers able to recreate prints that are the key to phones, computers and tablets. Researchers at Japan’s National Institute of Informatics (NII) have found that fingerprints can be easily recreated from photos taken up to three metres away without the need for advanced technology. So long as the picture is clear and well-lit, prints can be mimicked. Richard Prince Disowns His Ivanka Trump Portrait, Possibly Increasing Its Value However, given the many layers of irony, filtering, and conceptual framing that characterize Prince’s oeuvre, it’s unclear whether his public disowning of the work will negatively affect its worth and status as an authentic Richard Prince, or, on the contrary, it will add to its resale value. Ram Pages Reflective Analysis | qwertyuiop While I have made efforts to improve my understanding of other ideas and beliefs, I don’t necessarily accept them as fact, but a possibility that should be considered. RamPages has made me aware of the way I articulate my ideas and encouraged me to be careful when discussing controversial or sensitive topics. It has also made me elaborate as to be sure my point came across the way it was intended.