CAPDB.US accepting other Wings

Started by JoeTomasone, May 24, 2017, 01:27:47 AM

0 Members and 1 Guest are viewing this topic.

JoeTomasone

CAPDB is a system I created years ago to produce useful reports from CAPWATCH data that I couldn't get easily from eServices.   It was later expanded to include things like unit alerting (as opposed to a calldown tree, say) and searching for and alerting qualified ES members for missions (find all UDF/GTM3 within 25 miles of a given lat/long, zip, or city & state and alert them).   FLWG has been using it for years, and I have recently decided to open it up to other Wings after successful testing with other Wings.

The main features are:


1. ES report - Lists all qualifications and how many members are qualified, expired, and will expire in the next 30/60/90 days.
2. Unit report - Lists all the organizational data for a unit including how many members (broken down into Cadets/Seniors) and all duty assignments.
3. Member List & Currency Report - Displays all unit members, their grade, expiration, safety currency, and their OPSEC, EO, and CPPT currency.  Also provides totals on how many members need those courses.  Allows for alerting all members as well.
4. Duty Assignment - Lists all members who hold a selected duty assignment.  Great for Group level and above to find all Safety Officers, for example.
5. Qualification Report - Lists all members who hold a specific qualification - ES and pilot ratings, mainly.
6. Member Search - Essentially brings up an electronic member record with expiration info, contact info, lists of duty assignments, qualifications, and courses taken. 
7. Commercial Privilege Pilot Report - Lists all members with either FAA COMM SEL or ATP SEL and who have both current medical and are TMP rated.
7. Qualification Search - Finds all members qualified in a given ES qualification (and some combos like all aircrew or all UDF) a given distance from a provided lat/long, zip, or city & state.  Allows selective alerting and displays the member's home location on a map. 
8. DUAT Weather Archive - A 10-day archive of DUAT data for all airports in the Wing.  You can see some samples here: http://wx.capdb.us

The alerting function has 4 options:

1. Email - sent to eServices Primary and Secondary email addresses.
2. Email list - generates a list to paste into your email program of choice.
3. Text message - sent to eServices listed cell phone
4. Phone call - Robocall sent to eServices Primary home phone.

You can select any combination of alerting options for a given alert.


REQUIREMENTS:

The main CAPDB system is designed to operate at the Wing level.   It will require someone with Wing-level CAPWATCH access provide the CAPWATCH data to the system on a (pseudo) regular basis.  Ideally, that person would be on the ES/OPS or Command staff, but that is not mandatory.    That person should contact me either here or at joe@tomasone.com to arrange a WebEx demo and/or to get their Wing setup.   Members in a given Wing are granted accounts and therefore login rights by the main POC for the Wing or a designee.

The DUAT weather archive can be activated on request by any Wing staff member with whatever authority the Wing might require to make such a request.   :)

This system is offered free of charge to the CAP community, with all the warranties and tech support that "free" implies.  :)



Here are a few screen captures:



Main menu



ES Qualification Report (it has totals and statistics at the bottom)



UDF Qualified Member Search with Mass Contact Options



Mission Pilot Report



JoeTomasone

Welp, with the NHQ/CC deciding that systems like CAPDB are verboten after 2 January 2018, it appears that this offer needs to be officially rescinded.

So long, and thanks for all the fish.   


N Harmon

I wonder if the directive from NHQ affects my WMIRS scraper (https://github.com/nharmon/wmirs_scraper).
NATHAN A. HARMON, Capt, CAP
Monroe Composite Squadron

JoeTomasone

Quote from: N Harmon on July 07, 2017, 11:56:44 PM
I wonder if the directive from NHQ affects my WMIRS scraper (https://github.com/nharmon/wmirs_scraper).

It would certainly seem to meet the definition of a "locally developed mission tool". 

Thom

I don't want to give false hope, but we recently had a SWR IT briefing with more info from NHQ and got an update on this initiative.

My takeaway was this: If your local tool is used -In Addition To- WMIRS, and does not act as to prevent Mission/Operations data from being properly and promptly recorded in WMIRS, and it can work from the default CAPWATCH download, then it should still be OK.

Where they wanted to limit tools was those, such as CAPSTAR/CAPERS, that had folks doing things ONLY in the local tool, and not also in WMIRS.

Again, I did not get a direct confirmation on the approved continued use of any particular tool (other than Arizona's eWing which was mentioned as OK), so please go up the chain and check.

If you do get approval (or no shutdown notice) then we'd also like to look into this tool for LA Wing.

Good Luck!


JoeTomasone

Actually, I just found this - it bodes well for CAPDB: 
https://www.capmembers.com/eservices/capwatchfaq

Excerpts:

My command has local applications that are using CAPWATCH data.  We are not duplicating any eServices applications or capabilities.  What should we be doing now to prepare for the change?

If your unit is using CAPWATCH data, at your unit's respective organization scope, to provide unique local IT functionality, then there is no immediate action required.  You should continue to check with your IT Director and eServices news for updates and announcements.  It is important to note that the data will not change for you.  The process will change and NHQ IT will be communicating frequently on what to expect and when the new online process will be available.


Does CAP intend to shut down all local applications?

No, definitely not.  CAP NHQ IT recognizes and values the IT innovation that is occurring in the field.



Will we continue to have access to the CAPWATCH data either in its current format or in new format? 

Any member who is receiving CAPWATCH data for their respective organization scope today will continue to receive the same data set after 2 January provided they:
Have their Commanders' approval
Submit the purpose for which the CAPWATCH data will be used
Sign a user agreement acknowledging their responsibility to protect the data under their care
Are not duplicating functionality that is already within eServices/WMIRS




Holding Pattern

have you submitted capdb.us as an internet operations application?

JoeTomasone

Quote from: Mordecai on July 24, 2017, 07:43:12 PM
have you submitted capdb.us as an internet operations application?


Nope.  Never even heard of doing so. 


Holding Pattern

Quote from: JoeTomasone on July 24, 2017, 10:33:06 PM
Quote from: Mordecai on July 24, 2017, 07:43:12 PM
have you submitted capdb.us as an internet operations application?


Nope.  Never even heard of doing so.

PM inbound tonight.