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