Archive for the ‘YF’ Category

YF – Work Outline November, 2007

Thursday, November 15th, 2007

COE Server:

  • Further investigated Linux backup commands and strategies

  • Refined backup script
  • Monitoring data server logs

Other:

  • Fixed SR date sort problem in all report types

  • Beginning AWStats log compilation project
  • Friends of Library updates

YF – Work Outline October, 2007

Thursday, November 15th, 2007

COE Server:

  • Further analyzed structure of Compustat data

  • Investigated Linux backup commands and strategies
  • Implemented backup script
  • Made Compustat documentation available w/DPO
  • Assisted SET & DPO with discussions with Prof. Welch
  • Completed Compustat queries to create dataset, class began use

Friends of Library updates

YF – Work Outline September, 2007

Thursday, November 15th, 2007

This is an Incomplete outline due to retrospective recording
COE Server:

  • Further analyzed structure of Compustat data

  • Set up new user accounts for Econ class incl. working directories, environmental variables
  • Created CRSP documentation for test programs
  • Assisted Joe in setting up backup drive on data server
  • Began manual backups
  • Assisted SET & DPO with discussions with Prof. Welch
  • Learned command-line MySQL, began Compustat test outputs
  • Misc. other work

YF – Work Outline August, 2007

Thursday, November 15th, 2007

This is an Incomplete outline due to retrospective recording
COE Server:

  • Finished creation of MySQL version of Compustat Oracle data

  • Installed Red Hat EL 3 Linux on new server; SSH, MySQL, etc. configured
  • Compiled, ran CRSP C Programs on new data server, installed data
  • Assisted SET & DPO with discussions with Prof. Welch
  • Imported Compustat MySQL data to data server
  • Worked with Professor Welch to determine Compustat variables required
  • Misc. other work

YF – Work Outline July, 2007

Thursday, November 15th, 2007

This is an Incomplete outline due to retrospective recording
COE Server:

  • Note: June visit to Boston College with DPO to investigate WRDS software

  • Reinstalled Red Hat EL 3 on old test server
  • Investigation of CRSP C Programs on test Red Hat Server – C Struct setups
  • Compiled, ran CRSP C Programs, minor modifications
  • Assisting SET & DPO with discussions with Prof. Welch
  • Began reading Compustat documentation, investigating data structure
  • Misc. other work

YF – Work Week of May 21, 2007

Friday, May 25th, 2007
  • Finished list of Web Applications PHP pages for REGISTER_GLOBALS, MySQL user security, etc.
  • Mounted numerous brownradio pages for BT
  • Installed SAS for CRSP/Compustat data exploration, reviewing SAS operation

YF – Work Week of May 14, 2007

Friday, May 25th, 2007
  • Creating list of Web Applications PHP pages for REGISTER_GLOBALS, MySQL user security, etc.
  • Reading documentation for CRSP sample
  • Met with Professor Ivo Welch, DPO and SET re. CRSP/Compustat

YF – Work Week of April 30, 2007

Wednesday, May 2nd, 2007
  • Did find/grep for Webpub REGISTER_GLOBALS problems, found 7; fixed for new setting compatibility
  • Fixed php/mysql problem on hay staff page
  • Additional FOL updates

YF – Work Week of April 23, 2007

Wednesday, May 2nd, 2007
  • input_filter.php, filtering class for form input->database
    • Finished bug fix for “string” problem
    • Posted input_filter.php bug issue to creator’s MEETUP board (no good contact method available)
    • Resumed testing, another bug surfaced
  • Numerous FOL updates
  • gis.brown.edu web data source addition (T.S. request)
  • Emailed Patrick Laverty re. obtaining stable code for deep linking into Banner (works as expected from URLs)

YF – Work Week of April 9, 2007

Wednesday, April 11th, 2007
  • Reviewed PHP objects chapters – Safari
  • Implemented test version of filtering class for form input->database
    • Placed in include file, creating instance etc.
    • Testing optional parameters for appropriateness
  • Attended Web Programmers meeting/seminar
  • FOL updates
  • Eresources update