Hi Jennifer, I do believe this is something that is accomplished on the server side, via direct database changes. To my knowledge, it is not possible to change the creator of a bib record via the staff client.
Some SQL jargon that might apply for the technical side: -- what is the ID for the admin user? change the WHERE to fit the cataloger user too, you'll need that later SELECT id FROM actor.usr WHERE usrname = 'admin'; -- list of all the bib records created by user 1 (usually the admin user, change the ID to fit as needed) SELECT id FROM biblio.record_entry WHERE creator = 1; -- change the creator, where X is the original creator and Y is the new one you want UPDATE biblio.record_entry SET creator = Y WHERE creator = X; That all said, I'd be curious to know what error messages you're encountering due to the admin user being used to import the bibs. On our system, we have bibs imported by the admin user and all sorts of users and we do not encounter problems usually. I think there must be some other reason you are seeing issues, so I would troubleshoot further before you start making changes to your database's bib records. -- Ben On Mon, Dec 8, 2014 at 2:12 PM, Walz, Jennifer <[email protected]> wrote: > All – > > > > We have encountered error messages popping up because records were added to > the system under the admin login. Is there a way to find those records and > also to CHANGE the creator to a cataloger username? I can’t see a way to > do it on the record within the staff client. Is there a way at the database > level? > > > > Thanks! > > > > Jennifer > > -------------------------------------------------- > Jennifer Walz, MLS – ILS admin > Kinlaw Library - Asbury University > One Macklem Drive, Wilmore, KY 40390 > 859-858-3511 ext. 2269 > [email protected] -- Benjamin Shum Evergreen Systems Manager Bibliomation, Inc. 24 Wooster Ave. Waterbury, CT 06708 203-577-4070, ext. 113
