I got an email from a KQED reporter asking about this old post on importing CSVs into Google Sheets. The source data was big though and hosted on GitHub and they only wanted the California data. I thought that anything we did in Google Script was likely to time out so I built a little […]
Category: Data
Gravity Forms, Open Street Map API, and Leaflet JS
I’m sketching this one out because it’s a fun mix of things. I’m going to use Gravity Forms to accept submissions, the Open Street Map API will convert the address into latitude/longitude, and then we’ll display the data on a Leaflet JS map. I could have done it all in Google but I was irritated […]
Read More… from Gravity Forms, Open Street Map API, and Leaflet JS
Get your Jamboard text
We’re doing some strategic planning in Google’s Jamboard. I find it good for the live/interactive aspects of the conversation but when I was looking back over it, it was hard for me to read and organize in my head. I decided I wanted the text from the various sticky notes in a spreadsheet so that […]
JSON and the WP REST API
This post is supporting a bunch of tweets going out for pressedconf22 on March 24. Why? The basic idea is that WordPress is good for taking care of the mechanics of writing on the Internet. It deals with users, logins, uploading media, writing to the database, etc. On the other hand, WordPress themes can feel […]
Graph Page Transition via Illustrator
I’m working with Greg Pask to make a lab website. When I asked him for some visual inspiration he sent me two comic book covers by David Aja. That was a first! It’s driving me to do some interesting things in Illustrator for the first time. I’ve long promised myself I’d learn vector drawing but […]
Detox Site – Energy-conscious website breakdown
The following is what I wrote for this year’s DLINQ Digital Detox. It was strange writing without footnotes. It’s also a lot less of my normal writing voice. I was writing for a bunch of strangers rather than you, my dear readers.1 It’s easy to use the web without thinking about it much. Modern processors, […]
Read More… from Detox Site – Energy-conscious website breakdown
DoOO Data Considerations
This is for the Domain of One’s Own Roadshow workshop/conference thing. Reclaim stuff is always fun and I should have gotten this down earlier but I didn’t so I’m just trying to get down some ideas on assessment and data. I read it now and I’m kind of bored myself but overthinking the value of […]
CSV Bookmarklet
In the time of APIs, python scrapers and other cool things, bookmarklets have fallen from favor but they still have uses and I still like them. For small jobs that you want to make accessible to people they are still really handy. In this scenario Middlebury has lots of ways to get roster information about […]
Horizontally Combine Many CSV Sheets in Google Sheets
An odd request came in from a faculty member the other day. As part of their research they had 60 or so CSVs that they wanted combined horizontally. I have many ways to do it vertically but this was a new one. Each file was around 350KB so they weren’t huge and 60 isn’t a […]
Read More… from Horizontally Combine Many CSV Sheets in Google Sheets
FotoFika Art Baseball Cards
Origin Story The 2020 All Stars project1 is tied to the FotoFika site supporting photography faculty teaching online due to COVID. One of the concerns that came up in discussions was that this year’s graduating class wouldn’t be getting the personal connections that normally happen during exhibitions. That led to a discussion around Mike Mandel’s […]