Embed a Google Folder in Populr.me
We’ve had a few people who became big fans of populr.me. They’re also using Google Docs/Drive and since I like things to blend . . . here’s how you embed a Google Drive folder into populr.me. The example is here if you want to check it out.
Getting That iFrame Stuff
I started to write directions on how to do this but just built a little tool instead.
I remain kind of amazed with how many little tricks can be done with Google Sheets. After seeing Alan’s post today, I wonder how much of the data I could pull (assuming we had the right user names and knew the services . . . really the harder part) just using Google Sheets. Turns out we could get a pretty good amount. The following is a mix of XPath, regex, and APIs. I started with as little real programming as possible and gradually increased sophistication. The following are just meant to get a rough idea of how much stuff you’ve got in the various spaces. Flickr The URL: http://flickr.com/photos/bionicteaching The function: =IMPORTXML(C2,”//*[@class=’photo-count’]”) This uses a basic Google Sheets function to grab the photo-count content. The function is grabbing the div class with the title photo-count. Vimeo The URL: http://vimeo.com/twwoodward The function: =INDEX(IMPORTXML(C3,”//*[@class=’stat_list_count’]”),1) Pretty similar to the example above but with the addition of INDEX. That solves the problem that there are multiple items that are all in the stat_list_count class and we only want the first matching item. Sound Cloud The URL: http://soundcloud.com/cogdog The function: =REGEXEXTRACT(IMPORTXML(C4,”//*[@name=’description’]/@content”),”([0-9]+) Tracks”) This gets a bit fancier. IMPORTXML brings in a large chunk of content from the page but it wasn’t structured in a way that I could get the exact information I wanted. REGEX […]
Not perfect but control clicking on the title of the article in Feedly lets me choose Diigo Web Collector>Save to Diigo from the menu (on Chrome on a Mac with the Diigo plugin installed). I’m assuming right clicking on a PC will do the same. What’s funny is I’ve been trying to figure a decent way to do this for a while. I didn’t think it was worth the pro version fee. There are many people who want Feedly/Diigo integration (Delicious is the current default). I was about to go the very difficult route of trying to write a browser plugin similar to Alan’s Flickr CC attribution helper. I was already at the point of looking at Chrome’s API documentation. I was then in the place of wondering if a Chrome extension could impact a Chrome application . . . luckily I then thought of an amazingly easy straightforward solution. I know my reliance on the freemium tools of Internet is fraught with all kinds of drama. I’m working on it and I have backups. I will not weep if they wander off.
A while back I was messing with getting Instagram data without bothering with their API because I think their most recent API changes are really annoying. I’m also a bit fascinated with the scale of numbers in social media right now. I opted to look at Snoop Dogg’s Instagram followers and plot their change very 10 minutes. Click here or on the image to see the live chart. Get the Instagram Data w/o the API & Put it in the Database It turns out that each Instagram page has an embedded JSON file with the data I wanted. You can see it if you view the source of any page. This Stackoverflow post was kind enough to point it out and you see regex rearing it’s head again. I started out with my standard process of using Google Sheets as the database but decided I’d try MySQL because I wanted to try getting the JSON ought more cleanly. The chunk below grabs the data and puts it in the database. So that gets us the stuff we want in a nice little box on the Internet. I did try to do some fancy mysql stuff to avoid entering the change in followers as an additional field but I failed in enough ways that I just opted to proceed with the […]