Differences

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

--- howto:netspreadsheet [2021/01/10 13:56] – [Basic Idea] va7fi
+++ howto:netspreadsheet [2021/06/27 08:53] – [Notes for Admins] va7fi
@@ Line 87: / Line 87: @@
   * When ''jh'' was entered in the suffix, the callsign asked for a ''Prefix?'' because two callsigns have the same suffix.  Once the prefix is entered, the spreadsheet is able to fill in the rest of the information from the ''Local Data''.
   * When ''aaa'' is entered, it's not found in the ''Local Data'' so it asks for the ''Prefix'' to look it up in the ''ISED Data''.
-  * When ''wek'' is entered, it's not found in either databases so it returns ''Not Found''.  If you know that this is a valid callsign (maybe a new ham), please email [[va7fi@rbox.me |Patrick]] so he can update the ''Local Data''.
+  * When ''wek'' is entered, it's not found in either databases so it returns ''Not Found''.
 Here are a few more details:
@@ Line 136: / Line 136: @@
   * Every so often, you should delete your personal copy (or make a backup) and download a fresh copy so that you can have the latest database.
   * Please do NOT edit the database in your personal copy since no-one else will benefit from your edits.  Instead, email [[va7fi@rbox.me |Patrick, VA7FI]] the information that needs to be added / edited in the online version.
+====== Submit Updates ======
+To submit an update to the main online spreadsheet, use the [[https://docs.google.com/forms/d/e/1FAIpQLSc3Taz4Tvr-pABqXBsCBMtnhkxlly2jgiiDyzPxGa2qurb5Hw/viewform |Net Roll Call New Entry Submission Form]], which has a link in the spreadsheet:
+{{ :howto:submitlink.png }}
+Which will take you to the form:
+{{ :howto:submitform.png }}
 ====== Notes for Admins ======
-<hidden>
 <WRAP prewrap>
@@ Line 165: / Line 173: @@
 ===== Updating the "ISED Data" Tab =====
-{{ :howto:ised_import.png}}
+{{ :howto: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)]].
-  * Extract text file from zip file and change extension from: \\ ''.txt'' to ''.csv''
+  * Extract ''amateur_delim.txt''
   * In Google Sheets, unhide and select the ''ISED Data'' tab.
   * Go to ''File'' > ''Import'' > ''Upload'':
     * ''Replace Current Sheet''
-    * ''Custom:  ;''
+    * ''Custom''
+    * '';''
 </WRAP>
-</hidden>