Differences

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

--- links:netspreadsheet [2024/11/24 13:20] – va7fi
+++ links:netspreadsheet [2026/08/27 14:51] (current) – [How to Setup] va7fi
@@ Line 3: / Line 3: @@
 ===== How to Setup =====
 Here's an overview of how to download and setup your local copy the first time:
-  - Download the Google Sheet as ''OpenDocument (.ods)''.  It might take 30-45 seconds to prepare the download; this is normal.  Note that the file is not public, contact [[va7fi@rbox.me |Patrick, VA7FI]] if you'd like access.
+  - Download the Google Sheet: ''File -> Download -> OpenDocument (.ods)''.  It might take 30-45 seconds to prepare the download; this is normal.  Note that the file is not public, contact [[va7fi@rbox.me |Patrick, VA7FI]] if you'd like access.
   - Make sure you have [[https://www.libreoffice.org |LibreOffice]] installed on your computer.
   - Open the downloaded file, freeze the headers, and save the file.
@@ 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.
@@ Line 96: / Line 106: @@
     * '';''
-</WRAP>