[406] in Tooltime
web/oracle help tools progress
daemon@ATHENA.MIT.EDU (Steven Wade Neiterman)
Fri Sep 26 09:43:52 1997
Date: Fri, 26 Sep 1997 09:47:44 -0400
To: tooltime@MIT.EDU
From: Steven Wade Neiterman <wade@MIT.EDU>
First, welcome Suzana and Mike to the tooltime mailing list.
Debi,
While not complete, you can now insert a record into Oracle from the Web
interface. At this time, I only have a limited number of field being
inserted as "proof of concept".
There are two differences between the email/oracle and web/oracle interface:
1. The email interface takes the subject line and inserts it into the
"mit_summary" field in Oracle. The Scopus interface forces this field
to be filled in when a consultant enters a log.
The web/oracle interface does not have a summary field. Do you want
to look over the "submit" form and find a place for this field?
2. The email interface inserts the following categories into the
"mit_category" field. This is based on the mailing list, e.g.
mail to warehouse@mit.edu inserts "Warehouse", etc.
The web/oracle application does not have a category field. This
field was part of the initial requirements so that a consultant
could go into Scopus and find all logs for a specific category.
Do you want to add a pop-up list box for the customer to choose?
This would be a required field based on the initial requirements.
SQL> select mit_category_name from mit_lk_category;
MIT_CATEGORY_NAME
--------------------
Helpdesk
Mainframe
Housecall
Netinstall
HelpNet
DCS
UNIX/VMS
Warehouse
8 rows selected.
