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 11: | Line 11: | ||
=== Pending edits === | === Pending edits === | ||
- | Check my | + | Check my marked up copy of the call out list to see any changes |
- | may be necessary. | + | that may be necessary. |
+ | |||
=== Extract and validate === | === Extract and validate === | ||
Line 26: | Line 27: | ||
**** E-mail me when a page I'm watching is changed | **** E-mail me when a page I'm watching is changed | ||
**** E-mail me also for minor edits of pages | **** E-mail me also for minor edits of pages | ||
- | ** ( | + | ** (recheck) validate Activities upon edit |
*** Add [[Activities]] to PCSARBot's watchlist | *** Add [[Activities]] to PCSARBot's watchlist | ||
*** uses .procmailrc | *** uses .procmailrc | ||
*** uses script ~bot/sar/pc/membership/bin/wiki-membership-activities-validate to update [[Activities/Report/wiki-membership-activities-validate]] | *** uses script ~bot/sar/pc/membership/bin/wiki-membership-activities-validate to update [[Activities/Report/wiki-membership-activities-validate]] | ||
*** amend script to output errors with contextual lines | *** amend script to output errors with contextual lines | ||
- | ** validate each | + | ** validate each Membership Record upon edit |
- | *** ( | + | *** (recheck) write script to validate just member passed |
**** see ~bot/sar/pc/membership/bin/wiki-membership-member-validate | **** see ~bot/sar/pc/membership/bin/wiki-membership-member-validate | ||
**** Use "{{member|Brett Wuth}}" as experiment | **** Use "{{member|Brett Wuth}}" as experiment | ||
- | *** ( | + | *** (recheck) update all memrec pages to include validation report |
**** define as part of memrec template | **** define as part of memrec template | ||
*** develop trigger on memrec changes | *** develop trigger on memrec changes | ||
**** develop dispatch on changes to individual memrec or Activities | **** develop dispatch on changes to individual memrec or Activities | ||
***** (recheck) create trial watch on my mem record ({{member|Brett Wuth}}) | ***** (recheck) create trial watch on my mem record ({{member|Brett Wuth}}) | ||
- | |||
***** ''currently uses exact match on page name in .procmailrc | ***** ''currently uses exact match on page name in .procmailrc | ||
- | |||
***** develop mechanism to register dispatch for page, what script to run | ***** develop mechanism to register dispatch for page, what script to run | ||
****** ''on wiki itself | ****** ''on wiki itself | ||
Line 49: | Line 48: | ||
****** ''single page [[Members:PCSARBot/Watches]] | ****** ''single page [[Members:PCSARBot/Watches]] | ||
******* ''each line like:'' <code><nowiki>* [[pagename]]: script</nowiki></code> | ******* ''each line like:'' <code><nowiki>* [[pagename]]: script</nowiki></code> | ||
- | ******* ''with possible duplicates of pagename | + | ******* ''with possible duplicates of pagename |
- | ****** ( | + | ****** '''(next)''' scripts to add/remove watch scripts |
- | + | ****** dispatch scripts from page that changed | |
- | + | ****** unwatch pages if no script | |
- | + | ||
- | ****** | + | |
- | + | ||
- | + | ||
- | ****** | + | |
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
**** develop watch on memrec category | **** develop watch on memrec category | ||
***** add new pages | ***** add new pages | ||
***** delete removed pages | ***** delete removed pages | ||
- | |||
*** allow Members: page to transclude report from another Members: page | *** allow Members: page to transclude report from another Members: page | ||
*** when [[Activities]] changes, reprocess all Members | *** when [[Activities]] changes, reprocess all Members | ||
Line 92: | Line 73: | ||
=== Process === | === Process === | ||
- | |||
- | |||
- | |||
* <big>'''make sure current ssh-agent authority is extended'''</big> | * <big>'''make sure current ssh-agent authority is extended'''</big> | ||
ssh -AX wuth@localhost | ssh -AX wuth@localhost | ||
Line 101: | Line 79: | ||
* prints copies for myself | * prints copies for myself | ||
- | * sends | + | * sends membership list (names only) to [[Members:Protocols/Shell H2S/Global Training|Global Training for validation of H2S Alive course registration.]] |
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
d4h-web-interface.py user:pcsard4hbot@pcsar.ca.d4h.org membersImport | d4h-web-interface.py user:pcsard4hbot@pcsar.ca.d4h.org membersImport | ||
Line 115: | Line 87: | ||
wiki-extract | wiki-extract | ||
- | d4h-web-interface.py user:pcsard4hbot@pcsar.ca.d4h.org | + | d4h-web-interface.py user:pcsard4hbot@pcsar.ca.d4h.org exercisesAttendanceImport |
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
+ | rapid-notify-post | ||
** sometimes fails at initial log in and has to be restarted | ** sometimes fails at initial log in and has to be restarted | ||
** takes ~65 minutes to run | ** takes ~65 minutes to run | ||
*** see {{subpage|Rapid Notify}} | *** see {{subpage|Rapid Notify}} | ||
- | |||
* To Do: {{rbw|as used}} | * To Do: {{rbw|as used}} | ||
** additional policy checks | ** additional policy checks | ||
Line 158: | Line 125: | ||
=== sync wiki accounts === | === sync wiki accounts === | ||
- | * [http://iweb.castrov.cuug.ab.ca/mediawiki/index.php/Mediawiki#Syncing_user_list sync] the | + | * [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 | ** rename/merge Charlene/Charleen Bruder | ||
** Extract list of users currently with "Member" status | ** Extract list of users currently with "Member" status | ||
*** http://pcsar.dyndns.org:8080/mediawiki/index.php?title=Special:Listusers&limit=500&group=Members | *** http://pcsar.dyndns.org:8080/mediawiki/index.php?title=Special:Listusers&limit=500&group=Members | ||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
==Non-monthly processing== | ==Non-monthly processing== | ||
Line 226: | Line 183: | ||
--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--- |