TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

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

Print Reply
Subject:
From:
Chad Petrovay <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Thu, 12 Nov 2015 14:58:17 -0500
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (2274 bytes) , text/html (3369 bytes)
Leigh, I believe that inactivated thesaurus xrefs can be searched under
advanced query. You need to specify the Inactive terms node for searching.

Of course, if you simply wanted to purge all inactivated thesaurus xrefs
from TMS, that can be managed through a SQL script as well - which would
save you a lot of time and effort.

~Chad

On Thu, Nov 12, 2015 at 2:09 PM, Leigh Gleason <[log in to unmask]>
wrote:

> Hi All,
>
> We are working on a massive thesaurus cleanup that was half done when we
> converted to TMS -- we're now trying to move toward finishing it.  We're
> still running TMS 2012, and are hosted.  I realize that Thesaurus Manager
> gets better in TMS 2014, and perhaps I should be tabling this project until
> we upgrade -- but until then, I'm stuck on a problem I can't figure out how
> to fix and am hoping you might know how.
>
> In the Objects module's Attributes field, we apparently made "Inactive"
> but did not delete some terms that are clearly wrong (typos, for example).
> When I try to delete the entry from Thesaurus Manager, it won't let me
> because it is ThesXref'ed to object records as an inactive term.
>
> The problem is that I don't know what object records have these inactive
> terms.  Advanced search does not find inactive terms, and the particular
> case I'm working on has over a thousand records tied to the correct
> thesaurus term with the right spelling, so that would be a lot to slog
> through in hopes to spotting the greyed out inactive term.
>
> Is there a way in TMS 2012 to see what record uses this inactive term,
> short of the long slog? Is this something more easily fixed in 2014?
>
> With thanks,
>
>
> Leigh
>
>
> --
>
> Leigh Gleason
> Curator of Collections
> UCR/California Museum of Photography
> 3824 Main Street
> Riverside, CA 92521
>
> web: www.cmp.ucr.edu
> email: [log in to unmask]
> tel: 951-827-5303
> 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