Note - Learn In Public

Reference Learn in Public

December 29, 2022 · 1 min · 4 words · Eric

Convert HEIC Images to JPEG with macOS

The reference post can quickly help you create an Automator workflow to convert HEIC images to JPEG. Reference How to Create a Mac Quick Action to Convert HEIC to JPG

December 21, 2022 · 1 min · 30 words · Eric

Using ImageMagick to Add Watermark

When drafting my travel notes, I needs to modify lots of photos I took during the trip. Thus I started to dig again with ImageMagick . Lucky, I found this blog from Amy Tabb that achieves exactly what I am proposing to do. Here is a example code snippet of adding watermark to an image via imagemagick. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 # step 0 - get all available font list convert -list font > fonts....

December 18, 2022 · 2 min · 215 words · Eric

Create Random Pairs in Excel & Google Sheets

This week, I got this task to randomly generate pairs based on a name list. After googling on the internet, I found a perfect solution to achieve this. Here are the detailed steps to achieve a random pair of two. All the example data and formula can be found in this Google Sheet Random Pairs . Step 1 - Generate random numbers using RAND() Step 2 - Copy the random number values to a new column named Value Excel or Google Sheets will automatic re-generate a new series of random numbers with the RAND() function....

November 16, 2022 · 1 min · 213 words · Eric

Configure Java Environment on macOS Big Sur

Starting from macOS Big Sur (ver. 11.2.3), macOS doesn’t include pre-installed Java any more, the best option is to install AdoptOpenJDK . You can download the OpenJDK pkg binary and install it manually like here , or install AdoptOpenJDK via brew in your favourite terminal: 1 brew install --cask adoptopenjdk Hope it helps. Reference wolfpaulus.com: Installing Java on macOS 11 Big Sur github.com/AdoptOpenJDK: AdoptOpenJDK - HomeBrew TAP

April 7, 2021 · 1 min · 67 words · Eric