Skip to main content


How To Create An Android App That Posts Pictures To Google Sheets

I used the MIT App Inventor site to create an Android app that... Uses the camera to take a picture and saves it to the device's gallery Let's you select a picture from the gallery The image is converted into base64 and uploaded to a web app Additionally, it also sends rotation and lat/lng coordinates and lets you add a textual comment as well. This Android app sends it to an Apps Script web application inside a Google Spreadsheet here . The web application saves the image to Google Drive, makes a thumbnail of the image then gets the latest 3 thumbnails from the sheet and returns it.  Inside the Android app is a WebViewer component that displays those images, that gets updated once the image is uploaded. It's not pretty but it works. This app wouldn't be possible without the TaifunFile, TaifunTools and SimpleBase64 extensions. Thanks, all. The App Inventor code is here .  You can import an .aia file directly into MIT App Inventor. There was some tricky stuff, having to
Recent posts

Using Google Sites As Portfolio Projects

Just completed another project where 40 students used (old) Google Sites (because they are Apps Scriptable) as Portfolio Sites. Each student gets a copy of a template site. After they have worked on it, and the deadline has arrived, they are given a COPY of their site (and made EDITOR), and they are removed from their original site. If the student wants to invite a personal Gmail account to this new site, and then that personal Gmail account makes a Copy of it, it is removed completely from the york domain - meaning when the student leaves, it won't be deleted. They can keep it forever. They THEN can, if they choose, upgrade their site to New Sites and make it look a bit fancier. If you want to do this, make your Template Site in Classic Sites, then... File > Make a copy , fill in your students   edit the code Tools > Script Editor where it says CHANGE_THIS  Here are the ins

What's Going On?

About me   My Work At University of York A list of old projects here including a Marking App,  an iPad app and 3Sixty installation. Scraping "Sugar Tax" information from UK Government sites then running with semantic and sentiment analysis. Playing with scraping Box of Broadcast transcripts, and automatic MoviePy editing.   Chapbooks in the Borthwick on Glitch in Django Remix here:!/chapbooks Including the Augmented Reality Christmas Jumper Orchestra.

A Working Booking System In Google Sheets

Working with Andras Sztrokay we had another go at a booking system. This time it was to enable staff to book out a number of iPads over a number of days. You select the days you want, then select the Booking menu. Andras did an amazing job. It even creates a daily bookings sheet so you can see who has which iPads. To see this in action, go  here  and  File > Make a Copy (I won't be able to support you this is just provided to maybe give someone else a leg up, good luck!)

Coding with Livecode

I'm feeling a shade nostalgic today, because later I'm running a digital creativity session on coding with Livecode, which could be said to be an evolved descendent of my first geek love, HyperCard. The ideas and values I originally fell for,  its ease of use, a "you can too" approach to coding, open sauciness and a community of edu-focussed sharing, and it being free (or cheap) still hold true today. There are still enough of the things I remember in Livecode to make it worth sharing with the world, make Livecode worth learning even today. Like a cult movie, it's always a pleasure to return to.

SOLUTION: Blogger losing images when a user leaves

PLEASE DON'T ASK ME TO DO THIS FOR YOU :-) THIS IS JUST PROVIDED FOR INFO... At the University of York we have had an issue with Blogger for years , in that, when a user leaves the university and their account is deleted, although a blog post's text remains, and the blog itself, every blog post's image is LOST because they are stored somewhere in that user's account. I tried using command-line based scraping tools, like HTTrack to get a blog as static HTML files, but could never quite configure them to get all the content, the local images, the remote images but control the crawler enough not for them to wander off and try and download the entirety of YouTube. I tried scraping tools . I tried half a dozen aggregator tools. I tried process-oriented tools like IFTT. No joy. I tried writing my own scraper in python and failed. They moved the oAuth goalposts. I tried using Google Picasa (which they then shut down). I wanted to maybe use another servi

Coding Free Visualisation - WOW!

Today I stumbled across some similar tools that really help with visualisation. They take the approach that you start drawing and then attach attributes of your drawing to data (typically an uploaded .csv file). To get an idea of the field, Adobe have Project Lincoln, which is fun to watch, but with Adobe products I often discount them because they aren't cheap and readily available as a teaching resource. The video has lots of whooping, but shows the concept well. The tool that has blown my socks off is Charticulator    because I was able to upload .csv of trees that contains lat/long information and make this. Not only can you "see" the line of trees along University Road, the trees are coloured according to species and the heights are mapped to the heights in the data. Still a novice with the tool, I wondered how I might create a key, so I created a new visualisation that mapped the Y value to species and the X value to matur