Weekly Web Harvest (weekly)

Posted from Diigo. The rest of my favorite links are here.

OER Presentation

I gave a variation of a talk I’ve given before about all the stuff on the web that ought to be considered both educational and open. My rather blurry definition of open is that I can link to it on the Internet without a password- from there it’s degrees of openness towards Nirvana.

I may be getting towards some elements that I think matter in the selfies series of links and with the Shorpy photo becoming a writing prompt randomizer thanks to interactions with Luke Neff. They both start to grow and change based on input, then interaction, and then creation.

Anyway, there may be some stuff that’s useful to someone and since I went to all the trouble of writing it down I might as well make it visible.

Screen Shot 2014-04-03 at 8.51.24 PM

Biology Field Journal – Gravity Forms + Google Maps for WordPress

Turns out this won’t work for what I originally planned but the pattern is sound. You can see the form here and examples of the form submissions here.

You’ll need Gravity Forms (pay but well worth it) and Google Maps for WordPress but the idea should work for all kinds things.

The original goal was to have structured posts from students and the ability to associate those posts with a point on Google Maps.

After turning on the plugins, all the work is done in Gravity Forms.

Initially, make a text entry fields for latitude and separate text field for longitude. Add all the other fields you want in the mix. In this case we added some categories to do with the environment, plant descriptions etc.

Gravity Forms is fairly unique in that it has post elements for WP built in. I added the Post Body and Post Title fields at the bottom. Now we just need to create the content template that’ll mix our variables into the body of the post.

Screen Shot 2014-04-03 at 8.51.24 PM


You’ll notice in the image above that when  you mouse over an element it displays the Field ID – in this case 2. That’s important as to add this field you’ll need to reference both the title and the field ID like so {Latitude:2}.

The image below blends the form entries and the shortcode for the Google Map plugin in a way that’s transparent to the user.

Screen Shot 2014-04-03 at 8.51.53 PM


It’s important to then flip over to the advanced properties of the post form entry and change the visibility to Admin Only. That will keep users from seeing this element in the form.

Screen Shot 2014-04-03 at 8.52.15 PM

Oh yeah, the cheaters way to get latitude/longitude is to go to Google maps and either enter the address or move the map until the place you want is about in the middle. In the URL, highlighted in blue below, you’ll see the lat/long for the Hebrides ( between the @ and the first comma - 56.97835,-7.4873145).

Also, here’s the export of my  Gravity Form if you want to use it as a starting point. gravityforms-export-2014-04-04.xml


Citation Workflow – Diigo/Pinterest to Google SS

Talking to Bud the other day he mentioned that generating the citation page for his digital stories was something of a pain. I’ve thought about it a bit since then and decided to try to simplify a workflow for this.

Odd thing I learned – - CHAR(10) is the official way to get line breaks in Google Spreadsheet formulas.

Flickr to Diigo to Google Spreadsheets

Initially, I looked at the Flickr galleries because that’s the option that Bud normally uses. I saw that the gallery was in a standard HTML list format and I had some hope. Google spreadsheets lets you pull lists and tables like these in via the IMPORTHTML function. Martin Hawksey has some good instructions and examples over here. So that failed but I could import just about every other list on the page.

So, I decided doing this through Diigo would make pretty decent sense for a number of people.

Assuming you choose a unique tag for the images you plan to use- this example just uses “flickr”, I’d suggest something story/movie specific. So the basic Diigo URL you’d get is https://www.diigo.com/user/bionicteaching/flickr. Trying to make this really easy for people, I set up the first page to allow you to paste that URL in and our friendly formulas transform it into https://www.diigo.com/rss/user/bionicteaching/flickr.

The example linked here reformats the RSS feed into something like what’s below. Making it really easy to cut/paste into credits or publish as a webpage and link to in your video description. With minor effort you could make it even prettier or assume a different format. If it interests you, click here and choose FILE>MAKE A COPY to have one of your very own.


Pinterest to Google Spreadsheets

I did get to thinking that Diigo is not the most visual of bookmarking options and wondered if I might be able to do something similar using Pinterest. Turns out, only sort of.

You can get the RSS feed in no problem. You just add RSS to the end of the board URL and you’ve got a feed. It loads fine into the spreadsheet . . . but it doesn’t hold much info.

You can get the date/time of pinning, the description, and the URL to the pit itself (which does site the source and provide a link back to the original- but none of that is in the RSS feed).

I’m not overly impressed. I may revisit later with a little more effort and something beyond a vanilla Google spreadsheet. In any case, if you want a copy here it is.