Dimitry helped us come up with a SQL query to gang in a ConXref for a particular constituent to everything in an object package. The only restriction is that you have to know the display order in advance and it must be consistent across all the object records. This might keep it from being usable for you. If anyone wants it I would be happy to send it out.
Dick
Richard Grant
Executive Director
The Richard Diebenkorn Foundation
3214 College Avenue
Berkeley, CA 94705
510-459-4556 (mobile)
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of David Lowe
Sent: Monday, February 24, 2014 2:03 PM
To: [log in to unmask]
Subject: Re: Adding Constituents to an Object using SQL
Ha, yes, I've learned a few SQL lessons the hard way!
On Mon, Feb 24, 2014 at 4:59 PM, Smith, Jeffrey <[log in to unmask]> wrote:
David,
I have successfully inserted constituent links between objects and even media records using SQL, but you have to be very CAREFUL and there must be consistency concerning display order (among other things) in the records you are batch updating this way. It can be done, but is you must be super methodical!
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of David Lowe
Sent: Monday, February 24, 2014 4:24 PM
To: [log in to unmask]
Subject: Adding Constituents to an Object using SQL
I've used the TMS Bulk Importer to migrate legacy records from our Catalog and from our Digital Gallery into TMS. This has worked pretty well, as I'm dealing with several 10s of thousands of records. However, you can only put one Constituent in that way. I've been able to write SQL to map other data which isn't accommodated by the Bulk Importer, but the relationships between Objects & Constituents tables is impossibly complex to me. If I upload a table AddConstit with ConstituentID, ObjectID, and RoleID, how do I actually attach the name to the object? Any SQL masters out there?
Thanks in advance,
David Lowe
Photography Specialist
New York Public Library
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.