Brook Hatch’s Internship Worklog
Table of Contents

Fall Quarter 2000	2
Mon., October 09, 2000	2
Wednesday, October, 11, 2000	2
Mon., October 16, 2000	2
Thursday, October 19, 2000	2
Mon., October 23, 2000	2
Thursday, October 26, 2000	3
Sat., November 4, 2000	3
Mon., November 06, 2000	3
Sat., November 11, 2000	3
Mon., November 13, 2000	3
Wednesday, November 15, 2000	3
Sat., November 18, 2000	3
Tuesday, November 21, 2000	4
Wednesday, November 29, 2000	4
Sat., December 02, 2000	4
Mon., December 04, 2000	5
Wednesday, December 06, 2000	5
Thursday, December 8, 2000	5
Friday, December 08, 2000	5
Tuesday, December 12, 2000	5
Thursday, December 14, 2000	5
Winter Quarter 2001	5
Mon., January 08, 2001	5
Tuesday, January 09, 2001	5
Wednesday, January 10, 2001	6
Thursday, January 11, 2001	6
Tuesday, January 16, 2001	6
Wednesday, January 17, 2001	6
Thursday, January 18, 2001	6
Friday, January 19, 2001	6
Mon., January 22, 2001	6
Tuesday, January 23, 2001	7
Thursday, February 01, 2001	7
Friday, February 02, 2001	7
Sat., February 03, 2001	7
Mon., February 05, 2001	7
Tuesday, February 06, 2001	7
Thursday, February 08, 2001	8
Friday, February 9, 2001	8
Mon., February 12, 2001	8
100/0	8
Mon., February 12, 2001	8
Tuesday, February 13, 2001	8
Wednesday, February 14, 2001	8
Thursday, February 15, 2001	9
Mon., February 19, 2001	9
Tuesday, February 20, 2001	9
Wednesday, February 21, 2001	9
Thursday, February 22, 2001	9
Friday, February 26	9
Mon., February 26, 2001	9
Tuesday, February 27, 2001	9
Wednesday, February 28, 2001	9
Thursday, March 1, 2001	9
Friday, March 02, 2001	9
Sat., March 03, 2001	10
Mon., March 05, 2001	10
Tuesday, March 06, 2001	10
Thursday, March 08, 2001	10
Friday, March 09, 2001	10
Sat., March 10, 2001	11
Mon., March 11, 2001	11
Tuesday, March 11, 2001	11
Thursday, March 22, 2001	11
Friday, March 23, 2001	11
Spring Quarter 2001	12
Week 1 Mon. Apr. 2 to Sat., Apr. 07	12
Week 2 Mon. Apr. 9 to Sat., Apr. 14	12
Week 3 Mon. Apr.16 to Sat. Apr. 21	12
Week 4 Mon. Apr. 23 to Sat. Apr. 28	13
Week 5 Mon. Apr. 30 to Sat. May 5	13
Week 6 Mon. May 7 to Sat. May 12	13

Highlighted entries are days I worked on SOS stuff

Fall Quarter 2000
Mon., October 09, 2000
Fixed by reinstalling and configuring Front Page 2000 Server extensions on Scidb
Created bcd_design Interdev project
established connectivity to afore mentioned project from Mazama and Duwamish
ordered Photoshop 6 from Marshall Robinson
ScidbLab 100%
Wednesday, October, 11, 2000
Meeting at ICAN - BCD requirements & assignments
Researchers-David
Study Sites-John
Glossary-Steve/Lisa
Funding Sources-David/Steve (partially obtained from citations)
Communication/links/meetings-David
Newsletters-David
Citations-Steve
Popular Articles-Steve/David
Images (slide/video)-David 
Access Methods-Nalini/David
Equipment-Nalini/David
Damage to Sites/Trees-Nalini/David
Accidents-Nalini/David
Safety Protocols-Nalini/David
Training Programs-Nalini/David
Education-David
Copied ASP files to \\coyote - tested ODBC connection - pages fail because global.asa is not in the root web. Requested replacement Palm Pilot from Palm, Inc.
ScidbLab 100%
Mon., October 16, 2000
BCD - Slidedb - I have established that it is possible to display OLE objects on a form. The assignment of 
slides requires a tedious manual technique. Dynamic updating of lookup fields requires writing an event procedure in VB. This is a convenience issue. The database is usable as is. David (Nalini’s intern) has started inputing data. It turns out that the solution offered by media services is not suitable.
Backed up canopy database on lambda at starling. Copied backup files (db and asp) to \\duwamish
ScidbLab 100%
Thursday, October 19, 2000
Upgraded \\mazama with current version of McAfee VirusScan.
Scanned \\scidb - found one infected word file - reloadplan.doc - I’ll have to kill it and retype the doc.
Built a virus scan script for mazama, duwamish, kermit, and scidb on mazama. Testing it. 
Transferred ASP files to new Emerald directory. Tested - Encountered ODBC error. Will test Mon..
ScidbLab 100%
Mon., October 23, 2000
Tested ODBC with Steve Dublin. Discovered that Coyote has an older version of MDAC - Data Access 
Components. Steve said he needed to update it anyway. Worked on SOSWEB.
ScidbLab 100%
Thursday, October 26, 2000
Steve was constrained from upgrading MDAC on Coyote by Dave Metzler. Briefly discussed contingency plans with Eric. One idea would be to host both the production ASP and the development ASP on SCIDB. We still use kokanee to host the DB, and backup the ASP files to masu.
Finished cleaning \\kermit for it’s incipient reload - I believe Erik wants to load Win2K Pro on this machine. 
Worked more on SOSweb - implemented a stylesheet and cleaned up the look and feel on many pages. Still need to treat the rest of 1999-2000 with the new look. Need to change the image map in Photoshop - I’ll have to do that at home since Marshall is still on vacation and we can’t order Photoshop from him. I wonder if we could buy it from the bookstore and charge it to the NSF budget? It’s the same price - around $200. Also need to fix broken links all over the place and continue “yearifying” the date dependent content. 
ScidbLab 50%. SOS 50%
Sat., November 4, 2000
Due to midterms and incipient madness, I worked 9 hours today. Here’s what I did:
Installed Win2k on Kermit (accident), uninstalled Win2k on Kermit. Installed Win2k on Duwamish, worked more on SOSweb.
My production site is now available for viewing. I’m still working on 2000 and 1997. I have finished 1995. Bibliography is ready, Links, and Contacts as well. 1997 is almost complete. There are a few more broken links to fix.
Here is the URL: http://scidb.evergreen.edu/sosweb 
ScidbLab 50%. SOS 50%
Mon., November 06, 2000
Installed software on Duwamish
Fixed ACL problem on Erik’s shared directory on Scidb
Worked on SOSweb.
Fixed Vworlds installation on Duwamish - needed a patch from vworlds.org.
Wrote this work log.
ScidbLab 50%. SOS 50%
Sat., November 11, 2000
Updated document collection on SciDB. Finished SOSweb (still needs project descriptions).
 Did WebDocs design session with Erik.
ScidbLab 50%. SOS 50%
Mon., November 13, 2000
Worked on Webdocs website.
ScidbLab 100 %
Wednesday, November 15, 2000
ICAN meeting. Informal interview with Terrence Swain, prospective Lab Administrator successor.
ScidbLab 100 %
Sat., November 18, 2000
Because EasyCD creator software is incompatible with Win2K, I moved CDR drive to SciDB. 
Moved CDROM drive from Mazama to Duwamish. Installed Photoshop 6.0 on Duwamish. Updated Inventory database. Helped Erik with some VBS stuff in Emerald.
ScidbLab 100 %
Tuesday, November 21, 2000
Did some troubleshooting to discover why add template page was generating an ODBC open fail error 
message. It turns out that ODBC on coyote is a different version that doesn’t support multiple db opens. Erik is working with Dave Metzler to solve this one.
Corrected frmUpdate_Project.asp and frmAddtoSystem.asp on Scidb web files, solving bug #001039. 
Made changes to SOSweb on scidb per Judy’s change request document: 
•	Created descriptions for remaining projects. I have no content whatsoever for Muadib and I’m not satisfied by my mostly inadequate descriptions. I did add some graphics to the page to spruce it up.
•	Changed program description on main (home.html) page.
•	Edited bibliography page - I didn’t generate the content for this, I think it was one of the SOS students who was only taking seminar and works for a local game software company. I forget her name.
•	Added OGI link. I couldn’t find the UW lecture series, so I made a link to “UW colloquia on demand.”
•	Changed contact information.
•	Changed 1999-2000 link to program description to full year’s prospectus. Pam doesn’t have previous years program descriptions.
•	I wasn’t sure if you were referring to the “Moving Edge Colloquium” when you wrote “Check with doug schuler to see if this forum still exists.  But if you don’t hear from him, just Put the notes on a forum and its address off the main page. So I did not email him.
•	Fixed 1995 photo page
•	Added 1999 photo page on 1999 index page - also reorganized the page a bit for visual aesthetics and conceptual clarity. *sing it!*
•	Contacted Kane of Photo Services and made an informal appointment to pick out some photos from the tower of babel team building experiment to post on the site.
ScidbLab 10 %, SOS 90%
Wednesday, November 29, 2000
ICAN meeting - assigned photoshop retrieval duty.
Installed new copy of Photoshop 6 to David’s computer
CDR burn test failed on SCIDB - reinstalled software and patch. Burn test succeeds.
Looked over SOS photos in Photo Services. Picked out four tower, three software fair, and one group pic. I was informed that scanning the pics will cost $5 each. That’s eight pictures for a total of $40.  I told them to hold off until I figure out where the money is coming from. Judy?
Restored canopy, db17, db19, db31 to kokanee.
Made changed ODBC connection on SCIDB. Initial tests succeeded, but web test failed. Ended up having to reboot scidb to flush its caches after repeated attempts to reset the ODBC connection back to point at localhost.
ScidbLab 80 %, SOS 20%

Sat., December 02, 2000
Fixed secondary drive chain ribbon disconnected problem on duwamish. Mucked around with the printer 
jam problem. I cannot fix this, it’s a mechanical problem. Thing is, if we send this in for repair, we’ll be without a printer for an unknown period. I guess that’s all right though.
Fixed ODBC connection to kokanee. http://scidb.evergreen.edu/canopy now accesses asp files on scidb and the database on kokanee.
Backed up db dumps, canopydocs, archived data from scidb to masu.
ScidbLab 100%
Mon., December 04, 2000
Started gathering data for the inventory db. Sent request for electronic format pictures to Kane at TESC Photo Services. Read email.
50/50
Wednesday, December 06, 2000
ICAN meeting.
Created new SQL Server db: bibdb for Peter. He was encountering problems with db bib-db “-“ in db name. Created login, ODBC connection on Duwamish.
Bought a zip disk and delivered it to Photo Services for SOS scanned pics.
Put in work order for printer repair.
90/10
Thursday, December 8, 2000
Worked on a problem Peter is stuck with. A new db in MSSQL with a new table is reported as not existing when doing queries against it. I tried sp_changeobjectowner to dbo, but I get the same error message - object doesn’t exist. It does indeed exist. It’s in a list of tables in that database in SQL server manager. I emailed Casey at Starling after fruitless queries to the MS KB online and other documentation. I can also ask James Gutholm and try it on the Kokanee DB server.
100 /0
Friday, December 08, 2000
Wrote rough draft lab admin position.
Created SOS project description doc.
50/50
Tuesday, December 12, 2000
Reinstalled and updated McAfee virus scanner on Mazama.
Virus scanned all volumes on \\scidb, \\duwamish, \\catbox, and \\mazama - found numerous instances of a word macro viruse - cleaned all instances. 
Installed DirectX 8 on Duwamish and Mazama.
Interviewed Terence.
Met with Judy, Peter, Erik, and Neil re: BCD web functional and nonfunctional requirements.
100/0
Thursday, December 14, 2000
Seminar meeting, posted SOS pics, backed up and posted site to coyote. Helped Erik do a screen capture of the BCD.
50/50

Winter Quarter 2001
Mon., January 08, 2001
Posted edited SOS program descriptions to coyote. Edited grammar and spelling of Erik’s BCD 
specification.
40/60
Tuesday, January 09, 2001
Responded to emails.
100/0
Wednesday, January 10, 2001
Fixed Steve Rentmeester’s laptop network connectivity problem. Wrote internship contract. Provided feedback to Peter on search engine algorythms.
100/0
Thursday, January 11, 2001
Worked with Peter on HTML and Javascript functionality.
100/0
Tuesday, January 16, 2001
Discovered vforest pages linked to content on \\phage. Shored up this weakness by moving phage content to \\coyote and editing links.
Deleted old SQL backups from \\scidb.
Archived db dumps to \\masu
Zipped canopydocs.
50/50
Wednesday, January 17, 2001
ICAN meeting. Helped David with his HTML paradigm. Conferenced with Erik on what I’ll be working on. Mucked about with ResearchContacts.asp on BCD ASP. I need to get together with Neil to work up some coding standards.
BCD ASP - Moved menu bar text to include file. Edited person.asp and researchcontacts.asp to use the include rather than tons o' html on the page. Tried to reformat code layout so as to have all the vbscript on top followed by the HTML. I couldn't pull out the nested loop without destroying  the pages function.
100/0
Thursday, January 18, 2001
MSSQL on \\scidb generating error messages on table open from SQL Enterprise Manager. I will 
troubleshoot it tomorrow afternoon, perhaps by reinstalling it. I need to backup bcd_design db before doing anything.
BCD ASP - Implemented menu bar include on all pages except deeper nested pages like canopyworld. Also added a dynamic title and .css link. No .css file exists yet.
100/0
Friday, January 19, 2001
MSSQL - Contacted Casey and Laura at Starling to ask about SP3 - Laura recommended it and helped me figure out a good plan of action. Reinstalled MSSQL7, added SP3, restored canopy, db17, db19, db31, bcd_design. I ran into problems setting up user canopy_dev for db31 because I couldn’t clear out the user prior to initializing it - there are four tables owned by the user I was trying to delete. I was unable to use sp_changeobjectowner on these tables. I could do it successfully on the db copy on \\kokanee though. I emailed James Gutholm a request to copy a dump of db31 for me to restore on scidb. 
Installed SP3 on all the windows boxes thereby solving the error message Erik was getting on his machine when trying to open a table.
100/0
Mon., January 22, 2001
Restored DB31 from \\kokanee. Discussed db access with James Gutholm. Overhauled BCD ASP with formatting and .css references. Did some troubleshooting on a sudden and fleeting ODBC error on \\scidb. Need to test tomorrow.
100/0
Tuesday, January 23, 2001
Created bcd demo site. Created graphics for it. Created a db for Erik and restored his db into it. Added a user.
100/0
Thursday, February 01, 2001
I’m back after being sick and getting stuck in Seattle with a dead car. Met with Judy - discussed BCD front end design ideas for showing the crew. Performed troubleshooting on Keri’s laptop. After discussion with Erik, decided to nuke the OS and install WinME. This should be much more stable and compatible with integrated hardware. Proceeded to do the above on the aforementioned laptop. 
100/0
Friday, February 02, 2001
Helped Steve Dublin get his state vehicle back to motor pool in Lacey. Integrated Neil’s back end pages in BCD with GUI pages - person, citations, contacts. Installed Interdev on scidb.
100/0
Sat., February 03, 2001
Created share \\scidb\links to hold files referred to in \\scidb\links\emerald_devforms.mdb which I also 
created today. This one of the widgets for data entry. It’s functional, but ugly - still need to do person and logs. However, Canopy researches are welcome to copy the db from the above link to their local machines and start putting in URLs. I will be updating the db with more capabilities on Mon. afternoon. Created  ODBC update procedure to dynamically create DSN and refresh link tables.
100/0
Mon., February 05, 2001
Agonized for long moments over a bizarrely intermittent error in emerald_devforms.mdb with Steve R. In 
a form, default entry is dynamically provided. The user enters some text at the end of that, goes to next record, goes back and just the text in that box that they entered is missing from the record. I can’t reproduce it reliably though. It’s not a showstopper, so I told . I’ll talk to Steve D. about it. Created widgets for data entry to accidents and tree damage. I also gave the main  switchboard some polish. Fixed home.asp by creating another menubar include file. Discovered that researchcontacts displays no text in Netscape. Curious. The html shows up when you get source. Erik speculates that it’s a path to the .css file problem. Will investigate as time allows. Meanwhile, it appears that we are leaning toward mozilla as our target browser.
100/0
Tuesday, February 06, 2001
BCDdevforms.mdb - Removing repaint command in update macro seems to have solved the form problem mentioned above. Fixed bug preventing delete record command - I ripped out the event procedure which is auto generated by Access for that and replaced it with delete record macro. Added browse button on URL form to open Windows Explorer to the UNC path to scidb in the correct folder for data entry people to put html files. I did it quick and dirty - path to executable = c:\windows, executable = explorer.exe. I added a field to URLtype in BCD SQL db to hold UNC paths. This button will not work on Winnt - no c:\windows dir. It also will not work on machines where the windows directory lives on another drive letter for the same reason as above. 
Archived the copies of the db to \\scidb\canopydocs\bcd  Made a .mde version and put it in \\scidb\links - all users can share this one copy and run it from there.
BCD ASP - logged two bugs in tutos (http://kermit.evergreen.edu/tutos/) and worked on them with Neil.
100/0
Thursday, February 08, 2001
BCD - All display pages now conform to a new standard. The displaying page
starts out with a <table>, the inc_menu_bar then does a <table> and closes its table at the end of the page. The display page does a  <table> and finally closes this table and the first one. Also,  @language declaration now appears in inc_menu_bar. This should be the only place it exists.
This fixed the errors I logged in tutos.
100/0
Friday, February 9, 2001
Made a copy of the emerald webgem in purple, put it on the menu bar. Rreworked all the display pages for aesthetics. Assisted Steve R. with an append query problem in Access - turns out the one of the data types was wrong.
100/0
Mon., February 12, 2001
Demonstrated BCD website. Worked on configuring hardware drivers on new machine \\fishstix. Installed Access 97 and Office 2000.
100/0
Mon., February 12, 2001
Added Curriculum Vitae edit form to bcdforms. I had to change the db slightly and I should talk to Erik 
about the impact. Created prototype new gem and concept sketch for BCD logo.  Met with Erik and Neil to discuss current tasks - 
	Graphics and Icons for BCD 
	Work on Canopy World - DB it.
	Change some page layouts and data formats as pointed out during the walkthrough.
	BCD data entry widgets - citations 
100/0
Tuesday, February 13, 2001
Worked with Erik on getting cv form in bcdforms.mdb to update to person_cv table. This was unsuccessful. 
Apparently Access doesn’t like to post via ODBC values to tables which have autonum fields. This is senseless because it works fine for other tables with autonum fields. I will see if Steve Dublin or James Gutholm can help me out.
100/0
Wednesday, February 14, 2001
ICAN meeting - need to get canopy group from CAL domain and apply to permissions on <\\scidb\links> .
Gave (ICAN) David a tutorial on resizing images for the web with macros. Also did some analysis of the ICAN website which he is creating in Microsoft Publisher. He’s using layers, so the consequence is incredibly huge Publisher files and fairly hefty images slices. This might cause future difficulties in administration. It is ideal for him to be working with a GUI HTML editor. He’s pretty comfortable with Publisher, but I would have liked to see him use Macromedia Dreamweaver. I use it, so it’s easier for me to support him with it. Dreamweaver produces pure HTML making it much more likely to be compatible.
I will create a widget for species data when I get some specs from Steve R.
100/0
Thursday, February 15, 2001
Set up <\\mazama> as a file and print server (headless). James Gutholm unlocked the printer for me. He also helped me fix the update query for cv join table. Insert is the correct sql command, not update, and I was using incorrect parameter data. 
Helped Erik write a letter of rejection to Terence for my position.
I have now filled my 20 hours for the week. I’m going skiing. See you all Tuesday.
100/0
Mon., February 19, 2001
Skiing
0/0
Tuesday, February 20, 2001
Dentist Appointment - drilling, reaming, etc.
0/0
Wednesday, February 21, 2001
Hello Codeine!
0/0
Thursday, February 22, 2001
Caught up on email. Picked up software from EME. Discussed XML with Peter. Talked to Steve R. about the three REU positions. 
100/0
Friday, February 26
Built new BCD logo and deployed it.
100/0
Mon., February 26, 2001
Revamped all pages. Set up Canopy world as a dynamic ASP. I just need to do the data entry and I’ll have sites to display.
100/0
Tuesday, February 27, 2001
Brushed up bcdforms.mde. Discovered 6000 char field in Citations title field on emerld_design db. Worked on Citations, Glossary, Person_CV widgets. Helped David (ICAN) recreate a graphic with text for a publication. Discussed DB design with Peter, Steve D., Neil, and Terence. Submitted timesheets. Left voicemail for John Cushing about laptop pickup. Wrote a support email to Judy regarding Windows performance.
 100/0
Wednesday, February 28, 2001
Earthquake. Campus buildings off limits.
0/0
Thursday, March 1, 2001
Campus buildings off limits.
0/0
Friday, March 02, 2001
 I'm having some trouble with Person_CV - my form updates a link table - two foreign keys, one doing double duty as a primary key. I'm using a combo box to select a person (from Party table) to associate with a URL id. I have an update query that works to put parameter values into the link table, but I'm not sure how to invoke the query with values - I suppose a macro invoked on update or on change is the appropriate choice. Also, I'm having trouble binding the combo box on the form. The way it's broken now is that I can pull up a value, but it stays the same for every record. I had scheduled some time to troubleshoot it with Steve Dublin for the day of the earthquake, but, well, everything went to you know where in a hand basket. I'll try and get his attention early next week. I'll be in here on Sat. and perhaps Erik will be around also. I'm working on adding citation and glossary data entry forms.
I converted the static pages to a front end for Canopy World. I need to input the data for the sites. I suppose I'll need to make a widget for that at some point, but I don't know what the priority is for that. The way I understand the projected format for the world sites image map is a hierarchical, drill down, several layers deep thing culminating an ordinary page of generated text. 
I'm much happier with the look of the site now that I've tamed the unruly tables (for the most part - still have three pages that won't left justify for no apparent reason).
100/0
Sat., March 03, 2001
Entered site data, made form for editing it. Verified URLs for all the sites, fixed Canopy world so image map links, links below image map, and matrix links all point to the correct site id. Emailed Bonnie a copy of bcdforms.mdb. Downloaded a series of map images to use for the world map image map.
In regards to handing off Judy’s laptop to John, I talked to Russ on the phone and let him know that I don’t have the dongle or power supply yet. I do have Endnote. If I can’t get the hardware on Mon., I’ll have to give John the laptop anyway. I suppose I can mail the hardware when it comes in.
100/0
Mon., March 05, 2001
Talked to Steve R. and Erik about new job openings for the BCD. Generated a quote for two new 
machines. Picked up Gateway laptop accessories. Installed Endnote and fixed Visio on Judy’s laptop. Called Russ, he agreed to pick up the laptop around 10am tomorrow.
100/0
Tuesday, March 06, 2001
Dentist - root canal - ouchie!
0/0
Thursday, March 08, 2001
Discussed current status with Erik. My goal is to finish up the drill down image map for canopy world before I leave for Ireland Wednesday. Removed default letter A look up on ResearchContacts page. Fixed formatting on citations page - added column for icons, bold on author name, italics on year. Added canopy access citations to canopy access page. Added Academic programs to link types along with a folder in link directory for storing web files. Backed up SQL server DBs to Masu. Backed up canopydocs and ASP files to Masu in the form of zip files. Worked with Steve Dublin on BCD forms. I can insert valid data into Person_CV, but a select query based on Person_CV and Party, will not allow me to insert or update Person_ID on Person_CV. I’m planning on asking some Starling people for help. If nothing works, I’ll go to implementing a web form using DAO and Stored procedures.
100/0
Friday, March 09, 2001
Built new image map and drill down maps. Created canopy crane icons. Revamped aforementioned for 800 x 600 users. Replaced off green place holders on menu bar with transparent ones. Testing in Netscape reveals that smallest size of text used is nearly unreadable. No problems in Mozilla. Consolidated a stylesheet class by discontinuing usage of smallest font class. 
100/0
Sat., March 10, 2001
Tightened file permission security on \\scidb - created an ac_computing user group with with Peter, Neil, Erik, me, Steve Dublin, Mike Ficker, and Judy. Added this group to all shares on \\scidb and took away the “everyone” share on everything. Verified webshares: /bcd, /, canopy, /webdocs.
Discussed with Erik the prospects of creating a data entry website. NT auth would probably be the best method to process login on this hypothetical site.
100/0
Mon., March 11, 2001
Recursive permission assignment denied developers access to web project files. Fixed with a variety of techniques listed in the following KB articles: q165834, q220166, q272289, q230777, q199003, q165894, and use of ‘cacls’ command to give recursive system account and administrator account to all hard drives.  Renewed previous shares and permissions, yet was unsuccessful in allowing devs access to web files until I made them all administrators of \\scidb. This seems to me to be using a shotgun when a pellet gun should suffice
100/0
Tuesday, March 11, 2001
After mulling over the problem above, I believe the key lies in giving iwam_scidb account full access to appropriate web shares and to vti_bin\ on c: However, I am loathe to change anything now that things are back to nominal status, especially because I’m leaving for a couple of weeks.  I don’t like trusting my coworkers not to do the stupid crazy stuff I just did to the server. We have been planning to reload the OS on \\scidb though, so the default settings on the various components on clean install will bring us back to the point we were at before I messed up the permissions. I must formalize a reload plan for \\scidb. There’s a lot of services and data living on this machine right now. Well, I’m off to the UK. I’ll be back in a couple of weeks.
100/0
Thursday, March 22, 2001
Scidb has ceased communicating with the ac_computing domain controller. Erik discussed the situation with various network support staff and a decision was made to do a clean install of Win2k server. I produced a migration document and had it inspected by Mike Simmons and Erik. Verified backups to <\\goldie\users3\crainm\bk\*.zip>.  Nuked the primary HD on scidb. Installed Win2k server standard, sp1, and resource kit. Tomorrow I will get a domain admin to authenticate the scidb to the domain and do the ODBC and SQL server install. We should be back to full functionality before I leave for Mexico. 
Installed DreamWeaver on David’s (ICAN) machine. Did an HTML tutorial with him. I think he’s going to stick with Microsoft Publisher for now. It’s a tool he’s familiar with and its inconsistencies are not completely crippling.
100/0
Friday, March 23, 2001
Steve auth’d scidb to ac_computing. Installed Visual Source Safe 6.0, MSSQL 7. Recreated db and logins/users. Verified Interdev functions with web projects for myself and Erik. It should work for Neil. I’m off to Mexico. See you next week.
100/0

Spring Quarter 2001

Week 1 Mon. Apr. 2 to Sat., Apr. 07

Activities:
CDROM install in Mazama (now located in ICAN lab)
Configured Win95 print server box - \\numbers\hplj4
Produced several iterations of ‘best viewed in’ warnings on Emerald and BCD. Waiting for final approval from Judy and Erik before deployment. Target dates for compatible versions are BCD - May 10 and Emerald - July 10
Imparted Access 97 lore to Steve R.
Assigned scidb lab default homepage to Mike. It wouldn’t display until I moved index.htm to the first default document in IIS.
Wrote a new internship contract.
Wrote up the Lynda Weinman book report and sent it to Judy, Erik, Sherri, and Bonnie.
Produced a work schedule with Mike - Mon. 10-6, Tuesday 3 - 5, Wednesday off, Thursday 3 - 5, Friday 1 - 5, Sat. 1-5. Mike’s schedule is identical except that he’s working Sat. morning instead of afternoon.
Gave call\canopy rights to \\scidb\links I had assigned ac_computing\canopy before - I don’t know who’s in that group.
While training Mike, I tripped over a couple ommisions. 1. We have no Win2k manual, so training resources are coming out of my head and over the web. 2. I haven’t written out my job functions. I’ll rectify the latter, but I think it would be a really good idea to purchase, for the lab, a manual on supporting Win2k server standard. Even with my extensive Microsoft product support experience, this is still a new product for me.
Starling meeting: Bonnie recommended I setup an appointment with Rosalind to go over the Access widget. She also suggested again that we use Robohelp to produce help docs on our sites. She advised that MSSQL 2000 has more reserved keywords, so we’ll need to wait on upgrading until we’re sure that we won’t have namespace conflicts.
Implemented Visual Source Safe on SCIDB - this locks down BCD asp only. 
Trained Mike on basic Winnt admin - ACLs, IIS, MSSQL - all this is prelim and will require more in depth training. Mike has VBScript and UNIX admin manuals to study.
100/0
Week 2 Mon. Apr. 9 to Sat., Apr. 14
Installed Win2k, Office 2k, SQL client on Steve R.’s box. Problem - CDR software doesn’t recognize external HP cd writer. This may be corrected by installing a more current version of Adaptec CD writer. McAfee was also incompatible with Win2k and I removed that.
Put trees on canopyworld pages instead of crane icons.
Wrote rough draft Test Plan for BCD release May 1.
Training Mike - Access 97, MSSQL 7 administrative tools, relational database model, ASP model.
Arranged for TESC network services tour with Dave Metzler for Mike and I on Apr. 23
Wrote rough draft of BCD test plan and emailed it to Erik
100/0

Week 3 Mon. Apr.16 to Sat. Apr. 21
Revised rough draft of Test Plan, showed it to Judy, Bonnie and Erik. Got feedback. Started producing a Test Template for each screen. (this effort was ditched – too much work for little gain).
Fixed HTML on ResearchContacts.asp and Glossary.asp
Meeting at Starling with Rosalin – replicated widget/sql db on Lambda. Rosalin and Jay feel there is something wrong with one the relationships in the SQL db between Person_CV and either URL_links or Party.  Rosalin suggested upgrading to Access 2000 and installing a data access tool from the MSSQL SP3 CD on all client machines. I suggested we ditch Access for data entry and use ASP. This would require implementing secure login and sessions. Projected completion – June or July.
Met with Bonnie, Jay, Mike, and Neal. Bonnie had the idea to use a quiz for the usability test – just ask the user to perform some tasks. Watch them and then ask for feedback at the end.
Gave Mike a list of tasks to complete outside of main training focus.
Noted that 800x600 is a wee bit bigger in MSIE 5.5 than MSIE 5.0. Silly.
Removed url copy macro from url entry form. This was the error that Erik showed me. I tested the form and it works for me. 
Wrote the usabililty orientation and quiz with Mike. Submitted it to Judy, Bonnie, and Erik for approval.
100/0

Week 4 Mon. Apr. 23 to Sat. Apr. 28
Substituted a command button for the automatic URL generator in URL form in BCDforms.mdb
Categorized BCD Usability tests into feature requests and immediate code fixes.
Updated static page of popular citations
ICAN meeting – reported progress and once again indicated that I do not know when the next version of BCD will be deployed.
Retrieved replacement CDR drive for \\duwamish. 
Trained David (ICAN) in DreamWeaver global find/replace. Also reiterated the importance of using local <a href…> and <img src…> tags instead of absolute references for everything.
Fixed the following items as part of our functionality and usability test re-code:
•	Glossary – Make the ‘as cited in…’  a separate sentence/thought to separate it from the definition.
•	Start Page – Large gap between participants and mission statement.  Make ‘Web Site’ one word.  Separate the participant’s names better.
•	Meetings – Make them a consistent format.
•	Training programs – Hard to read
•	Canopy Access – Cluttered.  More space between Name and Description, and spaces in-between the links.
•	Research Resources is the only menu item followed by a colon
•	Website/links – Need to indent the mission statement and body
•	In search fields change the word ‘by’ to ‘in’ 
•	Citations listed under an author need to look like those in Scientific Citations
Fixed delete record command in damage form in bcdforms.mdb
100/0

Week 5 Mon. Apr. 30 to Sat. May 5
Finished recoding for Usability test. Performed browser compatibility testing and recoding. Declared BCD “golden.” Wrote rough draft of deployment plan and sent out for comments. Fixed Visual Source Safe. Ordered two server admin books from bookstore. Sent out official deployment plan. Helped restructure office furniture and fixtures.
Attended ICAN meeting. Printed docs for visiting VIP (Nalini’s orders).
Starling meeting – discussed deployment, training Mike, BCD image db.
Installed McAfee Virus scan 4.5 on \\numbers. Configured to scan all lab machines admin shared drives. Auto clean specified. \\numbers\c\WINDOWS\DESKTOP\VSClog.TXT is the log file. All Shares on \\numbers are readonly.
Built Judy’s LeSelect Poster in Adobe Illustrator. Discussed printing options with James Gutholm. I will use the plotter in the CAL for the intitial proof poster due Wednesday.
100/0

Week 6 Mon. May 7 to Sat. May 12
Revised LeSelect poster to Judy’s specs. Tried in vain to use Adobe Illustrator on a Macintosh in the CAL. Settled on a windows box. Printed a small proof on the plotter. Tried to print a full size version. Ran out of paper. 
Deployed MSSQL backend for BCD to \\kokanee – minor problems fixed with Erik, Neal, and James Gutholm’s help.
Commented this log with percentages of work perfomed regarding SOS and SCIDB lab. 
Printed out a full sized proof of the LeSelect poster. The colors on the Crustal Age topography images are too saturated. I also inadvertently printed some rather obvious placement guides on the face of the poster. The title text color doesn’t match anything and the graphics are jaggy. Sent email to Evergreen and INRIA webmasters requesting EPS logos.
Showed Poster to Judy, got revisions, fixed the poster, printed it out, and gave it to Judy.
Starling meeting – priority placed on thumbnail gallery image db for BCD. So, I really have two major jobs to complete before June 15, the image db and training Mike.