Re: Updating Patron ID #s in batch?

[groth <groth at csupomona dot edu>]

When we converted from ssn to student id no. we had our first file created 
with the ssn in the u field (for matching) and the student id in another field 
(we used the b field)  We loaded the records (matching on the u field), then 
deleted the u field with the ssn and replaced the u field with the b field.  
No more ssns!!  Before we did this we cleaned out the patron files as much as 
we could and did two loads this way (Fall Q and Winter Q)  After that, all the 
ssn's were deleted.

Gina

At 10:18 AM 6/24/2005, you wrote:
Greetings,

One of our sources of patron data has changed the content of the SSN field 
from SSN to a locally created student ID number.  After they made the updates, 
they sent me an Excel file with the old SSN and new student ID values for just 
over 500 patron records.  My problem is that the SSN field is a key matching 
field for the patron load, so I'm pretty sure I won't be able to update the 
SSN through any patron load profile chicanery.

Has anyone run across a similar situation?  Were you able to come up with a 
batch update method or did you have to resort to manually changing the SSN 
field so future overlays would work correctly?  Or did you just wait until the 
first batch load and use the error file listing all the new duplicate records 
to manually merge the duplicates?  Or is there some other method I have not 
thought of yet?

Thanks.  Have a great weekend.

-- 
Rich Atkinson
Tufts University Library Systems Manager
Phone: (617)627-5239
Fax: (617)627-3002
E-mail: richard dot atkinson at tufts dot edu


--
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
Gina Roth			groth at csupomona dot edu
Systems Librarian		(909) 869-3085
University Library		FAX: (909) 869-6922
Cal Poly Pomona		
3801 W. Temple Ave.		
Pomona, CA  91768

Gina