Importing CSV Channels

Report any bugs or errors you find here.
Post Reply
m0xrs
0posts
Posts: 6
Joined: Fri Aug 20, 2021 12:01 pm
Callsign: M0XRS

Importing CSV Channels

Post by m0xrs »

Having a problem importing CSV file after export and edit it errors at all the CTCSS numbers.
errorCTCSS.JPG
You do not have the required permissions to view the files attached to this post.
User avatar
MM7DBT
Site Admin
150posts
Posts: 193
Joined: Wed Jun 02, 2021 6:59 pm
Location: Scotland
Callsign: MM7DBT

Re: Importing CSV Channels

Post 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.
You do not have the required permissions to view the files attached to this post.
-73 de MM7DBT
m0xrs
0posts
Posts: 6
Joined: Fri Aug 20, 2021 12:01 pm
Callsign: M0XRS

Re: Importing CSV Channels

Post by m0xrs »

Thanks,

never considered it wasn't formatted as a number
User avatar
MM7DBT
Site Admin
150posts
Posts: 193
Joined: Wed Jun 02, 2021 6:59 pm
Location: Scotland
Callsign: MM7DBT

Re: Importing CSV Channels

Post 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.
-73 de MM7DBT
Post Reply