<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 11.00.9600.17924"></HEAD>
<BODY bgColor=#ffffff text=#000000>
<DIV><FONT size=2 face=Arial>> <FONT size=3>I believe you about what Chirp is
expecting, but when I run Chirp, choose <I><B>File/New</B></I>
</FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial><FONT size=3>> to create a new empty CSV file,
then I save that file, the resulting CSV file contains </FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial><FONT size=3>> the extra commas at the end of
the row.</FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial><FONT size=3></FONT></FONT> </DIV>
<DIV><FONT size=2 face=Arial><FONT size=3>Yes, that would be correct.
CHIRP includes the extra 5 commas, to match the full set of column labels in the
first row.</FONT></FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>> </FONT><FONT size=2 face=Arial><FONT size=3>I
use FileViewer to look at the raw text; this file has not been touched by Excel,
yet contains the same extra commas. </FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial><FONT size=3></FONT></FONT> </DIV>
<DIV><FONT size=2 face=Arial><FONT size=3>Remember that these are not "extra"
commas. These are commas that CHIRP needs to have. The problem
occurred when you imported a file that did NOT have these trailing commas in all
lines, although the first 16 or so lines in the second file you posted did have
the trailing commas.</FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial><FONT size=3></FONT></FONT> </DIV>
<DIV><FONT size=2 face=Arial><FONT size=3>When you deleted the unwanted column
labels, for some reason Excel then deleted the trailing commas in the first 16
or so lines. Did you delete just the cells in the first row or did you use
column delete in Excel?</FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial><FONT size=3></FONT></FONT> </DIV>
<DIV><FONT size=2 face=Arial><FONT size=3>> And I have to disagree-- the
whole benefit of a program like this is to be able to </FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial><FONT size=3>> manipulate (change) some data in
order to customize my memory list, and I bet </FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial><FONT size=3>> that's what most users are
looking for.</FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial><FONT size=3></FONT></FONT> </DIV>
<DIV><FONT size=2 face=Arial><FONT size=3>Well, I wasn't a developer, but my
understanding of the purpose of CHIRP is to allow you to put the same setup onto
multiple radios - potentially of different brands. The way it allows you
to do this is by exporting the channel setup to a CSV file and then allowing you
to import that CSV file into as many IMG files as you wish.</FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial><FONT size=3></FONT></FONT> </DIV>
<DIV><FONT size=2 face=Arial><FONT size=3>I suspect that the
developers anticipated that any customisation of the memory list would
actually be done in CHIRP, and then exported to CSV for import into the
other IMG files. CSV files are not easy to play with (as you have found)
and I doubt that the developers were anticipating that this would be the
way that most users would edit their frequency data,</FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial><FONT size=3></FONT></FONT> </DIV>
<DIV><FONT size=2 face=Arial><FONT size=3>Yes, you can edit a CSV file directly,
using Excel or simply a text editor. I do it myself for many CSV
files. But I am an experienced IT person, with an interest in radio, so I
know the types of things that can go wrong.</FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT><FONT size=2 face=Arial></FONT><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">Chris
Nordstrom</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=chirp_users@intrepid.danplanet.com
href="mailto:chirp_users@intrepid.danplanet.com">chirp_users@intrepid.danplanet.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, February 28, 2016 2:50
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>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 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 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
title=chirp_users@intrepid.danplanet.com
href="mailto:chirp_users@intrepid.danplanet.com" moz-do-not-send="true"><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:0ba901d171ec$36eb5cf0$0e00a8c0@Dad" width=275 height=91><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
class=moz-txt-link-abbreviated
href="mailto:chirp_users@intrepid.danplanet.com"
moz-do-not-send="true"><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:0bab01d171ec$36eb8400$0e00a8c0@Dad" width=413
height=290><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:0bad01d171ec$36eb8400$0e00a8c0@Dad" width=534
height=356><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 class=moz-txt-link-abbreviated
href="mailto:chirp_users@intrepid.danplanet.com"
moz-do-not-send="true">chirp_users@intrepid.danplanet.com</A><BR><A
class=moz-txt-link-freetext
href="http://intrepid.danplanet.com/mailman/listinfo/chirp_users"
moz-do-not-send="true">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" moz-do-not-send="true"><A
class=moz-txt-link-abbreviated
href="mailto:vk2fdjs@gmail.com">vk2fdjs@gmail.com</A></A><BR>To
unsubscribe, send an email to <A class=moz-txt-link-abbreviated
href="mailto:chirp_users-unsubscribe@intrepid.danplanet.com"
moz-do-not-send="true">chirp_users-unsubscribe@intrepid.danplanet.com</A>
<HR>
<P align=left color="#000000" avgcert??="">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 class=moz-txt-link-abbreviated href="mailto:chirp_users@intrepid.danplanet.com" moz-do-not-send="true">chirp_users@intrepid.danplanet.com</A>
<A class=moz-txt-link-freetext href="http://intrepid.danplanet.com/mailman/listinfo/chirp_users" moz-do-not-send="true">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" moz-do-not-send="true">cfnordstrom@gmail.com</A>
To unsubscribe, send an email to <A class=moz-txt-link-abbreviated href="mailto:chirp_users-unsubscribe@intrepid.danplanet.com" moz-do-not-send="true">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 align=left color="#000000" avgcert??="">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/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>
<P>
<HR>
<P></P>_______________________________________________<BR>chirp_users mailing
list<BR>chirp_users@intrepid.danplanet.com<BR>http://intrepid.danplanet.com/mailman/listinfo/chirp_users<BR>This
message was sent to Dave VK2FDJS at vk2fdjs@gmail.com<BR>To unsubscribe, send
an email to chirp_users-unsubscribe@intrepid.danplanet.com
<P>
<HR>
<P></P><A></A>
<P align=left color="#000000" avgcert??>No virus found in this
message.<BR>Checked by AVG - <A
href="http://www.avg.com">www.avg.com</A><BR>Version: 2015.0.6189 / Virus
Database: 4537/11711 - Release Date: 02/27/16</P></BLOCKQUOTE></BODY></HTML>