Oops. Yes, thank you for the correction. It was renamed whenever Thes became a web-based app. Apparently, there is a view simply called TermMaster (in our db anyway).
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Smith, Jeffrey
Sent: Friday, May 10, 2019 4:22 PM
To: [log in to unmask]
Subject: Re: Getty TGN TermIDs and URL
Apparently not - thank you! That's in TermMasterThes in TMS 2018.
From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Christina Gibbs
Sent: Friday, May 10, 2019 4:07 PM
To: ListServ tmsusers <[log in to unmask]<mailto:[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: https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fvocab.getty.edu%2Fpage%2Ftgn%2F7013547&data=02%7C01%7CTMSUSERS%40SI-LISTSERV.SI.EDU%7C4d64089653cc43090b7a08d6d58c8288%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C1%7C0%7C636931196810930025&sdata=VMEnfWeTJdgoIWtqEO31mIzV9UIhXOWZUVbXrIEk1Dw%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fvocab.getty.edu%2Fpage%2Ftgn%2F7013547&data=02%7C01%7CTMSUSERS%40SI-LISTSERV.SI.EDU%7C4d64089653cc43090b7a08d6d58c8288%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C1%7C0%7C636931196810940034&sdata=A2I7cMUkJVLnOrVtKoNfd4jHly%2BY8WrGK5GnXFs45tA%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]<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.
|