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]]
*Sent*: Thursday, January 31, 2013 09:16 AM
*To*: [log in to unmask] <[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] | (860) 236-5621 x(242)
*Connecticut Historical Society* | One Elizabeth Street | Hartford, CT
06105 | 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 *Moxley, Jeri
*Sent:* Wednesday, January 30, 2013 7:41 PM
*To:* [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]> 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
v. +1 310-440-7087 | f. +1 310-440-7752 | e. [log in to unmask]
>>> "Morgan, Amber" <[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:
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]] *On
Behalf Of *Christine Droll
*Sent:* Wednesday, January 30, 2013 10:39 AM
*To:* [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]<[log in to unmask]>]
*On Behalf Of *Morgan, Amber
*Sent:* Wednesday, January 30, 2013 9:27 AM
*To:* [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]<[log in to unmask]>]
*On Behalf Of *Chad Petrovay
*Sent:* Tuesday, January 29, 2013 6:07 PM
*To:* [log in to unmask]
*Subject:* Re: Bibliography query groups
In which context?
On Tuesday, January 29, 2013, Morgan, Amber <[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
> F 412.237.8340
> E [log in to unmask]
> W 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] 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.
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.
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.