[chirp_users] Problem updating CSV file to upload to radio
Hi: Radio: Baofeng F8HP and UV-5RV2+Computer: Dell, Win XP Professional I am able to clone both radios and make changes to the radio download and update if I manually change the data When I was trying upload a CSV file to the radio I got an error - shown in the attached file I developed the csv file from outputting a csv file from the RepeaterBook website. I was able to open it with MS Excel 2000 w/sp3 (also I was able to open a csv file from Chirp from my radio download. Trying to import the csv file from the Repeaterbook directly into Chirp, gave me the error I then used the scv file from my radio download and modified it with the data from the repeaterbook file by copying and pasting my new data from Repeaterbook csv file into the radio downloaded csv file. I saved this new combined data file with the same columns as shown in my radio downloaded csv file but when I tried to import to the Chirp program, I got the same error. Any idea what I am doing wrong? I know I have old programs and operating system but I have been able to run Chirp successfully for all things except this. 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
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
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
participants (2)
-
Jim Unroe -
Philip Wise