Home > WordPress > Rampages Numbers

Rampages Numbers

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.

My favorite function combos are to pull the unique values from a range =unique and then do a =countif off those values. It’s a really quick way to get graphs like these.

Related posts

stranger portrait - what?

WordPress for LMS iFrame Infiltration

Origin Story Over the years I’ve seen a number of people embedding WordPress within the LMS using iframes. There are lots of reasons to do this but it’s not something that WordPress is really meant to do. You end up with an odd feeling as it’s a website within a website and many things feel out of place (headers, footers, sidebars). I said something on Twitter one time that I might make a theme that would behave better in those kinds of scenarios. I was able to find that tweet using Twitter’s semi-hidden advanced search. Note that Sept. 9, 2018 date. It’s been a while but here’s a super simple theme that tries to play well in the land of iframe embeds. What is the best #WordPress theme that allows a seamless #LMS integration? #webdev #EdTech #bcpse — Erin Beattie ??? (@ehbeattie) September 9, 2018 Show Only What You Want As is my pattern, I figured I could hide most of the extra things through javascript and use the URL’s query string parametersIt’s a trail! Go see what these are if you don’t already know. as the way to decide what was shown. I haven’t built out all the various parameters but for this theme, I added some javascript to look at the URL for a ‘show’ parameter. So https://baseurl.com/some-page/?show=article […]

01

Super Cleansing Cut/Paste into Tiny MCE in WordPress

Had someone cut/pasting from Google Docs into WordPress and it was ending up littered with internal style elements and super irritating span classes. I found this post which got me 95% of the way there and just added .removeAttr(‘style’) to get rid of the inline styles. Now I can just re-cut/paste and get a clean chunk of text.

Will Wonka asking you to tell him again what WordPress can't do.

Form Follows Function – WordPress Authoring

This is my supporting documentation for the #PressEd WordPress conference that I’ll be doing via Twitter on Thursday. The Topic Given I’ve been playing around in WordPress since what feels like the dawn of time, I’ve heard lots of people say lots of things about it. I’ve heard it’s too complex. I’ve heard it’s too easy. I’ve been told it won’t allow you to map/GIS information and that it can’t be used for any number of other things. I’ve been told it won’t do things that you can do in this other CMS or that other LMS. As with most things, these boundaries are mostly imaginary and live more in people’s heads than they do in the software itself. My goal here will be to take you on a tour of what you can do to impact the authoring experience in WordPress. We’ll start by removing complexity from WordPress itself but staying within the typical authoring patterns. We’ll do that in the easiest ways first and then move to more involved interventions. After that, we’ll jump to non-standard authoring patterns and run around seeing where the edges are. Minimalism/Reducing Complexity Screen Options There’s quite a bit of control you have just within the Screen Options settings available to the author. If you can check/uncheck a box these options are available […]