If there is not a real “good” term to use, you can make a generic “bad” term--  like your own “DO NOT USE” concept (but in this case, you’d have only one for this use instead of a bunch of them).

I usually either preface terms like this with “z”—or (cleaner) I manually drag them to the bottom of the term list- either way, I like terms users shouldn’t use to be listed last.

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Diane Lee
Sent: 2013年1月31日 10:02
To: [log in to unmask]
Subject: Re: Bibliography query groups

Oh, this might work for me Karen –
Any suggestions on what to link it “to” without messing anything else up?
D.

==================================================================
Diane Lee | Collections Manager
[log in to unmask]<mailto:[log in to unmask]> | (860) 236-5621 x(242)
Connecticut Historical Society | One Elizabeth Street | Hartford, CT 06105 | www.chs.org<http://www.chs.org/>

Upcoming Events<http://www.chs.org/calendar> | Membership<http://www.chs.org/membership> | Donate<http://store.chs.org/donate/> | Volunteer<http://www.chs.org/volunteer>
Visit us on Facebook<http://www.facebook.com/CTHistoricalSociety> and Twitter<http://twitter.com/connhistsoc> @ConnHistSoc

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of KarenWaldemar
Sent: Thursday, January 31, 2013 9:42 AM
To: [log in to unmask]
Subject: Re: Bibliography query groups

Hi-

There is also a way of transferring the links to the term you want to delete to another term.

In Configuration, go to Edit -> Search and Replace ->  Linked Thesaurus Terms  (then link terms for moving “from” and “to” with the zoom box, etc.).

After you go through this process, the term won’t have links any more so you can delete it.

Karen

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Moxley, Jeri
Sent: 2013年1月31日 9:20
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Bibliography query groups

In dbconfig, you should be able to set up a query group with the fields to search on inactive entries. It's a different branch of the query groups hierarchy.
Jeri

From: Diane Lee [mailto:[log in to unmask]<mailto:[log in to unmask]>]
Sent: Thursday, January 31, 2013 09:16 AM
To: [log in to unmask]<mailto:[log in to unmask]> <[log in to unmask]<mailto:[log in to unmask]>>
Subject: Re: Bibliography query groups

I’m wondering if Amber is partially having the same problem that I’ve been having – I can’t find the silly inactive linked term to try to do the second delete.  I’ve tried playing with the dbconfig and the queries to search for the inactive terms, and also changed the term to have DONOTUSE in the front so it’s easier to spot, but I can’t find where they are linked.  It still shows up as ‘linked to 2 records’, but won’t come up in a search.

If anyone has any suggestions on how to track them down, you would be my favorite!

Diane.

==================================================================
Diane Lee | Collections Manager
[log in to unmask]<mailto:[log in to unmask]> | (860) 236-5621 x(242)
Connecticut Historical Society | One Elizabeth Street | Hartford, CT 06105 | www.chs.org<http://www.chs.org/>

Upcoming Events<http://www.chs.org/calendar> | Membership<http://www.chs.org/membership> | Donate<http://store.chs.org/donate/> | Volunteer<http://www.chs.org/volunteer>
Visit us on Facebook<http://www.facebook.com/CTHistoricalSociety> and Twitter<http://twitter.com/connhistsoc> @ConnHistSoc

From: The Museum System (TMS) Users [mailto:[log in to unmask]<mailto:[log in to unmask]>] On Behalf Of Moxley, Jeri
Sent: Wednesday, January 30, 2013 7:41 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Bibliography query groups

Hi Brenda,

That feature should work to protect you against accidental deletes. In the thesxrefs configuration you can choose to 'archive deletes' or not. If the type is configured to archive deletes, a single delete keystroke will make it inactive, but still visible if you right-click over the control on the data entry screen. Once visible, you can delete a second time if you're sure it needs to hit the road.

Jeri
Jeri Moxley
Manager, Collection and Exhibition Technologies
The Museum of Modern Art
11 West 53 Street, New York, NY 10019-5497
Tel. (212) 708-9599 Fax. (212) 333-1102

On Wed, Jan 30, 2013 at 7:07 PM, bpod <[log in to unmask]<mailto:[log in to unmask]>> wrote:
Hi Amber,

I've found that if a Term Attribute is deleted from its context (say Bibliography), the THESXREFS record still actually exists but is set to ACTIVE=0.  It doesn't appear in queries, but still shows as being in use from the Thesaurus.  When I've found myself in this situation in past, I manually deleted the inactive rows directly from the THESXREFS table prior.

Don't know if that's the recommended way to handle it, but it worked for us.

b




~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
Brenda Podemski
Principal Project Specialist
Collection Information and Access
The J. Paul Getty Museum
www.getty.edu<http://www.getty.edu>

v.  +1 310-440-7087<tel:%2B1%20310-440-7087>  |  f.  +1 310-440-7752<tel:%2B1%20310-440-7752>  |  e.  [log in to unmask]<mailto:[log in to unmask]>
>>> "Morgan, Amber" <[log in to unmask]<mailto:[log in to unmask]>> 1/30/2013 8:27 AM >>>
Hmm… Ok, now that I am doing this properly, and it works, and I can do the search I thought I needed to do, I still haven’t resolved my original problem…

The reason I wanted to search attributes in the Bibliography module is because I have an errant thesaurus term that I need to delete, but I can’t delete it because it’s in use in one record.  So I’m trying to track down the record where the term is used and I’m just not finding it.

Here’s the problem.  Someone inadvertently added a local term under AAT in the Thesaurus:
[cid:image001.png@01CDFF9D.3026A600]

When I try to delete the term, it says that it is in use in one record, Thesaurus Xrefs (Bibliography): 1 time, cannot delete.

I did a search on Terms(Attributes) = “Art, Modern--Themes, Motives—Exhibitions.”  I do get two records, but they are linked to the same term under Local Authorities (where it belongs).  I can’t track down a record using this term via the AAT hierarchy.  I’ve even tried deleting the link between the Local Authority version of the term to the two records, just in case, and that didn’t help (I didn’t actually expect it to).

Is there something I’m missing?  I’ve tried updating the database statistics and that didn’t help – maybe there is some other maintenance I should be performing?



From: The Museum System (TMS) Users [mailto:[log in to unmask]<mailto:[log in to unmask]>] On Behalf Of Christine Droll
Sent: Wednesday, January 30, 2013 10:39 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Bibliography query groups

You have to drop it in the Query Assistant (or other similar subfile), not the Bibliography Group.

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Morgan, Amber
Sent: Wednesday, January 30, 2013 9:27 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Bibliography query groups

Image attached.  That’s the order I’m doing things, and then I get the “Cannot!” message.

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Tuesday, January 29, 2013 6:07 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Bibliography query groups


In which context?

On Tuesday, January 29, 2013, Morgan, Amber <[log in to unmask]<mailto:[log in to unmask]>> wrote:
> Hi all,
>
>
>
> I’m having difficulty modifying the bibliography query group.  I’d like to be able to search by attribute terms, but when I select attribute terms from the available hierarchy and try to add it into the bibliography query group, I’m getting a “cannot drop here” message.  Is there a trick to the bibliography group or something else I’m missing?
>
>
>
> Thanks!
>
> Amber
>
>
>
> the warhol:
> Amber E. Morgan
> Associate Registrar
> 117 Sandusky Street
> Pittsburgh, PA 15212
> T 412.237.8306<tel:412.237.8306>
> F 412.237.8340<tel:412.237.8340>
> E [log in to unmask]<mailto:[log in to unmask]>
> W www.warhol.org<http://www.warhol.org>
>
> The Andy Warhol Museum
> One of the four Carnegie Museums of Pittsburgh
>
> Email newsletter http://members.carnegiemuseums.org/email
> Membership http://members.carnegiemuseums.org/SupportCMP
>
> warhol: facebook | warhol: twitter
>
> The information contained in this message and/or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any system and destroy any copies. Any views expressed in this message are those of the individual sender.   ­­
> To unsubscribe, send an email to [log in to unmask]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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.