LISTSERV - TMSUSERS Archives - SI-LISTSERV.SI.EDU

Hi Chad, Michelle, everyone,

At MoMA, I’ve set up a separate image folder for full-page image reports. All primary images (and others on request) are sized and padded with white to either:

72 dpi, 540x576

150 dpi, 1125x1200

Our weekly process is basically the following:

1. Query sql for the set of new primary images added during the previous week

2. Run a copyfile.cmd to extract copies of those images from our TMS images server

3. Use a combination of Expression Media and Photoshop to resize/pad with white and move to our full-page image folder

The resolution/size is decided based on the size of the original images.

By pointing full-page image reports to this separate folder, everything is perfectly sized on the page.

Jeri

Jeri Moxley

Manager, Collection and Exhibition Technologies

Collection Management and Exhibition Registration

The Museum of Modern Art

11 West 53 Street, New York, NY 10019-5497

Tel. (212) 708-9599 Fax. (212) 333-1102

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Wednesday, March 31, 2010 5:53 PM
To: [log in to unmask]
Subject: Re: Full Size Images in Reports

[Michelle asked for some clarification off-list, so I thought others might be interested as well.]

Insert any picture into your Crystal Reports. Right Click on the picture and select “Format Graphic”. The “Picture” tab has “Graphic Location” where you can enter the formula “{MediaPaths.Path}+{MediaFiles.FileName}” (You may be using a view that helps to filter images, but these are the two fields from that view that you’ll need. Beware that some views include Path and Filename, but these refer to the thumbnail file, rather than the fullsize image).

The problem is that unless all of your images have an identical height and width, it is very hard to get the sizing/scaling down perfect. You’ll notice that none of the other fields under the “Picture” tab allow you to enter a formula.

We cache our thumbnails padded with white to 192x192, so that scaling and sizing aren’t an issue when we create reports. But this limits us to having 192x192 as the maximum size of images, without resolution lose in stretching them to a larger size.

Blog: www.petrovay.com/tmsblog

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Wednesday, March 31, 2010 2:10 PM
To: [log in to unmask]
Subject: Re: Full Size Images in Reports

Your report uses the MediaRenditions.ThumbBLOB stored in the database, whereas you want to dynamically add an image using the MediaPaths.Path concatenated with the MediaFiles.FileName. Unfortunately, Crystal Reports will only allow you to set the width - and at that not dynamically with MediaFiles.PixelW – which works nicely with landscape images, but reeks havoc with portrait images. (A major shortcoming in my book.)

Blog: www.petrovay.com/tmsblog

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Roberts, Michelle, DCA
Sent: Wednesday, March 31, 2010 1:54 PM
To: [log in to unmask]
Subject: Full Size Images in Reports

I’m trying to add a full size image to my report (and I’m not having much luck). I have a report with a thumbnail which I’m trying to alter. Can anyone assist me? The report is attached.

Thanks,

Michelle

Michelle Gallagher Roberts

Chief Registrar

New Mexico Museum of Art

(formerly Museum of Fine Arts)
107 West Palace Avenue
Santa Fe, NM 87501

505-476-5066 phone

505-476-5076 fax

[log in to unmask]

Confidentiality Notice: This e-mail, including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the Sybari - Antigen Email System.