Chuck Grimmett

Month: January 2018

Changing the CSV Delimiter and Enclosure Characters on a Mac

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.

January 30, 2018

Excel
Building JSON for WPComplete in Excel with Concatenate

TIL how to build JSON strings in Excel with concatenate.

January 29, 2018

Excel, JSON, WordPress
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.

January 29, 2018

Excel
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.

January 26, 2018
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.

January 25, 2018
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.

January 24, 2018

Homestead, PHP, SQL
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!

January 22, 2018
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.

January 21, 2018

Jekyll, WordPress
SVG Viewbox

TIL how to use the viewbox attribute on an SVG to make it responsive and preserve the aspect ratio.

January 20, 2018

SVG
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.

January 9, 2018
Persistence with Chrome Dev Tools

TIL that you can save changes you make with Chrome Dev Tools directly to your disk.

January 7, 2018

Tools
CSS Confetti

TIL how to make confetti with CSS. No javascript needed.

January 5, 2018

CSS
WordPress Template Hierarchy

TIL a ton about the WordPress template hierarchy and the conditionals that select them.

January 4, 2018

WordPress
Genesis Framework’s Hooks and Filters

TIL about Genesis hooks and filters.

January 3, 2018

Genesis, WordPress
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:

January 3, 2018
CSS Grid

TIL about CSS Grid

January 1, 2018

CSS