Membership Database/Processing/How To

How to process the membership database
Processing the database requires UNIX scripts, which I (Brett Wuth) keep on the PCSAR virtual machine.

Unless you understand UNIX, you're not likely to understand much of this. If you need to get someone else to do this, you'll need to find someone with UNIX or Linux shell skills.

The scripts check for changes in the database, so they keep a running record of the last changes they've seen.

Pending edits
Check my marked up copy of the call out list to see any changes that may be necessary.

Extract and validate
to do:
 * validate upon edit rather than wait for process
 * validate Activities upon edit
 * (done) create script to just validate Activities page
 * (done) create calling script ~/bin/wiki-membership-activities-validate
 * save errors to wiki
 * (next) decide where on wiki errors should be reported
 * need to display when error log is outdated
 * similar in structure to Template:Sign, Template:Signature
 * experiment: Sandbox/Error check
 * automatically run script when Activities page modified
 * validate each Membership Record upon edit

to do: optimize for speed (last run 7min)

as user "wuth"

cd ~/sar/pc/membership wiki-extract

make any necessary changes.
 * Reconcile

Process
ssh -AX wuth@localhost
 * make sure current ssh-agent authority is extended

database-process


 * print copy for myself

rapid-notify-post
 * sometimes fails at initial log in and has to be restarted
 * takes ~65 minutes to run
 * see


 * To Do:
 * additional policy checks
 * write policy check for sar fund currency
 * Set type of existing Activities. See /[ssh/pcsar]/home/wuth/sar/pc/membership/lib/Membership.xsd ActivityCategoryType (done to 2012-01)
 * base on /[scp/pcsar]/home/wuth/sar/pc/membership/bin/policy-check-stale
 * see lib/SARFundStale.xsl
 * needs debugging
 * add to CVS
 * write policy check for voting member upgrade
 * write policy check for voting member currency
 * commonize elements of {bin,lib}/{call-out,first-call}

lpr -Pofficejet8500 -o outputorder=reverse run/print-queue/*{recorder,SARCAR}*
 * Personnel records: -- done by Adam now

first-call-list-fax
 * Fax to Fire Dispatch in Lethbridge -- not done any more

fan-out-list-send
 * Print/Send the Fan-Out list -- no longer done


 * Call Out List: -- done by Adam
 * for binder
 * for SARCAR
 * for overhead box at firehall
 * 3 copies

sync wiki accounts

 * sync the membership list with the wiki user list
 * rename/merge Charlene/Charleen Bruder
 * Extract list of users currently with "Member" status
 * http://pcsar.dyndns.org:8080/mediawiki/index.php?title=Special:Listusers&limit=500&group=Members

H2S list
h2s-training-list-email
 * Send membership list (names only) to Global Training for validation of H2S Alive course registration.

Non-monthly processing
These are tasks that aren't done on a regular basis. Some of them haven't been done in long time and their instructions are now out of date.

copy to Brett's laptop
Because the remaining steps don't run on the PCSAR virtual machine yet, the file must be copied to Brett's laptop and run from there. wuth@macbook:~/sar/pc/membership$ chmod 600 personnel-database.xml wuth@macbook:~/sar/pc/membership$ scp -p wuth@pcsar:sar/pc/membership/personnel-database.xml. wuth@macbook:~/sar/pc/membership$ chmod 400 personnel-database.xml wuth@macbook:~/sar/pc/membership$ scp -p wuth@pcsar:sar/pc/membership/tmp/personnel-database.txt tmp wuth@macbook:~/sar/pc/membership$ rm -r run wuth@macbook:~/sar/pc/membership$ scp -pr wuth@pcsar:sar/pc/membership/run.

To prepare a list of addresses and phone numbers of all our members
This was required for a casino application. xslt lib/MembersOnly.xsl < personnel-database.xml |xslt lib/NamePhoneAddress.xsl >tmp/addresses.txt

To print blank Personnel Records
personnel-blank-print 10
 * keep 10 copies at hand

To send call-out list via e-mail

 * Stop sending in September 2003

call-out-list-email Call-out list to executive.


 * verify doesn't send when no change:
 * Add note about any deletions
 * automate production of

To e-mail mailing labels
mailing-labels-email
 * Does not require anymore

Mailing Labels sent to Jackie.

To e-mail changes for Resource database

 * Stop doing October, 2003. Need another way to handle resource database

personnel-database-mail-resource-database

When new members join, or e-mail addresses filled in
To: Subject: Welcome --text follows this line-- Thanks for joining Pincher Creek SAR. Can you please check if I've correctly copied your membership record:

---cut--- ---cut---

Training sessions/meetings are the first Tuesday of every month, usually starting at 19:00.

If you'd like to join in a club discussion and receive notices via e-mail, please send a "subscribe" message to pcsar-discuss-request@castrov.cuug.ab.ca

Take Care,Brett Wuth wuth@acm.org wuth@telusplanet.net bwuth@cuug.ab.ca Box 1251-U, Pincher Creek, Alberta T0K 1W0, CANADA Tel:+1 403 627-2460 pgp-public-keys@uit.no has mine; Print=E4F8EDEECBE01AD2FA3D8B2D94B1A292 What is the meaning of life?! Yes.

To print the participation dates
xslt reformatted.xml