Dave,

I'm not a Windows user. I'm on a Mac running OS X, a BSD-derived OS with a bash shell. In my case, I was concatenating a distance column with the comment field, pulling columns from two CSV files, with one being a 'CHIRP-spec’ CSV file. So a spreadsheet made sense, not only for the operation, but also for printing the resultant "channel" list.

based on the unhelpful response I got to my last query

Would it be fair to conclude that requests for new features like a built-in print capability and a save/upload sorted capability are unlikely to be implemented?

From your other post:

Obviously…

You're kidding right? Have you actually tried this ... with 28 channels? That is even more tedious than hand sorting 3x5 index cards

Try to keep in mind that CHIRP is an open source project being created by volunteers and provided to us at no cost. And the people taking the time to answer your questions are trying to help you, again without any remuneration.

Regards, Fred KM4QLB

Sent from my iPad

On Mar 22, 2016, at 8:07 PM, Knight, Dave <diemkae@gmail.com mailto:diemkae@gmail.com> wrote:

I thought as much, based on the unhelpful response I got to my last query: "how can I print the entire list of entries" ... "Nope, can't do that. Just do a screen print." Which is just a pain, I suppose, unless you've got more than one screen of entries, then it's a ROYAL PITA!

Regarding save/upload of re-sorted rows, I devised a similar "creative workaround":

1 - export the .img to a .csv 2 - sort by frequency & renumber the rows wit a simple shell script (attached) and save the output in another .csv file 3 - import the new .csv file

To sort by a column other then frequency (column number 3), replace the 3s in -kn3,3 in the sort command with the column number by which you want to sort. This may be easier for Linux users that the spreadsheet approach. It would also work in a CYGWIN terminal under windows.

Would it be fair to conclude that requests for new features like a built-in print capability and a save/upload sorted capability are unlikely to be implemented?

Thanks, Dave Knight, K2COE

On Tue, Mar 22, 2016 at 7:18 PM, Fred Maxwell <_chirp@mail2fm.com mailto:_chirp@mail2fm.com> wrote: Dave,

I ran into the same problem and I don’t believe that a solution exists yet. There is not a way to sort everything but the memory location numbers, which I believe is what is needed. So you can sort them for display in any way you like (frequency, name, mode, etc.), but the memory location number for each entry will remain the same.

The only way that I was able to work around that was to created a spreadsheet, do the sorting from that, and then export a .csv file. In my case, I wanted the repeaters sorted by order of distance from my home, so lower memory location numbers mean closer repeaters.

Regards, Fred KM4QLB

...

On Mar 22, 2016, at 7:04 PM, Knight, Dave <diemkae@gmail.com mailto:diemkae@gmail.com> wrote:

After clicking on a column heading to sort the chirp entries, the new sort order is lost on upload or save.

Please advise how I can save/upload sorted rows.

---

chirp_users mailing list chirp_users@intrepid.danplanet.com mailto:chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Fred at _chirp@mail2fm.com mailto:chirp@mail2fm.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 mailto:chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Dave Knight at diemkae@gmail.com mailto:diemkae@gmail.com To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com mailto:chirp_users-unsubscribe@intrepid.danplanet.com

<sortBaofeng> _______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com <mailto:chirp_users@intrepid.danplanet.com> http://intrepid.danplanet.com/mailman/listinfo/chirp_users <http://intrepid.danplanet.com/mailman/listinfo/chirp_users> This message was sent to Fred at _chirp@mail2fm.com <mailto:chirp@mail2fm.com> To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com <mailto:chirp_users-unsubscribe@intrepid.danplanet.com>

Can't you print by exporting a csv to Excel and print that? Jardy Dawson WA7JRD Ham Radio

Sent by hurling dead pigeons over the wall by trebuchet.

From: "Knight, Dave" diemkae@gmail.com To: Discussion of CHIRP chirp_users@intrepid.danplanet.com Sent: Tuesday, March 22, 2016 5:07 PM Subject: Re: [chirp_users] How to save/upload after sorting the CHIRP rows?

I thought as much, based on the unhelpful response I got to my last query: "how can I print the entire list of entries" ... "Nope, can't do that.  Just do a screen print."  Which is just a pain, I suppose, unless you've got more than one screen of entries, then it's a ROYAL PITA!

Regarding save/upload of re-sorted rows, I devised a similar "creative workaround":

1 - export the .img to a .csv    2 - sort by frequency & renumber the rows wit a simple shell script (attached) and save the output in another .csv file    3 - import the new .csv file

To sort by a column other then frequency (column number 3), replace the 3s in -kn3,3 in the sort command with the column number by which you want to sort.  This may be easier for Linux users that the spreadsheet approach.  It would also work in a CYGWIN terminal under windows.

Would it be fair to conclude that requests for new features like a built-in print capability and a save/upload sorted capability are unlikely to be implemented?   Thanks, Dave Knight, K2COE

On Tue, Mar 22, 2016 at 7:18 PM, Fred Maxwell _chirp@mail2fm.com wrote:

Dave,

I ran into the same problem and I don’t believe that a solution exists yet.  There is not a way to sort everything but the memory location numbers, which I believe is what is needed.  So you can sort them for display in any way you like (frequency, name, mode, etc.), but the memory location number for each entry will remain the same.

The only way that I was able to work around that was to created a spreadsheet, do the sorting from that, and then export a .csv file.  In my case, I wanted the repeaters sorted by order of distance from my home, so lower memory location numbers mean closer repeaters.

Regards,   Fred   KM4QLB

On Mar 22, 2016, at 7:04 PM, Knight, Dave diemkae@gmail.com wrote:

After clicking on a column heading to sort the chirp entries, the new sort order is lost on upload or save.

Please advise how I can save/upload sorted rows.

---

chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Fred at _chirp@mail2fm.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 Dave Knight at diemkae@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 Jardy at jardy72@yahoo.com To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com

On Tue, Mar 22, 2016 at 8:27 PM, John LaMartina JohnLa@usa.net wrote:

Sorting by column only impacts the way the data is viewed on your screen. This is used to help visually identify duplicates, missing channels, etc. The channel number to the left follows the entry.

Obviously...

An option to renumber the channel column would solve this problem.

The actually change the positioning, you will need to left click on a channel and walk it up or down the data sheet.

You're kidding right? Have you actually tried this ... with 28 channels? That is even more tedious than hand sorting 3x5 index cards ;-)

Thanks, but I'll stick with my export/sort+renumber script/import approach for now.

Dave

John http://www.miklor.com

*From:* chirp_users-bounces@intrepid.danplanet.com [mailto: chirp_users-bounces@intrepid.danplanet.com] *On Behalf Of *Knight, Dave *Sent:* Tuesday, March 22, 2016 7:05 PM *To:* chirp_users@intrepid.danplanet.com *Subject:* [chirp_users] How to save/upload after sorting the CHIRP rows?

After clicking on a column heading to sort the chirp entries, the new sort order is lost on upload or save.

Please advise how I can save/upload sorted rows.

---

chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Dave Knight at diemkae@gmail.com To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com

On Mar 23, 2016, at 6:09 AM, Jim Unroe rock.unroe@gmail.com wrote:

On Tue, Mar 22, 2016 at 7:04 PM, Knight, Dave diemkae@gmail.com wrote:

...

After clicking on a column heading to sort the chirp entries, the new sort order is lost on upload or save.

Please advise how I can save/upload sorted rows.

Which column are you sorting by? What would be the reason that you what the channel rows not to be in the same order that they are in the radio?

What I believe that Dave wants is the ability to lock the memory location column order and sort everything else so as to reorder how the channels that will be programmed into the radio. I’ll join in saying that would be a good feature.

A user with dozens of repeaters might want them to be programmed into the radio sorted by repeater Name for easy location (clockwise rotation of the ‘channel' knob steps through alphabetically). Or someone with a dual-band, or tri-band radio might want them sorted by frequency so that the bands are separated into memory blocks. Or someone might want to group all of the entries by Duplex to separate out repeaters from simplex frequencies.

In my case, I sort by distance from my home — the higher the memory location number, the further from my home base station (and CHIRP does not support RepeaterBook queries by proximity; issue 3261). That forces me into a tedious off-line process involving two RepeaterBook queries, one in CHIRP format CSV and one in native RepeaterBook CSV, and then going through contortions in a spreadsheet. I won’t go into detail and turn this into a threadjacking, but it’s another example of how one might want to sort.

Hope that was of some assistance in explaining what was wanted. (Dave, if I screwed anything up, please let me know.)

Regards, Fred KM4QLB

On Mar 23, 2016, at 8:47 AM, Jim Unroe rock.unroe@gmail.com wrote:

I can't think of a good reason why you would would CHIRP to come up in any order other then the order that the channels are in the radio.

It’s not a matter of wanting it to come up in some other order. It’s wanting to be able to use CHIRP’s sorting features to let you re-order entries prior to programming the radio.

What I believe that you are wanting is to put the sorted order in the channel order and that is very easy to do.

Download from the radio (or load a saved image file) twice.

Or load two copies of a new CSV file that’s never been used to program a radio, I assume.

...

A user with dozens of repeaters might want them to be programmed into the radio sorted by repeater Name for easy location (clockwise rotation of the ‘channel' knob steps through alphabetically).

Click the Name header of the first tab to sort the column by Name. Click the first memory row with a name to highlight it. Shift-click the last memory row with a name to highlight the rest Right-click any highlighted memory row and choose Copy Right-click the first memory row in the second tab and choose Paste

So the location, although highlighted, doesn’t get copied. I did not know that and I’m sure that others did not either.

Thank you. That was very helpful.

Regards, Fred KM4QLB

On Mar 23, 2016, at 9:09 AM, Jim Unroe rock.unroe@gmail.com wrote:

...

...

Download from the radio (or load a saved image file) twice.

Or load two copies of a new CSV file that’s never been used to program a radio, I assume.

No. You can't program a Baofeng radios with a CSV. You have to Download from the radio (or load a saved image file) twice. And then import the CSV twice.

Sorry, but I have to disagree.

I work on CSV files that I paste into blank image files I keep for my two UV-82HP handhelds and my Yaesu FT-2900R mobile. My Kenwood TM-281A mobile only operates in “Live mode” so I just paste to that tab when operating in live mode. That allows me to easily keep the radios in sync such that, for example, memory 35 is the same repeater on all of them.

Just to verify in my own mind that I was not having a “senior moment,” I did a test. I just went to the RepeaterBook website and did a query (all 2m repeaters in VA), exporting the results to a CHIRP CSV file. I started CHIRP. I opened the CSV file twice (two tabs). I sorted by Name in one of the tabs. I copied and pasted the sorted one to the other. Sorting stuck (thanks to your tip). I saved that file. I then brought up my BaoFeng image file and pasted from the CSV into that. Worked great. Now I have a CSV file I can copy from and paste into each of my radios, either through the image feature or through live mode. Had I operated on the BaoFeng image and tried to paste that to my Kenwood or Yaesu, I’d have lost all of the comments that I retained by working with the CSV files.

Regards, Fred KM4QLB

...

Sorry, but I have to disagree.

You can't upload a CSV into a Baofeng radio and you proved it below.

Yeah, I can say, without a doubt, that you cannot upload a CSV file into a radio directly (any radio). BUT, see below:

...

I just went to the RepeaterBook website and did a query (all 2m repeaters in VA), exporting the results to a CHIRP CSV file. I started CHIRP. I opened the CSV file twice (two tabs). I sorted by Name in one of the tabs. I copied and pasted the sorted one to the other. Sorting stuck (thanks to your tip). I saved that file. I then brought up my BaoFeng image file and pasted from the CSV into that.

Right here ^^^^. You brought up a Faofeng image because you cannot directly program a Baofeng with a CSV file. You must have a compatible image loaded in CHIRP and then import the CSV into it. Then you can upload the image into your radio. And that is what I said.

I think this is just a matter of terminology.

Jim is correct: you cannot upload a CSV file into a radio.

Fred is correct: you can get the contents of a CSV file into a radio.

At the low level, you're always pulling images from the radio and pushing images back in. CHIRP won't do the merge for you live, you have to ask it to push an image. That's what Fred's last step is doing, but he's merging the CSV contents in with his paste before he uploads an image (not a CSV file) into the radio.

--Dan

Now that's what I'm talkin' about!

How can I specify a primary sort by name and a 2ndary sort by frequency?

On Wed, Mar 23, 2016 at 11:38 AM, Jim Unroe rock.unroe@gmail.com wrote:

You don't need a shell script or a CSV file to sort the channels by frequency.

1 I load my "master" CHIRP image for my UV-82 2 I then erase all 128 channels 2.1 click a channel row to highlight it 2.2 press Ctrl-A to highlight them all 2.3 press Delete 3. Import my "master" CHIRP image 3.1 click File 3.2 click Import 3.3 change the file mask to CHIRP Radio Images (*.img) 3.4 choose and open the same image as before 3.5 click the "Frequency" header to sort by frequency 3.6 click [Auto] to renumber the "To" column 3.7 click OK 3.8 upload to radio

Jim KC9HI _______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Dave Knight at diemkae@gmail.com To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com

That is rather clever! Thanks.

For my Baofeng radio, as noted in another response, it is necessary to open a writeable, downloaded .img file in the 2nd tab. Otherwise, the only save[as] option is to a .csv file.

The only advantage then of my sort script is that one can specify multiple sort keys, e.g. "-k 2,2 -k 3n,3" to sort primarily by name (column 2) and secondarily by frequency (column 3).

On Wed, Mar 23, 2016 at 8:47 AM, Jim Unroe rock.unroe@gmail.com wrote:

I can't think of a good reason why you would would CHIRP to come up in any order other then the order that the channels are in the radio. What I believe that you are wanting is to put the sorted order in the channel order and that is very easy to do.

Download from the radio (or load a saved image file) twice.

...

A user with dozens of repeaters might want them to be programmed into

the radio sorted by repeater Name for easy location (clockwise rotation of the ‘channel' knob steps through alphabetically).

Click the Name header of the first tab to sort the column by Name. Click the first memory row with a name to highlight it. Shift-click the last memory row with a name to highlight the rest Right-click any highlighted memory row and choose Copy Right-click the first memory row in the second tab and choose Paste

...

Or someone with a dual-band, or tri-band radio might want them sorted by

frequency so that the bands are separated into memory blocks.

Repeat the above sorted by the Frequency column

...

Or someone might want to group all of the entries by Duplex to separate

out repeaters from simplex frequencies.

Repeat the above sorted by the Duplex column

Jim KC9HI _______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Dave Knight at diemkae@gmail.com To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com

I may be missing the point Dave, why can't you open foo.csv in Libreoffice calc, sort by column 3, the frequency column. Move the header back to the top? Easier than trying to understand a Script.

Ken

On 03/23/2016 08:23 AM, Knight, Dave wrote:

My point exactly, thanks!

There are many good reasons to sort channels.

Periodically, I download the channels to CHIRP for editing (it's easier than on the HT) sorting** and printing, then upload the reorganized channels to the HT.

FWIW, I wrote the following (bash shell script) to sort CHIRP-exported .csv files by repeater frequency:

#!/bin/bash # # sortBaofeng - sorts chirp .csv file by frequency (field 3) and renumbers # the lines (filed 1) for import. # # FWIW, by clicking on the column name, CHIRP sorts the rows by that column, # but does not renumber the rows. # if [ "x$1" = "x" ] then echo "Usage: $0 <chirp_csv_filename>" echo " Sorts rows by frequency and renumbers them for CHIRP import." echo " The sorted and renumbered lines are written to stdout." exit 1 fi

IFN=$1 sort --field-separator=, -k3n,3 < $IFN | gawk -F, ' BEGIN{OFS=","} $1 != "Location"{$1 = ++n} {print $0 }'

and use it thus:

1 - download radio channels to CHIRP 2 - edit to add/remove channels as necessary 3 - export to foo.csv 4 - run the script (sortByFreq) on the .csv file:

     sortByFreq  foo.csv  > new.csv

5 - print new.csv 6 - import new.csv into CHIRP 7 - upload channels to radio

To modify the script to sort by another column, change the "3"s in the key (-kn3,3) to the number of the .csv column you want.

Steps 3 - 6 of this convoluted, external-to-chirp process would be obviated if CHIRP supported options to print, save and upload the channels after sorting.

Until then, I hope the above script & process might be useful to other CHIRP users.

On Wed, Mar 23, 2016 at 7:52 AM, Fred Maxwell <_chirp@mail2fm.com mailto:_chirp@mail2fm.com> wrote:

> On Mar 23, 2016, at 6:09 AM, Jim Unroe <rock.unroe@gmail.com <mailto:rock.unroe@gmail.com>> wrote:
>
> On Tue, Mar 22, 2016 at 7:04 PM, Knight, Dave <diemkae@gmail.com
<mailto:diemkae@gmail.com>> wrote:
>> After clicking on a column heading to sort the chirp entries,
the new sort
>> order is lost on upload or save.
>>
>> Please advise how I can save/upload sorted rows.
>
> Which column are you sorting by? What would be the reason that you
> what the channel rows not to be in the same order that they are
in the
> radio?
>

What I believe that Dave wants is the ability to lock the memory
location column order and sort everything else so as to reorder
how the channels that  will be programmed into the radio. I’ll
join in saying that would be a good feature.

A user with dozens of repeaters might want them to be programmed
into the radio sorted by repeater Name for easy location
(clockwise rotation of the ‘channel' knob steps through
alphabetically).  Or someone with a dual-band, or tri-band radio
might want them sorted by frequency so that the bands are
separated into memory blocks.  Or someone might want to group all
of the entries by Duplex to separate out repeaters from simplex
frequencies.

In my case, I sort by distance from my home — the higher the
memory location number, the further from my home base station (and
CHIRP does not support RepeaterBook queries by proximity; issue
3261).  That forces me into a tedious off-line process involving
two RepeaterBook queries, one in CHIRP format CSV and one in
native RepeaterBook CSV, and then going through contortions in a
spreadsheet.  I won’t go into detail and turn this into a
threadjacking, but it’s another example of how one might want to sort.

Hope that was of some assistance in explaining what was wanted. 
(Dave, if I screwed anything up, please let me know.)

Regards,
  Fred
  KM4QLB
_______________________________________________
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 Dave Knight at diemkae@gmail.com
<mailto:diemkae@gmail.com>
To unsubscribe, send an email to
chirp_users-unsubscribe@intrepid.danplanet.com
<mailto:chirp_users-unsubscribe@intrepid.danplanet.com>

-- The "Safe in Church" deception: believing that calling some building a "sanctuary" will magically deter criminal violence is a dangerous delusion!

The "Gun-Free Zone" deception: believing that a "No Guns" policy or sign will deter criminal violence is "magical thinking" in its most dangerous form!

In your time of need, may your piece be with you!

---

chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Ken at ken@wa0sbu.com To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com