[477] in Tooltime
help tools meeting notes 11/04
daemon@ATHENA.MIT.EDU (Steven Wade Neiterman)
Wed Nov 5 13:09:32 1997
Date: Wed, 5 Nov 1997 13:13:36 -0500
To: tooltime@MIT.EDU
From: Steven Wade Neiterman <wade@MIT.EDU>
Notes from 11/04 meeting (Barbara, Debi, Wade)
- Updated project plan (see below). Specifically, new items added to the
Scopus GUI, web/oracle and email/oracle applications.
- Barbara to conduct QA on the ragone/ho Scopus GUI changes.
- Four page Quick Guide written, should install on project notebook page.
- Student training scheduled for 11/4
- Decided to feed the computing-help@mit.edu and sap-help@mit.edu mailing
lists to Oracle, without customer acknowledgements as a test of this
function. Looking for target date of 11/7.
- Debi will complete the password change for existing accounts by
11/7. Filemaker conversion looks good, minor changes needed.
- Peter/David to complete the Scopus GUI changes
---------------------------------------------------------------------
Project dates and milestones:
- Dates: Still looking for final date for Scopus development is end of day
Monday November 10, 1997.
- Cut-over from Filemaker to Oracle to begin after 5:00 pm on
Friday, November 14, 1997. Probably completed over the weekend and
production available on Monday morning November 17, 1997.
- Web/Oracle application is in good shape. May be some missing fields
that need to be added. Development priority will shift to completing
the email/oracle application with possible "live" testing before the
November rollout date. The web/oracle application will continue to
proceed after the Scopus rollout.
---------------------------------------------------------------------
The critical path items to manage are:
- Set final date for development changes (NOTE: timeline leaves little time
for development, therefore, need to identify showstoppers versus items
that can be changed for a future release)
- Testing, testing, testing: Specifically the Scopus GUI and with
regards to the Filemaker legacy data import. Goal is to ensure
continuity of business.
- Identification of resources to ensure transition to Service and
committment of Delivery resources to ensure a phase 2 release.
---------------------------------------------------------------------
HELP TOOLS RELEASE 1.1 WORKPLAN
TOOLS
Web/Oracle
Complete application as follows:
Initial priority is:
- Need further check on consulting access, don't allow legacy people to
gain access (as currently is the case). New view should resolve.
- "Find Open" query should be consistent with Scopus, regarding
display of frozen status and taken field.
- Add search by category
Rest of proposed changes:
- "modified by" username needs to be filled in via the web
- Change search "within 60 days" to between "30 and 60". ??
- Add "MIT Computing Help Desk" with appropriate mail address to the
consultant reply to customer mail function.
- Change result screen working "Only first 100 records will be shown".
to "Showing first xx matching entries".
- Main screen: Change "Client:" to "Client Last Name:".
- Sorting on log status, sort in descending order by MIT_WEIGHT
- Change default sort order by (descending) log status weight and
then log number on the "Staff" side?
- Revise format of the email sent to the customer.
- Change "Notify customer via email" to "Send customer new entry via
email" or "Send customer new case history" depending what happens.
- Make this checkbox only appear if we know the customer's email
address?
- Search on other stati, including "taker" field
- Add hostname, machine location, vendor and account number to
the IP address request on the submit screen.
- Add 10 additional network fields to the log screen (see mail)
- Add 3 fields (taker, thaw, freeze) only for the consultant
- Make category, and status field - bold, red
- Put "client" in both received by and modified by fields when
customer submits log
- Duplicate IP address in the network section
- Move network fields infront of the log history text
- When customer appends to an existing log, change status to unseen
- Add word "client", in addition to existing client name.
Scopus GUI:
Complete GUI changes as follows (priority is shown):
1. Add new Find Open scripts per category (see debi's mail)
2. Add hostname field (needs to be added to database) to
the network screen.
3. Remove clipboard button from the logs screen.
4. When creating a new record, fill in modified by user and
timestamp with same information that is used for creation date.
5. Change display for taken field to use a view (needs to be
created) that does not show legacy users.
6. Repeat the IP Address field as a read-only field on the
network screen.
Completed items 10/31
1. Add Next Step field
2. Modify Find Open script to handle frozen date (do not show
Frozen logs in result window with a date greater than today.
3. Bug fix: on required field error, status reverts to New
4. Bug check: switching between main log and network screen, old
data shows on network screen when selecting new main log.
5. Change label from "Thaw" to "Close on Thaw"
Status: Working
Assigned: Ho/Ragone
Target: 11/10
Email/Oracle
- Need acknowldegement message on "reply logid"
- Appending to existing log, change status to "unseen"
- Review customized acknowldegement message on new message
- Populate received by and modified fields with "client"
- history_search_field needs to be populated
- Needs testing, begin to use computing-help, sap-help lists
- Change history to not have fixed upper limit
- Add code to handle bounced mail
Completed 10/31
- Review, complete and migrate to production:
- Minor changes include not hardcoding the login password
acknowledgement message.
- Install on production machine, revise syslog
Status: Open
Assigned: Wade
Target: 11/07
SYSTEM:
Database
Add missing database fields:
Next Step field. (completed 10/21)
hostname fiel to mit_ni table
Status: Completed
Assigned: Wade
Target: 11/07
Create cron process to modify Frozen logs based on Frozen date
and status of Thaw code, as well as set the close date, otherwise
set status to pending on thaw date.
Status: Open
Assigned: Wade
Target: 11/14
Create new view "legacy_users" to not display legacy users.
Status: Open
Assigned: Wade
Target: 11/14
Export test help-them database to production help-it database
Status: First attempt completed
Assigned: Wade
Target: 10/22
Data updates:
Update lookup/code tables as follows:
Add "Web" to Method, add "Unseen" to Status,
remove "Referred" from status, add "Projects" and "CWIS"
to Category, remove "Waiting" from status.
Status: Completed 10/20
Account table maintenance:
Review, modify and create new accounts:
Add "client" to profile and users table.
Drop those accounts where people do not need to login.
Move old consultants to status of Legacy
Add new users
Add Legacy users
Status: Completed 10/20
Alter the password for existing accounts
Status: Open
Assigned: Debi
Target: 10/27
Overall testing:
Perform business, stress and data testing
Status: Open
Assigned: Computing Help Desk
Target: 10/22
ROLLOUT:
Filemaker/Oracle Conversion:
Complete first pass and load of data
Status: Completed 10/21
Complete second pass and load of data
Need upper case for complete second pass and load of data
Status: Open
Assigned: Debi/Wade
Target: 10/30
Complete FINAL load of data
Status: Open
Assigned: Debi/Wade
Target: 11/14
Scopus deployment:
Install Scopus NT on machines as needed:
Need to deploy installer on net-dist.
Status: Open
Assigned: Smyser/Ho
Target: 10/22
Scopus Training:
Ensure consultants are ready
Status: Open
Assigned: Allen/Smyser/Ragone/Fuchs
Target: Two training sessions planned, 10/31
Solicit appropriate feedback
Check with DCS/Sampson for issues
Status: Open
Assigned: Fuchs/Goguen
Target: 10/17
---------------------------------------------------------------------
HELP TOOLS RELEASE 1.2 ??
Solaris Scopus GUI needs to work with ANO
Web/Oracle - send consultant mail when customer updates log
Add private comments field
Review design to look at records that exceed limit on result query
Add mail CC: field when consultant sends mail to customer (web/oracle)
Evalute issue with multpile saves in Scopus by same user on diff. machines
IP address should perform a "hostinfo" to check for existance
