Jim: Thanks for the info. I believe your comment will solve the problem. I used a text editor to look at the csv files from saving the radio download and the repeater book csv file. There were discrepancies in the columns regarding the comma separations missing and also the frequencies data from the radio download seems to have a fixed decimal field of 6 vs the repeaterbook having truncated zeros in their respective columns. I will update the files to match and try that.. Take care, Phil
“Any society that would give up a little liberty to gain a little security will deserve neither and lose both.” - Benjamin Franklin
From: Jim Unroe rock.unroe@gmail.com To: Philip Wise pswise@yahoo.com; Discussion of CHIRP chirp_users@intrepid.danplanet.com Sent: Wednesday, November 18, 2015 6:50 PM Subject: Re: [chirp_users] Problem updating CSV file to upload to radio
Any idea what I am doing wrong?
Excel has a bug that when there is an empty cell or cells at the end or a row, it can drop one or more commas. From the point of the first missing comma, the data is misaligned with the columns. My guess is that if you open the CSV file up in a text editor you will see that there is at least 1 comma missing.
I think a workaround is to simply type a single character into the RPT2CALL cell of each row. Unless your radio uses RPT2CALL the value should be ignored for your radio. And if your radio uses RPt2CALL, then you probably don't have this issue.
Jim KC9HI