<div dir="auto">You cannot use excel you have to use either open office or libre office.<div dir="auto"><br></div><div dir="auto">Excel is incompatible with Chirp. </div><div dir="auto"><br></div><div dir="auto">Regards, </div><div dir="auto"><br></div><div dir="auto">David N1EA </div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sun, Aug 20, 2023, 8:38 PM K0LNY <glenn@ervin.email> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div bgcolor="#ffffff">
<div><font size="2" face="Arial">Hi Ken,</font></div>
<div><font size="2" face="Arial">The copy I have was exported from
Chirp.</font></div>
<div><font size="2" face="Arial">I find it almost impossible to find missing fields
using notepad, my screenreader reads multiple commas as one.</font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">Glenn</font></div>
<div><font size="2" face="Arial"></font> </div>
<div style="FONT:10pt arial">----- Original Message -----
<div style="BACKGROUND:#e4e4e4"><b>From:</b> <a title="ken@n2vip.org" href="mailto:ken@n2vip.org" target="_blank" rel="noreferrer">Ken Hansen</a> </div>
<div><b>To:</b> <a title="chirp_users@intrepid.danplanet.com" href="mailto:chirp_users@intrepid.danplanet.com" target="_blank" rel="noreferrer">Discussion of CHIRP</a> </div>
<div><b>Sent:</b> Sunday, August 20, 2023 6:40 PM</div>
<div><b>Subject:</b> Re: [chirp_users] Tyt 9800 Importing Problems</div></div>
<div><br></div>
<div dir="ltr">
<div dir="ltr">If I follow your narrative correctly, you opened it up in Excel,
two different versions of Libre Office, THEN you edited it in Notepad. (I think
it was corrupted by one or both of the spreadsheet programs you opened it up in
first, I doubt Notepad would corrupt it.)</div>
<div dir="ltr"><br>
<div>Then you said you tried open office, and THEN you tried to import it into
the chirp.</div>
<div><br></div>
<div>Take a good, serious look at the CSV file in notepad again, there are
likely extraneous characters in the file that is messing up the import.</div>
<div><br></div>
<div>What is the source of the file? What is the file extension? (Sometimes this
matters, doubtful in this case, but who knows?)</div>
<div><br></div>
<div>Can you get a fresh copy (export from chirp) and then edit it on
Notepad?</div>
<div><br></div>
<div>Based on what you are describing, that's the best I can come up
with.<br><br>
<div dir="ltr">Ken</div>
<div dir="ltr"><br>
<blockquote type="cite">On Aug 20, 2023, at 18:19, K0LNY
<glenn@ervin.email> wrote:<br><br></blockquote></div>
<blockquote type="cite">
<div dir="ltr">
<div><font size="2" face="Arial">Well I mentioned that I did edit it in
notepad.</font></div>
<div><font size="2" face="Arial">But I sure don't know what would make it not
importable in Chirp.</font></div>
<div><font size="2" face="Arial">Glenn</font></div>
<div style="FONT:10pt arial">----- Original Message -----
<div style="BACKGROUND:#e4e4e4"><b>From:</b> <a title="ken@n2vip.org" href="mailto:ken@n2vip.org" target="_blank" rel="noreferrer">Ken Hansen</a> </div>
<div><b>To:</b> <a title="chirp_users@intrepid.danplanet.com" href="mailto:chirp_users@intrepid.danplanet.com" target="_blank" rel="noreferrer">Discussion of CHIRP</a>
</div>
<div><b>Sent:</b> Sunday, August 20, 2023 5:56 PM</div>
<div><b>Subject:</b> Re: [chirp_users] Tyt 9800 Importing Problems</div></div>
<div><br></div>Why do you keep opening the CSV file in a spreadsheet? Granted
it's easier to read in a spreadsheet, but somewhere along the line it seems
your CSV file got corrupted.
<div><br></div>
<div>Try opening the CSV file in notepad, it won't add anything to the file
that might cause these problems.</div>
<div><br></div>
<div>My suggestion:</div>
<div><br></div>
<div>A) Start with a brand-new, fresh CSV file </div>
<div>B) Open the file in Notepad (you may have to right-click on the file and
use "Open with..." to select Notepad</div>
<div>C) Edit the file as you like, and save it to the exact same name if you
can, if not, be sure to retain the file suffix (like .CSV)</div>
<div>D) Try to import the updated file</div>
<div><br></div>
<div>You could try importing the CSV file immediately after you export it -
don't touch it at all - to ensure you are starting with a known-good
file.</div>
<div><br></div>
<div>Hope this helps,<br><br>
<div dir="ltr">Ken, N2VIP</div>
<div dir="ltr"><br>
<blockquote type="cite">On Aug 20, 2023, at 17:48, K0LNY
<glenn@ervin.email> wrote:<br><br></blockquote></div>
<blockquote type="cite">
<div dir="ltr">
<div><font size="2" face="Arial">Hi All,</font></div>
<div><font size="2" face="Arial">I'm still working on my Tytera
9800.</font></div>
<div><font size="2" face="Arial">I have had trouble working on the CSV file of
the 227 memories.</font></div>
<div><font size="2" face="Arial">My MS Office Excel seems to mess up the
fields.</font></div>
<div><font size="2" face="Arial">For some reason, my LibreOffice Calc crashes
when I open the CSV in there.</font></div>
<div><font size="2" face="Arial">I had a portable version of Libre Office, so I
installed the full version, and that kept crashing too.</font></div>
<div><font size="2" face="Arial">I'm using windows 10.</font></div>
<div><font size="2" face="Arial">So I ran Dism with the repair switches, and
that didn't find anything.</font></div>
<div><font size="2" face="Arial">So I ran SFC and that fixed a problem and I
rebooted.</font></div>
<div><font size="2" face="Arial">I tried Libre Office again, and it keeps
crashing.</font></div>
<div><font size="2" face="Arial">I fixed up the CSV in Notepad, making sure to
not mess with the commas.</font></div>
<div><font size="2" face="Arial">But I need to get the data into Chirp to upload
it to the radio.</font></div>
<div><font size="2" face="Arial">I installed Open Office, and opened it up in
there, but the data does not past into Chirp.</font></div>
<div><font size="2" face="Arial">I tried to import the CSV file into Chirp, but
it does not find it to be a file it can open.</font></div>
<div><font size="2" face="Arial">The error is:</font></div>
<div><font size="2" face="Arial">An error has occurred</font></div>
<div><font size="2" face="Arial">Unknown File Format</font></div>
<div><font size="2" face="Arial">Should Chirp be able to import a CSV
file?</font></div>
<div><font size="2" face="Arial">I am using Chirp Next from a couple days
ago.</font></div>
<div><font size="2" face="Arial">Thanks for any suggestions.</font></div>
<div><font size="2" face="Arial">Glenn</font></div>
<div> </div>
<div><font size="2" face="Arial">A man with a clock always knows what time it
is.<br>A man with two clocks is never sure.<br>-- A derivative of Segal's
law</font></div><span>_______________________________________________</span><br><span>chirp_users
mailing
list</span><br><span><a href="mailto:chirp_users@intrepid.danplanet.com" target="_blank" rel="noreferrer">chirp_users@intrepid.danplanet.com</a></span><br><span><a href="http://intrepid.danplanet.com/mailman/listinfo/chirp_users" target="_blank" rel="noreferrer">http://intrepid.danplanet.com/mailman/listinfo/chirp_users</a></span><br><span>This
message was sent to Ken Hansen at <a href="mailto:ken@n2vip.org" target="_blank" rel="noreferrer">ken@n2vip.org</a></span><br><span>To
unsubscribe, send an email to
<a href="mailto:chirp_users-unsubscribe@intrepid.danplanet.com" target="_blank" rel="noreferrer">chirp_users-unsubscribe@intrepid.danplanet.com</a></span><br><span>To report
this email as off-topic, please email
<a href="mailto:chirp_users-owner@intrepid.danplanet.com" target="_blank" rel="noreferrer">chirp_users-owner@intrepid.danplanet.com</a></span><br><span>Searchable archive:
<a href="https://www.mail-archive.com/chirp_users@intrepid.danplanet.com" target="_blank" rel="noreferrer">https://www.mail-archive.com/chirp_users@intrepid.danplanet.com</a></span></div></blockquote></div>
<p></p>
<hr>
<p></p>_______________________________________________<br>chirp_users mailing
list<br><a href="mailto:chirp_users@intrepid.danplanet.com" target="_blank" rel="noreferrer">chirp_users@intrepid.danplanet.com</a><br><a href="http://intrepid.danplanet.com/mailman/listinfo/chirp_users" target="_blank" rel="noreferrer">http://intrepid.danplanet.com/mailman/listinfo/chirp_users</a><br>This
message was sent to K0LNY at glenn@ervin.email<br>To unsubscribe, send an
email to <a href="mailto:chirp_users-unsubscribe@intrepid.danplanet.com" target="_blank" rel="noreferrer">chirp_users-unsubscribe@intrepid.danplanet.com</a><br>To report this
email as off-topic, please email
<a href="mailto:chirp_users-owner@intrepid.danplanet.com" target="_blank" rel="noreferrer">chirp_users-owner@intrepid.danplanet.com</a><br>Searchable archive:
<a href="https://www.mail-archive.com/chirp_users@intrepid.danplanet.com" target="_blank" rel="noreferrer">https://www.mail-archive.com/chirp_users@intrepid.danplanet.com</a>
<span>_______________________________________________</span><br><span>chirp_users
mailing
list</span><br><span><a href="mailto:chirp_users@intrepid.danplanet.com" target="_blank" rel="noreferrer">chirp_users@intrepid.danplanet.com</a></span><br><span><a href="http://intrepid.danplanet.com/mailman/listinfo/chirp_users" target="_blank" rel="noreferrer">http://intrepid.danplanet.com/mailman/listinfo/chirp_users</a></span><br><span>This
message was sent to Ken Hansen at <a href="mailto:ken@n2vip.org" target="_blank" rel="noreferrer">ken@n2vip.org</a></span><br><span>To
unsubscribe, send an email to
<a href="mailto:chirp_users-unsubscribe@intrepid.danplanet.com" target="_blank" rel="noreferrer">chirp_users-unsubscribe@intrepid.danplanet.com</a></span><br><span>To report this
email as off-topic, please email
<a href="mailto:chirp_users-owner@intrepid.danplanet.com" target="_blank" rel="noreferrer">chirp_users-owner@intrepid.danplanet.com</a></span><br><span>Searchable archive:
<a href="https://www.mail-archive.com/chirp_users@intrepid.danplanet.com" target="_blank" rel="noreferrer">https://www.mail-archive.com/chirp_users@intrepid.danplanet.com</a></span></div></blockquote></div></div></div>
<p>
<hr>
<p></p>_______________________________________________<br>chirp_users mailing
list<br><a href="mailto:chirp_users@intrepid.danplanet.com" target="_blank" rel="noreferrer">chirp_users@intrepid.danplanet.com</a><br><a href="http://intrepid.danplanet.com/mailman/listinfo/chirp_users" target="_blank" rel="noreferrer">http://intrepid.danplanet.com/mailman/listinfo/chirp_users</a><br>This
message was sent to K0LNY at glenn@ervin.email<br>To unsubscribe, send an email
to <a href="mailto:chirp_users-unsubscribe@intrepid.danplanet.com" target="_blank" rel="noreferrer">chirp_users-unsubscribe@intrepid.danplanet.com</a><br>To report this email as
off-topic, please email <a href="mailto:chirp_users-owner@intrepid.danplanet.com" target="_blank" rel="noreferrer">chirp_users-owner@intrepid.danplanet.com</a><br>Searchable
archive:
<a href="https://www.mail-archive.com/chirp_users@intrepid.danplanet.com" target="_blank" rel="noreferrer">https://www.mail-archive.com/chirp_users@intrepid.danplanet.com</a></p></div>
_______________________________________________<br>
chirp_users mailing list<br>
<a href="mailto:chirp_users@intrepid.danplanet.com" target="_blank" rel="noreferrer">chirp_users@intrepid.danplanet.com</a><br>
<a href="http://intrepid.danplanet.com/mailman/listinfo/chirp_users" rel="noreferrer noreferrer" target="_blank">http://intrepid.danplanet.com/mailman/listinfo/chirp_users</a><br>
This message was sent to D.J.J. Ring, Jr. at <a href="mailto:n1ea@arrl.net" target="_blank" rel="noreferrer">n1ea@arrl.net</a><br>
To unsubscribe, send an email to <a href="mailto:chirp_users-unsubscribe@intrepid.danplanet.com" target="_blank" rel="noreferrer">chirp_users-unsubscribe@intrepid.danplanet.com</a><br>
To report this email as off-topic, please email <a href="mailto:chirp_users-owner@intrepid.danplanet.com" target="_blank" rel="noreferrer">chirp_users-owner@intrepid.danplanet.com</a><br>
Searchable archive: <a href="https://www.mail-archive.com/chirp_users@intrepid.danplanet.com" rel="noreferrer noreferrer" target="_blank">https://www.mail-archive.com/chirp_users@intrepid.danplanet.com</a></blockquote></div>