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]
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]
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

 

Detroit Institute of Arts

5200 Woodward AvenueDetroit, MI

313.578.1051  [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]
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]

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] 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.

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.