TIL that you can’t change the CSV delimiter or enclosure characters on Excel for Mac or Apple Numbers. You have to use Open Office.
Month January 2018
Building JSON for WPComplete in Excel with Concatenate
TIL how to build JSON strings in Excel with concatenate.
macOS Excel Fill Down Keyboard Shortcut
I never remember the keyboard shortcut for Fill Down in Excel on macOS, so I’m posting it here where I’ll have it. Control + D.
Three More Book Notes
I’m catching up on my book notes. Today I posted three more: Show Your Work, Shoe Dog, and E-Myth Revisited.
Catching up on Book Notes
I’m catching up on my book notes. There are a lot of books I read this past year that I neglected to post notes for, so I’m getting caught up on that. I posted five new books to my Book Notes section today: Kindred, Stories of Your Life and Others, A Burglar’s Guide to the City, Boon Island, and The Story of Sushi.
How to Back Up Your Laravel Homestead Databases
Today I upgraded from Homestead 4.0.0 to 5.0.1 so I could test my sites in PHP 7. That was a major upgrade and a number of things changed, so I decided that I needed to back up my databases before I did the upgrade. I’d only ever dumped specific databases before, but TIL how to dump them all at once. Here is how to do that in Laravel Homestead.
Free Charting Tools for Your Next Article
A Praxis participant emailed me last week asking for recommendations on free embeddable charting tools for an article he is writing. I thought that the information would be useful for everyone, so I wrote an article with examples!
Rebuilding cagrimmett.com and Moving Old WordPress Posts to Jekyll
Earlier this week I did a major revamp of cagrimmett.com. It started with redesigning my page templates to include a sidebar, then it morphed into making a long-standing goal of mine reality: Reviving the posts from my old 2008-2012 WordPress blog and getting them into Jekyll while preserving old links. Here’s how I did it.
SVG Viewbox
TIL how to use the viewbox attribute on an SVG to make it responsive and preserve the aspect ratio.
Altcoin Research: What is Sia?
This month I’m spending some time researching altcoins. I’m posting my notes on Yours.org. First up: Sia.
Persistence with Chrome Dev Tools
TIL that you can save changes you make with Chrome Dev Tools directly to your disk.
CSS Confetti
TIL how to make confetti with CSS. No javascript needed.
WordPress Template Hierarchy
TIL a ton about the WordPress template hierarchy and the conditionals that select them.
Genesis Framework’s Hooks and Filters
TIL about Genesis hooks and filters.
100 Highlights of 2017
Derek Magill’s 100 Things That Made My Year post inspired me to write one, too. Here are my 100 highlights of 2017:
CSS Grid
TIL about CSS Grid