In responding to some data requests, I delved into the WP tables to pull some rampages data.
All users ever . . .
I need to set up something more automated but for this I dumped the MySQL tables as CSVs and then just imported them to Google Sheets. With very minimal functions, I got this data.
This post is specifically about addressing a syllabus submission problem but it’s worth thinking about more broadly. It should be pretty applicable to any structured data entry problem you have. These are often administrative chores (like this one) but could also be about cataloging grave markers or indexing resources or Collecting the syllabi for their department is one of those miserable things department chairs often have to do. They then need to store and reference those syllabi for a few years.I feel like I already wrote this post . . . but since I can’t find it . . . The normal pattern is to ask people to email the syllabus and there is usually some desperate plea for a common naming convention.Start with your last name, then underscore . . . This plea is followed by ~2 people. People are bad at directions (giving and following). Email makes this basic flaw 20 times worse.You can then square the chance of error because everyone hates turning in stuff like this. This particular pattern for misery incarnate is repeated over and over at VCU and across universities everywhere. I recently met with a faculty member who’d at least been asked to submit the syllabus to a shared Google Drive folder but he was having issues because of directions and Google’s interface […]
Image from page 776 of “The Ladies’ home journal” (1889) flickr photo by Internet Archive Book Images shared with no copyright restriction (Flickr Commons) Continuing on from Part One . . . I have way too many examples. If you read this blog often, you’ve probably seen most of these being bornAbsent the increasing number of imaginary posts I seem to write in my head that don’t magically appear here. Got to work on that API/neuron integration. but this is my first attempt at organizing and a more cohesive structure around key categories/processes and all in one place. This isn’t my normal pattern as I’m more of a folksonomic structure guy rather than taxonomic. What this has done is remind me of just how much work has been done in a relatively short time. I’ve only been here three years. Rampages is roughly three years old but wasn’t publicized initially and then had some rough growing pains. The last year or so I’ve been trying to convince people my department still exists . . . and still people find ways to do tons of amazing work. I’m not even including the stuff we do outside of WordPress. I’m only scratching the surface but this post keeps getting longer and longer. I threw a bunch of the links here. Some will […]