Page 1 of 1
Importing CSV Channels
Posted: Sat Apr 15, 2023 6:28 pm
by m0xrs
Having a problem importing CSV file after export and edit it errors at all the CTCSS numbers.
errorCTCSS.JPG
Re: Importing CSV Channels
Posted: Sat Apr 15, 2023 11:25 pm
by MM7DBT
When the CSV is opened in an editor like Excel. The CTCSS/DCS Tone values will be interpreted as numbers so 77.0 will become 77.
Which, as the error says, is not a valid tone. 77.0 is valid, 77 is not.
When you open the CSV file you'll have to set the formatting for those cells as a number with 1 decimal place, so that the .0 is preserved.
formatcells.PNG
Then when saving it as a csv file, those .0 values should keep the .0 rather than being dropped. Since technically speaking 77.0 and 77 are the same value.
I'll add some extra checks to the import function to hopefully get around this issue but it's recommended to set the cell formatting as well.
Re: Importing CSV Channels
Posted: Sun Apr 16, 2023 4:50 pm
by m0xrs
Thanks,
never considered it wasn't formatted as a number
Re: Importing CSV Channels
Posted: Sun Apr 16, 2023 10:48 pm
by MM7DBT
The latest update should fix this issue.
Where CTCSS is selected and the tone does not contain the .0 it will be automatically added, so the import should not fail.