We have made the jump to the abbreviated checkin sheet.
The next step is to update the processing software to directly
deal with a marked-up "AS RUN Participant ROLL CSV"
file where a character in column 'F' indicates a checkin.
You may use column "G' to record traffic, if desired.
The other versions are no longer linked from the web page.
link for updates.
        Notes are in RED!
Prerequisites
If you are using the on-line checkin web page, please
try working with it a bit before you run a net.
The web page is primitive, at best, and it is not difficult to
discard your logs with a misplaced click/button-press.
There is no communication between the web server and the logging
entries you are making on the web page. A misplaced refresh or
back space will bring up a fresh copy of the web page from the icarc
server, the result being you loose everything.
You can, at any time, save a local copy of the web page.
That local copy can be brought up in your web browser, but
practice recovering from a misplaced keystroke before the net.
There are two saved files (at least when using the machine hosting the website),
an HTML file with your log entries,
and a GIF file (image file: ICARC_Logo_small.gif).
Send the HTML file to the club email listed above and it will
get posted to the website.
And, now that you're ready, a few minutes prior to the net
call for a signal report to verify your station is working
correctly and you're siglan is clear & strong.
Look at the Participant Roll File Information
section, a bit further down the page, if you're logging on paper and
forwarding a file.
It looks like we can transition to a more abbreviated list at
any time!
Part 1, Introduction
        PLEASE NOTE:
            Do not think with your finger on the PTT key !!!
            If you need time to collect your thoughts RELEASE THE CHANNEL !!!
                Take your finger off ther PTT button !!!
            You may simply give out a "STANDBY" command to indicate you are not releasing control.
            When you hold the channel for extended periods you block EMERGENCY TRAFFIC,
                this is particularly egregious when not talking!
            Participants will patiently wait for you to return.
All stations on frequency this is callsign
calling the Johnson County Sunday Evening Net.
My name is name
and I am located in location.
This net meets every Sunday evening at 7:30 PM. local time
and I will be your ACE or Net Control this evening.
We now meet on the 147.150 machine
which is located on the west side of Iowa City.
Please set your CTCSS access tone to 192.8 Hz for this repeater.
Although this is an informal net, it is a directed net.
We encourage participants to share ham radio news.
Stations with emergency traffic may break in at any time
by using the words “break” or “break emergency”
along with their call sign.
        You may wist to query for emergency traffic
            at this point before we get rolling.
        Poll for club related traffic prior to the roll call.
            (the club president, for example)
Club officers (and "gold" members) are sorted at the top of the checkin list,
this to allow for relaying official club traffic.
We will accept traffic from them shortly.
If there is any other high priority traffic please come now.
        We place the gap for emergency traffic!
Part 2, Upcoming Meeting (only on the Sunday prior to the
meeting)
        Notes:
            If this is the net before the upcoming
            announce it and ask for who is bringing support
            equipment and such.
        IF THE MEETING IS NOT THIS WEDNESDAY, SKIP THIS!
The monthly meeting is this Wednesday at the
First United Methodist Church of North Liberty
located at 85 N. Jones Blvd.
You will find directions in the upcoming meeting
section on the main web page.
David, K0LUM, please report on the status of the Zoom link
when you check in.
Also, whoever plans to bring a computer to host the
meeting, please report your status as you check in.
Part 3, Roll Call
        Notes:
            The participant Roll has phonetic callsigns for your convenience.
            Don't take this as the use phonetics being required!
(I just can't always think that fast:-)
I will now call the roll of those who frequently check in,
starting with the club officers.
Please acknowledge with your call sign and let me know if you have traffic. ACE (or Net control) will typically pick up traffic as you checkin.
ACE (or Net control) will then reopen the net for additional check-ins.
        Notes:
            The link to the roll call web page may be directly edited and saved.
            You may also print a hardcopy to mark-up the old-fashioned way.
            Note the addition of PS and PDF files that are more compact than
            printing the web page.
        Notes:
            IF you choose to split out stations
        with traffic, call them now, or simply skip this.
I will now call on those stations with traffic.
        Notes:
            Call the stations with traffic!
Part 7, Other Local Nets
        Notes:
            I dropped the list here and simply
            include a hyperlink to the
            "Local & HF Nets" page so I
            don't have to try and update this
            page when things change.
            Use the back button to get back here...
Please see the Iowa City Amateur Radio Club web site at
www.icarc.org for additional nets, frequencies, club news,
and announcements.
Part 8, Final Call
        Notes:
Any stations that are still waiting
to check in, please call now.
        Notes:
            You may have additional traffic to
handle here.
Part 9, Upcoming Net Operators
        Notes:
               
Refer to the nets.htm Page to find the
               
operators for next weeks net.
The Primary net control operator for next week is Primary
if the Primary is late/missing,
then the Secondary (Secondary)
is expected to jump in and take over
Failing that our last backup is Tertiary .
Please jump in to start the net if you don't hear it starting as planned,
        passing control over to the Primary should they make it in.
               
If, for example, the Primary would
have radio problems at the start of the net.
The net script can be found in the ICARC website
by clicking on
the red Local & HF Nets button
at the top of all of the web pages.
The participant roll is linked
near the top of the Local & HF Nets page.
Part 10, Net Rundown
        Notes:
This completes the Johnson County Sunday Evening Net.
We had count fast !!! participants
including the ACE (or Net control) and stations checking in via relay.
Wishing you all a good evening and thanks to all who have
participated tonight.
Thanks to the Iowa City Amateur Radio Club for the use of
the WØJV repeater and the WØFDA both of which are maintained
by John K0GH.
We now return the repeater to regular amateur use.
This is callsign closing the
Johnson County Sunday Evening Net,
73 and clear.
Please collect you log of stations that checked in and
forward it through this
link.
This email link is obscured to prevent the harvesting of the
email address.
You may find it convenient to use the link
to discover the address, copy it, and then use it directly.
Please review your submission before sending it off!
It should be a simple list of one callsign per line.
Headers and footers are not needed and shouldn't be in the file!
The Participant ROLL
The Participant ROLL lists those who have checked into the net
and the last time that they called in.
This file is used to produce the HTML page and the printable
log sheets (i.e. the PDF and PS files).
The program that produces these files looks at the current
date and the ACTIVE field in the Participant ROLL
when producing output files.
If the ACTIVE field is more than 60 days old,
the entry is not printed.
The entry need not be removed from the Participant ROLL
file, it is simply not included in the output files.
If someone returns to being active, we don't have to gather
all their information to re-instate them.
The AS RUN Participant ROLL
has the complete list of those that have checked in over
several years (i.e. since Jeff has updated the list).
The list is on the same order as you see in the HTML/PDF/PS files.
There is also an abbreviated roll, with only station names that will work
with the update procedures.
This Abbreviated Participant ROLL
has only the station callsigns.
You can use this list to edit out (i.e. delete lines)
stations that didn't call.
Any stations that weren't on the list can simply be entered
in the file.
Send it to the ICARC mail address and we're all set!
Participant ROLL File Format
A CSV (Comma Seperated Value) file with at least 5 columns.
These first 5 columns need to be kept in this order:
Example:
"YYYY-MON-DD" Year, Month, Day (month name, case insensitive)
       
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
"YY-MON-DD" Year, Month, Day (Month name as above)
"YYYY-MM-DD" Year, Month, Day
"YY-MM-DD" Year, Month, Day (2 digit year is OK)
"YYYY-DDD" Year, Day-of-Year (for us old NASA hags)
"YY-DDD" Year, Day-of-Year (2 digit year is OK)
"0xXXXXXXXX" Unix Time (not for the faint of heart :-)
"0" ZERO, in Unix time this is early 1970,
        so this entry won't show up anymore.
""   Unknown. Will show up on the list
Participant Report from the Sunday Evening Net
To update the participant roll, I only need the station callsign.
A simple text file (i.e. a CSV with a single column) is adequate.
This file is used to update the ACTIVE column in the
roster file (all the other fields are retained).
Example:
KC0JFQ
WB0VZK
If this is a new station, not already buried somewhere in the list,
you may also include the NAME and LOCATION fields, comma
seperated.
These two fields will be inserted into the list.
The ACTIVE date is added to these fields when I run the
update.
Although the update will run some time later, it shouldn't be so far
after the net to cause a problem.
File Naming
The update procedures run on a Linux box and make use of
a default set of filenames.
Please send the update file as an e-mail attachment
with a name of "ICARC_Checkins.csv".
link for updates.
The Participant ROLL Software
Descriptions of running the Net Roll Maintenance programs
The checkin update program
This program takes the Participant Report (this is a simple list of callsigns
that checked in in any order) produced by the
ACE (or Net control) and runs it against the Participant ROLL.
The date field in the Participant ROLL (of the matching callsign)
is updated to the current date
(or the date called out in the -D argument).
Program Help Text:
$ ./roll_update -h
Sunday Evening Net Roster UPDATE (./roll_update) HELP HELP HELP
ROLL_UPDATE_Version V0.06
ROLLLIB_Version V1.0
-D date to log (otherwise uses current date)
-i SundayNet_IN_Roster.csv
-c ICARC_Checkins.csv
-o SundayNet_OUT_Roster.csv
This utility rebuilds the "SundayNet_OUT_Roster.csv" output file
from the "SundayNet_IN_Roster.csv" input file.
Copy the "SundayNets_Roster.csv" file down into a working directory,
run the update (./roll_update) in that working directory.
Finally, copy the "SundayNet_OUT_Roster.csv" file
back up to "SundayNets_Roster.csv"
FILES:
OLD Participant ROLL: "SundayNet_IN_Roster.csv"
Participant Report: "ICARC_Checkins.csv" (from ACE)
NEW Participant ROLL: "SundayNet_OUT_Roster.csv"
Abbreviated Participant ROLL file formed from the
"NEW Participant ROLL" filename.
> #!/usr/bin/bash
> cd ...ICARC
> cd Sunday_Net
> #
> # Copy files to the working directory
> #
> cp ../SundayNets_Roster.csv SundayNet_IN_Roster.csv
> cp ../ICARC_Checkins.csv .
> #
> # Process the update
> #
> ./roll_update
> #
> # Rename last weeks list (i.e. do NOT delete it!)
> #
> mv ../SundayNets_Roster.csv ../Roster_yyyy_mm_dd.csv
> mv ../ICARC_Checkins.csv ../Checkins_yyyy_mm_dd.csv
> #
> # Verify that the "SundayNet_OUT_Roster.csv" file is correct...
> # and the copy it back up
> #
> cp SundayNet_OUT_Roster.csv ../SundayNets_Roster.csv
> cd ..
> ./mail_list.bash
The list update program
This program takes the new Participant ROLL and recreates
all of the web pages and the printable log sheets.
Taking a look at the Sample Output from running the roll: below,
you will notice that the Participant ROLL is sorted prior to use,
keeping the callsigns in order.
Program Help Text:
$ ./roll -h
Sunday Evening Net Roster (./roll) HELP HELP HELP
ROLL_Version V1.19
ROLLPS_Version V1.3
ROLLLIB_Version V1.0
This updates the web pages, PDF, PS, and HTML
with the latest roster.
Input Files:
Input File: SundayNets_Roster.csv
Output Files:
Ordered File: Sunday_As_Run.csv
Abbreviated File: Sunday_As_Run_abb.csv
UNsorted File: rollus.csv
Sorted 1 File: rolls1.csv
Sorted 2 File: rolls2.csv
Sorted FFA File: rollffa.csv
UNsorted HTML File: rollus.html
Sorted 1 HTML File: rolls1.html
Sorted 2 HTML File: rolls2.html
Sorted FFA HTML File: rollffa.html
-H and -h this HELP file.
-C Club Name (top of pages)
-c Club Initials (top of pages)
-P Produced by (bottom of page)
-t Inactivity timeout (60.0 days)
-q remove output
Sample Output from running the roll-update:
This updates the roll CSV files
Notice the filenames get twiddled to hold the date
the net was run.