<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI Emoji";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.ox-6bb14e4d5b-msonormal, li.ox-6bb14e4d5b-msonormal, div.ox-6bb14e4d5b-msonormal
{mso-style-name:ox-6bb14e4d5b-msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.default-style, li.default-style, div.default-style
{mso-style-name:default-style;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:591818151;
mso-list-template-ids:-784022592;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Nigel,<o:p></o:p></p>
<p class="MsoNormal">I can't paste anything into chirp. Only way i can enter anything into it is manually, or import an .img or .csv file.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">Be blessed!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">May 2019 be our year of change & growth!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">Gary Craig<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">Maintenance<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">Webco Industries<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">Texas Distribution<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">750 Martin Luther King Jr Dr<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">Orange, TX 77630-3094<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">409-886-0807 ext. 107<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">Fax 918-246-7045<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D"><a href="mailto:gcraig@webcotube.com"><span style="color:#0563C1">gcraig@webcotube.com</span></a><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Nigel A. Gunn G8IFF/W8IFF <nigel@ngunn.net> <br>
<b>Sent:</b> Monday, January 21, 2019 9:16 AM<br>
<b>To:</b> Discussion of CHIRP <chirp_users@intrepid.danplanet.com>; Gary Craig <gcraig@WebcoIndustries.com><br>
<b>Subject:</b> Re: [chirp_users] Tyt 9800 Update working with CSV files<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0">
<tbody>
<tr>
<td style="background:pink;padding:.75pt .75pt .75pt .75pt">
<div id="EmailWarning2">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif">This email originated from an external sender. Use caution when following links or opening attachments as they could be malicious
<o:p></o:p></span></b></p>
</div>
</td>
</tr>
</tbody>
</table>
<p>Isn't it easier to just use Chirp's inbuilt editor?<o:p></o:p></p>
<p>I've never neededd to play with CSV format.<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal" style="margin-bottom:12.0pt">On 21 January 2019 at 10:05 Gary Craig <<a href="mailto:gcraig@WebcoIndustries.com">gcraig@WebcoIndustries.com</a>> wrote:
<o:p></o:p></p>
<div>
<p class="ox-6bb14e4d5b-msonormal">Glenn,<o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal">Thanks for the heads up about open office. I have had issues with excel and open office working with csv files. Did a little research trying to find a good csv editor and ran across this article:<o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal"><strong><span style="font-size:24.0pt;font-family:"Calibri",sans-serif">How to open CSV files safely with Microsoft Excel
</span></strong><o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal" style="text-align:justify">SupportAbility exports a number of CSV (Comma Separated Value) data files that can be used by other applications for invoicing, NDIS payment requests and other purposes.<o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal" style="text-align:justify"><strong><span style="font-family:"Calibri",sans-serif">THE PROBLEM</span></strong><o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal" style="text-align:justify">It is quite common for SupportAbility users to open these exported CSV files using programs like Microsoft Excel to check their contents before importing the file into a third party application such
as MYOB. However, when Microsoft Excel opens a CSV file, it attempts to interpret the data in that file and starts making changes to it. <o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal" style="text-align:justify">For example, if Excel sees something in the CSV file that it identifies as a date (often incorrectly), Excel will change the date format in the CSV file to suit the way that it prefers to dates to
be formatted. Unfortunately, this generally has the unintended consequence of breaking the CSV file for the third party application that the CSV was specifically designed for.<o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal" style="text-align:justify"><strong><span style="font-family:"Calibri",sans-serif">THE SOLUTION</span></strong><o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal" style="text-align:justify">If you need to open a CSV file in Excel without breaking it, here's how to do it:<o:p></o:p></p>
<ol start="1" type="1">
<li class="ox-6bb14e4d5b-msonormal" style="mso-list:l0 level1 lfo1">Open a new Excel sheet, select the Data tab, then click 'From Text' in the Get External Data group.<o:p></o:p></li><li class="ox-6bb14e4d5b-msonormal" style="mso-list:l0 level1 lfo1">Browse to the CSV file and select 'Import'.<o:p></o:p></li><li class="ox-6bb14e4d5b-msonormal" style="mso-list:l0 level1 lfo1">In step 1 of the Import Wizard choose 'Delimited' as the original data type. Click 'Next'.<o:p></o:p></li><li class="ox-6bb14e4d5b-msonormal" style="mso-list:l0 level1 lfo1">In step 2 of the Import Wizard choose Comma as the delimiter (deselect the Tab check box) and click 'Next'.<o:p></o:p></li><li class="ox-6bb14e4d5b-msonormal" style="mso-list:l0 level1 lfo1">In step 3 of the Import Wizard, you tell Excel not to change your formats. With the first column in the Data Preview selected, scroll across to the last column and select it while holding the
SHIFT key (all columns should now be selected). Then select 'Text' as the Column Data Format and click 'Finish'. <o:p></o:p></li><li class="ox-6bb14e4d5b-msonormal" style="mso-list:l0 level1 lfo1">Click OK to insert the data into cell A1<o:p></o:p></li></ol>
<p class="ox-6bb14e4d5b-msonormal" style="text-align:justify">You should now have a spreadsheet with the imported data but without Excel breaking the formatting required for the intended third party application. Remember to export the file from Excel to CSV
again before uploading to the third party application if you have made changes.<o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal"><a href="https://help.supportability.com.au/article/250-how-to-open-csv-files-safely-with-microsoft-excel">https://help.supportability.com.au/article/250-how-to-open-csv-files-safely-with-microsoft-excel</a><o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal"> <o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal">I will try this out when i get a chance and see if it will solve my issues so i can get all my radios programmed correctly.<o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">
</span><o:p></o:p></p>
<div>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">Be blessed!
</span><o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">May 2019 be our year of change & growth!
</span><o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">
</span><o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">Gary Craig
</span><o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">Maintenance
</span><o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">Webco Industries
</span><o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">Texas Distribution
</span><o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">750 Martin Luther King Jr Dr
</span><o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">Orange, TX 77630-3094
</span><o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">409-886-0807 ext. 107
</span><o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">Fax 918-246-7045
</span><o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D">
</span><o:p></o:p></p>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#1F497D"><a href="mailto:gcraig@webcotube.com"><span style="color:#0563C1">gcraig@webcotube.com</span></a>
</span><o:p></o:p></p>
</div>
<p class="ox-6bb14e4d5b-msonormal"> <o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="ox-6bb14e4d5b-msonormal"><strong><span style="font-family:"Calibri",sans-serif">From:</span></strong>
<a href="mailto:chirp_users-bounces@intrepid.danplanet.com">chirp_users-bounces@intrepid.danplanet.com</a> <<a href="mailto:chirp_users-bounces@intrepid.danplanet.com">chirp_users-bounces@intrepid.danplanet.com</a>>
<strong><span style="font-family:"Calibri",sans-serif">On Behalf Of </span></strong>Glenn At Home<br>
<strong><span style="font-family:"Calibri",sans-serif">Sent:</span></strong> Saturday, January 19, 2019 6:27 PM<br>
<strong><span style="font-family:"Calibri",sans-serif">To:</span></strong> Discussion of CHIRP <<a href="mailto:chirp_users@intrepid.danplanet.com">chirp_users@intrepid.danplanet.com</a>><br>
<strong><span style="font-family:"Calibri",sans-serif">Subject:</span></strong> [chirp_users] Tyt 9800 Update<o:p></o:p></p>
</div>
</div>
<p class="ox-6bb14e4d5b-msonormal"> <o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0">
<tbody>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="ox-6bb14e4d5b-msonormal"><strong><span style="font-size:10.0pt;font-family:"Arial",sans-serif">This email originated from an external sender. Use caution when following links or opening attachments as they could be malicious
</span></strong><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<div>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Thanks All, I think I got it working.</span><o:p></o:p></p>
</div>
<div>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">I tweaked the CSV file, at one point, Open Office took out all the values in the offset column, so I opened another file in Excel that was about the same, and I
selected the column and copied it and switched over to the file in Open Office and pasted it in.</span><o:p></o:p></p>
</div>
<div>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Setting it to the defaults helped, because this time when I imported the file, I think, the VHF is on the left and the UHF is on the right.</span><o:p></o:p></p>
</div>
<div>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Not much UHF going on around here to be sure.</span><o:p></o:p></p>
</div>
<div>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">I need to learn the buttons on the mic other than the number pad and I know the top switch locks some of the keys, including the two top ones.</span><o:p></o:p></p>
</div>
<div>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">It's good to turn those off, as I find myself pressing keys on that thing just by holding it while punching a button.</span><o:p></o:p></p>
</div>
<div>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Anyway, thanks all for helping me get this far.</span><o:p></o:p></p>
</div>
<div>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Glenn</span><o:p></o:p></p>
</div>
<div>
<p class="ox-6bb14e4d5b-msonormal"> <o:p></o:p></p>
</div>
<div>
<p class="ox-6bb14e4d5b-msonormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><br>
Sent From My Tabletop</span><o:p></o:p></p>
</div>
</div>
</blockquote>
<p class="default-style"><br>
<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">_______________________________________________ <br>
chirp_users mailing list <br>
<a href="mailto:chirp_users@intrepid.danplanet.com">chirp_users@intrepid.danplanet.com</a>
<br>
<a href="http://intrepid.danplanet.com/mailman/listinfo/chirp_users">http://intrepid.danplanet.com/mailman/listinfo/chirp_users</a>
<br>
This message was sent to Nigel Gunn, W8IFF at <a href="mailto:nigel@ngunn.net">nigel@ngunn.net</a>
<br>
To unsubscribe, send an email to <a href="mailto:chirp_users-unsubscribe@intrepid.danplanet.com">
chirp_users-unsubscribe@intrepid.danplanet.com</a><o:p></o:p></p>
</blockquote>
<p class="default-style"><br>
<o:p></o:p></p>
<p><o:p> </o:p></p>
<div>
<p style="margin-bottom:12.0pt">Nigel A. Gunn, 1865 El Camino Drive, Xenia, OH 45385-1115, USA. tel +1 937 825 5032<br>
Amateur Radio G8IFF W8IFF and GMRS WRBV701, e-mail <a href="mailto:nigel@ngunn.net">
nigel@ngunn.net</a> www <a href="http://www.ngunn.net">http://www.ngunn.net</a> <o:p>
</o:p></p>
</div>
</div>
</body>
</html>