In the interim, while you work out a solution or if you don’t want to
obliterate values you used to use, I've seen many institutions put zz in
front of the values they don't want users to select for new entries so that
they sort to the bottom of the list. Reports that include this authority
may also need adjustment and could include a formula to strip off the zz
prefixes.

Jeri

On Aug 22, 2017 1:14 PM, "Diane Hall" <[log in to unmask]> wrote:

> Hi Karen,
>
>
>
> Do you have any IT Support staff that could help you with a SQL query? I
> don’t know if you are running TMS on a SQL Server database or an Oracle
> database – as we are at Tate.
>
>
>
> A SQL query can be written to identify all of the object location records
> (table objlocations) that are linked to the location purposes that are no
> longer required. Once identified these records would have to be updated
> with a location purpose that is still required (could be set to 0, a
> default value for not entered) – another SQL query can be used to do this.
> I would not advise deleting the objlocations records using the location
> purposes you want to remove, as they form an object’s location history.
>
>
>
> Once all of location purposes in the objlocations table have been updated,
> you can then remove the location purposes – either with another SQL query
> or through TMS.
>
>
>
> If you don’t have IT support who can write the SQL queries, GS will be
> able to help, especially if a lot of objlocations records are using the
> location purposes you want to remove.
>
>
>
> Best wishes
>
> Diane
>
>
>
>
>
> *From:* The Museum System (TMS) Users [mailto:[log in to unmask]]
> *On Behalf Of *Heather Fulton
> *Sent:* 22 August 2017 17:02
> *To:* [log in to unmask]
> *Subject:* Re: Location Purpose Drop-down List
>
>
>
> Hi Karen,
>
>
>
> We just finished 3 days of TMS training, so I'm pretty fresh on
> this...Unfortunately,
> You will have to deleted the unused locations in each file. Our trainer
> did say that you could have GS help with "batch" removals.
>
>
>
>
> Sent from my iPhone
>
>
> On Aug 22, 2017, at 9:38 AM, Karen Hines <[log in to unmask]> wrote:
>
> Hi All,
>
>
>
> Just one last effort to see if anyone out there might be able to help us
> out (please see email below), as I didn't receive any replies from my first
> email. Any suggestions would be really appreciated!
>
>
>
> Many thanks,
>
> Karen
>
>
> *Karen Casey Hines* Associate Registrar* Frances Lehman Loeb Art Center *
>
> *Vassar College *Box 703, 124 Raymond Avenue, Poughkeepsie, NY 12604* | T*
> 845.437.5249 <(845)%20437-5249>* | F*845.437.5955 <(845)%20437-5955>* | **http://fllac.vassar.edu/
> <http://fllac.vassar.edu/>*
>
> JUL 14 - SEP 17* Other People's Pictures: Snapshots from the Peter J.
> Cohen Gift *
>
> AUG 11 - DEC 22* A Neoclassical Portrait of a Classicist: Houdon's Bust
> of Jean-Jacques Barthélemy*
>
>
>
>
>
> On Fri, Aug 4, 2017 at 4:11 PM, Karen Hines <[log in to unmask]> wrote:
>
> Hi Everyone,
>
> I am wondering if anyone knows a way to edit or replace the drop-down list
> for the "Location Purpose" field. We have a lot of old items listed there
> that are no longer in use, even though they would still appear on some
> older historical records, we are no longer using them and want to avoid
> having anyone use these older terms in future.
>
> I did try deleting them, but it would not allow me to delete them, as long
> as they are in some of our records. I am wondering if there is a way to
> maybe deactivate them or at least not make them visible in the drop-down
> list.
>
> I really appreciate any suggestions on this!
>
> Many thanks,
>
> Karen
>
>
>
> *Karen Casey Hines* Associate Registrar* Frances Lehman Loeb Art Center *
>
> *Vassar College *Box 703, 124 Raymond Avenue, Poughkeepsie, NY 12604* | T*
> 845.437.5249 <(845)%20437-5249>* | F*845.437.5955 <(845)%20437-5955>* | **http://fllac.vassar.edu/
> <http://fllac.vassar.edu/>*
>
> JUL 14 - SEP 17* Other People's Pictures: Snapshots from the Peter J.
> Cohen Gift *
>
> AUG 11 - DEC 22* A Neoclassical Portrait of a Classicist: Houdon's Bust
> of Jean-Jacques Barthélemy*
>
>
>
>
>
> 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.
>
> Please note that any information sent, received or held by Tate may be
> disclosed under the Freedom of Information Act 2000
> 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.