Hi Jon,
Appreciate your clarifications. I have the entity relationship diagrams from 2012. So, are the diagrams available updated to TMS 2018 (we just upgraded, as of yesterday). Or do the 2012-era diagrams + document
summarizing changes for 2016 cover everything?
Best,
Aaron
From: The Museum System (TMS) Users <[log in to unmask]>
On Behalf Of Jon Thristan
Sent: Tuesday, December 11, 2018 6:31 AM
To: [log in to unmask]
Subject: Re: Reporting on media-related constituents
Hi All
Media-related Constituents are linked to MediaRenditions not MediaMaster. For the vast majority of clients where only one media file is ever related to a TMS media record, one row in the MediaMaster table is related to
one row in the MediaRenditions table, which has Tableid = 322.
So, the Tableid in ConXrefs for MediaRendtions is 322 and the ID is the MediaRenditionID. As Geoffrey points out, link from ConXrefs to ConXrefDetails and from ConXrefDetails to Constituents to fetch the DisplayName,
and filter out the ‘UnMasked’ row on ConXrefDetails i.e. {ConXrefDetails.UnMasked} = True (there are 2 rows inserted into ConXrefDetails for every Conxref row to support ConstituentAnonymity: one
row has ‘UnMasked’ value =1 and another row has ‘UnMasked’ value = 0: this is represented by Crystal Reports as True/False)
The schema diagrams can be downloaded from the Community Portal (contained in Upgrade Packages, as Rupert points out). The schema diagrams weren’t updated for TMS 2016 and TMS 2016R2, but a document summarising the changes
was produced for both. The full set of schema diagrams is available for all other versions of TMS, including TMS 2017 and 2018.
Best wishes
Jon
Jon Thristan |
Manager of Professional Services
[log in to unmask]
|
+44 20 7993 8402
GallerySystems |
www.gallerysystems.com
----
Join us in Dublin, Ireland for
Collective Imagination 2019
The International TMS Users Conference
Workshops: April 8 – 9, 2019
Conference: April 10 – 11, 2019
Learn more
here.
From: The Museum System (TMS) Users <[log in to unmask]>
On Behalf Of Aaron Zalonis
Sent: 11 December 2018 09:57
To: [log in to unmask]
Subject: Re: Reporting on media-related constituents
Thanks, Rupert. I will give this a try. We just (as of yesterday) upgraded to TMS 2018. I'm test-piloting it to make sure everything still works fine for us, then having our IT people port everyone else over.
Best,
Aaron
box 90732 durham nc 27708-0732
t +1
919 684 1971
f +1
919 681 8624
From: The Museum System (TMS) Users <[log in to unmask]>
on behalf of Shepherd, Rupert <[log in to unmask]>
Sent: Tuesday, December 11, 2018 4:26 AM
To: [log in to unmask]
Subject: Re: Reporting on media-related constituents
Try ConXrefs.TableID = 322.
23 would be linking constituents to constituents, which is handled in the Associations table.
I usually refer to the schema diagrams to confirm the relevant joins; they'll be in your folder of upgrade files, though I think were last issued in 2014: the ones I use (and we're on 2016 R2) are in ..\TMS2014_(from_2012)\Documentation\Data Dictionary\TMS
2014 Schema diagrams.
Hope this helps!
Rupert
Rupert Shepherd, PhD FSA
Collection Information Manager
[log in to unmask]
Tel: +44 (0)20 7747 5921
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Aaron Zalonis
Sent: 11 December 2018 02:13
To: [log in to unmask]
Subject: Re: Reporting on media-related constituents
I'm working with this but I'm a little confused; there is no tableID = 23 in ConXrefs.TableID.
Best,
Aaron
-----Original Message-----
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Smith, Jeffrey
Sent: Monday, December 10, 2018 3:17 PM
To: [log in to unmask]
Subject: Re: Reporting on media-related constituents
Attached is a picture of the table linking you'll need to use. Selection formula must include {ConXrefs.TableID} = 23 (meaning constituents) and {ConXrefDetails.UnMasked} = True.
-----Original Message-----
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Aaron Zalonis
Sent: Monday, December 10, 2018 1:37 PM
To: [log in to unmask]
Subject: Reporting on media-related constituents
Hi, all,
Has anyone ever created a report that reports on media-related constituents? Despite all my efforts, I'm failing miserably at this. Any advice or actual reports is greatly appreciated.
All my best,
Aaron
AARON ZALONIS
ASSISTANT REGISTRAR / DATABASE MANAGER
NASHER MUSEUM OF ART AT DUKE UNIVERSITY
box 90732 durham nc 27708-0732
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.