TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Chris Scrofani <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Mon, 15 Jun 2009 14:31:21 -1000
Content-Type:
text/plain
Parts/Attachments:
text/plain (97 lines)
Ashley, once you have the list of images from the query that Shyam 
provided, you could just create a simple autoexec.bat file that 
automatically copies all of the files into one folder.

Chris

--
Chris Scrofani
Network Administrator
Honolulu Academy of Arts
900 South Beretania Street
Honolulu, HI 96814
Tel. 808 532-3625
[log in to unmask]



Oberoi, Shyam wrote:
>
> Hi Ashley, don’t know if this is useful, but you can always query your 
> TMS DB to get the info:
>
> select p.path, f.filename, *
>
> from mediafiles f, mediarenditions r, MediaXrefs x, mediapaths p, 
> objects o, objpkglist opl, objectpackages op
>
> where f.renditionid = r.renditionid
>
> and r.mediamasterid = x.mediamasterid
>
> and f.pathid = p.pathid
>
> and x.id = o.objectID
>
> and o.objectid = opl.objectid
>
> and opl.objectpackageid = op.objectpackageid
>
> and op.name = ‘[name of your TMS object package]’
>
> Once you have the network path & filename it should be relatively 
> straightforward to retrieve the actual files
>
> Shyam Oberoi
>
> Sr. Website Technology Manager
>
> The Metropolitan Museum of Art
>
> ---------------------------------------------
>
> [log in to unmask]
>
> p. 212-650-2303
>
> ------------------------------------------------------------------------
>
> *From:* The Museum System (TMS) Users 
> [mailto:[log in to unmask]] *On Behalf Of *Burke, Ashley
> *Sent:* Tuesday, June 09, 2009 2:21 PM
> *To:* [log in to unmask]
> *Subject:* image request help
>
> Hello Wise TMS users-
>
> I would love to export a group of images based off an object package. 
> Is there an easy way to do a batch export of images like this? Of 
> course, we can open each image in an external viewer, but this is time 
> consuming when you have a hundred images OR we could copy out of our 
> media folder, but this is also time consuming when you have thousands 
> of images in a folder. We are just looking for a shortcut to help us 
> when we are working on exhibitions based off of object packages. Maybe 
> someone has a plug in that can do this?
>
> Thanks!
>
> Ashley
>
> Ashley Burke
>
> Assistant Registrar
>
> The John and Mable Ringling Museum of Art
>
> 5401 Bay Shore Rd.
>
> Sarasota, FL 34243
>
> 941-359-5700 ext. 1504
>
> [log in to unmask]
>
> This e-mail is subject to the Sunshine Act and its contents may be 
> subject to public disclosure.
>

ATOM RSS1 RSS2