Rampages Numbers
- Author: Tom Woodward
- Category: WordPress
- Tags: Data, google sheets, rampages
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
Troubleshooting WordPress
This is an attempt to explain a pattern of troubleshooting WordPress through a specific event and perhaps reinforce the need for me to be humble in all interactions with people. So even if you never have this problem this might be useful. Symptoms An admin for one of our sites using FeedWordPress and suddenly can’t see any feeds in her syndicated sites view for that plugin. She sends me an email. I drop into the site and check. All looks good to me. Sadly. Sadly. Sadly. I respond to her and say it seems to be working on my end . . . has she tried another browser, computer, login/logout/restart etc. It’s easy to end up assuming the person reporting the problem is wrong by default. I get a fair number of emails. Many of them, probably most of them, report problems that are more human than mechanical. It’s easy to fall into a trap of assuming it’s a human issue, especially if a superficial inspection confirms that suspicion. It’s also called a trap for a reason. Avoid it if at all possible and if you fall into it please attempt to climb out.Lying at the bottom while slowly becoming less and less human is an option but one I would not recommend. A bit later she indicates that she […]
- Author: Tom Woodward
- Category: WordPress
- Tags: feedwordpress, rampages, wp_usermeta
I’m not dead yet . . . Google Scripts to Check on a Bunch of WP Sites
John Stewart is going to write up something more systematic and structured as he’s taken these rough ideas up a notch but I figured I’d throw this functional Google Script code in here before I lost it. I believe I got up to five positive statements on blogging more in-process stuff so I’m taking that as an overwhelming mandate. These Google Script functions are meant to loop through a set of URLs in a Google Sheet pulled as an array to see if the site’s still in use. The first two take a look at the WP REST API endpoints for posts and pages. That way if the person only writes pages you won’t be tricked. I’d probably write them all to the sheet because I’m paranoid. The third (aka the hassle as I hadn’t ever messed with XML using javascript) looks at the RSS/XML feed in case the site is not updated enough to have a functional API endpoint or if it’s broken for some reason. This won’t help you out if they’re just writing pages but there’s only so much a person can do. John made a more robust structure with error checking, the piece where it writes to the spreadsheet etc. and I’ll loop in his post once it’s up.
- Author: Tom Woodward
- Category: Data, WordPress
- Tags: javascript, json, WP JSON, xml
Edu-pumkin II – The Bava
Unlike Jim Groom, who only lavishes surface praise while harboring deep hatred, I truly respect the Bava and integrate him into our family’s holiday traditionsYou should see what Santa looks like in our house.. I had to make a hole in the back of Jim’s head to let some of the hot air out. Still needs some work though as the candle keeps going out.
- Author: Tom Woodward
- Category: WordPress
- Tags: Folly, Humor