<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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"><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 11.00.9600.19236">
<STYLE>@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Segoe UI Emoji;
}
@page WordSection1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; MARGIN: 0in 0in 0pt
}
LI.MsoNormal {
FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; MARGIN: 0in 0in 0pt
}
DIV.MsoNormal {
FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; MARGIN: 0in 0in 0pt
}
H1 {
FONT-SIZE: 24pt; FONT-FAMILY: "Calibri",sans-serif; FONT-WEIGHT: bold; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; mso-style-priority: 9; mso-style-link: "Heading 1 Char"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
A:link {
TEXT-DECORATION: underline; COLOR: #0563c1; mso-style-priority: 99
}
SPAN.MsoHyperlink {
TEXT-DECORATION: underline; COLOR: #0563c1; mso-style-priority: 99
}
A:visited {
TEXT-DECORATION: underline; COLOR: #954f72; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
TEXT-DECORATION: underline; COLOR: #954f72; mso-style-priority: 99
}
P.msonormal0 {
FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-style-name: msonormal
}
LI.msonormal0 {
FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-style-name: msonormal
}
DIV.msonormal0 {
FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-style-name: msonormal
}
SPAN.EmailStyle18 {
FONT-FAMILY: "Calibri",sans-serif; mso-style-type: personal-reply
}
SPAN.Heading1Char {
FONT-FAMILY: "Calibri",sans-serif; FONT-WEIGHT: bold; mso-style-priority: 9; mso-style-link: "Heading 1"; mso-style-name: "Heading 1 Char"
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
DIV.WordSection1 {
page: WordSection1
}
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=#0563c1 bgColor=white vLink=#954f72>
<DIV><FONT size=2 face=Arial>That's good information Gary.</FONT></DIV>
<DIV><FONT size=2 face=Arial>Thanks.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV> </DIV>
<DIV style="FONT: 10pt arial">----- Original Message -----
<DIV style="BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A
title=gcraig@WebcoIndustries.com href="mailto:gcraig@WebcoIndustries.com">Gary
Craig</A> </DIV>
<DIV><B>To:</B> <A title=chirp_users@intrepid.danplanet.com
href="mailto:chirp_users@intrepid.danplanet.com">Discussion of CHIRP</A> </DIV>
<DIV><B>Sent:</B> Monday, January 21, 2019 9:05 AM</DIV>
<DIV><B>Subject:</B> Re: [chirp_users] Tyt 9800 Update working with CSV
files</DIV></DIV>
<DIV><BR></DIV>
<DIV class=WordSection1>
<P class=MsoNormal>Glenn,<o:p></o:p></P>
<P class=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=MsoNormal
style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><B><SPAN
style="FONT-SIZE: 24pt">How to open CSV files safely with Microsoft
Excel<o:p></o:p></SPAN></B></P>
<P class=MsoNormal
style="TEXT-ALIGN: justify; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto">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=MsoNormal
style="TEXT-ALIGN: justify; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><B>THE
PROBLEM</B><o:p></o:p></P>
<P class=MsoNormal
style="TEXT-ALIGN: justify; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto">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=MsoNormal
style="TEXT-ALIGN: justify; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto">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=MsoNormal
style="TEXT-ALIGN: justify; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><B>THE
SOLUTION</B><o:p></o:p></P>
<P class=MsoNormal
style="TEXT-ALIGN: justify; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto">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 type=1>
<LI class=MsoNormal
style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; 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 class=MsoNormal
style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1">Browse
to the CSV file and select 'Import'.<o:p></o:p>
<LI class=MsoNormal
style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; 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 class=MsoNormal
style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; 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 class=MsoNormal
style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; 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 class=MsoNormal
style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1">Click
OK to insert the data into cell A1<o:p></o:p></LI></OL>
<P class=MsoNormal
style="TEXT-ALIGN: justify; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto">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=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=MsoNormal><o:p> </o:p></P>
<P class=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=MsoNormal><SPAN
style='FONT-SIZE: 12pt; FONT-FAMILY: "Segoe UI Emoji",sans-serif; COLOR: #1f497d'><o:p> </o:p></SPAN></P>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 12pt; FONT-FAMILY: "Segoe UI Emoji",sans-serif; COLOR: #1f497d'>Be
blessed!<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 12pt; 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: 12pt; FONT-FAMILY: "Segoe UI Emoji",sans-serif; COLOR: #1f497d'><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 12pt; FONT-FAMILY: "Segoe UI Emoji",sans-serif; COLOR: #1f497d'>Gary
Craig<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 12pt; FONT-FAMILY: "Segoe UI Emoji",sans-serif; COLOR: #1f497d'>Maintenance<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 12pt; FONT-FAMILY: "Segoe UI Emoji",sans-serif; COLOR: #1f497d'>Webco
Industries<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 12pt; FONT-FAMILY: "Segoe UI Emoji",sans-serif; COLOR: #1f497d'>Texas
Distribution<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 12pt; 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: 12pt; 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: 12pt; 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: 12pt; 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: 12pt; FONT-FAMILY: "Segoe UI Emoji",sans-serif; COLOR: #1f497d'><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 12pt; 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-TOP: #e1e1e1 1pt solid; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0in; PADDING-TOP: 3pt; PADDING-LEFT: 0in; BORDER-LEFT: medium none; PADDING-RIGHT: 0in">
<P class=MsoNormal><B>From:</B> chirp_users-bounces@intrepid.danplanet.com
<chirp_users-bounces@intrepid.danplanet.com> <B>On Behalf Of </B>Glenn At
Home<BR><B>Sent:</B> Saturday, January 19, 2019 6:27 PM<BR><B>To:</B> Discussion
of CHIRP <chirp_users@intrepid.danplanet.com><BR><B>Subject:</B>
[chirp_users] Tyt 9800 Update<o:p></o:p></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<TABLE class=MsoNormalTable cellSpacing=3 cellPadding=0 border=0>
<TBODY>
<TR>
<TD
style="BACKGROUND: pink; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt">
<DIV id=EmailWarning2>
<P class=MsoNormal><B><SPAN
style='FONT-SIZE: 10pt; 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>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>Thanks All, I think I
got it working.</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; 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=MsoNormal><SPAN
style='FONT-SIZE: 10pt; 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=MsoNormal><SPAN
style='FONT-SIZE: 10pt; 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=MsoNormal><SPAN
style='FONT-SIZE: 10pt; 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=MsoNormal><SPAN
style='FONT-SIZE: 10pt; 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=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>Anyway, thanks
all for helping me get this far.</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>Glenn</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'><BR>Sent From My
Tabletop</SPAN><o:p></o:p></P></DIV></DIV>
<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 Glenn at glennervin@cableone.net<BR>To unsubscribe, send an
email to chirp_users-unsubscribe@intrepid.danplanet.com</BODY></HTML>