From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Kelly,
Rodger S
Sent: Tuesday, May 03, 2016 1:27 PM
To: [log in to unmask]
Subject: Re: Companies with multiple names

Alternate names are available in the Constituent Lookup. Note in this example how a search for "Wilhelmina" returns the constituent "Queen Caroline" because of the alternate name "Wilhelmina Charlotte Caroline". It does not display all of the alternate names, only those that meet your search criteria.

The alternate names are grouped under their primary name, and for some reason I cannot explain, are placed in brackets following an indented repeat of the primary name.

You have noted a deficiency, in that the tool is looking for Constituents records, not just name records, so you are correct that if a user did not know the form of the name they wanted to search on they would need to perform two searches.

Alternately, you could configure the Alternate Names Display Name field to display as a distinct value list in Query Assistant.

On Thu, Apr 28, 2016 at 9:33 AM, Kelly, Rodger S <[log in to unmask]> wrote:

Thanks, Chad.

 

I’ve experimented with this before and came to the conclusion that it’s a run-around solution in that it’s not fully functional with Constituent Lookup.

 

Am I understanding this correctly?  With this method one could use Constituent Lookup to see what forms of the name exist, and then switch over to QA and search the Alternate Name field on the specific name. Is that how you’ve done it?

 

Since the alternate name can be assigned to object records, ideally one would have the option of bringing the alternate name into Constituent Lookup.

 

(Sorry. I forgot to mention we are on TMS 2012.)

 

Rodger

 

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Wednesday, April 27, 2016 5:09 PM
To: [log in to unmask]
Subject: Re: Companies with multiple names

 

Rodger,

 

You can use Alternate Names for this. In the ConXref screen, you can select the exact name that you want to use for that object - the primary name is selected by default.

 

 

You can also reconfigure your query groups to be able to search on the alternate names (to find those with "Gibson Mandolin-Guitar Company") by adding fields from the Constituents Alternate Names node to your query groups.

 

 

In the past, I've done the same thing with journals in Bibliography, since some journals changed their names over time.

 

I hope this helps. It was great seeing you at CI! ~Chad

 

On Wed, Apr 27, 2016 at 3:33 PM, Kelly, Rodger S <[log in to unmask]> wrote:

Dear TMS users,

 

If anyone has dealt with varying company names I’d appreciate your input. In the musical-instrument world we quite often have companies that used different names at different times. For example, we currently have the following constituents:

 

Orville Gibson

Gibson, Inc.

Gibson Mandolin-Guitar Company

Gibson USA

 

These are not Alternate Names per se since they represent distinct periods of the company's history. We've been looking for a way to implement an umbrella-type term in order for us to retrieve, in this case, all objects made by all iterations of Gibson. But at the same time we want to be able to limit search results to a specific company name. I've been experimenting with the Alternate Names field but I don't think this will work for us for two reasons:

 

1. You cannot assign the specific Alternate Name to an object record. (TMS assigns the main constituent.)

2. You cannot limit your search results to a specific alternate name.

 

I've also experimented with Parent-Child relationships in the Constituent module, but this doesn't seem to accomplish much in terms of search and retrieval.

 

We are considering adding a master term, in this case, "Gibson", to each object record that has one of the constituents listed above. This would allow us to search on the master term, and also any of the specific iterations of the company.

 

If you have done this or something similar I'd love to hear from you.

 

Thanks,

Rodger

 

P.S. I very much enjoyed CI 2016. Thanks to everyone who was involved!

 

RODGER KELLY Collections Manager  /  TMS (The Museum System) Administrator National Music Museum University of South Dakota 414 E. Clark St., Vermillion SD 57069 http://nmmusd.org [log in to unmask] (605) 677-5306

 

 

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.