Differences

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

--- links:netspreadsheet [2025/02/15 10:46] – va7fi
+++ links:netspreadsheet [2025/02/15 10:49] (current) – va7fi
@@ Line 88: / Line 88: @@
 ===== Updating the "ISED Data" Tab =====
 {{ :links:ised_import.png?350}}
-  * Download [[http://www.ic.gc.ca/eic/site/025.nsf/eng/h_00004.html |Amateur call sign list (delimited TXT format)]].
+  * Download [[http://www.ic.gc.ca/eic/site/025.nsf/eng/h_00004.html |Amateur call sign list (delimited TXT format)]].((Instead of manually downloading the file from the ISED website, and unzipping it, I use this short BASH script:<code BASH>
+#!/bin/bash
+DIR="/home/ptruchon/Desktop"
+wget --report-speed=bits http://apc-cap.ic.gc.ca/datafiles/amateur_delim.zip -P $DIR
+cd $DIR
+unzip amateur_delim.zip
+mv amateur_delim.txt amateur_delim.csv
+chmod 644 amateur_delim.csv
+rm amateur_delim.zip lisezmoi_amat_delim.txt readme_amat_delim.txt
+</code>))
   * Extract ''amateur_delim.txt''
   * In Google Sheets, unhide and select the ''ISED Data'' tab.