User Tools

Site Tools


yaesu_adms_11

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
yaesu_adms_11 [2022/12/03 09:23]
kd6kpc [Importing / Exporting]
yaesu_adms_11 [2023/04/26 10:41] (current)
kd6kpc [Procedure with File Editing]
Line 18: Line 18:
 To import the RepeaterBook export into the ADMS software, use the File >> Import option from the menu bar at the top. To import the RepeaterBook export into the ADMS software, use the File >> Import option from the menu bar at the top.
  
 +====== Troubleshooting Errors ======
 +
 +When the export is conducted from RepeaterBook.com, the file may automatically open in Excel. If any column contains values like “#NAME?” then you cannot use Excel to manipulate the data. Usually, the culprit is Column F, where the offset symbols with “+” and “-” are used. Excel attempts to convert that to a formula and fails. Saving the file will corrupt that column and cause it to fail on import.
 +
 +**Do not edit and save the file in Excel.**
 +
 +When the file opens in Excel, close it without saving it. Import it directly from the Downloads folder. Editing must be done in a program such as Notepad.
 ===== Supported Searches ===== ===== Supported Searches =====
  
 ^ Search Page      ^ North America    ^ Rest of World       ^ ^ Search Page      ^ North America    ^ Rest of World       ^
-| **Favorite**         | <color green>Operational</color>In Development +| **Favorite**         | <color green>Operational</color><color green>Operational</color>
-| **Feature**          | <color green>Operational</color>Development Planned+| **Feature**          | <color green>Operational</color><color green>Operational</color>
-| **Keyword**          | <color green>Operational</color>Development Planned+| **Keyword**          | <color green>Operational</color><color green>Operational</color>
-| **Location**         | <color green>Operational</color>Development Planned|+| **Location**         | <color green>Operational</color><color green>Operational</color>|
 | **Multi-County**     | Development Planned    |                | | **Multi-County**     | Development Planned    |                |
 | **Multi-State**      | Development Planned                       | | **Multi-State**      | Development Planned                       |
 | **Proximity**        | <color green>Operational</color>| <color green>Operational</color>| | **Proximity**        | <color green>Operational</color>| <color green>Operational</color>|
-| **Proximity 2.0**    | <color green>Operational</color>Development Planned |+| **Proximity 2.0**    | <color green>Operational</color><color green>Operational</color> |
 | **Quick**            | <color green>Operational</color>| <color green>Operational</color>| | **Quick**            | <color green>Operational</color>| <color green>Operational</color>|
 | **Special Modes**    | Development Planned| Development Planned| | **Special Modes**    | Development Planned| Development Planned|
Line 128: Line 135:
 Multiple files can be stored here, but only the file named “BACKUP.dat” will be read by the radio. This gives you the flexibility to store multiple configurations on the card and just change their names as needed. Multiple files can be stored here, but only the file named “BACKUP.dat” will be read by the radio. This gives you the flexibility to store multiple configurations on the card and just change their names as needed.
  
 +==== Procedure with File Editing====
 +
 +  * Complete a search on RepeaterBook and export the data. If Microsoft Excel is installed on your computer, the file may automatically open with Excel
 +  * Change the extension to .txt. 
 +  * Using Excel, open the file.
 +  * Using the Text Import Wizard, select Comma as the delimiter and the column with "+RPT" and "-RPT" as a Text data format.
 +  * You can renumber Column A as desired but rows 1 - 900 MUST be present.
 +  * Make sure there is a "0" in column BB of any newly added rows.
 +  * Save the file as a .CSV.  
 +
 +There is an alternative method for editing in Excel. After the file downloads:
 +
 +  * It is possible to edit the file with Excel. Column F is the potential issue. This is the repeater Offset Direction field with "-RPT", "+RPT", "-/+", and "OFF" as possible values. Any field with a leading operator such as "-" and "+" will be interpreted by Excel as a faulty equation and will display "#NAME?". If the file is saved while "#NAME?" is displayed, the original offset value will be overwritten with "#NAME?" and cause the file to error when imported into the programming software. ALL of column F must be manually adjusted before saving the file.
 +  * You can renumber Column A as desired but rows 1 - 900 MUST be present.
 +  * Make sure there is a "0" in column BB of any newly added rows.
 +  * Save the file as a .CSV.
 + 
 +  
 ===== Firmware ===== ===== Firmware =====
  
Line 134: Line 159:
 When updating firmware, use the supplied cable. When updating firmware, use the supplied cable.
  
-===== Troubleshooting Errors ===== 
- 
-When the export is conducted from RepeaterBook.com, the file may automatically open in Excel. If any column contains values like "#NAME?" then you cannot use Excel to manipulate the data. Usually, the culprit is Column F, where the offset symbols with "+" and "-" are used. Excel attempts to convert that to a formula and fails. Saving the file will corrupt that column and cause it to fail on import. 
- 
-**Do not edit and save the file in Excel.** 
  
-When the file opens in Excel, close it without saving it. Import it directly from the Downloads folder. 
yaesu_adms_11.1670081006.txt.gz · Last modified: 2022/12/03 09:23 by kd6kpc