<!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>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><FONT size=2 face=Arial></FONT> </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><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>In your case, here are the two rows at the position
of the problem:</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </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><FONT size=2 face=Arial></FONT> </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><FONT size=2 face=Arial></FONT> </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><FONT size=2 face=Arial></FONT> </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.)</DIV></FONT>
<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">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 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:0ae401d171ae$76dba790$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
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> 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:0ae601d171ae$76e96330$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:0ae801d171ae$76e9b150$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>
<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 avgcert??="" color="#000000">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">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 avgcert?? color="#000000">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/11706 - Release Date: 02/27/16</P></BLOCKQUOTE></BODY></HTML>