TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show HTML 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:
"Oberoi, Shyam" <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Mon, 15 Jun 2009 15:40:31 -0400
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (1799 bytes) , text/html (14 kB)
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