Repeater Book

KC5JIM
Posts: 2
Joined: Sat Sep 23, 2023 9:15 pm

Re: Repeater Book

Post by KC5JIM » Mon Oct 02, 2023 11:20 pm

I have a duplex hotspot on the way as we speak.

KB8YKF
Posts: 61
Joined: Tue Oct 17, 2023 6:55 pm
Location: USA

Re: Repeater Book

Post by KB8YKF » Mon Nov 27, 2023 5:13 am

VK3KYY wrote:
Thu Sep 14, 2023 8:15 pm
Repeater book file for GD77 is not for OpenGd77 it's for the official CPS
I’m a first time OpenGD77 user. Just today I exported my local repeater list from RepeaterBook and had no issues using OpenGD77 CPS to import the CSV file to my Retevis RT3S running firmware 20231119.

I don’t know if it mattered that I used the Proximity Search 2.0 feature - but the menu option explicitly says OpenGD77. I was also logged into the website which unlocks some features I believe.
Attachments
IMG_0995.jpeg
IMG_0995.jpeg (61.12 KiB) Viewed 2871 times

SA0BUX
Posts: 584
Joined: Tue Jul 05, 2022 8:50 am
Location: JO99ah, Stockholm, Sweden
Contact:

Re: Repeater Book

Post by SA0BUX » Mon Nov 27, 2023 8:09 am

The export format is for Radioddity GD-77, I guess you could use the data in the CSV file as input to create a CSV for OpenGD77 with som
hands on work.

VK3KYY
Posts: 7590
Joined: Sat Nov 16, 2019 3:25 am
Location: Melbourne, Australia

Re: Repeater Book

Post by VK3KYY » Mon Nov 27, 2023 8:47 am

SA0BUX wrote:
Mon Nov 27, 2023 8:09 am
The export format is for Radioddity GD-77, I guess you could use the data in the CSV file as input to create a CSV for OpenGD77 with som
hands on work.
The Radioddity files are intended for the official CPS, they are not directly compatible with the OpenGD77CPS even though the OpenGD77CPS was originally created by reverse engineering the official CPS files

Repeater book has some other generic CSV formats which contain more information, which you would be better off using in order to convert them into the CSV export / import files that the OpenGD77CPS now uses

KB8YKF
Posts: 61
Joined: Tue Oct 17, 2023 6:55 pm
Location: USA

Re: Repeater Book

Post by KB8YKF » Mon Nov 27, 2023 2:16 pm

This is what Repeaterbook Channels.CSV gave in in terms of fields:

Code: Select all

Channel Number,Channel Name,Channel Type,Rx Frequency,Tx Frequency,Bandwidth (kHz),Colour Code,Timeslot,Contact,TG List,DMR ID,TS1_TA_Tx ID,TS2_TA_Tx ID,RX Tone,TX Tone,Squelch,Power,Rx Only,Zone Skip,All Skip,TOT,VOX,No Beep,No Eco
This is Channels.CSV fields exported from OpenGD77 CPS:

Code: Select all

Channel Number,Channel Name,Channel Type,Rx Frequency,Tx Frequency,Bandwidth (kHz),Colour Code,Timeslot,Contact,TG List,DMR ID,TS1_TA_Tx,TS2_TA_Tx ID,RX Tone,TX Tone,Squelch,Power,Rx Only,Zone Skip,All Skip,TOT,VOX,No Beep,No Eco,APRS,Latitude,Longitude
The only differences are Repeaterbook has fields "TS1_TA_Tx ID,TS2_TA_Tx ID" and OpenGD77 CPS omits the "ID" from the first column calling it just "TS1_TA_Tx" instead without "ID". Additionally, OpenGD77 has fields for "APRS,Latitude,Longitude" that Repeaterbook is missing.

To use Repeaterbook CSV, I opened the Channels.CSV from my export, and copy/pasted in all the lines (minus header) from Repeaterbook CSV into that file - I didn't modify them at all. It Imported fine and I ended up with 46 "Analogue" Channels that seemed correct. All had correct RX/TX frequencies, bandwidth, RX/TX tones configured, channel names, etc. Leaving "APRS,Latitude,Longitude" columns blank didn't seem to matter.

Just thought it might be helpful to get people going for any Analogue repeaters near them. My only nearby DMR repeater wasn't in Repeaterbook, so I added that via CPS myself after importing the Analogue repeaters.

SA0BUX
Posts: 584
Joined: Tue Jul 05, 2022 8:50 am
Location: JO99ah, Stockholm, Sweden
Contact:

Re: Repeater Book

Post by SA0BUX » Mon Nov 27, 2023 3:54 pm

Hmm, my repeaterbook CSV export has these columns

Code: Select all

Output Freq,Input Freq,Offset,Uplink Tone,Downlink Tone,"Location",lat,long,Call,Use,Op Status,Mode,Digital Access,EchoLink,IRLP,AllStar,Coverage,Last Update
Anyway, it's possible to do some copy paste and create a channels.csv that can be imported.

But for Swedish repeaters we have some more problems like national characters and encoding that must be corrected.

Code: Select all

145.300000,145.300000,0,118.8,,"Lidköping / Kållandsö",58.66000000,13.15000000,SM6YRB,OPEN,On-Air,Analog/analog,,,5517,,,2021-04-16
Seems to be some funny rounding error for offset too.

Code: Select all

145.600000,145.000000,-0.59999999999999,79.7,79.7,"Algutsrum",56.68281700,16.56464800,SK7RFL,OPEN,On-Air,Analog/analog,,353167,,,,2022-08-10

KB8YKF
Posts: 61
Joined: Tue Oct 17, 2023 6:55 pm
Location: USA

Re: Repeater Book

Post by KB8YKF » Mon Nov 27, 2023 4:23 pm

SA0BUX wrote:
Mon Nov 27, 2023 3:54 pm
Hmm, my repeaterbook CSV export has these columns
You are right!! I didn't expect there to be a difference between North America and Worldwide.

If I pick North America (where I am), and do an Export I can select Radioddity -> "OpenGD77 Channels FIle" as my file format and get the output above that I can import easily.

If I pick Worldwide and select a random country outside North America, the Export option says Radioddity -> GD-77 - doesn't mention OpenGD77 and the file format is totally different.

It's unfortunate Worldwide can't export to OpenGD77 format - I'm curious the reason behind this difference.

SA0BUX
Posts: 584
Joined: Tue Jul 05, 2022 8:50 am
Location: JO99ah, Stockholm, Sweden
Contact:

Re: Repeater Book

Post by SA0BUX » Mon Nov 27, 2023 8:17 pm

KB8YKF wrote:
Mon Nov 27, 2023 4:23 pm
SA0BUX wrote:
Mon Nov 27, 2023 3:54 pm
Hmm, my repeaterbook CSV export has these columns
You are right!! I didn't expect there to be a difference between North America and Worldwide.

If I pick North America (where I am), and do an Export I can select Radioddity -> "OpenGD77 Channels FIle" as my file format and get the output above that I can import easily.

If I pick Worldwide and select a random country outside North America, the Export option says Radioddity -> GD-77 - doesn't mention OpenGD77 and the file format is totally different.

It's unfortunate Worldwide can't export to OpenGD77 format - I'm curious the reason behind this difference.
Seems that they use different PHP scripts.

For US the path is https://www.repeaterbook.com/repeaters/Display_SS.php

But it's https://www.repeaterbook.com/row_repeaters/Display_SS.php for rest of world.

I tried to modify the URL but it seems that the page use a different database for rest of world.

User avatar
i5ekx
Posts: 37
Joined: Fri Dec 09, 2022 3:14 pm
Location: JN53DM
Contact:

Re: Repeater Book

Post by i5ekx » Sat Dec 02, 2023 5:44 pm

KJ5CIM wrote:
Thu Sep 14, 2023 7:46 pm
Hello all!
I've been trying to find a way to load a codeplug to my radio. I see that repeaterbook has an option to export as a OpenGD77 file under Radioddity, but the CPS doesn't seem to want to play nice with it or any other .csv I can find. I have 101 analog repeaters alone in my other radios not to mention the added DMR info the MD-UV390 would use. Has anyone figured out ANY WAY to load data besides manual entry. Any help would be appreciated!
KJ5CIM
https://www.iz8wnh.it/ Try this site, it has excellent functions also dedicated to OpenGD77

KD0RK
Posts: 14
Joined: Mon Nov 13, 2023 5:46 pm

Re: Repeater Book

Post by KD0RK » Mon Dec 04, 2023 3:17 pm

I contacted the admin at RepeaterBook and sent my current code plug indicating the differences (APRS, Lat/Long and another field) and he seemed interested in helping change their format. We'll see what happens; the Lat/Long are in the GPX export so I took the time to grab the coordinates and put them in my file.

Post Reply