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