Importing CSV Channels
Importing CSV Channels
Having a problem importing CSV file after export and edit it errors at all the CTCSS numbers.
You do not have the required permissions to view the files attached to this post.
Re: Importing CSV Channels
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. 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.
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. 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.
You do not have the required permissions to view the files attached to this post.
-73 de MM7DBT
Re: Importing CSV Channels
Thanks,
never considered it wasn't formatted as a number
never considered it wasn't formatted as a number
Re: Importing CSV Channels
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.
Where CTCSS is selected and the tone does not contain the .0 it will be automatically added, so the import should not fail.
-73 de MM7DBT