<!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">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff text=#000000>
<DIV><FONT size=2 face=Arial>> <FONT size=3>I am not aware of these bugs in
Excel that were mentioned. ...</FONT></FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>There are (or were) bugs in Excel for CSV files, but these
are not them. :-)</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>Excel will write a CSV file that contains the
information it knows to put in. It will get this from two
places:</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>1) Cells that came from a CSV file,</FONT></DIV>
<DIV><FONT face=Arial>2) Cells that you've put values in.</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>So, the first 16 entries came in from the CSV file when it
was read. These lines had included the 5 trailing commas, so Excel knew
there were empty cells in those rows that needed to be written out.</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>The remainder of the entries came from extra rows that you
added (I assume). There is no formal layout to a worksheet, so Excel has
no way of guessing that you want all rows to have the same number of columns, or
even that these rows are supposed to be the same width as what's in row 1 of the
worksheet, which is simply another row of information.</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>I certainly couldn't put it any better than Tom, so: " It
sounds like you are a relatively new user of Chirp, yet<BR>using third party
software to edit Chirp files is arguably one of the most advanced things you can
do with Chirp."</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV>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 8:48
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>Tom,<BR><BR>Okay, I just tested it again and it
works as you say. When I was getting the import errors before--caused by
not having data in key fields--it appeared that it stopped at the default
number--25--which was only limiting what I could see, not what was
imported. So it works fine.<BR><BR>I am not aware of these bugs in Excel
that were mentioned. After creating my CSV file, I used a raw file
viewer and did not see any extra characters or missing characters. I am
using Excel now to edit the CSV files and they import fine. Is it true
that there has to be a default value in <I><B>rToneFreq</B></I>? And
what about the errors I get when there are columns with header text but no
data in the column? Could this be caused by Excel?<BR><BR>Regards, Chris
W7CFN<BR><BR><BR>On 2/27/2016 11:57 AM, Tom Hayward wrote:<BR></DIV>
<BLOCKQUOTE
cite=mid:CAFXO5Z1jQXSLK+Hb_Mbps3m1Oyo06Qnw=rn9esM=YKsbH0jSQQ@mail.gmail.com
type="cite"><PRE wrap="">On Sat, Feb 27, 2016 at 11:33 AM, Chris Nordstrom <A class=moz-txt-link-rfc2396E href="mailto:cfnordstrom@gmail.com"><cfnordstrom@gmail.com></A> wrote:
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">But I could not find where it says you should delete column header text
for columns that contain no data and it also does not say that the
Memory Range entry on the edit window must match the number of rows you
are importing; the error you get doesn't lead you make this connection.
Did I miss this too?
</PRE></BLOCKQUOTE><PRE wrap="">Not sure what you mean about memory range view being related to the
number of rows imported. I've imported outside the currently selected
range many times and never had an issue. I just did it again now to
verify. The memory range view is just a view; it doesn't affect
imports.
Regarding the Excel bugs, there's only so much we can do about people
using 3rd party software to edit Chirp files and getting unexpected
results. As I said in my first email, I recommend editing Chirp files
with Chirp. When you edit with Chirp, it maintains all the proper data
in the proper columns. There is no need to delete headers or fill your own
defaults--it's all automatic in Chirp. Feel free to write some documentation
about the caveats you discovered when editing Chirp files in Excel.
Tom KD7LXL
_______________________________________________
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/11709 - Release Date: 02/27/16</P></BLOCKQUOTE></BODY></HTML>