RE: [IUG] Blank/Bad Code

["Kathy Johnson" <kjohnson at library dot caltech dot edu>]

Sarah,

I've been doing a lot of fixed-field cleanup work lately, and run into
the "blank code" or "no code" problem a lot, especially with older
records.  I run my lists with the following search strings - for
argument's sake, assume these are item records, but it works with other
records too:

Examples:

"no code" errors: item record / imessage = <nothing> (just hit return)

"blank code" errors: item record / imessage HAS <blank space> (hit the
space bar once then return)

"bad code" errors: item records / imessage HAS <whatever the bad code
was> (then hit return)

Another example which works well when the fixed field could have a blank
field on purpose, such as "ctry" in bib records:

Bib records / ctry STARTS WITH <blank>
  
bib records / ctry STARTS WITH <whatever code I'm looking for>

You can run these search strings together with an "OR" at the beginning
of your next search string, but depending on what you're looking for,
you probably wouldn't or you might fill up the review file you're using
before it's finished running the search.

Good luck!

Katherine Johnson
Head of Metadata Resources and Services, Caltech Libraries
California Institute of Technology
Mail Code 1-32
Pasadena, CA  91125
tel: (626) 395-6065 -- fax: (626) 395-6266
kjohnson at library dot caltech dot edu


-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org] On Behalf Of Sarah Smith
Sent: Tuesday, August 22, 2006 4:04 PM
To: innopac at innopacusers dot org
Subject: [IUG] Blank/Bad Code

When I run Millennium Statistics reports, I come up with a hefty amount
of Bad Code in several different fields. Is there a good way to find
these? I have tried running a list (in Create Lists) on everything that
is not equal to valid values but it isn't pulling up as many records as
it should, given what I'm seeing in Statistics and Web Management
Reports. I know whatever it is won't be easy, but I'm willing to do some
convoluted list making to get the database cleaner. (Primarily, I'm
interested in pulling records that have invalid fixed-field entries.)

Thanks,

 

Sarah Smith

Systems Supervisor, ssmith at saclibrary dot org  

Sacramento Public Library <http://www.saclibrary.org> 

828 I Street, Sacramento, CA 95814

Phone (916) 264-2892; Fax (916) 264-2959 

 



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---
--
This message was distributed through the Innovative Users Group INNOPAC
list
Public replies:  INNOPAC at innopacusers dot org
Update your subscription options:
http://innopacusers.org/mailman/listinfo/innopac