Most welcome, glad we could help.
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christina Gibbs
Sent: October-29-15 12:35 PM
To: [log in to unmask]
Subject: Re: Object Related Constituent insert
Liana,
Thank you so much. The script and notes were very clear, easy to alter it to acquisition related constituent and looks great in the test db. Our staff will be very happy to not have to add this constituent to 1006 records.
My very best,
Christina
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Radvak, Liana
Sent: Wednesday, October 28, 2015 3:50 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Object Related Constituent insert
Hi Christina,
Olga is away. We didn't receive a script but our team came up with the following. Try in test environment, we have used it a few times with success.
Best,
Liana
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christina Gibbs
Sent: October-27-15 5:21 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Object Related Constituent insert
Dear Olga,
Did you ever receive a SQL script from anyone? If so, would you mind sharing?
Thank you,
Christina
Christina Gibbs
Collections Database Manager
[30Americans_Email]<http://www.dia.org/calendar/exhibition.aspx?id=4998&iid=>
Detroit Institute of Arts
5200 Woodward AvenueDetroit, MI
313.578.1051 [log in to unmask]<mailto:[log in to unmask]>
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Zotova, Olga
Sent: Wednesday, August 13, 2014 12:08 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Object Related Constituent insert
Dear TMS Users,
Does anyone have a SQL script that will batch add a constituent to Object Related? We are on TMS2012.
Thank you in advance,
Olga.
...........................
Olga Zotova
Coordinator, Collections Database Administration
Collection Information & Resources
AGO - Art Gallery of Ontario
416.979.6660 ext. 262
[log in to unmask]<mailto:[log in to unmask]>
www.ago.net<http://www.ago.net>
Up next at the AGO: Alex Colville, honouring the legacy of a Canadian icon with more than 100 works. Opens August 23.
This message is a private communication. It may contain information that is privileged or confidential. If you are not the intended recipient, please do not read, copy or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it and any attachments from your system. Thank you.
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.
|
