[amsat-bb] SATpc32 -- doppler.sqf Editor

Mon Apr 13 23:04:42 UTC 2020

Replied directly to Mike and John with my first response, copying to the list now.

Straight CSV format doesn't provide support for comments, and while it's probably not terribly complex to add support for them to a parser, there are other ways to do the job.

For example, import the CSV file into Excel (or your spreadsheet manipulation program of choice). Add a column "Status" and for each line, mark whether they are active or inactive. Save it as a proper Excel workbook (.xlsx).

Then, create a new worksheet in the same workbook (new tab down at the bottom). With a little bit of Excel-fu, you can have that worksheet display only those rows from the original worksheet that have "Active" in the Status field you just added. You can simply then save that worksheet as CSV to create your new working CSV file, but still have all of those original entries backed up and archived.

--
Devin L. Ganger (WA7DLG)
email: devin at thecabal.org
web: Devin on Earth
cell: +1 425.239.2575

> -----Original Message-----
> From: AMSAT-BB <amsat-bb-bounces at amsat.org> On Behalf Of John Brier
> via AMSAT-BB
> Sent: Monday, April 13, 2020 3:56 PM
> To: Mike Diehl <diehl.mike.a at gmail.com>
> Cc: AMSAT BB <amsat-bb at amsat.org>
> Subject: Re: [amsat-bb] SATpc32 -- doppler.sqf Editor
> 
> I should have been more specific about what I meant when I used the word
> sections.
> 
> Add a comment somewhere in the file that says something like "the sats
> below are dead." In that way you create sections using comments as headers.
> 
> At the very least you could say satellites that have re-entered the atmosphere
> are dead.
> 
> That said, yes, it is not hard to edit the files as you prefer.
> 
> One advantage to having the default files list sats in different sections would
> be that all the people who prefer that don't have to do the same change
> themselves on new installs.
> 
> It could also be helpful to new satops who might not know what sats are alive
> or dead.
> 
> 73, John Brier KG4AKV
> 
> 
> On Mon, Apr 13, 2020, 17:31 Mike Diehl <diehl.mike.a at gmail.com> wrote:
> 
> > As far as I’m aware there are no “sections” of the file, it is simply
> > just a CSV with a different file extension. There is no way to
> > differentiate between alive and dead. And speaking of dead, it’s dead
> > simple to edit the file. With so many different opinions, like
> > everything else, on how it should be done it’s easier if people just
> > generate what fits their need. A satellite no longer is relevant to
> > you, delete the line. Something new in orbit, add a line. We have the
> > technology https://www.amsat.org/doppler-sqf-line-generator/
> >
> > 73,
> > Mike Diehl
> > W8LID/VE6LID
> >
> > On Apr 13, 2020, at 16:41, John Brier via AMSAT-BB
> > <amsat-bb at amsat.org>
> > wrote:
> >
> > I would prefer them to stay as it is a good reference for historical
> > reasons.
> >
> > Maybe put dead ones all at the bottom of the file or under a different
> > section of the file.
> >
> > 73, John Brier KG4AKV
> >
> > On Mon, Apr 13, 2020, 16:24 Jim Walls via AMSAT-BB
> > <amsat-bb at amsat.org>
> > wrote:
> >
> > On 04/13/2020 12:43, Thomas Schaefer via AMSAT-BB wrote:
> >
> > A related question…Is there some reason we need to carry old, no
> > longer
> >
> > in-use, satellites in these files? The
> >
> > Doppler.sql file is full of satellites one cannot possibly use anymore.
> >
> > Same question about the lists in general. Can one filter the lists so
> >
> > adding AO-51 for example to tracking is never even an option —as in
> > one
> >
> > never even sees it.
> >
> >
> > Well, for one thing, dead satellites sometimes come back from the dead.
> >
> > AO-7 comes to mind - and yes, I was on the first US pass after it was
> >
> > confirmed to be alive after 21 years of silence.
> >
> >
> > --
> >
> > 73
> >
> > -------------------------------------
> >
> > Jim Walls - K6CCC
> >
> > jim at k6ccc.org
> >
> > Ofc:  818-548-4804
> >
> > http://members.dslextreme.com/users/k6ccc/
> >
> > AMSAT Member 32537 - WSWSS Member 395
> >
> >
> > _______________________________________________
> >
> > Sent via AMSAT-BB at amsat.org. AMSAT-NA makes this open forum
> available
> >
> > to all interested persons worldwide without requiring membership.
> > Opinions
> >
> > expressed
> >
> > are solely those of the author, and do not reflect the official views
> > of
> >
> > AMSAT-NA.
> >
> > Not an AMSAT-NA member? Join now to support the amateur satellite
> program!
> >
> > Subscription settings: https://www.amsat.org/mailman/listinfo/amsat-bb
> >
> >
> > _______________________________________________
> > Sent via AMSAT-BB at amsat.org. AMSAT-NA makes this open forum
> available
> > to all interested persons worldwide without requiring membership.
> > Opinions expressed are solely those of the author, and do not reflect
> > the official views of AMSAT-NA.
> > Not an AMSAT-NA member? Join now to support the amateur satellite
> program!
> > Subscription settings: https://www.amsat.org/mailman/listinfo/amsat-bb
> >
> >
> _______________________________________________
> Sent via AMSAT-BB at amsat.org. AMSAT-NA makes this open forum available
> to all interested persons worldwide without requiring membership. Opinions
> expressed are solely those of the author, and do not reflect the official views
> of AMSAT-NA.
> Not an AMSAT-NA member? Join now to support the amateur satellite
> program!
> Subscription settings: https://www.amsat.org/mailman/listinfo/amsat-bb