TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

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

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

Print Reply
Sender:
"The Museum System (TMS) Users" <[log in to unmask]>
Date:
Tue, 16 Jun 2009 08:53:10 -0400
Reply-To:
"The Museum System (TMS) Users" <[log in to unmask]>
Subject:
MIME-Version:
1.0
Content-Transfer-Encoding:
quoted-printable
In-Reply-To:
Content-Type:
text/plain; charset="us-ascii"
From:
"Smith, Jeffrey" <[log in to unmask]>
Parts/Attachments:
text/plain (160 lines)
This is promising and could be very helpful. Thanks very much for
sharing!

-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Felton, Larry
Sent: Monday, June 15, 2009 9:33 PM
To: [log in to unmask]
Subject: Re: image request help

Ashley, 

While it's not a plug in, we developed a Crystal Report to help download
batches of image files. This report (attached) produces text for a batch
file, which when exported and run will copy all the images associated
with selected object records from the server to a folder of your choice.


Steps are as follows: (it's actually easier done than said :-)

1. Install the attached report in TMS; create a folder to receive the
images (e.g. F:\TMS_Image_Copy) 2. Find the object records with the
images you want (a query, object package, whatever).
3. Run the report; at the parameter prompt, identify the destination
folder (e.g. F:\TMS_Image_Copy) 4. Hit <Display>; report displays lines
of text like:
    Copy "\\mshqnas01\images\096\372\P166-131-8325_d.jpg"
F:\TMS_Image_Copy
5. Export report; format = Text (TXT); Destination = Disk file; <OK>;
<OK>; Save exported report in folder created to receive image files.
6. Change extension of exported report from .TXT to .BAT (either while
exporting or after the fact) 7. Go to destination directory; click on
batch file to run. Image files will be copied to the destination folder.
I keep the same destination folder; I just empty it after download and
reuse it.

This is not very elegant, and I make no guarantees it will work for in
all cases.  It works for us on a Microsoft Active Directory network with
Windows XP computers. I believe the destination must be a mapped drive
(i.e. have a drive letter), and assumes user has rights to both the
source and destination locations. It may not work with all odd file
naming conventions (spaces, special characters, very long path/file
names, etc.). 


Larry Felton
Archaeological Collections Unit
California State Parks
(916) 375-5923

 

-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Chris Scrofani
Sent: Monday, June 15, 2009 5:31 PM
To: [log in to unmask]
Subject: Re: image request help

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