Differences

This shows you the differences between two versions of the page.

--- blog:2026-05-01:quick_offline_ham_search [2026/05/01 18:21] – created va7fi
+++ blog:2026-05-01:quick_offline_ham_search [2026/05/12 06:32] (current) – [Setup] va7fi
@@ Line 1: / Line 1: @@
+~~NOTOC~~
+====== Quick Offline Ham Search ======
+On my linux computer, I keep a ''csv'' file of the ISED ham database for when I need to quickly look up someone.  Here are a few tricks to make the process really quick.
+===== Setup =====
+Instead of using my browser to download the file from ISED (http://apc-cap.ic.gc.ca/datafiles/amateur_delim.zip), I run this script, which:
+  - Downloads the ''zip'' file to my ''~/Ham'' folder
+  - Changes the extension to ''csv''
+  - Deletes all the files I don't want
+<file bash ised.sh>
+#!/bin/bash
+DIR=$HOME"/Ham"
+echo "Downloading Amateur Archive from ISED website:"
+wget --report-speed=bits http://apc-cap.ic.gc.ca/datafiles/amateur_delim.zip -P $DIR
+echo
+echo "Unzipping archive:"
+cd $DIR
+unzip amateur_delim.zip
+echo "Changing extension to csv"
+mv amateur_delim.txt amateur_delim.csv
+chmod 644 amateur_delim.csv
+echo "Deleting amateur_delim.zip, lisezmoi_amat_delim.txt, and readme_amat_delim.txt"
+rm amateur_delim.zip lisezmoi_amat_delim.txt readme_amat_delim.txt
+echo
+echo
+echo "Done.  Note that the custom separator is:   ;"
+echo
+</file>
+To look up the file, I added this line to my ''alias'':
+<code bash>
+alias hamsearch='cat ~/Ham/amateur_delim.csv |grep -i '
+</code>
+===== Usage =====
+To update my local file, I only have to type this into the terminal:
+<code bash>
+ised.sh
+</code>
+To look up something, I only have to type this into the terminal
+<code bash>
+hamsearch [Search Term]
+</code>
+==== Examples ====
+You can search for a callsign:
+<code>
+hamsearch ve7aaa
+VE7AAA;Arthur Ellwood;Abrahamson;760 OXFORD PLACE;CAMPBELL RIVER;BC;V9W7Y7;A;;C;D;;;;;;;
+</code>
+Or search for any strings in that file. Use <key>'</key><key>'</key> if there's more than one word.
+<code>
+hamsearch 'vancouver general'
+VA7LGH;Ernest;Mix;436 CARDIFF WAY;PORT MOODY;BC;V3H3T1;A;B;;D;;Vancouver Coastal Health Amateur Radio Group;c/o VCH Emergency Management - Vancouver General Hospital;855 West 12th Avenue, JPPS1, Room 1769;VANCOUVER;BC;V5Z1M9
+VA7PRH;Ernest;Mix;436 CARDIFF WAY;PORT MOODY;BC;V3H3T1;A;B;;D;;Vancouver Coastal Health Amateur Radio Group;c/o VCH Emergency Management - Vancouver General Hospital;855 West 12th Avenue, JPPS1, Room 1769;VANCOUVER;BC;V5Z1M9
+VA7RHS;Ernest;Mix;436 CARDIFF WAY;PORT MOODY;BC;V3H3T1;A;B;;D;;Vancouver Coastal Health Amateur Radio Group;c/o VCH Emergency Management - Vancouver General Hospital;855 West 12th Avenue, JPPS1, Room 1769;VANCOUVER;BC;V5Z1M9
+VA7SGH;Ernest;Mix;436 CARDIFF WAY;PORT MOODY;BC;V3H3T1;A;B;;D;;Vancouver Coastal Health Amateur Radio Group;c/o VCH Emergency Management - Vancouver General Hospital;855 West 12th Avenue, JPPS1, Room 1769;VANCOUVER;BC;V5Z1M9
+VA7SMH;Ernest;Mix;436 CARDIFF WAY;PORT MOODY;BC;V3H3T1;A;B;;D;;Vancouver Coastal Health Amateur Radio Group;c/o VCH Emergency Management - Vancouver General Hospital;855 West 12th Avenue, JPPS1, Room 1769;VANCOUVER;BC;V5Z1M9
+VA7VCH;Ernest;Mix;436 CARDIFF WAY;PORT MOODY;BC;V3H3T1;A;B;;D;;Vancouver Coastal Health Amateur Radio Group;c/o VCH Emergency Management - Vancouver General Hospital;855 West 12th Avenue, JPPS1, Room 1769;VANCOUVER;BC;V5Z1M9
+VA7VCS;Ernest;Mix;436 CARDIFF WAY;PORT MOODY;BC;V3H3T1;A;B;;D;;Vancouver Coastal Health Amateur Radio Group;c/o VCH Emergency Management - Vancouver General Hospital;855 West 12th Avenue, JPPS1, Room 1769;VANCOUVER;BC;V5Z1M9
+VA7VGH;Ernest;Mix;436 CARDIFF WAY;PORT MOODY;BC;V3H3T1;A;B;;D;;Vancouver Coastal Health Amateur Radio Group;c/o VCH Emergency Management - Vancouver General Hospital;855 West 12th Avenue, JPPS1, Room 1769;VANCOUVER;BC;V5Z1M9
+</code>
+~~DISCUSSION~~