<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Dave,<br>
<br>
I believe you about what Chirp is expecting, but when I run Chirp,
choose <i><b>File/New</b></i> to create a new empty CSV file,
then I save that file, the resulting CSV file contains the extra
commas at the end of the row. I use FileViewer to look at the raw
text; this file has not been touched by Excel, yet contains the
same extra commas. <br>
<br>
I already discovered that if I delete the unused columns in Excel
and re-import, the column number mismatch error is gone.<br>
<br>
And I have to disagree-- the whole benefit of a program like this
is to be able to manipulate (change) some data in order to
customize my memory list, and I bet that's what most users are
looking for.<br>
<br>
Regards, Chris W7CFN<br>
<br>
<br>
On 2/27/2016 2:30 PM, Dave VK2FDJS wrote:<br>
</div>
<blockquote cite="mid:0af701d171ae$8ab57110$0e00a8c0@Dad"
type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<meta name="GENERATOR" content="MSHTML 11.00.9600.17924">
<div><font size="2" face="Arial">If you are editing CSV files, it
is important that you use a text editor to at least inspect
the results of the edit. In the event of problems using a CSV
file modified in a third-party program (e.g. Excel), it
becomes VITAL that you inspect the file in a text editor.</font></div>
<div> </div>
<div><font size="2" face="Arial">CSV files are text files, not
Excel files. Excel can make use of them, but there is no
reason to expect it to maintain a presupposed file format. In
particular, there is no concept in a CSV file of a header row
naming columns or a fixed number of "columns" per line.</font></div>
<div> </div>
<div><font size="2" face="Arial">In your case, here are the two
rows at the position of the problem:</font></div>
<div> </div>
<div><font size="2" face="Arial">15,SARO-U,444.1,+,5,Tone,179.9,88.5,23,NN,FM,5,,,,,<br>
16,SARO-U,444.125,+,5,Tone,179.9,88.5,23,NN,FM,5<br>
</font></div>
<div><font size="2" face="Arial">As you can see, the line
beginning with "15," which is the 16th line in the file, ends
with a series of commas. These separate the last 5 values in
the line, which all happen to be empty.</font></div>
<div> </div>
<div><font size="2" face="Arial">The line beginning with "16," -
and subsequent lines - are lacking these 5 commas and
accordingly contain five fewer values per line. Because CHIRP
is expecting more values per line than you gave it, it doesn't
know what to do, and hands the problem back to you with the
"column number mismatch" error message. (Certainly it would
be nice if the error message was a bit more informative - e.g.
by including the number of values expected and the number of
values actually in the line - perhaps the programmers can
improve the error message.)</font></div>
<div> </div>
<div><font size="2" face="Arial">When I look at the file from
yesterday (from which you had removed column headings), there
are no trailing commas in any of the lines. I assume these
were removed by Excel, but can't know for sure.</font></div>
<div> </div>
<div><font size="2" face="Arial">As a simple rule of thumb, only
work on CSV files in the program that actually created them.
If you do this, you are unlikely to have problems with them.
As I understand it, the idea of CHIRP's CSV files is to allow
you to copy entire sets of frequencies from one radio image to
another, not to allow you to manipulate the frequency sets in
third-party programs like Excel. (Like all rules, this is, of
course, meant to be broken ... but caveat emptor.)</font></div>
<div><br>
Regards, Dave VK2FDJS<br>
</div>
<blockquote style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
BORDER-LEFT: #000000 2px solid; PADDING-RIGHT: 0px;
MARGIN-RIGHT: 0px" dir="ltr">
<div style="FONT: 10pt arial">----- Original Message ----- </div>
<div style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color:
black"><b>From:</b> <a moz-do-not-send="true"
title="cfnordstrom@gmail.com"
href="mailto:cfnordstrom@gmail.com">Chris Nordstrom</a> </div>
<div style="FONT: 10pt arial"><b>To:</b> <a
moz-do-not-send="true"
title="chirp_users@intrepid.danplanet.com"
href="mailto:chirp_users@intrepid.danplanet.com"><a class="moz-txt-link-abbreviated" href="mailto:chirp_users@intrepid.danplanet.com">chirp_users@intrepid.danplanet.com</a></a>
</div>
<div style="FONT: 10pt arial"><b>Sent:</b> Sunday, February 28,
2016 5:17 AM</div>
<div style="FONT: 10pt arial"><b>Subject:</b> Re: [chirp_users]
Chirp won't read CSV files correctly</div>
<div><br>
</div>
<div class="moz-cite-prefix">Dave,<br>
<br>
Yup, success! When I put 88.5 in the <b><i>rToneFreq</i></b>
column (also used 67, I guess any valid tone freq) <u><i>and</i></u>
deleted column headers from any column that contains no data <u><i>and</i></u>
entered the correct number of rows in <b>Memory Range</b>---badda
bing -- it works.<br>
<img alt="" src="cid:part3.07070702.01080805@gmail.com"
height="91" width="275"><br>
<br>
I also figured out that I cannot directly <i><b>Upload</b></i>
a CSV file to the radio, it has to be an IMG file, which makes
sense, but the method for getting an IMG file is not obvious
and with no documentation (that I could find), eew! So what I
did was <b><i>Download</i></b> from the radio, delete all
except the first row, save it as an "Empty" IMG file. Next, I
<b><i>Open</i></b> that IMG file then <i><b>Import</b></i>
the CSV file containing the memory channel data I want, and
magically, it becomes an IMG file that I can now <i><b>Upload</b></i>
to the radio. Is this how it is supposed to work or is there
another way to do this? Does it work basically the same
regardless of the radio brand?<br>
<br>
Attached is the CSV file that causes the Column number
mismatch error. The only difference between this file and the
one that successfully imports is that there<b> IS</b> column
heading text in columns M, N, O, P and Q, but there is no data
in those columns. When I removed the heading text from just
those columns, the problem goes away.<br>
<br>
Thanks for your encouragement and ideas,<br>
<br>
Regards, Chris W7CFN<br>
<br>
P.S. Is there no one working on some basic documentation?
Perhaps I can contribute something, it's been pretty painful
for me.<br>
<br>
<br>
On 2/26/2016 10:43 PM, Dave VK2FDJS wrote:<br>
</div>
<blockquote cite="mid:094b01d1712a$43f156b0$0e00a8c0@Dad"
type="cite">
<meta name="GENERATOR" content="MSHTML 11.00.9600.17924">
<style></style>
<div><font size="2" face="Arial">I assume the file you
attached was the one that gave you the second (smaller)
set of errors.</font></div>
<div> </div>
<div><font size="2" face="Arial">If you look at it in Excel,
you'll see that rows 33, 35 and 40 are the only rows that
have nothing in the rToneFreq and cToneFreq columns.</font></div>
<div> </div>
<div><font size="2" face="Arial">There are two other rows that
have nothing in the Tone column (rows 2 and 3), but these
still have values in the other two columns. Looks like
you have to have a value of some sort in these two
columns.</font></div>
<div> </div>
<div><font size="2" face="Arial">Could you please post the
file that gave you the errors from row 17 on, so we can
have a look at it too.</font></div>
<div><br>
Regards, Dave VK2FDJS<br>
</div>
<blockquote style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
BORDER-LEFT: #000000 2px solid; PADDING-RIGHT: 0px;
MARGIN-RIGHT: 0px" dir="ltr">
<div style="FONT: 10pt arial">----- Original Message ----- </div>
<div style="BACKGROUND: #e4e4e4; FONT: 10pt arial;
font-color: black"><b>From:</b> <a
title="cfnordstrom@gmail.com"
href="mailto:cfnordstrom@gmail.com"
moz-do-not-send="true">Chris Nordstrom</a> </div>
<div style="FONT: 10pt arial"><b>To:</b> <a
moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:chirp_users@intrepid.danplanet.com"><a class="moz-txt-link-abbreviated" href="mailto:chirp_users@intrepid.danplanet.com">chirp_users@intrepid.danplanet.com</a></a>
</div>
<div style="FONT: 10pt arial"><b>Sent:</b> Saturday,
February 27, 2016 4:15 PM</div>
<div style="FONT: 10pt arial"><b>Subject:</b> Re:
[chirp_users] Chirp won't read CSV files correctly</div>
<div><br>
</div>
<div class="moz-cite-prefix">This is the error I get when
importing or opening my CSV file:<br>
<img alt="" src="cid:part6.03080601.03050605@gmail.com"
height="290" width="413"><br>
I'm using a file that was generated by Chirp using the
export function, then (In Excel) I copy/paste my channels
into that CSV file. When opened in Chirp using either
File/Open or File/Import, same errors every time.<br>
<br>
So, a little experimentation and I discover that it
doesn't like the empty columns to the right (where there
is a column heading but nothing in the column). So I
deleted the column headers (that Chirp created!) for the
columns with no data and voila, it got past that error.
Now I get this one:<br>
<img alt="" src="cid:part7.06010705.02060709@gmail.com"
height="356" width="534"><br>
<br>
The new error about line 33 "[rTone] could not convert
string to float" I generally get what this error means
but don't get what exactly is causing it. And why does it
reference line 33 and only import up to memory channel
25? I notice at the top of the memory list window is an
item called "Memories Memory Range" where the default
entries are 1 to 25. Bingo! I changed the top end to 39
and it imported all the rows in my CSV file. Wow, I know,
there is a disclaimer about how you guys are good at
programming and not so much at documentation. Not sure I
agree with that and the documentation part seems like a
cop out. <br>
<br>
I can't say never, but rarely have I encountered a program
so unintuitive and persnickity. I know, I know, it's
free, what do I want for nothing. I guess I need to lower
my expectations. <br>
<br>
Chris Nordstrom<br>
<br>
<br>
<br>
<br>
<br>
<br>
</div>
<br>
<hr> _______________________________________________<br>
chirp_users mailing list<br>
<a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:chirp_users@intrepid.danplanet.com">chirp_users@intrepid.danplanet.com</a><br>
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://intrepid.danplanet.com/mailman/listinfo/chirp_users">http://intrepid.danplanet.com/mailman/listinfo/chirp_users</a><br>
This message was sent to Dave VK2FDJS at <a
moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:vk2fdjs@gmail.com"><a class="moz-txt-link-abbreviated" href="mailto:vk2fdjs@gmail.com">vk2fdjs@gmail.com</a></a><br>
To unsubscribe, send an email to <a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:chirp_users-unsubscribe@intrepid.danplanet.com">chirp_users-unsubscribe@intrepid.danplanet.com</a>
<hr>
<p avgcert??="" color="#000000" align="left">No virus found
in this message.<br>
Checked by AVG - <a href="http://www.avg.com"
moz-do-not-send="true">www.avg.com</a><br>
Version: 2015.0.6189 / Virus Database: 4537/11703 -
Release Date: 02/26/16</p>
</blockquote>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
chirp_users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:chirp_users@intrepid.danplanet.com">chirp_users@intrepid.danplanet.com</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://intrepid.danplanet.com/mailman/listinfo/chirp_users">http://intrepid.danplanet.com/mailman/listinfo/chirp_users</a>
This message was sent to Chris at <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:cfnordstrom@gmail.com">cfnordstrom@gmail.com</a>
To unsubscribe, send an email to <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:chirp_users-unsubscribe@intrepid.danplanet.com">chirp_users-unsubscribe@intrepid.danplanet.com</a></pre>
</blockquote>
<br>
<p> </p>
<hr> _______________________________________________<br>
chirp_users mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:chirp_users@intrepid.danplanet.com">chirp_users@intrepid.danplanet.com</a><br>
<a class="moz-txt-link-freetext" href="http://intrepid.danplanet.com/mailman/listinfo/chirp_users">http://intrepid.danplanet.com/mailman/listinfo/chirp_users</a><br>
This message was sent to Dave VK2FDJS at <a class="moz-txt-link-abbreviated" href="mailto:vk2fdjs@gmail.com">vk2fdjs@gmail.com</a><br>
To unsubscribe, send an email to
<a class="moz-txt-link-abbreviated" href="mailto:chirp_users-unsubscribe@intrepid.danplanet.com">chirp_users-unsubscribe@intrepid.danplanet.com</a>
<p> </p>
<hr>
<p avgcert??="" color="#000000" align="left">No virus found in
this message.<br>
Checked by AVG - <a moz-do-not-send="true"
href="http://www.avg.com">www.avg.com</a><br>
Version: 2015.0.6189 / Virus Database: 4537/11706 - Release
Date: 02/27/16</p>
</blockquote>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
chirp_users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:chirp_users@intrepid.danplanet.com">chirp_users@intrepid.danplanet.com</a>
<a class="moz-txt-link-freetext" href="http://intrepid.danplanet.com/mailman/listinfo/chirp_users">http://intrepid.danplanet.com/mailman/listinfo/chirp_users</a>
This message was sent to Chris at <a class="moz-txt-link-abbreviated" href="mailto:cfnordstrom@gmail.com">cfnordstrom@gmail.com</a>
To unsubscribe, send an email to <a class="moz-txt-link-abbreviated" href="mailto:chirp_users-unsubscribe@intrepid.danplanet.com">chirp_users-unsubscribe@intrepid.danplanet.com</a></pre>
</blockquote>
<br>
</body>
</html>