Re: [chirp_users] programming assistance
Not sure in what way Excel is not compatible with chirp? I am using it as I develop and share a list of Emergency Op Ctr channels. The initial pass consisted of reading from a IC-2100H (most of the local EOCs are using this), saving both img and csv, editing the csv in Excel, and using the results to upload to the 2100. I didn't have a problem...maybe the error is radio-dependent? I think I have asked this before, and I need to develop a process for others in the area to follow, so I am curious about this.
73 Rich NE1EE The Dusty Key On the banks of the Piscataqua
On 2024-01-09 20:21:, D.J.J. Ring, Jr. wrote:
csv files are just spreadsheet files - you can edit them with LibreOffice (don't use Excel as it's not compatible� with CHIRP).
Excel is not compatible because it tends to put spurious characters into empty cells.
On 10/01/2024 12:09 GMT Rich NE1EE thedustykey@imaginarian.org wrote:
Not sure in what way Excel is not compatible with chirp? I am using it as I develop and share a list of Emergency Op Ctr channels. The initial pass consisted of reading from a IC-2100H (most of the local EOCs are using this), saving both img and csv, editing the csv in Excel, and using the results to upload to the 2100. I didn't have a problem...maybe the error is radio-dependent? I think I have asked this before, and I need to develop a process for others in the area to follow, so I am curious about this.
73 Rich NE1EE The Dusty Key On the banks of the Piscataqua
On 2024-01-09 20:21:, D.J.J. Ring, Jr. wrote:
csv files are just spreadsheet files - you can edit them with LibreOffice (don't use Excel as it's not compatible� with CHIRP).
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 To report this email as off-topic, please email chirp_users-owner@intrepid.danplanet.com Searchable archive: https://www.mail-archive.com/chirp_users@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
On 2024-01-10 07:44:, Nigel A. Gunn G8IFF/W8IFF wrote:
Excel is not compatible because it tends to put spurious characters into empty cells. > On 10/01/2024 12:09 GMT Rich NE1EE thedustykey@imaginarian.org wrote: > > > Not sure in what way Excel is not compatible with chirp?
I have not run into this ever, and I have been using Excel for decades. Is this something specific to chirp files? csv files, which I don't use as often, but when ever I have, I have not see spurious chars when I edit the csv files as plain text in EditPad Pro...please clarify?
73 Rich NE1EE The Dusty Key On the banks of the Piscataqua
Good morning Rich, Excel contains Formatting data where a CVS file is raw data.
Stay safe and healthy. John
On Jan 10, 2024, at 7:09 AM, Rich NE1EE TheDustyKey@imaginarian.org wrote:
Not sure in what way Excel is not compatible with chirp? I am using it as I develop and share a list of Emergency Op Ctr channels. The initial pass consisted of reading from a IC-2100H (most of the local EOCs are using this), saving both img and csv, editing the csv in Excel, and using the results to upload to the 2100. I didn't have a problem...maybe the error is radio-dependent? I think I have asked this before, and I need to develop a process for others in the area to follow, so I am curious about this.
73 Rich NE1EE The Dusty Key On the banks of the Piscataqua
On 2024-01-09 20:21:, D.J.J. Ring, Jr. wrote: csv files are just spreadsheet files - you can edit them with LibreOffice (don't use Excel as it's not compatible with CHIRP).
chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to John LaMartina at johnla@usa.net To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com To report this email as off-topic, please email chirp_users-owner@intrepid.danplanet.com Searchable archive: https://www.mail-archive.com/chirp_users@intrepid.danplanet.com
On 2024-01-10 08:12:, John LaMartina wrote:
Good morning Rich, Excel contains Formatting data where a CVS file is raw data. Stay safe and healthy. John
Got that. Thanks, John. But that is the whole reason for using csv files, yes? chirp won't import /any/ native spreadsheet? I need to switch to my ham laptop and go through my steps and document them here...but see my reply to Jim Unroe coming up.
73 Rich NE1EE The Dusty Key On the banks of the Piscataqua
On Wed, Jan 10, 2024 at 7:10 AM Rich NE1EE TheDustyKey@imaginarian.org wrote:
Not sure in what way Excel is not compatible with chirp? I am using it as I develop and share a list of Emergency Op Ctr channels. The initial pass consisted of reading from a IC-2100H (most of the local EOCs are using this), saving both img and csv, editing the csv in Excel, and using the results to upload to the 2100. I didn't have a problem...maybe the error is radio-dependent? I think I have asked this before, and I need to develop a process for others in the area to follow, so I am curious about this.
73 Rich NE1EE The Dusty Key On the banks of the Piscataqua
On 2024-01-09 20:21:, D.J.J. Ring, Jr. wrote:
csv files are just spreadsheet files - you can edit them with LibreOffice (don't use Excel as it's not compatible with CHIRP).
CHIRP CSV files often have multiple trailing commas at the end of each line due to the URXALL, RPT1CALL, RPT2CALL and DVCODE fields rarely being used.
Power,Comment,URCALL,RPT1CALL,RPT2CALL,DVCODE 5.00,,Low,,,,,
Excel is known to remove multiple trailing commas at the end of a line. When CHIRP reads the CSV file where the trailing commas have been removed, the trailing data will be read into the wrong fields.
Excel always works fine if there is alway something in the last field of each line. I've read that there is a setting that you can enable in excel that tells it to leave trailing commas alone. I don't have excel so I can't verify this.
Perhaps it would be possible to have CHIRP always resync with the beginning of the CSV file's next line when a linefeed is encountered?
Jim KC9HI
participants (4)
-
Jim Unroe -
John LaMartina -
Nigel A. Gunn G8IFF/W8IFF -
Rich NE1EE