2021-03-20 20:15:07 -07:00
|
|
|
#
|
|
|
|
|
# This script generates a weekly report from our DMR Net Check-In data.
|
|
|
|
|
#
|
|
|
|
|
#
|
|
|
|
|
|
|
|
|
|
import pandas as pd
|
|
|
|
|
#import odf
|
|
|
|
|
import os
|
|
|
|
|
import sys
|
|
|
|
|
#import logzero
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
# setup output parameters for jupyter interactive execution
|
|
|
|
|
# Use 3 decimal places in output display
|
|
|
|
|
pd.set_option("display.precision", 0)
|
|
|
|
|
|
|
|
|
|
# Don't wrap repr(DataFrame) across additional lines
|
|
|
|
|
pd.set_option("display.expand_frame_repr", False)
|
|
|
|
|
|
|
|
|
|
# Set max rows displayed in output to 25
|
|
|
|
|
pd.set_option("display.max_rows", 150)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
# point to our various input files - adjust this to your environment
|
2026-01-18 20:45:07 -08:00
|
|
|
data_dir = '/home/syncthing/ham-radio/ARES-RACES/Nets--PNW_ARES_DMR_Weekly_Net'
|
2021-03-20 20:15:07 -07:00
|
|
|
filename = 'Check_In_Data.xlsx'
|
|
|
|
|
data_file = os.path.join(data_dir, filename)
|
|
|
|
|
output_file = os.path.join(data_dir, "PNW_Digital_ARES_EMCOMM_Weekly_Net_Check_In_Form.txt")
|
|
|
|
|
|
|
|
|
|
# Our check-in form as a dictionary
|
|
|
|
|
blank_checkin_form_dict = {
|
2024-10-02 15:09:38 -07:00
|
|
|
'MT': { '*':{'Missoula':[]}
|
|
|
|
|
},
|
2021-03-20 20:15:07 -07:00
|
|
|
'ID': { '1':{'Boundary':[],'Bonner':[],'Kootenai':[],'Benewah':[],'Shoshone':[]},
|
|
|
|
|
'2':{'Latah':[],'Nez Pierce':[],'Lewis':[],'Clearwater':[],'Idaho':[]},
|
|
|
|
|
'3':{'Adams':[],'Washington':[],'Payette':[],'Gem':[],'Canyon':[],'Ada':[],
|
|
|
|
|
'Owyhee':[],'Valley':[],'Boise':[],'Elmore':[]},
|
|
|
|
|
'4':{'Camas':[],'Blaine':[],'Gooding':[],'Lincoln':[],'Jerome':[],'Twin Falls':[],
|
|
|
|
|
'Minidoka':[],'Cassia':[]},
|
|
|
|
|
'5':{'Bingham':[],'Power':[],'Bannock':[],'Oneida':[],'Franklin':[],
|
|
|
|
|
'Bear Lake':[],'Caribou':[]},
|
|
|
|
|
'6':{'Lemhi':[],'Custer':[],'Butte':[],'Clark':[],'Jefferson':[],'Fremont':[],
|
|
|
|
|
'Madison':[],'Teton':[],'Bonneville':[]}
|
|
|
|
|
},
|
|
|
|
|
'OR': { '1':{'Clatsop':[],'Columbia':[],'Tillamook':[],'Washington':[],'Multnomah':[],
|
|
|
|
|
'Clackamas':[]},
|
|
|
|
|
'2':{'Hood River':[],'Wasco':[],'Sherman':[],'Jefferson':[],'Deschutes':[],
|
|
|
|
|
'Crook':[]},
|
|
|
|
|
'3':{'Gilliam':[],'Wheeler':[],'Morrow':[],'Umatilla':[],'Union':[],
|
|
|
|
|
'Wallowa':[]},
|
|
|
|
|
'4':{'Yamhill':[],'Polk':[],'Lincoln':[],'Benton':[],'Marion':[],
|
|
|
|
|
'Linn':[],'Lane':[]},
|
|
|
|
|
'5':{'Douglas':[],'Coos':[],'Curry':[],'Josephine':[],
|
|
|
|
|
'Jackson':[]},
|
|
|
|
|
'6':{'Klamath':[],'Lake':[],'Harney':[],'Grant':[],'Baker':[],
|
|
|
|
|
'Malheur':[]}
|
|
|
|
|
},
|
|
|
|
|
'WA': { '1':{'Island':[], 'San Juan':[], 'Skagit':[], 'Snohomish':[], 'Whatcom':[], 'unknown':[]},
|
|
|
|
|
'2':{'Clallam':[],'Jefferson':[],'Kitsap':[], 'unknown':[]},
|
|
|
|
|
'3':{'Grays Harbor':[],'Lewis':[],'Mason':[],'Pacific':[],'Thurston':[]},
|
|
|
|
|
'4':{'Clark':[],'Cowlitz':[],'Skamania':[],'Wahkiakum':[]},
|
2021-06-06 16:37:31 -07:00
|
|
|
'5':{'Pierce':[]},
|
2021-03-20 20:15:07 -07:00
|
|
|
'6':{'King':[]},
|
|
|
|
|
'7':{'Chelan':[],'Douglas':[],'Grant':[],'Kittitas':[],'Okanogan':[]},
|
|
|
|
|
'8':{'Benton':[],'Franklin':[],'Klickitat':[],'Walla Walla':[],'Yakima':[]},
|
|
|
|
|
'9':{'Adams':[],'Asotin':[],'Columbia':[],'Ferry':[],'Garfield':[],'Lincoln':[],
|
|
|
|
|
'Pend Orielle':[],'Spokane':[],'Stevens':[],'Whitman':[]},
|
|
|
|
|
'State EMD':{'none':[]}
|
|
|
|
|
},
|
|
|
|
|
'Philippines': { '-':{'-':[]}
|
|
|
|
|
},
|
2024-04-28 20:09:43 -07:00
|
|
|
'Canada': {'-':{'-':[]}
|
2021-03-20 20:15:07 -07:00
|
|
|
},
|
|
|
|
|
'Visitor' : { '-':{'-':[]}
|
|
|
|
|
}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
# create dataframes from input file
|
|
|
|
|
print("Reading input file from: ")
|
|
|
|
|
print(" ", data_file)
|
2021-06-06 16:37:31 -07:00
|
|
|
xls = pd.ExcelFile(data_file, engine='openpyxl')
|
2021-03-20 20:15:07 -07:00
|
|
|
checkins_df = pd.read_excel(xls, "Check-ins", dtype=str)
|
|
|
|
|
checkins_df["Date"] = pd.to_datetime(checkins_df["Date"]).dt.strftime('%Y-%m-%d')
|
|
|
|
|
#checkins_df['Date'] = checkins_df['Date'].strftime('%Y-%m-%d')
|
|
|
|
|
#print("checkins_df:")
|
|
|
|
|
#print(checkins_df)
|
|
|
|
|
callinfo_df = pd.read_excel(xls, "Call_Data", dtype=str)
|
|
|
|
|
#print("callinfo_df:")
|
|
|
|
|
#print(callinfo_df)
|
2025-11-22 21:51:19 -08:00
|
|
|
hoip_dir_df = pd.read_excel(xls, "hoip_subscribers", dtype=str)
|
|
|
|
|
#print("hoip_dir_df:")
|
|
|
|
|
#print(hoip_dir_df)
|
2021-04-02 12:00:49 -07:00
|
|
|
|
|
|
|
|
# build dictionary of HH phone numbers
|
2025-11-22 21:51:19 -08:00
|
|
|
hoip_phone_dict = {"Callsign" : "HH Number"}
|
|
|
|
|
for i,row in hoip_dir_df.iterrows():
|
2024-04-28 20:09:43 -07:00
|
|
|
callsign = row.iloc[1]
|
2025-11-22 21:51:19 -08:00
|
|
|
hoip_num = row.iloc[0]
|
|
|
|
|
# we only add the hoip number first seen for a unique callsign
|
|
|
|
|
if callsign not in hoip_phone_dict.keys():
|
|
|
|
|
hoip_phone_dict.update({callsign : hoip_num})
|
2021-03-20 20:15:07 -07:00
|
|
|
|
|
|
|
|
# fill in any missing data (NAN's) with default text
|
2024-12-01 20:07:05 -08:00
|
|
|
callinfo_df.fillna({'Name' : ''}, inplace=True)
|
|
|
|
|
callinfo_df.fillna({'State' : 'none'}, inplace=True)
|
|
|
|
|
callinfo_df.fillna({'District' : 'unknown'}, inplace=True)
|
|
|
|
|
callinfo_df.fillna({'County' : 'unknown'}, inplace=True)
|
|
|
|
|
callinfo_df.fillna({'Affiliation' : ''}, inplace=True)
|
2021-03-20 20:15:07 -07:00
|
|
|
|
|
|
|
|
# build dictionary of calls indexed by check-in date
|
|
|
|
|
calls_on_date_dict = {}
|
2021-04-02 12:00:49 -07:00
|
|
|
checkin_count_dict = {"Callsign" : "Check-in Count"}
|
2021-03-20 20:15:07 -07:00
|
|
|
for i,row in checkins_df.iterrows():
|
2024-04-28 20:09:43 -07:00
|
|
|
checkin_date = row.iloc[0]
|
|
|
|
|
checkin_call = row.iloc[1]
|
2021-03-20 20:15:07 -07:00
|
|
|
if checkin_date in calls_on_date_dict.keys():
|
|
|
|
|
if checkin_call not in calls_on_date_dict[checkin_date]:
|
|
|
|
|
calls_on_date_dict[checkin_date].append(checkin_call)
|
|
|
|
|
else:
|
|
|
|
|
calls_on_date_dict.update({checkin_date:[checkin_call]})
|
2021-04-02 12:00:49 -07:00
|
|
|
if checkin_call in checkin_count_dict.keys():
|
|
|
|
|
checkin_count_dict[checkin_call] = checkin_count_dict[checkin_call] + 1
|
|
|
|
|
else:
|
|
|
|
|
checkin_count_dict.update({checkin_call : 1})
|
2021-03-20 20:15:07 -07:00
|
|
|
|
|
|
|
|
# build dictionary of call info indexed by callsign
|
|
|
|
|
call_data_dict = {}
|
|
|
|
|
for i,row in callinfo_df.iterrows():
|
2025-11-22 21:51:19 -08:00
|
|
|
# row of data is call, name, state, district, county, affiliation, hoip_num
|
|
|
|
|
# dictionary becomes: { call: [name[0], state[1], district[2], county[3], affiliation[4]], hoip_num[5]}
|
2024-04-28 20:09:43 -07:00
|
|
|
callsign = row.iloc[0]
|
2025-11-22 21:51:19 -08:00
|
|
|
if callsign in hoip_phone_dict.keys():
|
|
|
|
|
hoip_num = hoip_phone_dict[callsign]
|
2021-04-02 12:00:49 -07:00
|
|
|
else:
|
2025-11-22 21:51:19 -08:00
|
|
|
hoip_num = ""
|
|
|
|
|
call_data_dict.update({callsign:[row.iloc[1],row.iloc[2],row.iloc[3],row.iloc[4],row.iloc[5],hoip_num]})
|
2021-03-20 20:15:07 -07:00
|
|
|
|
|
|
|
|
# build checkin_form_dict dictionary
|
|
|
|
|
checkin_form_dict = blank_checkin_form_dict
|
|
|
|
|
for call in call_data_dict.keys():
|
|
|
|
|
#print("Looking at:", call)
|
2025-11-22 21:51:19 -08:00
|
|
|
#if call in hoip_phone_dict.keys():
|
|
|
|
|
#print("Call "+call+" has HOIP #"+hoip_phone_dict[call])
|
2021-03-20 20:15:07 -07:00
|
|
|
call_state = call_data_dict[call][1]
|
|
|
|
|
call_dist = call_data_dict[call][2]
|
|
|
|
|
call_county = call_data_dict[call][3]
|
|
|
|
|
call_affil = call_data_dict[call][4]
|
2025-11-22 21:51:19 -08:00
|
|
|
call_hoip_num = call_data_dict[call][5]
|
|
|
|
|
#print("State, Dist, Cnty, Affil, HH Num: ", call_state, call_dist, call_county, call_affil, call_hoip_num)
|
2021-03-20 20:15:07 -07:00
|
|
|
|
|
|
|
|
# sanity check the data - error if not found in dictionary keys...
|
2022-07-23 20:12:31 -07:00
|
|
|
# print("Verifying at: ", call, call_state, call_dist, call_county)
|
2021-03-20 20:15:07 -07:00
|
|
|
if call_state not in checkin_form_dict.keys():
|
|
|
|
|
print("ERROR: ",call_state,"not in checkin_form_dict!")
|
|
|
|
|
if call_dist not in checkin_form_dict[call_state].keys():
|
|
|
|
|
print("ERROR: ",call_dist, "not in checkin_form_dict under state of", call_state,"!")
|
|
|
|
|
if call_county not in checkin_form_dict[call_state][call_dist].keys():
|
|
|
|
|
print("ERROR: ",call_county, "not in checkin_form_dict under district ", call_dist,"!")
|
|
|
|
|
|
|
|
|
|
# okay, safe to move on...
|
|
|
|
|
call_list = checkin_form_dict[call_state][call_dist][call_county]
|
|
|
|
|
#print(" calls in",call_county,":", call_list)
|
|
|
|
|
if call not in call_list:
|
|
|
|
|
checkin_form_dict[call_state][call_dist][call_county].append(call)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
# print check-in form based on historical check-ins
|
|
|
|
|
with open(output_file,"w") as outfile:
|
|
|
|
|
outfile.write("\n")
|
|
|
|
|
outfile.write("PNW Digital ARES & EMCOMM Check-In Net - Check-ins for _______________\n\n")
|
|
|
|
|
for state in checkin_form_dict.keys():
|
|
|
|
|
if state not in ['Philippines','Canada','Visitor']:
|
|
|
|
|
outfile.write("State: " + state +"\n")
|
|
|
|
|
for district in checkin_form_dict[state].keys():
|
|
|
|
|
outfile.write(" District: " + district + "\n")
|
|
|
|
|
if district not in ["State EMD"]:
|
|
|
|
|
|
|
|
|
|
# print the list of counties in this district
|
|
|
|
|
outfile.write(" Counties: ")
|
|
|
|
|
county_list = sorted(checkin_form_dict[state][district])
|
|
|
|
|
county_count = len(county_list)
|
|
|
|
|
index = 0
|
|
|
|
|
if county_count >= 1:
|
|
|
|
|
outfile.write(county_list[index])
|
|
|
|
|
county_count -= 1
|
|
|
|
|
index += 1
|
|
|
|
|
while county_count >= 1:
|
|
|
|
|
if county_list[index] == "unknown":
|
|
|
|
|
county_count -= 1
|
|
|
|
|
index += 1
|
|
|
|
|
continue
|
|
|
|
|
|
|
|
|
|
if (index % 5) == 0:
|
|
|
|
|
outfile.write("\n "+county_list[index])
|
|
|
|
|
else:
|
|
|
|
|
outfile.write(", "+county_list[index])
|
|
|
|
|
county_count -= 1
|
|
|
|
|
index += 1
|
|
|
|
|
outfile.write("\n\n")
|
|
|
|
|
|
|
|
|
|
# now collect all of the calls from all counties
|
|
|
|
|
call_list = []
|
|
|
|
|
for county in sorted(checkin_form_dict[state][district]):
|
|
|
|
|
for county_call_item in checkin_form_dict[state][district][county]:
|
|
|
|
|
call_list.append(county_call_item)
|
|
|
|
|
call_list.sort()
|
|
|
|
|
for call in call_list:
|
|
|
|
|
call_name = call_data_dict[call][0]
|
|
|
|
|
call_county = call_data_dict[call][3]
|
|
|
|
|
call_affil = call_data_dict[call][4]
|
2021-04-02 12:00:49 -07:00
|
|
|
if call in checkin_count_dict.keys():
|
|
|
|
|
checkin_count = checkin_count_dict[call]
|
|
|
|
|
checkin_str = ", [{}]".format(checkin_count)
|
|
|
|
|
else:
|
|
|
|
|
checkin_count = 0
|
|
|
|
|
checkin_str = ""
|
2022-07-23 20:12:31 -07:00
|
|
|
if checkin_count > 0:
|
|
|
|
|
outfile.write(" "+call+", "+call_name+checkin_str)
|
2025-11-22 21:51:19 -08:00
|
|
|
if call in hoip_phone_dict.keys():
|
|
|
|
|
outfile.write(", HOIP #"+hoip_phone_dict[call])
|
2022-07-23 20:12:31 -07:00
|
|
|
if call_affil != "":
|
|
|
|
|
outfile.write(", "+call_affil+"\n")
|
|
|
|
|
else:
|
|
|
|
|
outfile.write("\n")
|
2021-03-20 20:15:07 -07:00
|
|
|
else:
|
|
|
|
|
for county in checkin_form_dict[state][district].keys():
|
|
|
|
|
call_list = checkin_form_dict[state][district][county]
|
|
|
|
|
call_list.sort()
|
|
|
|
|
for call in call_list:
|
2021-04-02 12:00:49 -07:00
|
|
|
if call in checkin_count_dict.keys():
|
|
|
|
|
checkin_count = checkin_count_dict[call]
|
|
|
|
|
checkin_str = ", [{}]".format(checkin_count)
|
|
|
|
|
else:
|
|
|
|
|
checkin_count = 0
|
|
|
|
|
checkin_str = ""
|
2022-07-23 20:12:31 -07:00
|
|
|
if checkin_count > 0:
|
|
|
|
|
outfile.write(" "+call+", "+call_data_dict[call][0]+checkin_str)
|
2025-11-22 21:51:19 -08:00
|
|
|
if call in hoip_phone_dict.keys():
|
|
|
|
|
outfile.write(", HOIP #"+hoip_phone_dict[call])
|
2022-07-23 20:12:31 -07:00
|
|
|
affil = call_data_dict[call][4]
|
|
|
|
|
if affil != '':
|
|
|
|
|
outfile.write(", "+affil+"\n")
|
|
|
|
|
else:
|
|
|
|
|
outfile.write("\n")
|
2021-03-20 20:15:07 -07:00
|
|
|
outfile.write("\n")
|
|
|
|
|
outfile.write("\n")
|
|
|
|
|
else:
|
2021-04-02 12:00:49 -07:00
|
|
|
if state == "Visitor":
|
|
|
|
|
outfile.write("Visitor Check-ins:\n")
|
|
|
|
|
else:
|
|
|
|
|
outfile.write("Country: "+state+"\n")
|
2021-03-20 20:15:07 -07:00
|
|
|
for district in checkin_form_dict[state].keys():
|
|
|
|
|
for county in checkin_form_dict[state][district].keys():
|
|
|
|
|
call_list = checkin_form_dict[state][district][county]
|
|
|
|
|
call_list.sort()
|
|
|
|
|
for call in call_list:
|
2021-04-02 12:00:49 -07:00
|
|
|
if call in checkin_count_dict.keys():
|
|
|
|
|
checkin_count = checkin_count_dict[call]
|
|
|
|
|
checkin_str = ", [{}]".format(checkin_count)
|
|
|
|
|
else:
|
|
|
|
|
checkin_count = 0
|
|
|
|
|
checkin_str = ""
|
|
|
|
|
outfile.write(" "+call+", "+call_data_dict[call][0]+checkin_str)
|
2025-11-22 21:51:19 -08:00
|
|
|
if call in hoip_phone_dict.keys():
|
|
|
|
|
outfile.write(", HOIP #"+hoip_phone_dict[call])
|
2021-04-02 12:00:49 -07:00
|
|
|
affil = call_data_dict[call][4]
|
|
|
|
|
if affil != '':
|
|
|
|
|
outfile.write(", "+affil+"\n")
|
|
|
|
|
else:
|
|
|
|
|
outfile.write("\n")
|
2021-03-20 20:15:07 -07:00
|
|
|
outfile.write("\n")
|
|
|
|
|
outfile.write("\n")
|
|
|
|
|
|
|
|
|
|
outfile.close()
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
# generate net reports based on check-in data
|
|
|
|
|
report_dir = os.path.join(data_dir, "reports")
|
|
|
|
|
net_day_list = checkins_df['Date'].unique()
|
2022-07-23 20:12:31 -07:00
|
|
|
#print("DEBUG: net_dat_list =", net_day_list)
|
2021-03-20 20:15:07 -07:00
|
|
|
for net_day in net_day_list:
|
|
|
|
|
|
|
|
|
|
#print("Looking at checkins for: ", net_day)
|
|
|
|
|
|
|
|
|
|
# get list of calls checked in on this day
|
|
|
|
|
call_list = calls_on_date_dict[net_day]
|
|
|
|
|
num_checkins = len(call_list)
|
|
|
|
|
#print(" ",num_checkins,"Check-ins on this day: ",call_list)
|
|
|
|
|
|
|
|
|
|
# fill in report dictionary from call list
|
|
|
|
|
report_dict = {}
|
|
|
|
|
for call in call_list:
|
|
|
|
|
|
|
|
|
|
if call not in call_data_dict.keys():
|
|
|
|
|
print("Unknown call in call database: {}".format(call))
|
|
|
|
|
continue
|
|
|
|
|
|
|
|
|
|
#print("report_dict:")
|
|
|
|
|
#print(report_dict)
|
|
|
|
|
#print("")
|
|
|
|
|
#print("Looking at:", call)
|
|
|
|
|
call_state = call_data_dict[call][1]
|
|
|
|
|
call_dist = call_data_dict[call][2]
|
|
|
|
|
call_county = call_data_dict[call][3]
|
|
|
|
|
call_affil = call_data_dict[call][4]
|
|
|
|
|
#print(" State, Dist, Cnty, Affil: ", call_state, call_dist, call_county, call_affil)
|
|
|
|
|
|
|
|
|
|
# sanity check the data - error if not found in dictionary keys...
|
|
|
|
|
#print("Verifying at: ", call, call_state, call_dist, call_county)
|
|
|
|
|
if call_state not in report_dict.keys():
|
|
|
|
|
# make new state entry
|
|
|
|
|
report_dict.update({call_state:{call_dist:{call_county:[call]}}})
|
|
|
|
|
#print("ERROR: ",call_state,"not in report_dict!")
|
|
|
|
|
continue
|
|
|
|
|
if call_dist not in report_dict[call_state].keys():
|
|
|
|
|
report_dict[call_state].update({call_dist:{call_county:[call]}})
|
|
|
|
|
#print("ERROR: ",call_dist, "not in report_dict under state of", call_state,"!")
|
|
|
|
|
continue
|
|
|
|
|
if call_county not in report_dict[call_state][call_dist].keys():
|
|
|
|
|
report_dict[call_state][call_dist].update({call_county:[call]})
|
|
|
|
|
#print("ERROR: ",call_county, "not in report_dict under district ", call_dist,"!")
|
|
|
|
|
continue
|
|
|
|
|
|
|
|
|
|
# okay, safe to move on...
|
|
|
|
|
report_call_list = report_dict[call_state][call_dist][call_county]
|
|
|
|
|
#print(" calls in",call_county,":", call_list)
|
|
|
|
|
if call not in report_call_list:
|
|
|
|
|
report_dict[call_state][call_dist][call_county].append(call)
|
|
|
|
|
|
|
|
|
|
# Now print a weekly report for this net_day
|
|
|
|
|
|
|
|
|
|
output_file = os.path.join(report_dir, "Weekly_Check-in_Report_for_"+net_day+".txt")
|
|
|
|
|
#print("Weekly report for",net_day,"will be written here:")
|
|
|
|
|
#print(" "+output_file)
|
|
|
|
|
with open(output_file,"w") as outfile:
|
|
|
|
|
|
|
|
|
|
# Opening text
|
2025-04-29 07:01:37 -07:00
|
|
|
headertext = '\n'.join([
|
|
|
|
|
'PNW Digital ARES & EmComm Check-In Net - '+str(num_checkins)+
|
2025-11-02 19:59:12 -08:00
|
|
|
' check-ins on '+net_day+'\n',
|
2025-04-29 07:01:37 -07:00
|
|
|
'There were '+str(num_checkins)+' check-ins on '+net_day+' to the Pacific',
|
|
|
|
|
'Northwest (PNW) Digital ARES & EmComm Check-In Net.',
|
|
|
|
|
' ',
|
|
|
|
|
'The following is the detailed check-in list grouped',
|
|
|
|
|
'by our region\'s ARRL ARES districts. If any of the',
|
|
|
|
|
'info (i.e. name or agency affiliation) below is',
|
|
|
|
|
'incomplete or incorrect, please IM me on Jabber/',
|
2025-11-02 19:59:12 -08:00
|
|
|
'XMPP at n7ekb@n7ekb.net, e-mail me at ed@n7ekb.net, or',
|
|
|
|
|
'call me on HOIP extension 103675 with your updates.',
|
2025-04-29 07:01:37 -07:00
|
|
|
'\n\n'
|
|
|
|
|
])
|
|
|
|
|
outfile.write(headertext)
|
2021-03-20 20:15:07 -07:00
|
|
|
|
|
|
|
|
# Check-in details
|
|
|
|
|
for state in sorted(report_dict):
|
|
|
|
|
if state not in ['Philippines','Canada','Visitor']:
|
|
|
|
|
outfile.write(state+" State:\n")
|
|
|
|
|
for district in sorted(report_dict[state]):
|
|
|
|
|
if district not in ["State EMD"]:
|
|
|
|
|
outfile.write(" District: " + district + "\n")
|
|
|
|
|
for county in sorted(report_dict[state][district]):
|
|
|
|
|
cur_call_list = report_dict[state][district][county]
|
|
|
|
|
if len(cur_call_list) > 0:
|
|
|
|
|
outfile.write(" " + county + " County:\n")
|
|
|
|
|
cur_call_list.sort()
|
|
|
|
|
for call in cur_call_list:
|
|
|
|
|
affil = call_data_dict[call][4]
|
2025-11-22 21:51:19 -08:00
|
|
|
hoip_num = call_data_dict[call][5]
|
2021-04-02 12:00:49 -07:00
|
|
|
outfile.write(" "+call+", "+call_data_dict[call][0])
|
2025-11-22 21:51:19 -08:00
|
|
|
if hoip_num != '':
|
|
|
|
|
outfile.write(", HOIP #"+hoip_num)
|
2021-03-20 20:15:07 -07:00
|
|
|
if affil != '':
|
2021-04-02 12:00:49 -07:00
|
|
|
outfile.write(", "+affil+"\n")
|
2021-03-20 20:15:07 -07:00
|
|
|
else:
|
2021-04-02 12:00:49 -07:00
|
|
|
outfile.write("\n")
|
2021-03-20 20:15:07 -07:00
|
|
|
else:
|
|
|
|
|
outfile.write(" "+district+"\n")
|
|
|
|
|
for county in sorted(report_dict[state][district]):
|
|
|
|
|
cur_call_list = report_dict[state][district][county]
|
|
|
|
|
cur_call_list.sort()
|
|
|
|
|
for call in cur_call_list:
|
2021-04-02 12:00:49 -07:00
|
|
|
affil = call_data_dict[call][4]
|
2025-11-22 21:51:19 -08:00
|
|
|
hoip_num = call_data_dict[call][5]
|
2021-04-02 12:00:49 -07:00
|
|
|
outfile.write(" "+call+", "+call_data_dict[call][0])
|
2025-11-22 21:51:19 -08:00
|
|
|
if hoip_num != '':
|
|
|
|
|
outfile.write(", HOIP #"+hoip_num)
|
2021-04-02 12:00:49 -07:00
|
|
|
if affil != '':
|
|
|
|
|
outfile.write(", "+affil+"\n")
|
|
|
|
|
else:
|
|
|
|
|
outfile.write("\n")
|
2021-03-20 20:15:07 -07:00
|
|
|
#outfile.write("\n")
|
|
|
|
|
outfile.write("\n")
|
|
|
|
|
for state in sorted(report_dict):
|
2021-04-02 12:00:49 -07:00
|
|
|
if state in ['Canada','Philippines','Visitor']:
|
2021-03-20 20:15:07 -07:00
|
|
|
outfile.write(state+":\n")
|
|
|
|
|
for district in sorted(report_dict[state]):
|
|
|
|
|
for county in sorted(report_dict[state][district]):
|
|
|
|
|
cur_call_list = report_dict[state][district][county]
|
|
|
|
|
cur_call_list.sort()
|
|
|
|
|
for call in cur_call_list:
|
2021-04-02 12:00:49 -07:00
|
|
|
affil = call_data_dict[call][4]
|
2025-11-22 21:51:19 -08:00
|
|
|
hoip_num = call_data_dict[call][5]
|
2021-04-02 12:00:49 -07:00
|
|
|
outfile.write(" "+call+", "+call_data_dict[call][0])
|
2025-11-22 21:51:19 -08:00
|
|
|
if hoip_num != '':
|
|
|
|
|
outfile.write(", HOIP #"+hoip_num)
|
2021-04-02 12:00:49 -07:00
|
|
|
if affil != '':
|
|
|
|
|
outfile.write(", "+affil+"\n")
|
|
|
|
|
else:
|
|
|
|
|
outfile.write("\n")
|
2021-03-20 20:15:07 -07:00
|
|
|
outfile.write("\n")
|
|
|
|
|
outfile.write("\n")
|
|
|
|
|
|
|
|
|
|
# output the footer text...
|
2025-04-29 07:01:37 -07:00
|
|
|
footer = '\n'.join([
|
|
|
|
|
'About the net:\n',
|
|
|
|
|
'The PNW Digital ARES & EMCOMM Check-In Net is held',
|
|
|
|
|
'every Sunday evening at 7:30 PM local time on PNW',
|
|
|
|
|
'Regional, DMR talkgroup 31771. DMR Talk Group 31771 is',
|
|
|
|
|
'available on both the PNW Digital and the Brandmeister',
|
|
|
|
|
'DMR networks. Anyone interested in Amateur Radio and',
|
|
|
|
|
'Emergency Communications is welcome to check-in. The',
|
|
|
|
|
'net is an opportunity for DMR-capable ARES and EmComm',
|
|
|
|
|
'hams to exercise their DMR equipment in a regional,',
|
|
|
|
|
'directed net. The net demonstrates the wide coverage',
|
|
|
|
|
'area and capability of DMR repeaters and hot spots in',
|
|
|
|
|
'our Pacific Northwest region. It also highlights the',
|
|
|
|
|
'wide range of EmComm-related organizations who have',
|
|
|
|
|
'members with DMR capability.\n\n',
|
2025-11-23 20:32:55 -08:00
|
|
|
'#net-reports #hamradio #EmComm #ARES #DMR #HOIP #PNWDigital\n'
|
2025-04-29 07:01:37 -07:00
|
|
|
])
|
|
|
|
|
outfile.write(footer)
|
2021-03-20 20:15:07 -07:00
|
|
|
|
|
|
|
|
# close this week's report file
|
|
|
|
|
outfile.close()
|
|
|
|
|
|
|
|
|
|
print("Processed {} check-ins for {}.".format(num_checkins, net_day))
|
|
|
|
|
print("All Done!")
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
# In[ ]:
|
|
|
|
|
|
