QR Code URL Extractor

A small utility that reads QR code images referenced in a CSV file (generated by BT QR Code Export) and appends the decoded URLs back into the CSV.

Prerequisites

• Node.js (v14 or later)

Installation

npm install

Usage

node decode-qr.js "<csvPath>" "<optionalBaseFolder>"

Argument	Required	Description
csvPath	Yes	Path to the CSV file generated by BT QR Code Export.
baseFolder	No	Root folder where the QR code images are stored. Defaults to the directory containing the CSV file.

Example

node decode-qr.js "C:\Temp\BT QR Code Export\QR Code Export.csv"

How It Works

1. Reads the input CSV file, stripping any BOM (Byte Order Mark) that may be present in files exported from Excel or Windows tools.
2. Expects a QRCodeImgFile column containing relative paths to QR code images.
3. Decodes each QR code image and extracts the embedded URL.
4. Writes a new CSV file (with - Updated appended to the original filename) that includes a QRCodeLink column with the decoded URLs.

Dependencies

• csv-parser — CSV reading
• csv-writer — CSV writing
• jimp — Image processing
• jsqr — QR code decoding
• strip-bom-stream — BOM removal from input streams