[ List Archives Home ] [ Thread index for 2008 ] [ Date index for 2008 ] [ Author index for 2008 ]


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
I need to track down a data entry error, but don't know if I can use
Create Lists for this,

or otherwise how to find the error. All suggestions are welcome!

I use Create Lists to make a list of current patrons. When I sort it by
patron name,

the total number of patrons increases by 2. If I dedup the file, it goes
back to the original

count.

I suspect that I have 2 patron records which each have two "name" fields.
But I don't know

how to find those two records among the thousands in the file. Does
anyone have any

ideas how to find those two records?

I know how to search the original file using the "review" file process in
order to find a subset

of the original file. I just don't know if Create Lists has a way to
indicate that a record has 2

of the same field. And I don't know if the two name fields are identical
(and are actually two

fields with the same name), or two different names (e.g. maiden name and
married name),

or if one is the actual patron name, and the other has completely
different data but was given

the wrong field name. For instance, someone might have used the wrong tag
("n" which is our tag

for the Name field) when they were actually entering an internal note
field (we use "x" for the

Internal note field).

Sincerely,

Sue Whitehead, Systems Librarian/Archivist

Biola University
13800 Biola Ave., La Mirada, CA 90639-0001

sue dot whitehead at biola dot edu
562-903-6000, ext. 5611
fax: 562-903-4840