[OPEN-ILS-GENERAL] Changing creator on records?

[Ben Shum]

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 <jlwalz at asbury.edu> 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
> jlwalz at asbury.edu



-- 
Benjamin Shum
Evergreen Systems Manager
Bibliomation, Inc.
24 Wooster Ave.
Waterbury, CT 06708
203-577-4070, ext. 113