TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Chad Petrovay <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Sat, 27 Aug 2022 21:51:47 -0400
Content-Type:
multipart/related
Parts/Attachments:
text/plain (9 kB) , text/html (21 kB) , image001.png (18 kB) , image002.png (32 kB) , image003.jpg (49 kB) , image004.jpg (49 kB) , image005.png (37 kB)
External Email - Exercise Caution
Isn't the whole point of the MainImage view that you just connect that the main table using the ID (ie, ObjectID => ID), then filter with the TableID (108), without the need for any other Media tables?

On Fri, Aug 26, 2022 at 2:01 PM Brenda Podemski <[log in to unmask]<mailto:[log in to unmask]>> wrote:
External Email - Exercise Caution
You didn’t mention it, but if you have multiple Media Renditions for a given Media Master entry and/or multiple image filenames attached to individual MediaRenditions you can filter for just the Primary Display renditions/files by making your links like so:


[cid:182e2246b484cff311]

From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Blochel-Dittrich, Iris
Sent: Friday, August 26, 2022 9:11 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: AW: Crystal formula for primary image only

External Email - Exercise Caution
Mine look like this. The main reports links to the subreport object.id<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fobject.id%2F&amp;data=05%7C01%7CTMSUSERS%40si-listserv.si.edu%7C9d8467ab083b48090e6608da8897ec87%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637972483353661922%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=MMSvqtRHmSH79teGz3vAJQJ4%2Bbuyjvyai4%2BHwEEKLjk%3D&amp;reserved=0> <-> MediaXrefs.ID

[cid:182e2246b485b16b22]

Von: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> Im Auftrag von Brad Hubley
Gesendet: Freitag, 26. August 2022 17:58
An: [log in to unmask]<mailto:[log in to unmask]>
Betreff: Re: Crystal formula for primary image only

External Email - Exercise Caution
I’ve created a report that runs from the Objects module that displays just the primary image even if the object has more than one image.  In the report I group on Object.Id and in Select Expert I have: {vgsrpMediaXrefsS_RO.PrimaryDisplay} = 1

Here are my joins:

[cid:182e2246b496917eb3]



Hope this helps.  Let me know if you’d like a copy of my report; you would of course have to modify it to run in the Loans module.


[Das Bild wurde vom Absender entfernt.]
Brad Hubley
Technician, Entomology & TMS

100 Queen's Park
Toronto, ON M5S 2C6
416 586 5764

Royal Ontario Museum is an agency of the Government of Ontario.ROM acknowledges that this museum sits on what has been the ancestral lands of the Wendat, the Haudenosaunee Confederacy,and the Anishinabek Nation, including the Mississaugas of the Credit First Nation, since time immemorial to today.

Le Musée royal de l'Ontario est un organisme du gouvernement de l'Ontario.Le ROM reconnaît que le Musée est situé sur les terres ancestrales des Wendats, de la Confédération des Haudenosaunee et des Anishinabes, y compris la Première Nation des Mississaugas de Credit, et qu’ils occupent ces terres depuis la nuit des temps.

From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Kimberly Koons
Sent: Friday, August 26, 2022 11:14 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Crystal formula for primary image only


[EXTERNAL EMAIL] DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe.
External Email - Exercise Caution
Hm.  Spoke too soon.  Still repeating - 2 entries (better than 5!). Maybe how new table (Media XRefs) is linked  - out of the box, 2 links, both inner joins...
(I freeze at the mere mention of 'joins...')
[cid:182e2246b4a855d355]

On Fri, Aug 26, 2022 at 11:08 AM Kimberly Koons <[log in to unmask]<mailto:[log in to unmask]>> wrote:
Perfect! Thank you!
Kim


On Fri, Aug 26, 2022 at 10:25 AM Blochel-Dittrich, Iris <[log in to unmask]<mailto:[log in to unmask]>> wrote:
External Email - Exercise Caution
{MediaXrefs.PrimaryDisplay} = 1


Von: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> Im Auftrag von Kimberly Koons
Gesendet: Freitag, 26. August 2022 16:20
An: [log in to unmask]<mailto:[log in to unmask]>
Betreff: Crystal formula for primary image only

External Email - Exercise Caution
I am running a Crystal report for outgoing receipt that runs from the Loans module, and pulls in tombstone information and a thumblob for inked loan objects.

If an object record has more than one media attached (eg 5 media attached0 the report is repeating object entries in the report (eg 5 times).

The image piece is a subreport, with current formulas:

{vgsrpMediaImageS_RO.ID} = {?Pm-Objects.ObjectID} and
{vgsrpMediaImageS_RO.TableID} = 108

Does anyone know how to add a formula that will only pull the Primary image?

thanks,
Kim
--
Kimberly Koons, Museum Collections Officer
Division of Museum Services
National Archives & Records Administration
700 Pennsylvania Ave., NW
Washington, D.C.    20408
NARA mobile: 301-832-0321
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.


--
Kimberly Koons, Museum Collections Officer
Division of Museum Services
National Archives & Records Administration
700 Pennsylvania Ave., NW
Washington, D.C.    20408
NARA mobile: 301-832-0321


--
Kimberly Koons, Museum Collections Officer
Division of Museum Services
National Archives & Records Administration
700 Pennsylvania Ave., NW
Washington, D.C.    20408
NARA mobile: 301-832-0321
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.

The Museum is now open and we are delighted to welcome you back. For more details and helpful information for planning your visit, please visit https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rom.on.ca%2F&amp;data=05%7C01%7CTMSUSERS%40si-listserv.si.edu%7C9d8467ab083b48090e6608da8897ec87%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637972483353661922%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=ZsJsg%2FUkFO93KJGpaCS93niqcqApDvTGEJDYFozLmA8%3D&amp;reserved=0<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rom.on.ca%2F&amp;data=05%7C01%7CTMSUSERS%40si-listserv.si.edu%7C9d8467ab083b48090e6608da8897ec87%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637972483353661922%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=WbGGAJ%2FS1SXaJBkxPGw%2B%2BsqkX%2B9LcmonzvzVJs7af9w%3D&amp;reserved=0>

________________________________

Le Musée a rouvert ses portes et nous sommes ravis de vous accueillir de nouveau. Pour en savoir plus et bien planifier votre visite, veuillez consulter https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rom.on.ca%2Ffr&amp;data=05%7C01%7CTMSUSERS%40si-listserv.si.edu%7C9d8467ab083b48090e6608da8897ec87%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637972483353661922%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=F3GlMeX3gRQOQsrhOd4HuHzhZ%2FL6Yb7W%2FO57ceW4gqY%3D&amp;reserved=0<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rom.on.ca%2Ffr&amp;data=05%7C01%7CTMSUSERS%40si-listserv.si.edu%7C9d8467ab083b48090e6608da8897ec87%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637972483353661922%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=KwJ5ph3g%2FcGWsGqZPNjatgcrr8ucqr2G7OG864IOnFU%3D&amp;reserved=0>
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.

CAUTION: This email originated from outside of the Getty. Do not click links or open attachments unless you verify the sender and know the content is safe.

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.


ATOM RSS1 RSS2