Thank you all for your helpful responses!

 

JRW

 

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Milby, Jessica
Sent: Monday, November 09, 2015 10:59 AM
To: [log in to unmask]
Subject: Re: exporting a batch of images

 

We use the eMuseum Thumbnailer for this…super simple.  Run it on a package in either Objects or Media modules.  Might be easier or more comfortable for folks not expert at Crystal or SQL.  Just a thought.

--Jessica

 

 

 


Jessica Milby
Assistant Director for Collection Information

t 215-684-7283
f 215-235-0035

Philadelphia Museum of Art
PO Box 7646, Philadelphia, PA 19101-7646
www.philamuseum.org


From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christina Gibbs
Sent: Wednesday, November 04, 2015 5:43 PM
To: [log in to unmask]
Subject: Re: exporting a batch of images

 

Christine’s solution looks great. Just in case, here is another solution, courtesy Dimitry. The SQL script runs on an object package and you save the results as a .bat file. Below are my “notes to self” if they make any sense.

 

Batch Export Media Files Instructions

 

1. Create destination folder (in Temp, location probably doesn’t matter)

2. Update and Run saved query "ExportMediaFiles.sql" (script attached, please read notes)

2. Select all records, copy & paste into Notepad

3. Save as .bat file on Desktop

4. Open Command Prompt

5. Execute .bat file (example below)

 

C:\Users\CGibbs>cd desktop

 

C:\Users\CGibbs\Desktop>"type file name here (do not include extension or quotes)"

 

e.g. C:\Users\CGibbs\Desktop>BRphoto OR if there is only one .bat file on desktop: C:\Users\CGibbs\Desktop>dir *.bat

 

Best,

 

Christina Gibbs

Collections Database Manager

 

Detroit Institute of Arts

5200 Woodward AvenueDetroit, MI

313.578.1051  [log in to unmask]

 

 

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christine Droll
Sent: Wednesday, November 04, 2015 5:09 PM
To: [log in to unmask]
Subject: Re: exporting a batch of images

 

Jarred, I have just the ticket! Courtesy Larry Felton from the California State Parks at the request of Ashley Burke, from your very institution, back in June 2009.

 

Open the e-mail thread, and there’s a Crystal Report that will facilitate this. While I use it infrequently, it comes in so handy when I need it!

 

 

Christine Droll

Registrar, Database & Collections

The Nelson-Atkins Museum of Art

4525 Oak Street | Kansas City, MO 64111

p 816.751.1333 | f 816.751.0499

[log in to unmask]

 

 

 

 

 

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Wilson Jarred
Sent: Wednesday, November 04, 2015 3:52 PM
To: [log in to unmask]
Subject: exporting a batch of images

 

Hi all,

 

I need to export a bunch of images (upwards of 2,000). I can pick them out of our media folder, but they’re not sequential and this seems daunting to do one-by-one. Does anyone know of a way to isolate images based on a set of records (i.e. a query result or an object package)? I imagine this would involve running a report to generate a list of media paths & file names, then using that list to load into a script on our network which can copy/paste to a location we choose.


If anyone has done something like this or has some insight, I would greatly appreciate it.


Thanks!

Jarred

 

Jarred Wilson

Associate Registrar

 

The John and Mable Ringling Museum of Art

5401 Bay Shore Road

Sarasota, FL 34243

 

tel. 941-359-5700 x1504

fax 941-359-7716

www.ringling.org

 

TheRingling_iconsTOP_fsu

 

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.