Also don't forget to set ConXrefDetails.NameID. That is easy to slipup on if you are doing this manually and will also cause TMS to lockup and crash if it isn't set.
-Scott
From: <Smith>, Jeffrey
Reply-To: "The Museum System (TMS) Users"
Date: Wednesday, March 25, 2015 at 4:43 PM
To: "[log in to unmask]<mailto:[log in to unmask]>"
Subject: Re: Attaching constituents to objects with SQL
I did create a series of SQL inserts to link constituents to either object or media records in TMS2012, but you have to be methodical and oh-so-careful, and scope out the records in advance, because the display order for each Xrefs link must be unique, or TMS freezes up. It’s easy to screw-up.
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Wednesday, March 25, 2015 3:47 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Attaching constituents to objects with SQL
I think Richard is still using version 9.35. The structure for ConXrefs in 9.35 was much simpler, but a more complicated structure was introduced in TMS 2010. A simple SQL INSERT statement will not work, instead you either need a cursor or a stored procedure to be able to create ConXrefs through the back end.
~Chad
On Wed, Mar 25, 2015 at 12:49 PM, David Lowe <[log in to unmask]<mailto:[log in to unmask]>> wrote:
Richard,
Yes, please! I can likely modify, if I can understand the SQL. We're still on 2010, though hopefully not for long.
Thanks,
d
On Wed, Mar 25, 2015 at 12:47 PM, Richard Grant <[log in to unmask]<mailto:[log in to unmask]>> wrote:
Do you want to attach the same constituent with the same role to everything in an object package? Dimitry helped me develop a SQL query to do that. Let me know if you want it. You will need to confirm with Dimitry or someone else in support that it will work for your version of TMS.
Dick
Richard Grant
Executive Director
The Richard Diebenkorn Foundation
3214 College Avenue
Berkeley, CA 94705
510-428-1400<tel:510-428-1400>
510-459-4556<tel:510-459-4556> (mobile)
From: The Museum System (TMS) Users [mailto:[log in to unmask]<mailto:[log in to unmask]>] On Behalf Of David Lowe
Sent: Tuesday, March 24, 2015 2:00 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Attaching constituents to objects with SQL
Does anyone know how to do this?
Let's say I want to attach ConstituentID 50 to ObjectID 100 with a RoleID of 5. I can't seem to even see what table(s) I'd be inserting this into! I do a lot of my data cleaning and upgrading from the backend, so it's particularly annoying and time-consuming to have to click through 75 records one at a time to add a constituent name to each. Help?
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]<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]<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]<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]<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.
|
