Differences

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

--- yaesu_adms_11 [2022/12/01 18:16] – kd6kpc
+++ yaesu_adms_11 [2024/10/18 12:01] (current) – [Yaesu ADMS-11] KD6KPC
@@ Line 1: / Line 1: @@
 ====== Yaesu ADMS-11 ======
-The ADMS-11 software provides editing capabilities for the [[https://www.yaesu.com/indexVS.cfm?cmd=DisplayProducts&ProdCatID=111&encProdID=84807B1262BFED6AC816544D94D310E3&DivisionID=65&isArchived=0|FT3DR/DE]] memory channel frequencies, channel information, and alpha tags, using a personal computer. Also, the transceiver parameters and the setup menu items may be edited and configured.
+The **ADMS-11** software allows you to edit memory channel frequencies, channel info, alpha tags, and transceiver settings for the [[https://www.yaesu.com/indexVS.cfm?cmd=DisplayProducts&ProdCatID=111&encProdID=84807B1262BFED6AC816544D94D310E3&DivisionID=65&isArchived=0|Yaesu FT3DR/DE]]. It provides easy configuration via a personal computer.
-The radio is shipped with a micro-USB cable. This cable is NOT for programming the radio. It is only for performing firmware updates. The cloning cable is about $25.
+Sometimes, users want to combine multiple RepeaterBook search exports into a single memory file for their radio. This involves using spreadsheet editing software, such as Microsoft Excel.
+Please note, the radio includes a micro-USB cable, but this is only for firmware updates, **not for programming**. To program the radio, you’ll need a separate cloning cable, which costs around $25.
+An alternative method for programming the radio is with a [[https://amzn.to/3SbeZbg|microSD card]]. A [[https://amzn.to/3SbeZbg]|microSD card]] is not included with the radio but can be [[https://amzn.to/3SbeZbg|purchased]] separately.
+We recommend using [[https://www.rtsystemsinc.com/|RT Systems]] programming software as the easiest and most reliable option for programming your radio. Using Excel to manipulate repeater data before importing it into programming software can cause many issues. RT Systems software is hassle-free and comes with excellent customer support, making it a much better alternative.
-An alternative method for programming the radio is with a microSD card. A microSD card is not included with the radio but can be purchased separately.
-{{url>https://ws-na.amazon-adsystem.com/widgets/q?ServiceVersion=20070822&OneJS=1&Operation=GetAdHtml&MarketPlace=US&source=ac&ref=tf_til&ad_type=product_link&tracking_id=nwhamcom-20&marketplace=amazon&region=US&placement=B073JWXGNT&asins=B073JWXGNT&linkId=17baae0c3f61a0b4fb223c4579d3fe97&show_border=true&link_opens_in_new_window=true&price_color=333333&title_color=0066c0&bg_color=ffffff 120px,240px noscroll|xx}}
@@ Line 15: / Line 19: @@
 memory channels.
+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 =====
 ^ 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-State**      | Development Planned   |                     |
 | **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>|
 | **Special Modes**    | Development Planned| Development Planned|
@@ Line 111: / Line 125: @@
 Maximum MicroSD card size is 32 GB.
-Reading and Writing Data on the MicroSD Card with the Radio:
+Reading and Writing Data on the [[https://amzn.to/3LuXwqu|MicroSD Card]] with the Radio:
   - Turn the radio on. “SD” should display on the upper portion of the display.
   - Ordered List ItemHold the [DISP] key until the menu appears.
@@ Line 125: / Line 139: @@
 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 =====
@@ Line 131: / Line 163: @@
 When updating firmware, use the supplied cable.
+===== Accessories =====
+  * [[https://amzn.to/3Scl5YR|RT Systems programming software and cable]]
+  * [[https://amzn.to/3y3Yqr6|CD-41 Rapid Charger]]
+  * [[https://amzn.to/3y2wzr4|Nifty Mini Manual]]
+  * [[https://amzn.to/3Y8wyMV|Battery dry cell pack]]
+  * [[https://amzn.to/3LuXwqu|32-GB microSD card]]