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.

 

 

Chad Petrovay  |  Collections Database Administrator
MIM-Musical Instrument Museum | 4725 E. Mayo Boulevard  | Phoenix, AZ
85050 
480.478.6000 main  |  480.478.6058 direct | 480.471.8690 fax  |
www.themim.org

 

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.)

 

 

Chad Petrovay  |  Collections Database Administrator
MIM-Musical Instrument Museum | 4725 E. Mayo Boulevard  | Phoenix, AZ
85050 
480.478.6000 main  |  480.478.6058 direct | 480.471.8690 fax  |
www.themim.org

 

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.