Editing Personnel Database/Processing/How To
From PCSAR
Warning: You are not logged in. Your IP address will be recorded in this page's edit history.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Current revision | Your text | ||
Line 1: | Line 1: | ||
- | ==How to process the | + | ==How to process the membership database== |
Processing the database requires UNIX scripts, which I ([[Brett Wuth]]) keep | Processing the database requires UNIX scripts, which I ([[Brett Wuth]]) keep | ||
on the PCSAR virtual machine. | on the PCSAR virtual machine. | ||
Line 10: | Line 10: | ||
running record of the last changes they've seen. | running record of the last changes they've seen. | ||
- | === | + | === Extract from wiki === |
- | + | {{rbw}} to do: optimize for speed (last run 37min) | |
- | + | ||
- | + | cd ~/sar/pc/membership/wiki-extract | |
- | + | time ./wiki-membership-database-get >db.out | |
- | + | mv db.out ../personnel-database.xml | |
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | === Merging Edits to Personnel Records === | |
- | + | ||
- | + | ||
cd ~/sar/pc/membership | cd ~/sar/pc/membership | ||
- | |||
+ | I may have made changes to my copy of the database at the same | ||
+ | time as Bob has. The changes need to be merged. | ||
+ | use: | ||
+ | rlog personnel-database.xml | head -20 | ||
+ | to find out what version I gave to Bob most recently (usually | ||
+ | latest). | ||
- | + | check in my changes: | |
- | + | rcsdiff personnel-database.xml | |
+ | ci -l personnel-database.xml | ||
+ | for 1.18 use whatever version Bob based his changes on: | ||
+ | c ~/tmp/personnel-database.xml . | ||
+ | rcsdiff -r1.18 personnel-database.xml | ||
+ | to see his changes | ||
- | + | make my edits to his changes. | |
- | + | ||
+ | rcsmerge -r1.18 personnel-database.xml | ||
- | * | + | * resolve any conflicts: |
- | + | ||
- | + | rcsdiff personnel-database.xml | |
+ | to verify only his changes have been propogated | ||
- | + | === validate === | |
- | + | ||
- | + | * Validate Edits to Personnel Records | |
- | * | + | validate |
- | + | (uses less) or | |
- | + | validation-report | |
- | + | ||
- | + | ||
- | + | Check my marked up copy of the call out list to see any changes | |
+ | that may be necessary. | ||
- | + | * Reconcile | |
- | + | make any necessary changes. | |
- | + | === check in === | |
+ | wuth@pcsar:~/sar/pc/membership$ ci -l personnel-database.xml | ||
- | ==== | + | === Tagged Percent === |
- | + | ||
- | + | ||
- | + | ||
- | * | + | * Prepare the TaggedPercent version: |
- | + | ||
- | + | ||
- | ==== | + | RecordTaggedPercentFieldsDefault -v FieldsFile=lib/RecordTaggedPercentFields.txt <tmp/personnel-database.not-validated >tmp/personnel-database.txt |
- | + | === Clean up old print jobs === | |
- | + | rm run/print-queue/* | |
- | + | ||
- | + | === call-out list === | |
- | + | * To Do: | |
- | * | + | |
- | + | ||
- | + | ||
- | * | + | |
- | + | ||
** commonize elements of {bin,lib}/{call-out,first-call} | ** commonize elements of {bin,lib}/{call-out,first-call} | ||
+ | * To print Call-out list for RCMP, [[FireHall]], Recorder, and CallOut Coordinator | ||
+ | wuth@pcsar:~/sar/pc/membership$ call-out-list-print | ||
+ | |||
+ | === first-call list === | ||
+ | * Print and deliver copy to Fire Hall, RCMP | ||
+ | wuth@pcsar:~/sar/pc/membership$ first-call-list-print | ||
- | |||
- | |||
* Fax to Fire Dispatch in Lethbridge -- not done any more | * Fax to Fire Dispatch in Lethbridge -- not done any more | ||
first-call-list-fax | first-call-list-fax | ||
+ | === personnel records === | ||
+ | * To print the individual personnel sheets: | ||
+ | wuth@pcsar:~/sar/pc/membership$ xslt <personnel-database.xml lib/MembersAndApplicants.xsl | changes-print recorder | ||
+ | wuth@pcsar:~/sar/pc/membership$ xslt <personnel-database.xml lib/MembersOnly.xsl | changes-print SARCAR | ||
+ | ** not RCMP because they no longer keep records | ||
+ | |||
+ | === mailing lists === | ||
+ | * To update the pcsar-board/pcsar-preplan mailing lists: | ||
+ | wuth@pcsar:~/sar/pc/membership$ mailing-lists-update | ||
+ | |||
+ | === e-mailed reports === | ||
+ | |||
+ | * e-mail to [[Training Coordinator]]: | ||
+ | wuth@pcsar:~/sar/pc/membership$ training-coordinator-send | ||
* Print/Send the Fan-Out list -- no longer done | * Print/Send the Fan-Out list -- no longer done | ||
fan-out-list-send | fan-out-list-send | ||
- | * Call | + | * Report on automatically detected policy issues: |
+ | ** additional policy checks | ||
+ | *** write policy check for voting member upgrade | ||
+ | *** write policy check for voting member currency | ||
+ | *** write policy check for sar fund currency | ||
+ | wuth@pcsar:~/sar/pc/membership$ policy-checks-email | ||
+ | |||
+ | * To E-Mail to SARA: | ||
+ | wuth@pcsar:~/sar/pc/membership$ sara-send | ||
+ | |||
+ | * To E-Mail to the agencies: | ||
+ | wuth@pcsar:~/sar/pc/membership$ first-call-send | ||
+ | |||
+ | * To E-Mail the call-out list: | ||
+ | wuth@pcsar:~/sar/pc/membership$ call-out-list-send | ||
+ | |||
+ | === printing === | ||
+ | * Personnel records: | ||
+ | lpr -Pofficejet8500 -o outputorder=reverse run/print-queue/*{recorder,SARCAR}* | ||
+ | * First Call List: | ||
+ | ** 1 copy (for binder) | ||
+ | lpr -Pofficejet8500 run/print-queue/*FirstCall* | ||
+ | * Call Out List: | ||
** for binder | ** for binder | ||
** for SARCAR | ** for SARCAR | ||
** for overhead box at firehall | ** for overhead box at firehall | ||
- | ** | + | ** for myself |
+ | ** 4 copies | ||
+ | lpr -#4 -Pofficejet8500 -o Collate=True -o outputorder=reverse run/print-queue/*CallOutList* | ||
+ | * To print the print queue: | ||
+ | print-queue-email-bob | ||
+ | ** (to Bob Costa) | ||
+ | ** or | ||
+ | print-queue-email | ||
+ | ** (to Roy Davidson) | ||
- | === | + | === etc === |
+ | * E-mail board list of member applicants | ||
- | + | <pre> | |
- | + | To: Pincher Creek SAR Board <pcsar-board@castrov.cuug.ab.ca> | |
- | + | Subject: membership | |
- | + | --text follows this line-- | |
+ | Hi All, | ||
- | + | This month there are two returning people that want to rejoin PCSAR: | |
- | + | Wanda Burchert and Claus Burchert. | |
- | + | ||
- | + | http://pcsar.dyndns.org:8080/mediawiki/index.php/Members:Claus_Burchert | |
+ | http://pcsar.dyndns.org:8080/mediawiki/index.php/Members:Wanda_Burchert | ||
- | ' | + | Please let me know if their memberships are approved. When you make a |
- | + | decision, could you please inform me by e-mail; just letting me know | |
- | + | in person during the training session, doesn't work very well because | |
+ | I don't always remember. | ||
- | + | Take Care, | |
+ | -- | ||
+ | Brett Wuth wuth@castrov.cuug.ab.ca wuth@acm.org | ||
+ | Box 1251-U, Pincher Creek, Alberta T0K 1W0, CANADA Tel:+1 403 627-2460 | ||
+ | OpenPGP FingerPrint=628F C9DA BDBC 2A0E 18F1 2F6A 3300 8422 BE6A 0E79 | ||
+ | What is the meaning of life?! Yes. | ||
+ | </pre> | ||
+ | |||
+ | |||
+ | * [[:Image:Members:Call Out List.pdf|Upload the Call Out List]] to the wiki. | ||
+ | * [[:Image:Members:First Call List.pdf|Upload the First Call List]] to the wiki. | ||
+ | |||
+ | * [http://iweb.castrov.cuug.ab.ca/mediawiki/index.php/Mediawiki#Syncing_user_list sync] the membership list with the wiki user list | ||
+ | ** rename/merge Charlene/Charleen Bruder | ||
==Non-monthly processing== | ==Non-monthly processing== | ||
Line 226: | Line 225: | ||
--text follows this line-- | --text follows this line-- | ||
Thanks for joining Pincher Creek SAR. Can you please check if I've correctly | Thanks for joining Pincher Creek SAR. Can you please check if I've correctly | ||
- | copied your | + | copied your membership record: |
---cut--- | ---cut--- |