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 ([[ | + | Processing the database requires UNIX scripts, which I ([[BrettWuth]]) keep |
- | on the PCSAR virtual machine. | + | on my laptop. |
+ | I'm migrating them to the PCSAR virtual machine. | ||
Unless you understand UNIX, you're not likely to understand much | Unless you understand UNIX, you're not likely to understand much | ||
Line 8: | Line 9: | ||
The scripts check for changes in the database, so they keep a | The scripts check for changes in the database, so they keep a | ||
- | running record of the last changes they've seen. | + | running record of the last changes they've seen. This running |
+ | record is currently on [[BrettWuth]]'s laptop. | ||
- | + | The Membership Coordinator e-mails me the database as | |
- | + | personnel-database.xml. [[BrettWuth]] is currently doing the data | |
- | + | entry on behalf of the vacant Membership Coordinator position. | |
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | + | Copy my working directory from my laptop to the PCSAR | |
+ | '''only if''' my laptop is more up to date. | ||
+ | wuth@macbook:~/sar/pc/membership$ rsync -avz . wuth@pcsar:sar/pc/membership | ||
- | |||
- | + | === Merging Edits to Personnel Records === | |
- | + | ||
+ | cd sar/pcsar/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 | |
+ | wuth@pcsar:~/sar/pc/membership$ validate | ||
+ | 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 === |
- | + | ||
- | + | ||
- | + | ||
- | + | Update the "includes changes" date comment at start of the | |
- | + | file: | |
- | + | ||
- | + | 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 | |
- | + | ||
- | |||
- | |||
- | + | === call-out list === | |
- | * | + | * To Do: |
- | ** | + | ** 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 | |
+ | 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 | |
- | + | xslt <personnel-database.xml lib/MembersOnly.xsl | changes-print SARCAR | |
- | + | ** not RCMP because they no longer keep records | |
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
=== copy to Brett's laptop === | === copy to Brett's laptop === | ||
Line 189: | Line 110: | ||
wuth@macbook:~/sar/pc/membership$ scp -p wuth@pcsar:sar/pc/membership/tmp/personnel-database.txt tmp | 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$ rm -r run | ||
- | wuth@macbook:~/sar/pc/membership$ scp - | + | wuth@macbook:~/sar/pc/membership$ scp -p wuth@pcsar:sar/pc/membership/run . |
</pre> | </pre> | ||
+ | |||
+ | === etc === | ||
+ | * e-mail to [[TrainingCoordinator]]: | ||
+ | training-coordinator-send | ||
+ | |||
+ | * Print/Send the Fan-Out list -- no longer done | ||
+ | fan-out-list-send | ||
+ | |||
+ | * Report on automatically detected policy issues: | ||
+ | policy-checks-email | ||
+ | |||
+ | * To update the pcsar-board/pcsar-preplan mailing lists: | ||
+ | mailing-lists-update | ||
+ | |||
+ | * To E-Mail to SARA: | ||
+ | sara-send | ||
+ | |||
+ | * To distribute the First Call List: | ||
+ | first-call-list-pdf ~/tmp/PincherSARFirstCall.pdf | ||
+ | <pre> | ||
+ | To: pcsar-firstcall@castrov.cuug.ab.ca | ||
+ | Subject: Pincher SAR First Call List | ||
+ | |||
+ | Hi, | ||
+ | |||
+ | Please find attached Pincher Creek Search and Rescue's (PCSAR) current | ||
+ | First Call List. This list is provided for agencies that initiate | ||
+ | requests to PCSAR or relay those requests from other areas. | ||
+ | |||
+ | For details on PCSAR's incident notification, see: | ||
+ | |||
+ | http://pcsar.webhop.org/emergency.html | ||
+ | |||
+ | Thank you for your participation in this process. | ||
+ | </pre> | ||
+ | * E-mail call out list: | ||
+ | <pre> | ||
+ | To: PCSAR Emergency Callers <pcsar-caller@castrov.cuug.ab.ca>, | ||
+ | Pincher Creek SAR Board <pcsar-board@castrov.cuug.ab.ca>, | ||
+ | PCSAR Preplan Committee <pcsar-preplan@castrov.cuug.ab.ca> | ||
+ | Subject: Call Out List | ||
+ | |||
+ | FYI, | ||
+ | |||
+ | Please find attached the current call-out list. | ||
+ | </pre> | ||
+ | |||
+ | === printing === | ||
+ | * Personnel records: | ||
+ | lpr -Pofficejet-pcsar -o outputorder=reverse run/print-queue/*{recorder,SARCAR}* | ||
+ | * First Call List: | ||
+ | ** 1 copy (for binder) | ||
+ | lpr -Pofficejet-pcsar run/print-queue/*FirstCall* | ||
+ | * Call Out List: | ||
+ | ** for binder | ||
+ | ** for SARCAR | ||
+ | ** for overhead box at firehall | ||
+ | ** for myself | ||
+ | ** 4 copies | ||
+ | lpr -#4 -Pofficejet-pcsar -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) | ||
+ | |||
+ | ==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. | ||
===To prepare a list of addresses and phone numbers of all our members=== | ===To prepare a list of addresses and phone numbers of all our members=== | ||
Line 226: | Line 218: | ||
--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--- | ||
Line 241: | Line 233: | ||
Alberta T0K 1W0, CANADA Tel:+1 403 627-2460 pgp-public-keys@uit.no | 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. | has mine; Print=E4F8EDEECBE01AD2FA3D8B2D94B1A292 What is the meaning of life?! Yes. | ||
- | < | + | <pre> |
===To print the participation dates=== | ===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 | 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 |