External Email - Exercise Caution
Dear Sally

As of 2016 R2, at least, you can't: the table exists, but there's no access to it through the UI. This is frustrating.

Alas, I've only added a couple of rows so far, and don't have a note of the script I used, but you'll want to INSERT INTO TermMasterGeo, and you'll need to know the TermMasterID of the place whose details you're recording. I'm not sure of precisely how the fields are used for TGN entries (we don't have the TGN), but a quick look at existing data should tell you what you need to know.

Sorry not to be more help,

Rupert


Rupert Shepherd, PhD FSA
Collection Information Manager
E [log in to unmask]<mailto:[log in to unmask]>
T +44 (0)20 7747 5921

Currently working remotely; calls to the number above should still reach me.

-----Original Message-----
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Sally Fletcher
Sent: 27 September 2021 04:29
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: [EXTERNAL] Adding latitude and longitude data to Thes of Geographic Names

This Message originated outside your organization.

Hello TMS users

I have added a new concept place name to the Thesaurus of Geographic Names but I can’t see how to add latitude and longitude and related data to this concept. Can anyone tell me how to do this through the thesaurus manager?

If not possible through the thesaurus manager, does anyone have a script to add this data through SQL?

We are currently using TMS2018 (version 9.70).

Thank you for any help,

Sally

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.