You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This is a project Oliver needs to do (as one of the last remaining Casetracker experts) to allow IS&T Server Operations to retire the Casetracker production service. This project is on a short timeline as we would like to retire the production server (sheep.mit.edu) on Tuesday, July 7th 2009.

The plan

  1. Install Actual ODBC drivers on Oliver's Mac
  2. Test Perl or PHP connection to make sure database can be gotten to programmatically
  3. Review table layouts of Casetracker Oracle database
  4. Write PHP or Perl program to pull data off Casetracker Oracle database
    1. Run one export for each category
      1. How do we deal with subcategories? Treat them as separate categories for simplicities sake? They won't have owners.
      2. Write consultants with access to a category into a file (access) in the export directory.
      3. Run a query for all non-canceled tickets and write a single TSV file of the case meta data, one row per case
      4. Run a query for each case and write an ASCII text file of the case meta data and case history into a single file. File name is the case number.
  5. Copy data over to AFS (tooltime locker)
  6. Set ACLs on each directory to category owners
  7. Send Garry Zacheiss mail that sheep.mit.edu can be turned off
  8. Record total project hours
  • No labels