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]<mailto:[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.