Differences

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

--- links:netspreadsheet [2024/11/11 21:06] – created - external edit 127.0.0.1
+++ links:netspreadsheet [2025/02/15 10:49] (current) – va7fi
@@ Line 37: / Line 37: @@
 <WRAP centeralign>
-{{:howto:mobile_01.jpg?300}} {{:howto:mobile_02.jpg?300}}
+{{:links:mobile_01.jpg?300}} {{:links:mobile_02.jpg?300}}
 </WRAP>
@@ Line 44: / Line 44: @@
 <WRAP centeralign>
-{{:howto:mobile_03.jpg?300}} {{:howto:mobile_04.jpg?300}}
+{{:links:mobile_03.jpg?300}} {{:links:mobile_04.jpg?300}}
 </WRAP>
@@ Line 53: / Line 53: @@
     * The one on the right is your own personal copy.
 <WRAP centeralign>
-{{:howto:mobile_05.jpg?300}} {{:howto:mobile_06.jpg?300}}
+{{:links:mobile_05.jpg?300}} {{:links:mobile_06.jpg?300}}
 </WRAP>
@@ Line 73: / Line 73: @@
 </WRAP>
-{{ :howto:unsorted.png  }}
+{{ :links:unsorted.png  }}
 Now to sort, click on the upside-down triangle sign on the right of ''Suffix'' to see the filter menu for that column, and select ''Sort A -> Z'':
-{{ :howto:filter.png  }}
+{{ :links:filter.png  }}
 All the entries are now sorted by callsign suffix:
-{{  :howto:sorted.png  }}
+{{  :links:sorted.png  }}
 \\
@@ Line 87: / Line 87: @@
 ===== Updating the "ISED Data" Tab =====
-{{ :howto:ised_import.png?350}}
+{{ :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.
@@ Line 96: / Line 106: @@
     * '';''
-</WRAP>