Personnel Database/Processing/How To

From PCSAR

(Difference between revisions)

Revision as of 21:18, 17 January 2012

1 How to process the membership database
2 Non-monthly processing

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

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

cd ~/sar/pc/membership
wiki-extract

Reconcile

make any necessary changes.

Process

database-process

To Do: (review: Brett Wuth)
- commonize elements of {bin,lib}/{call-out,first-call}
- additional policy checks
  - write policy check for voting member upgrade
  - write policy check for voting member currency
  - write policy check for sar fund currency

Personnel records: -- done by Adam now

lpr -Pofficejet8500 -o outputorder=reverse run/print-queue/*{recorder,SARCAR}*

First Call List: -- done by Adam now
- 1 copy (for binder)

lpr -Pofficejet8500 run/print-queue/*FirstCall*

Call Out List:
- for binder
- for SARCAR
- for overhead box at firehall
- for myself
- 4 copies -- 3 copies done by Adam, 1 copy for myself

lpr -Pofficejet8500 -o Collate=True -o outputorder=reverse run/print-queue/*CallOutList*

Fax to Fire Dispatch in Lethbridge -- not done any more

first-call-list-fax

Print/Send the Fan-Out list -- no longer done

fan-out-list-send

etc

Upload the Call Out List to the wiki.

wuth@fiore:~/tmp$                             
 scp -p pcsar:sar/pc/membership/run/print-queue/*CallOutList* .
 wiki-upload-doc pcsar 2011-03*CallOutList* Members:Call_Out_List.pdf ""

Upload the First Call List to the wiki.

wuth@fiore:~/tmp$ 
 scp -p pcsar:sar/pc/membership/run/print-queue/*FirstCall* .
 wiki-upload-doc pcsar 2011-03*FirstCall* Members:First_Call_List.pdf ""

sync the membership list with the wiki user list
- rename/merge Charlene/Charleen Bruder

Send membership list (names only) to Global Training for validation of H2S Alive course registration.

 xslt lib/MembersOnly.xsl < personnel-database.xml |xslt lib/MembersSorted.xsl | xslt lib/Name.xsl >tmp/member-list.txt

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

keep 10 copies at hand

 personnel-blank-print 10

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

Does not require anymore

mailing-labels-email

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 <personnel-database.xml Activities.xsl | awk -v FS=":" {printf "%-24s:%-7s:%s\n", $1, $2, $3 } | mail -s "activity history" `MailRCAliasAddressGet "Bob Costa"` wuth

participation-report-make

Add any missing entries to partitipation-type.txt

Brett Wuth, 2006/07/15 09:35 MST (via web): Reformat the database after automatic translation using:

  xml-tidy "Training, Experience, Equipment, Notes" <personnel-database.xml >reformatted.xml

Facts about Personnel Database/Processing/How ToRDF feed

Review

unspecified +

Retrieved from "http://pcsar.dyndns.org:8080/mediawiki/index.php/Personnel_Database/Processing/How_To"

Category: Review/Brett Wuth

@@ Line 37: / Line 37: @@
 *** write policy check for sar fund currency
-* Personnel records:
+* Personnel records: -- done by Adam now
  lpr -Pofficejet8500 -o outputorder=reverse run/print-queue/*{recorder,SARCAR}*
-* First Call List:
+* First Call List: -- done by Adam now
 ** 1 copy (for binder)
  lpr -Pofficejet8500 run/print-queue/*FirstCall*
@@ Line 48: / Line 50: @@
 ** for overhead box at firehall
 ** for myself
-** 4 copies
+** 4 copies -- 3 copies done by Adam, 1 copy for myself
  lpr -Pofficejet8500 -o Collate=True -o outputorder=reverse run/print-queue/*CallOutList*