Subject: | |
From: | |
Reply To: | The Museum System (TMS) Users |
Date: | Fri, 10 May 2019 20:22:26 +0000 |
Content-Type: | multipart/related |
Parts/Attachments: |
|
|
Apparently not - thank you! That's in TermMasterThes in TMS 2018.
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Christina Gibbs
Sent: Friday, May 10, 2019 4:07 PM
To: ListServ tmsusers <[log in to unmask]>
Subject: Re: Getty TGN TermIDs and URL
Hi Jeffrey,
Did you check the SourceTermID in TermMaster table (not Terms table)?
select T.TermID, T.Term, T.TermMasterID, TM.SourceTermID as [TM.TermSourceID aka ConceptID]
from Terms T
inner join TermMaster TM on T.TermMasterID = TM.TermMasterID
where TermID = 943322
TermID Term TermMasterID TM.TermSourceID aka ConceptID
943322 Detroit 663106 7013547
Best,
Christina Gibbs
Collections Database Manager
Detroit Institute of Arts
5200 Woodward AvenueDetroit, MI
313.578.1051 [log in to unmask]<mailto:[log in to unmask]>
From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Smith, Jeffrey
Sent: Friday, May 10, 2019 11:39 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Getty TGN TermIDs and URL
Hello TMS Users,
I was hoping that the SourceTermID in the Getty's TGN would be the same ID as that term's online record, so I could invoke the URL to point to the authoritative source term when I needed to. I guess I was wrong, but perhaps I've missed something. Perhaps someone with more experience using the TGN could explain a way to do this. Thanks for any help you might be able to provide!
Example:
Term TermID SourceTermID
Detroit 943322 236364
ID: 7013547
Page Link: http://vocab.getty.edu/page/tgn/7013547<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fvocab.getty.edu%2Fpage%2Ftgn%2F7013547&data=02%7C01%7Csmithje%40si.edu%7Ce09af07d3d344a22589308d6d58335cc%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C1%7C0%7C636931156873775695&sdata=eNh9THaIaR4w%2BR3re3ogMPygZAye1dcXwJ6JNgRWTcY%3D&reserved=0>
Jeffrey Smith
Assistant Registrar for Collections Information
Freer Gallery of Art and Arthur M. Sackler Gallery
Smithsonian
[log in to unmask]<mailto:[log in to unmask]>
202-633-0348
[cid:image001.png@01D354C6.1F08E210]
Experience where Asia meets America at the
Smithsonian's Freer|Sackler
Connect with us on social media
@freersackler #freersackler
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.
|
|
|