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.
    2. Export access control list in a format that can be pasted to AFS command lines for AFS ACL setting
  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