[chirp_users] Using premade cvs or execl spreadsheet
Good morning, MERRY CHRISTMAS. In programming my Baofengs, I'm wondering how to convert pre done lists into the chirp to download to the radios.
Sent from my Verizon Motorola Smartphone
You type them in to the Chirp editor.
On 25/12/2020 12:25 Glen Terry <acetech1@cox.net> wrote: Good morning, MERRY CHRISTMAS. In programming my Baofengs, I'm wondering how to convert pre done lists into the chirp to download to the radios. Sent from my Verizon Motorola Smartphone _______________________________________________ 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
Nigel A. Gunn, ///shoulders.outwards.resolutions tel +1-937-971-0366 Amateur Radio G8IFF W8IFF and GMRS WRBV701, e-mail nigel@ngunn.net www http://www.ngunn.net
Hi Glen,
On Fri, Dec 25, 2020 at 12:27 PM Glen Terry ACETECH1@cox.net wrote:
Good morning, MERRY CHRISTMAS. In programming my Baofengs, I'm wondering how to convert pre done lists into the chirp to download to the radios.
To expand on Nigel's advice, enter a few known to be working channels into the CHIRP spreadsheet style memory editor. Export these channels to a CSV file. The CSV file saved from CHIRP is now your template for how a CSV file must be formatted to be compatible with CHIRP.
Jim KC9HI
Because of a known issue with MS Excel, I never recomment the use of spreadsheets with Chirp.
On 25/12/2020 13:48 Jim Unroe rock.unroe@gmail.com wrote:
Hi Glen,
On Fri, Dec 25, 2020 at 12:27 PM Glen Terry ACETECH1@cox.net wrote:
Good morning, MERRY CHRISTMAS. In programming my Baofengs, I'm wondering how to convert pre done lists into the chirp to download to the radios.
To expand on Nigel's advice, enter a few known to be working channels into the CHIRP spreadsheet style memory editor. Export these channels to a CSV file. The CSV file saved from CHIRP is now your template for how a CSV file must be formatted to be compatible with CHIRP.
Jim KC9HI _______________________________________________ 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
Nigel A. Gunn, ///shoulders.outwards.resolutions tel +1-937-971-0366 Amateur Radio G8IFF W8IFF and GMRS WRBV701, e-mail nigel@ngunn.net www http://www.ngunn.net
I'm not sure which issue you're referring to, but there are many alternatives to Excel, whether you're using Windows, Mac or Linux. It seems unlikely that all of them have the same problem.
Martin. KD6YAM
On Fri, Dec 25, 2020 at 11:02 AM Nigel A. Gunn G8IFF/W8IFF nigel@ngunn.net wrote:
Because of a known issue with MS Excel, I never recomment the use of spreadsheets with Chirp.
On 25/12/2020 13:48 Jim Unroe rock.unroe@gmail.com wrote:
Hi Glen,
On Fri, Dec 25, 2020 at 12:27 PM Glen Terry ACETECH1@cox.net wrote:
Good morning, MERRY CHRISTMAS. In programming my Baofengs, I'm
wondering how to convert pre done lists into the chirp to download to the radios.
To expand on Nigel's advice, enter a few known to be working channels into the CHIRP spreadsheet style memory editor. Export these channels to a CSV file. The CSV file saved from CHIRP is now your template for how a CSV file must be formatted to be compatible with CHIRP.
Jim KC9HI _______________________________________________ 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
Nigel A. Gunn, ///shoulders.outwards.resolutions tel +1-937-971-0366 Amateur Radio G8IFF W8IFF and GMRS WRBV701, e-mail nigel@ngunn.net www http://www.ngunn.net _______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Martin Cooper at mfncooper@gmail.com To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com
Hi Martin,
On Fri, Dec 25, 2020 at 2:11 PM Martin Cooper mfncooper@gmail.com wrote:
I'm not sure which issue you're referring to, but there are many alternatives to Excel, whether you're using Windows, Mac or Linux. It seems unlikely that all of them have the same problem.
Martin. KD6YAM
For some reason when Excell encounters a series of commas (which is typical as shown in the example below), it can drop one or more commas.
0,WXM78,162.450000,off,0.000000,,88.5,88.5,023,NN,FM,5.00,S,,,,, 1,EMA NET,155.025000,off,0.000000,,88.5,88.5,023,NN,NFM,5.00,,,,,, 2,FD DSP,154.995000,off,0.000000,,88.5,88.5,023,NN,NFM,5.00,,,,,,
Unfortunately when this happens, all of the data from that point on is shifted into the wrong column and CHIRP becomes upset. This does not happen in other spreadsheet programs like LibreOffice Calc and Apache Open Office Calc.
Jim KC9HI
On 2020-12-25 11:31, Jim Unroe wrote:
Hi Martin,
On Fri, Dec 25, 2020 at 2:11 PM Martin Cooper mfncooper@gmail.com wrote:
I'm not sure which issue you're referring to, but there are many alternatives to Excel, whether you're using Windows, Mac or Linux. It seems unlikely that all of them have the same problem.
Martin. KD6YAM
For some reason when Excell encounters a series of commas (which is typical as shown in the example below), it can drop one or more commas.
Jim KC9HI
I thought the issue was more easily summarised as Excel truncates empty fields at the end-of-line. I always wondered why the solution wasn't for Chirp to respect EOL as a field (column) reset, as Excel obviously does?
Is that not right or just a gross oversimplification?
Benton 27dec20 -- NX7O benton@siletzbay.com
Several have reported that Excel can insert extra random characters into empty cells which Chirp then rejectd. I use Libre Office which seems OK. The other problem is people having difficulty getting the columns and their labels in the right order.
Safer to stick to the Chirp editor.
On 25/12/2020 14:10 Martin Cooper <mfncooper@gmail.com> wrote: I'm not sure which issue you're referring to, but there are many alternatives to Excel, whether you're using Windows, Mac or Linux. It seems unlikely that all of them have the same problem. Martin. KD6YAM On Fri, Dec 25, 2020 at 11:02 AM Nigel A. Gunn G8IFF/W8IFF <nigel@ngunn.net mailto:nigel@ngunn.net > wrote: > > Because of a known issue with MS Excel, I never recomment the use of spreadsheets with Chirp.> On 25/12/2020 13:48 Jim Unroe <rock.unroe@gmail.com mailto:rock.unroe@gmail.com > wrote: > > > Hi Glen, > > On Fri, Dec 25, 2020 at 12:27 PM Glen Terry <ACETECH1@cox.net mailto:ACETECH1@cox.net > wrote: > > > > Good morning, MERRY CHRISTMAS. In programming my Baofengs, I'm wondering how to convert pre done lists into the chirp to download to the radios. > > > > To expand on Nigel's advice, enter a few known to be working channels > into the CHIRP spreadsheet style memory editor. Export these channels > to a CSV file. The CSV file saved from CHIRP is now your template for > how a CSV file must be formatted to be compatible with CHIRP. > > Jim KC9HI > _______________________________________________ > chirp_users mailing list > chirp_users@intrepid.danplanet.com mailto: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 mailto:nigel@ngunn.net > To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com mailto:chirp_users-unsubscribe@intrepid.danplanet.com Nigel A. Gunn, ///shoulders.outwards.resolutions tel +1-937-971-0366 Amateur Radio G8IFF W8IFF and GMRS WRBV701, e-mail nigel@ngunn.net mailto:nigel@ngunn.net www http://www.ngunn.net _______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com mailto:chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Martin Cooper at mfncooper@gmail.com mailto:mfncooper@gmail.com To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com mailto: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
Nigel A. Gunn, ///shoulders.outwards.resolutions tel +1-937-971-0366 Amateur Radio G8IFF W8IFF and GMRS WRBV701, e-mail nigel@ngunn.net www http://www.ngunn.net
THANK YOU MERRY CHRISTMAS.
Sent from Mail for Windows 10
From: Nigel A. Gunn G8IFF/W8IFF Sent: Friday, December 25, 2020 12:00 PM To: Discussion of CHIRP; Martin Cooper Subject: Re: [chirp_users] Using premade cvs or execl spreadsheet
Several have reported that Excel can insert extra random characters into empty cells which Chirp then rejectd. I use Libre Office which seems OK. The other problem is people having difficulty getting the columns and their labels in the right order.
Safer to stick to the Chirp editor. On 25/12/2020 14:10 Martin Cooper mfncooper@gmail.com wrote:
I'm not sure which issue you're referring to, but there are many alternatives to Excel, whether you're using Windows, Mac or Linux. It seems unlikely that all of them have the same problem.
Martin. KD6YAM
On Fri, Dec 25, 2020 at 11:02 AM Nigel A. Gunn G8IFF/W8IFF nigel@ngunn.net wrote: Because of a known issue with MS Excel, I never recomment the use of spreadsheets with Chirp.
On 25/12/2020 13:48 Jim Unroe rock.unroe@gmail.com wrote:
Hi Glen,
On Fri, Dec 25, 2020 at 12:27 PM Glen Terry ACETECH1@cox.net wrote:
Good morning, MERRY CHRISTMAS. In programming my Baofengs, I'm wondering how to convert pre done lists into the chirp to download to the radios.
To expand on Nigel's advice, enter a few known to be working channels into the CHIRP spreadsheet style memory editor. Export these channels to a CSV file. The CSV file saved from CHIRP is now your template for how a CSV file must be formatted to be compatible with CHIRP.
Jim KC9HI _______________________________________________ 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
Nigel A. Gunn, ///shoulders.outwards.resolutions tel +1-937-971-0366 Amateur Radio G8IFF W8IFF and GMRS WRBV701, e-mail nigel@ngunn.net www http://www.ngunn.net _______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Martin Cooper at mfncooper@gmail.com 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
Nigel A. Gunn, ///shoulders.outwards.resolutions tel +1-937-971-0366 Amateur Radio G8IFF W8IFF and GMRS WRBV701, e-mail nigel@ngunn.net www http://www.ngunn.net
THANK YOU, I’LL TRY THAT. MERRY CHRISTMAS
Sent from Mail for Windows 10
From: Martin Cooper Sent: Friday, December 25, 2020 11:12 AM To: Discussion of CHIRP Subject: Re: [chirp_users] Using premade cvs or execl spreadsheet
I'm not sure which issue you're referring to, but there are many alternatives to Excel, whether you're using Windows, Mac or Linux. It seems unlikely that all of them have the same problem.
Martin. KD6YAM
On Fri, Dec 25, 2020 at 11:02 AM Nigel A. Gunn G8IFF/W8IFF nigel@ngunn.net wrote: Because of a known issue with MS Excel, I never recomment the use of spreadsheets with Chirp.
On 25/12/2020 13:48 Jim Unroe rock.unroe@gmail.com wrote:
Hi Glen,
On Fri, Dec 25, 2020 at 12:27 PM Glen Terry ACETECH1@cox.net wrote:
Good morning, MERRY CHRISTMAS. In programming my Baofengs, I'm wondering how to convert pre done lists into the chirp to download to the radios.
To expand on Nigel's advice, enter a few known to be working channels into the CHIRP spreadsheet style memory editor. Export these channels to a CSV file. The CSV file saved from CHIRP is now your template for how a CSV file must be formatted to be compatible with CHIRP.
Jim KC9HI _______________________________________________ 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
Nigel A. Gunn, ///shoulders.outwards.resolutions tel +1-937-971-0366 Amateur Radio G8IFF W8IFF and GMRS WRBV701, e-mail nigel@ngunn.net www http://www.ngunn.net _______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Martin Cooper at mfncooper@gmail.com To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com
THANK YOU ALL FOR YOUR INFO. SUCH GREAT HELP. MERRY CHRISTMAS. GLEN
Sent from Mail for Windows 10
From: Jim Unroe Sent: Friday, December 25, 2020 10:50 AM To: Discussion of CHIRP Subject: Re: [chirp_users] Using premade cvs or execl spreadsheet
Hi Glen,
On Fri, Dec 25, 2020 at 12:27 PM Glen Terry ACETECH1@cox.net wrote:
Good morning, MERRY CHRISTMAS. In programming my Baofengs, I'm wondering how to convert pre done lists into the chirp to download to the radios.
To expand on Nigel's advice, enter a few known to be working channels into the CHIRP spreadsheet style memory editor. Export these channels to a CSV file. The CSV file saved from CHIRP is now your template for how a CSV file must be formatted to be compatible with CHIRP.
Jim KC9HI _______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to ACE at acetech1@cox.net To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com
participants (6)
-
benton＠siletzbay.com -
Glen Terry -
GLEN TERRY
-
Jim Unroe -
Martin Cooper -
Nigel A. Gunn G8IFF/W8IFF