Skip to content

www.rolfje.com

Tag: Utilities

Print posters on a regular printer with Excel.

Posted on 2014-05-15 By rolfje No Comments on Print posters on a regular printer with Excel.

TS-50-RX-TX-board-banner

I recently needed to print out a big schematic diagram of the RX/TX board of a Kenwood TS50 Transceiver. This did not fit on a single piece of paper. Instead of downloading all kinds of crappy tools or uploading the image to some “free” site which is going to use it for whatever they think justifies their definition of “free”, I found out you can do this in Excel. Here’s how:

  1. Make sure the image you want to print out as a poster has a decent resolution
  2. Open Excel (maybe this will work in LibreOffice too, I haven’t tested, let me know)
  3. Drag the image into a new worksheet so that it is top-left of the sheet.
  4. Open the “Print preview” (the little icon in the bottom left of the window)
  5. Resize the image so that it covers more than one page, up to the number of pages you’d like the poster to be. Your screen should now look somewhat like this:
    Screen Shot 2014-05-15 at 21.58.23
  6. Optional: Adjust the page margins.
  7. Print.

After this, you’ll be gluing the pages together, but I think you already figured that out beforehand.

Have fun!

 

Fun, Workshop

There’s life without Google. Or iCloud. Or Facebook.

Posted on 2014-03-08 By rolfje 5 Comments on There’s life without Google. Or iCloud. Or Facebook.

Threema, the secure Whatsapp alternativeRegular readers of this blog already know that I am not using dropbox, and I was an Evernote user, but recently decided it became to dangerous and replaced it with my own scripts. I had an interesting discussion on Twitter which made me decide to show you how I run my digital life without the help of Google, Facebook, Dropbox, Whatsapp or iCloud, and still be able to have all the functionality these services offer.

The search was hard and sometimes I need to reconsider some of the choices, but the last few years the selection of products was very stable and the setup has worked flawlessly. Searching for a secure replacement for Whatsapp or Google? It’s in here.

Read More “There’s life without Google. Or iCloud. Or Facebook.” »

Software

From the Finder to the Shell (and back)

Posted on 2013-12-20 By rolfje No Comments on From the Finder to the Shell (and back)

A quick tip for OSX users out there who frequently need to open a Terminal window for the current location in the finder, or the other way around:

Go2Shell and Back

Install the free application from the App Store: Go2Shell. It will give you an icon on the toolbar of your Finder, and pressing it will open a Terminal window and automatically change it’s directory to match the Finder’s location.

The other way around is easier; you can already do that on any Mac. Simply type “open .” (that’s the word “open”, followed by a space and a period). This command will open a Finder window for the directory location your Terminal window is in.

Bonus tip: Also check the “open -t [filename]” command, it will open your system’s default text editor with the given file.

Apple, Software

Anonimatron: Quick Start

Posted on 2013-11-032026-05-07 By rolfje 18 Comments on Anonimatron: Quick Start

Anonymous customerAfter reading my last blogpost on Anonimatron, you must have asked yourself “Great, but how do I actually use Anonimatron to de-personalize my database”? I tried my best to make basic Anonimatron configuration as self-explanatory as possible, just start it without any command line arguments and it will tell you.

Less adventurous or in a big hurry? This blogpost will show how simple it is to install and configure Anonimatron on an example MySQL database.

Read More “Anonimatron: Quick Start” »

Software

Anonimatron: Overview

Posted on 2013-10-31 By rolfje No Comments on Anonimatron: Overview

It's the LawIn every software project, there comes a time where a bug pops up, nobody knows how to reproduce it, and somebody says “I know, let’s test this against a copy of the production database”. Even with the best intentions, once production data leaves the production machine with all its safeguards it becomes really hard to do access control on that data.

Most of the time, it’s not even needed to have that data. Developers just need a data set which resembles the production scenario close enough. Some brave souls have mixed succes with data generators, but those generators usually are tedious to maintain and die a slow death under the pressure of the daily grind.

In some ambitious projects automated integration testcases are built on top of the data which was inserted by the data generators. As the generators die, so die the tests. If you recognize this pattern, Anonimatron might be the answer for you.

Read More “Anonimatron: Overview” »

Software

Script: Text-to-NATO-spelling

Posted on 2013-05-27 By rolfje No Comments on Script: Text-to-NATO-spelling

Straight KeyIn my morse training adventure on lcwo.net, I hit a slight bump in the road. At Koch lesson 33 (of 40 lessons total), I can’t seem to copy with 90% accuracy, which is the criterea for moving to the next lesson. See my downward trend here. It is partly because of gradually speeding up the Farnsworth timing from 10wpm to 12wpm so I can be on 20wpm at lesson 40. It is also because of shorter, less focussed daily training sessions, I must confess.

LCWO.net progress

I experimented a bit, and it seems I can recognize characters easily at 37wpm, but I can’t form the words and recognize letters at the same time. More accurately: I can’t seem to be able to remember 3 to 5 characters, form a word and listen to new characters at the same time.

Read More “Script: Text-to-NATO-spelling” »

Fun

Open letter to Keith Lang about Skitch

Posted on 2013-01-03 By rolfje No Comments on Open letter to Keith Lang about Skitch

Skitch 1.0.2Dear Keith,

I read your letter about Skitch and would like to respond to all that has happened from my end-user perspective.

I am a long-time Evernote user and fan. Evernote changed note taking by being truly searchable. I can confidently drop all the websites, receipts, todos and ideas in there, and clear my mind of the “I must remember that” burden. The OCR of Evernote works beautifully on photos of whiteboards, making even my whiteboard notes searchable.

In 2010, I discovered Skitch. The simplicity and razor sharp focus on anotating a screencapture and share the anotated image by dragging it anywhere was sheer brilliance. My daily work includes making annotated screenhots and mailing them to team members to discuss improvements. Skitch changed this ugly capture-save-edit-save-attach-send cycle to pure poetry in motion. Dragging images into Evernote even made my screenshots searchable. It instantly became second nature and my go-to image tool.

Read More “Open letter to Keith Lang about Skitch” »

Apple

Gmail: Save an email to disk

Posted on 2011-10-18 By rolfje 15 Comments on Gmail: Save an email to disk

Gmail save to diskWant to save a single email from gmail to disk, in a readable format for Outlook, Thunderbird or Apple Mail? Here’s how:

  1. Open your browser and log into your gmail account.
  2. Open the email you want to save.
  3. On the top-right, there is a little triangle next to the “Reply” button. Click that, and select “Show Original”.
  4. The original, raw email opens in a new window or tab.
  5. Right-click on this new window, and select “Save as…”.
  6. When saving the file, make sure the extension of the filename is “eml“. So for example “MyEmail.eml”.

All done. Now you dan open the file in Thunderbird, Outlook or whatever email viewer you have out there and see the original mail, in all it’s marked-up glory.

Software

Fixing Photo Creation Dates

Posted on 2011-08-15 By rolfje 2 Comments on Fixing Photo Creation Dates

Count down to your vacationYou know how it is on vacation. You take your camera, shoot pictures, and when you get home you see that you forgot to set the date/time on your camera. Even worse: your wife also took a camera with her, and she actually read the manual and set the time correctly. So now you have two sets of photos with mismatching date/times. Now what?

It turns out that there is actually a pretty simple trick to solve this, and you don’t even haven to install exiftool or do funny command line voodo. If you have iPhoto and a mouse, here’s what you do:

Read More “Fixing Photo Creation Dates” »

Apple

Changing the Order of your UnitTests

Posted on 2011-04-01 By rolfje No Comments on Changing the Order of your UnitTests

A few months ago we had a problem where Eclipse could not automatically run all jUnit unit tests in a package if that package references a class called “enum”, which is a reserved word in Java 1.6. I’ll spare you the details, but we were forced to create a TestSuite. Normally we avoid this construction because it’s easy to create a new unit test and forget to add it to the correct TestSuit. So as a workaround we wrote some code which could build and return a TestSuite dynamically. Right-click in eclipse, select “Run as Unittest”, sit back and enjoy.

Lately this piece of code came in handy while testing another application, which required the removal of data from a database. Yes I know, Unittests should maybe not depend on databases because it leans towards integration testing, but here we are, and I need to solve it. I used the old TestSuite code and changed it so that the TestCase I needed to run first was singled out, while still maintaining the functionality of auto-detecting testcases in the source folder.

Read More “Changing the Order of your UnitTests” »

Software

Posts navigation

Previous 1 2 3 4 Next
         
@rolfje.com
www.youtube.com/watch?v=_ZBK...
2 hours ago
@rolfje.com
www.youtube.com/watch?v=anwK...
2 days ago
Reposted by @rolfje.com
@michaelspicer.bsky.social
What if James Bond had to do a few days in the office. Short film below.

youtu.be/hhd0hOIDljA
2 days ago

Recent Comments

  • rolfje on Spring SystemPropertyInitializingBean
  • plinko idle clicker on Spring SystemPropertyInitializingBean
  • rolfje on The podcast problem (fixed)
  • SirenMix on The podcast problem (fixed)
  • egorio on Volkswagen e-Up! 80% charge trick

Tags

Anonimatron Apple backup design DIY DRM eclipse environment fix Fun gmail google hacking hamradio Hardware helicopter iphone ipod iTunes Java Kawasaki Keynote linux modelling motorcycle music news opinion oracle osx photo photography programming repair review security Software technology Time Machine Ubuntu usability Utilities vacation windows Workshop

Categories

  • Apple (107)
  • Divorce (1)
  • Electronics (5)
  • Fun (58)
  • Games (8)
  • Hardware (74)
  • Microsoft (18)
  • Racing (16)
  • Software (144)
  • Uncategorized (69)
  • Workshop (23)

Archives

Brought to you without adds, banners, cookies or tracking. This one is on me. Yes, life can be this good. Pay it forward.
AI policy - Privacy policy

Copyright © 2026 www.rolfje.com.

Powered by PressBook WordPress theme