I, too, have added a constituent to the Registration Set constituents (for a recent acquisition) and updated the records. But also, to no avail because the individual object records are not showing the additional constitutent.
Enlightenment would be most appreciated!
Christine
Christine Droll
Collections Database Administrator
The Nelson-Atkins Museum of Art
4525 Oak Street
Kansas City, MO 64111-1873
t: 816.751.1333
f: 816.751.0499
[log in to unmask]
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Ella Rothgangel
Sent: Thursday, April 19, 2012 10:06 AM
To: [log in to unmask]
Subject: Re: inserting acquisition constituents
Thank you Sue for this idea. The several hundred objects for which I am trying to add an acq constituent are not related to a recent acquisition or a pending acquisition, but I played around with a test accession lot of two of the objects to see if this would still work for backlog data entry. The only piece of data that I am trying to update for these records is the addition of one acq constituent. While I have now added this constituent to the Registration Set constituents, when I update the object records, it does not appear to populate the individual object records.
Has anyone used the accession lot feature for old data entry in this way? Am I missing a step in my updating?
Ella
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Finkel, Susan
Sent: Thursday, April 19, 2012 9:19 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: inserting acquisition constituents
Ella,
You can add Acquisition-Related constituents through the Registration/Accession Lot using the Registration Set Constituents.
We've found this to be the quickest and easiest way to do this kind of addition. Let me know if you have questions about how to do this.
Sue Finkel
National Gallery of Art
Washington, DC
From: The Museum System (TMS) Users [mailto:[log in to unmask]]<mailto:[mailto:[log in to unmask]]> On Behalf Of Ella Rothgangel
Sent: Thursday, April 19, 2012 10:13 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: inserting acquisition constituents
Hello,
Does anyone have an sql insert statement that will add an acquisition-related constituent? I am looking for one that works in tms2010.
Thank you!
Ella
Ella Rothgangel
Collections Information & Imaging Administrator
Saint Louis Art Museum
One Fine Arts Drive, Forest Park
St. Louis, Missouri 63110
314.655.5408
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.