<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div class="default-style">
Agreed. If you can, use Libre Office rather than a Microsoft product. Excel messes with the empty comma seperated fields at the end of each row.
</div>
<div class="default-style">
<br>
</div>
<blockquote type="cite">
<div>
On 23/03/2021 11:37 Glenn K0LNY <glennervin@cableone.net> wrote:
</div>
<div>
<br>
</div>
<div>
<br>
</div>
<div>
<span style="font-family: Arial; font-size: small;">Well from the perspective of a screenreader user, I find editing things much easier to make changes in a spreadsheet program outside of Chirp and import them after the changes were made, so I would call that, the better way.</span>
</div>
<div>
<span style="font-family: Arial; font-size: small;">Glenn</span>
</div>
<div>
<br>
</div>
<div style="font: 10pt arial;">
----- Original Message -----
<div style="background: #e4e4e4; font-color: black;">
<strong>From:</strong> <a href="mailto:nigel@ngunn.net">Nigel A. Gunn G8IFF/W8IFF</a>
</div>
<div>
<strong>To:</strong> <a href="mailto:eric.oyen@icloud.com">Eric Oyen</a> ; <a href="mailto:chirp_users@intrepid.danplanet.com">Eric Oyen via chirp_users</a>
</div>
<div>
<strong>Sent:</strong> Tuesday, March 23, 2021 7:45 AM
</div>
<div>
<strong>Subject:</strong> Re: [chirp_users] I get an "unknown file format" when importing
</div>
</div>
<div>
<br>
</div>
<div class="default-style">
The best way is not to use CSV files at all.
</div>
<blockquote type="cite">
<div>
On 23/03/2021 02:08 Eric Oyen via chirp_users <<a href="mailto:chirp_users@intrepid.danplanet.com">chirp_users@intrepid.danplanet.com</a>> wrote:
</div>
<div>
<br>
</div>
<div>
<br>
</div>One good way I have found to edit CsV files is to use a spreadsheet program like Microsoft excel or one of the linux free variants. Simply import as a cSV, do your editing, then export back to a CSV file. Compare the original to the new edited version to make sure the same number of commas are in place on the right lines. BTW, I have already tried this on my windows box using excel and a program specifically designed for the Baofeng radio. So, it should work the same way with chirp as both that program and cHIRP should read or write CSV files in the same way.
<div>
<br>
</div>
<div>
DE n7zzt Eric
</div>
<div>
<br>
<div>
<br>
<blockquote type="cite">
<div>
On Mar 20, 2021, at 11:39 AM, Jim Unroe <<a href="mailto:rock.unroe@gmail.com">rock.unroe@gmail.com</a>> wrote:
</div>
<div>
<span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">On Sat, Mar 20, 2021 at 1:25 PM Steve Vecchiarelli via chirp_users</span>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><</span><a href="mailto:chirp_users@intrepid.danplanet.com" style="font-size: 12px; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; font-variant-caps: normal; -webkit-text-stroke-width: 0px; -webkit-text-size-adjust: auto;">chirp_users@intrepid.danplanet.com</a><span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">> wrote:</span>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">
<blockquote type="cite">
<br>’m trying to import a csv file into CHIRP to upload back to my radio.
<br>
<br>
<br>
<br>Steps I’ve taken:
<br>
<br>
<br>
<br>Connected radio to CHIRP and downloaded the memories to CHIRP
<br>Exported memories to a CSV file
<br>Added the new frequencies to the CSV file
<br>Saved CSV and tried to import back to CHIRP bur getting an unknown file format message
<br>
<br>
<br>
<br>What am I missing?
<br>
<br>
<br>
<br>Thanks for any help!
<br>
<br>
<br>
<br>Steve
<br>
<br>KF0CPV
<br>
</blockquote>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">How did you edit the CSV file?</span>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">What did you change?</span>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">Did you compare the new CSV file to the original file CSV file using a</span>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">text editor?</span>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">Attach both the before and after CSV files to this conversation so</span>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">that they can be reviewed.</span>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">The most common cause of trouble is...</span>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">- The data format of a cell was changed.</span>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">- The number of commas required at the end of a data row was changed.</span>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">Jim KC9HI</span>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">_______________________________________________</span>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">chirp_users mailing list</span>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><a href="mailto:chirp_users@intrepid.danplanet.com" style="font-size: 12px; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; font-variant-caps: normal; -webkit-text-stroke-width: 0px; -webkit-text-size-adjust: auto;">chirp_users@intrepid.danplanet.com</a>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><a href="http://intrepid.danplanet.com/mailman/listinfo/chirp_users" style="font-size: 12px; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; font-variant-caps: normal; -webkit-text-stroke-width: 0px; -webkit-text-size-adjust: auto;">http://intrepid.danplanet.com/mailman/listinfo/chirp_users</a>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">This message was sent to Eric Oyen at<span class="Apple-converted-space"> </span></span><a href="mailto:eric.oyen@icloud.com" style="font-size: 12px; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; font-variant-caps: normal; -webkit-text-stroke-width: 0px; -webkit-text-size-adjust: auto;">eric.oyen@icloud.com</a>
<br style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;"><span style="font-size: 12px; text-decoration: none; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; float: none; font-weight: normal; font-style: normal; display: inline !important; letter-spacing: normal; text-indent: 0px; caret-color: #000000; font-variant-caps: normal; -webkit-text-stroke-width: 0px;">To unsubscribe, send an email to<span class="Apple-converted-space"> </span></span><a href="mailto:chirp_users-unsubscribe@intrepid.danplanet.com" style="font-size: 12px; font-family: Monaco; white-space: normal; word-spacing: 0px; text-transform: none; font-weight: normal; font-style: normal; letter-spacing: normal; text-indent: 0px; font-variant-caps: normal; -webkit-text-stroke-width: 0px; -webkit-text-size-adjust: auto;">chirp_users-unsubscribe@intrepid.danplanet.com</a>
</div>
</blockquote>
</div>
<br>
</div>_______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Nigel Gunn, W8IFF at nigel@ngunn.net To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com
</blockquote>
<div class="default-style">
<br>
</div>
<div class="io-ox-signature">
<p>Nigel A. Gunn, ///shoulders.outwards.resolutions tel +1-937-971-0366<br>Amateur Radio G8IFF W8IFF and GMRS WRBV701, e-mail nigel@ngunn.net www http://www.ngunn.net <br><br></p>
</div>
<p><br></p>
<hr>
<p><br></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 Glenn at glennervin@cableone.net
<br>To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com _______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Nigel Gunn, W8IFF at nigel@ngunn.net To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com
</blockquote>
<div class="default-style">
<br>
</div>
<div class="io-ox-signature">
<p>Nigel A. Gunn, ///shoulders.outwards.resolutions tel +1-937-971-0366<br>Amateur Radio G8IFF W8IFF and GMRS WRBV701, e-mail nigel@ngunn.net www http://www.ngunn.net <br><br></p>
</div>
</body>
</html>