TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Condense Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Sender:
"The Museum System (TMS) Users" <[log in to unmask]>
Date:
Wed, 8 Jul 2015 23:31:22 +0000
Reply-To:
"The Museum System (TMS) Users" <[log in to unmask]>
Message-ID:
Subject:
MIME-Version:
1.0
Content-Type:
text/plain; charset="utf-8"
In-Reply-To:
Content-Transfer-Encoding:
base64
From:
"Thompson, Dave" <[log in to unmask]>
Parts/Attachments:
text/plain (1 lines)
Hi Jeremy,

My apologies for the late reply.  Hopefully you've already received help, but if not, let me know, I've done lots of similar updates lately.

DAVID THOMPSON | MFAH
713.639.7580  o
281.330.3803  m
[log in to unmask]


-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Jeremy Munro
Sent: Thursday, June 25, 2015 8:36 AM
To: [log in to unmask]
Subject: Mass Changing TMS Media Departments

Hey all!

I was wondering if anyone could assist us with some SQL in order to change the Media Department for all records which share the same Rendition-Related Constituent for one record set and Public Caption field for another record set? We have about 800 records to change the departments on and by hand that will be just a little time consuming.

Cheers,

Jeremy Munro
Collections Information Specialist
Crystal Bridges Museum of American Art

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.

ATOM RSS1 RSS2