The script I used to pull data from
http://qrz.com is based on
http://aa6e.net/wiki/Qrz.py.
I modified it to return Comma Separated Values (CSV) consisting of Call,
First Name, and e-mail
I then merged this CSV file into the Excel spreadsheet I created from the
AMPR hosts file.
I exported that spreadsheet to a CSV file consisting of Call, First Name,
e-mail, ip address, and hostname.
That was read by my second script which uses Python's SMTP library to send
the e-mails.
I'm a little hesitant to publish that script publicly because it could be
turned into a SPAM tool. In fact, I had to batch my e-mails 100 at a time
because my hosting provider limits me to 100 e-mail recipients per hour.
(which is perfectly understandable).
-Neil
On Thu, Aug 1, 2013 at 3:01 PM, <kb9mwr(a)gmail.com> wrote:
(Please trim inclusions from previous messages)
_______________________________________________
Neil,
Can you share these scripts or the links to what you used as a base.
I can see myself doing this once the DNS part of the portal is functional.
Steve, KB9MWR
WI/Upper MI Coordinator
---- Quote ----
Having just volunteered as a coordinator for the state of Iowa (
44.50.0.0/16).
I went through the amprhost file and:
- Pulled out all the IP address entries for the state.
- Manually pulled out the call signs from the host names.
- Modified a python script I found on github ( called qrz.py) to get as
many email addresses as I could from
qrz.com,
- Used another python script to send a nicely formatted e-mail to each
user asking them to register their IP on the portal or tell me if they
no
longer needed it. Stated in the e-mail that if I didn't hear from them
in
90 days. I would reclaim their allocation.
- The plan is to send a reminder email at 60, 30, and 7 days.
I'm not sure what I will do with those call signs that don't have e-mails
associated with them (56 out of 175). Possibly send a post card ?
Of the 119 e-mails I sent, I've received 27 responses so far. 20 saying I
can reclaim their allocation, and 7 requests through the portal.
The previous volunteer did a wonderful job of dividing up the state into
regions, sub-regions, and cities, but assumed there would be only one
gateway per city. I'll have to understand the existing network topology
and see if I can fit them into new subnet boundaries.
-Neil
_________________________________________
44Net mailing list
44Net(a)hamradio.ucsd.edu
http://hamradio.ucsd.edu/mailman/listinfo/44net
http://www.ampr.org/donate.html
--
Neil Johnson -N0SFH
http://erudicon.com