[235] in Tooltime
Re: results of testing of Lookup on students in data warehouse
daemon@ATHENA.MIT.EDU (Steven Wade Neiterman)
Tue Sep 10 13:34:21 1996
Date: Tue, 10 Sep 1996 13:35:08 +0100
To: Rob Smyser <smyser@MIT.EDU>, sousa@MIT.EDU, tooltime@MIT.EDU
From: wade@MIT.EDU (Steven Wade Neiterman)
The warehouse data was refreshed and I fixed the student email case issue.
I was able to locate the people you listed below (even found pakulat !).
You can type in either case (first name, last name, email, phone) to locate
the student or staff.
There does seem to be a problem with displaying the department name, but we
can debug this later. It's possible that we once used department numbers.
I do know that the warehouse feed gave us 50 character names.
Good luck in your further testing.
..Steve
At 12:01 PM 9/10/96, Rob Smyser wrote:
>1.) Phil Kim (philkim@mit) not in Lookup anywhere
>2.) Misha Kim (mishakim@mit) Lookup on email did not find him
> but lookup by last name did. Hmmm.
>
> (maybe because Warehouse shows a lowercase
> username, and search forces ToUpper?)
>
> ... Yeah, when i search for usernames that are known to be in lowercase
> in the warehouse data, the people are not found.
>action: This implies we need a filter on the warehouse updates to massage
> all searchable fields into uppercase.
>
>3.) Adam D'Amico (adamico@mit) not in Lookup anywhere
>4.) Terrance Harmon (terrax) lowercase username problem
>5.) Kaitlyn Lioa (ktmeow) lowercase username problem
>
>I'm going to cut short testing at this point to indicate that
>
>we have a real problem with consistency between
>the two data feeds in the warehouse. Personnel data seems to
>come through in upper case, but all the student data seems to have
>email addresses in LOWER case -- from what I can tell, that will kill
>searching by username.
>
>I say it's a problem with the student data feed because when
>I search for people whose first name begins with K, then
>sort the Result Set by username -- just about everyone with a lowercase
>username has a phone number beginning in 5, for campus residence.
>
>I understand from Lynne that someone was "supposed to have fixed that".
>Whatever.
>
>-----------
> Rob Smyser Computing Help Desk, MIT Information Systems, 11-226
> smyser@mit.edu (617) 253 1358
