Naar de inhoud
OneKitly
Daniel Okonkwo

Artikelen van Daniel Okonkwo

Front-enddeveloper en techredacteur · Profiel bekijken

· 4 min leestijd

Eight Pages or Three, and the Word Count Did Not Change

2,000 words is 8 pages double-spaced, 4 single-spaced and 3.3 in a dense report layout. "How many pages" is a question about the layout, not about the text — and the 250-word page has a history.

· 4 min leestijd

The Same 1,200 Words Run from Seven Minutes to Eleven

Delivery speed decides a talk's length more than the script does. At 170 words a minute the same text takes 7 min 04 s; at 110 it takes 10 min 55 s — and only one of those fits a ten-minute slot.

· 4 min leestijd

One File per Tab, and What a Split Leaves Behind

Splitting a workbook writes one .xlsx per sheet, named after the tab. It carries the values across and not the formulas — which is the right default when the point is to send one department its own tab.

· 4 min leestijd

A Column Called "Total (EUR)" Cannot Be an XML Element Name

JSON takes your header text as a key exactly as written. XML cannot — its names may not hold spaces, parentheses or a leading digit — so they are normalised, and knowing how prevents a surprise downstream.

· 3 min leestijd

Three vCard Versions, and the Same Person in Each

2.1 marks types without an equals sign, 3.0 is what everything reads, 4.0 writes some values as URIs — so a phone can arrive as tel:+33612345678, prefix included. Knowing which you have explains most import surprises.

· 3 min leestijd

Two Emails in One Cell, or Two Strings in an Array

A contact can have several phone numbers and several addresses. The CSV joins them with a middle dot into one cell; the JSON keeps them as a list, which is the difference between a script that works and one that splits on a guess.

· 4 min leestijd

A vCard Address Has Seven Parts, and a CSV Column Has One

Names, addresses and organisations are structured fields in a vCard. Flatten them into a spreadsheet and they read identically while losing the seams — which matters the moment you build a vCard back out of that spreadsheet.

· 3 min leestijd

Splitting a Mail Archive Into One File per Message

An .mbox is one enormous file your operating system cannot search. Turn it into .eml files and every message becomes something your machine indexes, your mail client opens and you can delete one at a time.

· 4 min leestijd

You Do Not Have to Rename Your Columns to English

The header row is matched in six languages, so prénom, apellidos, Vorname and cognome are all understood. One header is genuinely ambiguous — nom — and it is settled by the column next to it.

· 5 min leestijd

A Recurring Event Is One Line in the CSV, Not Twelve

An .ics file stores a weekly meeting once, with a rule attached. Export it to CSV and you get a single row for the whole series — which is the file being honest, not the converter losing rows.

· 4 min leestijd

An Attachment Grows by a Third Inside the Email

Mail carries files as text, three bytes written as four characters. A 10 MiB attachment occupies 13.68 MiB of the message, which is why a 25 MB limit really means about 18 MiB of files.

· 5 min leestijd

Opening an .eml File Without Telling the Sender

A saved message is a text file you can read anywhere. The catch is that opening it in something that loads remote images announces the moment you did — which is what a tracking pixel is for.