Clean-up Full-time faculty webpages

 Problem Description : 

Once a semester run script to archive web folders for full-time faculty that are no longer active.

 Resolution : 

1. In Toad, open FTfacultySED.sql located at \\falcon\d$\batch\faculty. This pulls all active FT Faculty and puts it in sed format to delete matching lines ( i.e. /jdoe/d )

2. Export data as text and save as ftfac_active.sed under \\falcon\d$\batch\faculty

3. If you need to add exclusions to prevent specific Faculty web folders from being deleted that are not in the sed file created in step #2, open file \\falcon\d$\batch\faculty\man_exclude_dir.sed in notepad and add folder names - one per line - using the sed delete pattern command ( i.e. /jdoe/d )

3. Logon onto Falcon and double-click on the batch file clean_up_faculty.bat located at d:\batch\faculty

4. This batch will move (non active) faculty web folders to d:\facweb_archive and then zip them up.

5. Open d:\facweb_archive to verify that zip folders have been created for all faculty that were moved. 

6. Finally, delete all folders under d:\facweb_archive (leaving the zipped faculty web archives)

Summary of important files created from this process for reference...

ftfac_active.sed - sed script file created when exporting active faculty using SQL in Step #1 above

ftfac_dir.txt - list of current faculty web folders at d:\inetpub\wwwroot\Faculty. Created when batch is run.

man_exclude_dir.sed - sed script file that contains folders that should be excluded from archiving. This file is updated manually when needed.

currentfac_exclude.sed - sed script file created when batch is run that combines ftfac_active.sed and man_exclude_dir.sed into this one file.

remove_fac_list.txt - file created when batch is run which contains all faculty folders that need to be archived. File ftfac_dir.txt is run through sed script file currentfac_exclude.sed to remove exclusions and active faculty.

 Revision Date : 9/3/2015