LISTSERV - TMSUSERS Archives - SI-LISTSERV.SI.EDU

I'm with Jeri - use a prefix like "zz". But instead of modifying all the
reports, you could just modify the view vgsrpLocPurposesS_RO to strip the
zz prefix, since most reports use this for their source.

On Tue, Aug 22, 2017 at 3:15 PM, Jeri Moxley <[log in to unmask]> wrote:

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

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.