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<http://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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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<http://www.ringling.org/>

[cid:image001.jpg@01D11BAA.F7162930]

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

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.