I definitely did this when we were still on 9.35 – good to know it is no longer an issue!
Thanks Danielle!
D.
==================================================================
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
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Danielle Uchitelle
Sent: Thursday, January 31, 2013 4:06 PM
To: [log in to unmask]
Subject: Re: Bibliography query groups
All,
Regarding the orphan ThesXRef rows after deletion of a Media record containing ThesXRefs, we’ve reviewed this with the GS Chief Software Architect and he confirmed that it is a bug in TMS 9.35. This was fixed in subsequent releases, and Media deletion occurs correctly in both TMS 2010 and TMS 2012.
If you’re still on 9.35 (as I know you are, Brenda), you should upgrade to TMS 2012 to resolve this issue. In addition, if you’d like a script that will remove the orphan rows from your ThesXRef table, please contact [log in to unmask].
Best,
Danielle
Danielle Uchitelle | Managing Director
[log in to unmask] | 646.733.2239 x264
GallerySystems | www.gallerysystems.com
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of bpod
Sent: Thursday, January 31, 2013 1:35 PM
To: [log in to unmask]
Subject: Re: Bibliography query groups
Hi,
Just one last follow-up on this topic...
I decided to try out Jeri's suggestion about showing the inactive terms (thank you Jeri--I did not know that!) and coincidentally was doing the very same thing you were, Diane -- cleaning up a few old extraneous media records that linked to a now-defunct thesaurus term. Here's what happened:
- I deleted five media records that happened to have the link to the thes term I'm trying to delete. When I search in TMS on Term Attributes using the term, I get 0 results. All good.
- I go to Thes Manager and Check Usage on that term--it shows it's being used 5 times. Boo.
- I look at the THESXREFS table and can isolate those five orphaned rows linking to this term's TERMID, all set with ACTIVE = 1.
So it looks like deleting media object records is not removing rows from THESXREFS. Once I delete the offending rows from the THESXREFS table, I am able to remove the term from the Thesaurus hierarchy, no problem.
So Diane, I DO suspect there might be orphaned THESXREFS records out there.
b
>>> Diane Lee <[log in to unmask]> 1/31/2013 6:59 AM >>>
Thanks Jeri – Tried that, but to no avail. I go back to it every once in a while, maybe one of these days I’ll kit on the solution.
As my ‘bad’ terms were the result of an experiment in the Media module, where I think I later deleted the test media records, I’m wondering if the terms are floating around without an actual record to be linked to. Is that possible?
Anyway, one of these days I’m sure I’ll track them down – good luck Amber on your searching!
D.
==================================================================
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
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Moxley, Jeri
Sent: Thursday, January 31, 2013 9:20 AM
To: [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]]
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 | Membership | Donate | Volunteer
Visit us on Facebook and Twitter @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]] 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]] 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.
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.