[chirp_users] Tyt 9800 Update working with CSV files

Mon Jan 21 08:22:10 PST 2019

I personally haven't found it to be very intuitive for editing.
Glenn
----- Original Message ----- 
From: Nigel A. Gunn G8IFF/W8IFF 
To: Discussion of CHIRP ; Gary Craig 
Sent: Monday, January 21, 2019 9:15 AM
Subject: Re: [chirp_users] Tyt 9800 Update working with CSV files

Isn't it easier to just use Chirp's inbuilt editor?

I've never neededd to play with CSV format.

  On 21 January 2019 at 10:05 Gary Craig <gcraig at WebcoIndustries.com> wrote: 

  Glenn,

  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:

  How to open CSV files safely with Microsoft Excel 

  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.

  THE PROBLEM

  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.  

  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.

  THE SOLUTION

  If you need to open a CSV file in Excel without breaking it, here's how to do it:

    1.. Open a new Excel sheet, select the Data tab, then click 'From Text' in the Get External Data group.
    2.. Browse to the CSV file and select 'Import'.
    3.. In step 1 of the Import Wizard choose 'Delimited' as the original data type. Click 'Next'.
    4.. In step 2 of the Import Wizard choose Comma as the delimiter (deselect the Tab check box) and click 'Next'.
    5.. 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'. 
    6.. Click OK to insert the data into cell A1
  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.

  https://help.supportability.com.au/article/250-how-to-open-csv-files-safely-with-microsoft-excel

  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.

  Be blessed! 

  May 2019 be our year of change & growth! 

  Gary Craig 

  Maintenance 

  Webco Industries 

  Texas Distribution 

  750 Martin Luther King Jr Dr 

  Orange, TX 77630-3094 

  409-886-0807 ext. 107 

  Fax 918-246-7045 

  gcraig at webcotube.com 

  From: chirp_users-bounces at intrepid.danplanet.com <chirp_users-bounces at intrepid.danplanet.com> On Behalf Of Glenn At Home
  Sent: Saturday, January 19, 2019 6:27 PM
  To: Discussion of CHIRP <chirp_users at intrepid.danplanet.com>
  Subject: [chirp_users] Tyt 9800 Update

        This email originated from an external sender. Use caution when following links or opening attachments as they could be malicious 

  Thanks All, I think I got it working.

  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.

  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.

  Not much UHF going on around here to be sure.

  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.

  It's good to turn those off, as I find myself pressing keys on that thing just by holding it while punching a button.

  Anyway,  thanks all for helping me get this far.

  Glenn

  Sent From My Tabletop

  _______________________________________________ 
  chirp_users mailing list 
  chirp_users at intrepid.danplanet.com 
  http://intrepid.danplanet.com/mailman/listinfo/chirp_users 
  This message was sent to Nigel Gunn, W8IFF at nigel at ngunn.net 
  To unsubscribe, send an email to chirp_users-unsubscribe at intrepid.danplanet.com

Nigel A. Gunn, 1865 El Camino Drive, Xenia, OH 45385-1115, USA. tel +1 937 825 5032
Amateur Radio G8IFF W8IFF and GMRS WRBV701, e-mail nigel at ngunn.net www http://www.ngunn.net 

--------------------------------------------------------------------------------

_______________________________________________
chirp_users mailing list
chirp_users at intrepid.danplanet.com
http://intrepid.danplanet.com/mailman/listinfo/chirp_users
This message was sent to Glenn at glennervin at cableone.net
To unsubscribe, send an email to chirp_users-unsubscribe at intrepid.danplanet.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://intrepid.danplanet.com/pipermail/chirp_users/attachments/20190121/badebb01/attachment.html 