Updated OpenGD77-CSV Utility
Posted: Sat Oct 31, 2020 5:48 pm
I have spent the last few days updating my OpenGD77-CSV utility to fully support the current OpenGD77 releases.
The program and Instructions can be downloaded from https://www.gb3gf.co.uk/Files/OpenGD77-CSV.zip
Updates from the previous version are :-
More error checking to try to prevent crashes. However I am sure it will still crash under some circumstances!
.CSVs now only include items that are used by the firmware. Unused items in the codeplug are no longer included. This simplifies the structure of the files and should make editing easier especially for the channels.csv file which now only has 19 columns.
There is now an option to use comma as the decimal separator in the .csv files. The deliminator between fields has been changed to semi-colon. This should improve use for those countries that do not use the same convention as the UK.
There is a new button to optionally append .csv files to an existing codeplug. Entry names in the .csv file are checked against those in the codeplug. If they are found then the existing entry is replaced with the new one. If they are not found then the new entry is appended to the codeplug.
All matching is done using the names of items so if you see unexpected results check that the names are identical. For example if you rename a channel in Channels.csv then you must also rename it exactly the same in Zones.csv .
Because all operations need to work with a codeplug there is a new button to load a blank one as a starting point. This is the same blank codeplug that is created by the CPS. Note that if you use this to create a new codeplug you will then need to enter your DMR ID and other settings using the CPS.
I have also include an instruction manual with details of the program and .csv file contents. Please read this, it does explain a lot of things.
This new version only supports the current OpenGD77 firmware. It will not work with the manufacturers firmware or the early OpenGD77 with less than 80 channels in a zone.
At the moment the .csv files created by this utility are not compatible with those created by the CPS.
Colin G4EML
Note for Roger, I am also working on a command line version that may be suitable for calling from the CPS.
The program and Instructions can be downloaded from https://www.gb3gf.co.uk/Files/OpenGD77-CSV.zip
Updates from the previous version are :-
More error checking to try to prevent crashes. However I am sure it will still crash under some circumstances!
.CSVs now only include items that are used by the firmware. Unused items in the codeplug are no longer included. This simplifies the structure of the files and should make editing easier especially for the channels.csv file which now only has 19 columns.
There is now an option to use comma as the decimal separator in the .csv files. The deliminator between fields has been changed to semi-colon. This should improve use for those countries that do not use the same convention as the UK.
There is a new button to optionally append .csv files to an existing codeplug. Entry names in the .csv file are checked against those in the codeplug. If they are found then the existing entry is replaced with the new one. If they are not found then the new entry is appended to the codeplug.
All matching is done using the names of items so if you see unexpected results check that the names are identical. For example if you rename a channel in Channels.csv then you must also rename it exactly the same in Zones.csv .
Because all operations need to work with a codeplug there is a new button to load a blank one as a starting point. This is the same blank codeplug that is created by the CPS. Note that if you use this to create a new codeplug you will then need to enter your DMR ID and other settings using the CPS.
I have also include an instruction manual with details of the program and .csv file contents. Please read this, it does explain a lot of things.
This new version only supports the current OpenGD77 firmware. It will not work with the manufacturers firmware or the early OpenGD77 with less than 80 channels in a zone.
At the moment the .csv files created by this utility are not compatible with those created by the CPS.
Colin G4EML
Note for Roger, I am also working on a command line version that may be suitable for calling from the CPS.