I'm having problems constructing a CSV list of channels that the CPS will accept. The CSV that I'm trying to use contains a mix of digital and analog channels, and for some reason the CPS imports my digital channels without a problem, but chokes on the analog ones.
When I view the CSV in a text editor, I see that the digital channels that the CPS will import look like this:
Code: Select all
7,Acton U NO1A,Digital,442.35,447.35,12.5,1,,None,MA DMR,None,Off,Off,,,,Master,No,No,No,0,Off,No,No,None,0.128,0.008
Code: Select all
99,Attleboro K1SMH,Analogue," 147.795"," 146.13",25,,,,,,,,None,127.3,Disabled,Master,No,No,No,0,Off,No,No,None,0,0
Code: Select all
103,Braintree AE1TH,Analogue,447.5,442.5,25,,,,MA analog,,,,,118.8,Disabled,Master,No,No,No,0,Off,No,No,None,0,0
I have 140+ analog repeater and simplex channels that I'd like to include in the my codeplug, and I'm copying the information about them out of other preexisting spreadsheets, so I'd like to build the channel CSV in either Google Sheets or Excel (as opposed to copying each frequency one-by-one into a text file). But no matter what I do, the CSVs that I get out of them look like the line 103 example above (which the CPS refuses), not the line 99 example (which the CPS will accept). Neither Google Sheets nor Excel seem to be able to insert the TAB character that the CPS is looking for (at least, I haven't been able to figure out how to do that). But also, I don't know why the CPS seems to be looking for that character in the analog channels of my CSV and not the digital ones.
Any suggestions as to what I'm missing? (It's probably something obvious that I just don't see.)
Thanks and 73.