Creating lists - empty variable fields, progress report

[innopac@xxxxxxxxxx (West, Barbara - HPL)]

So far I've run three files and this strategy for creating a list is working
like a charm.

-----Original Message-----
From: West, Barbara - HPL 
Sent: Wednesday, August 28, 2002 5:56 PM
To: 'innopac@xxxxxxxxxx'
Subject: RE: Creating lists - empty variable fields


This looks like it's working!  So far I've searched about 66K records and
found 14, all of which really are "apparently blank" volume fields!

I'll report again later.  Thanks, Matt.

-----Original Message-----
From: Matt Polcyn [mailto:MattP@xxxxxxxxxx]
Sent: Wednesday, August 28, 2002 3:02 PM
To: 'innopac@xxxxxxxxxx'
Subject: RE: Creating lists - empty variable fields


Barb,

Try searching for item records where VOLUME is not equal to blank (press
enter) and VOLUME is less than "                                          "
(i.e. a whole string of spaces.

We've found quite a few of them (records with apparently blank fields) in
our database as well.

Good luck!!

Matt

-----Original Message-----
From: West, Barbara - HPL [mailto:Barbara.West@xxxxxxxxxx]
Sent: Wednesday, August 28, 2002 3:21 PM
To: IUG Listserve (E-mail)
Subject: Creating lists - empty variable fields


I've been reading the suggestions about how to create lists of records with
blank fixed fields.  At HALAN we have a different problem.

We are doing a massive cleanup of the Volume field to prepare for two of our
member sites initiating Automated Request Processing (aka Patron-Placed
Holds.)  Lots of messy data came across when we migrated from our old
system, so I've been creating multitudes of lists and using MilCat to delete
invalid volume data.  Any data in the volume field will prompt the patron to
select a specific item for hold rather than placing a title-level hold,
which is all that is needed in the majority of cases.

We have recently discovered, however, that even the presence of an -empty-
volume field will trigger a prompt to select a specific item.  Although the
final step in my processing is to delete the volume field from records in
each list, there are an unknown number of empty volume fields remaining in
the database.  We think they were created because one of our members
included volume in some of their item templates.

So -- has anyone successfully searched for empty variable fields?  What
syntax did you use?  Everything I've tried either pulls up records with
volume fields that aren't really empty, or records with no volume fields at
all.  There are so many variables involved that looking for records that "do
not have [value]" is impractical.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Barbara F. West, Assistant Database Administrator
Houston Area Automated Library Network (HALAN)
500 McKinney Ave.
Houston, TX 77002-2534
Phone:   832-393-1410
Fax: 	   713-247-1182
E-Mail:  Barbara.West@xxxxxxxxxx

--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC@xxxxxxxxxx
Update your subscription options:
http://innopacusers.org/list/listinfo/innopac
--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC@xxxxxxxxxx
Update your subscription options:
http://innopacusers.org/list/listinfo/innopac
--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC@xxxxxxxxxx
Update your subscription options:
http://innopacusers.org/list/listinfo/innopac