Hello Melissa,

I use the media plug-in provided by Gallery Systems.  In addition to the Media plug-in, I’ve created a list view report that I export out of TMS into Excel, cut and paste it into the plug-in (MS Access), and then re-export it back into TMS. 

Here is the script for the list view report:

CREATE view MediaAdd as

select Objects.ObjectID AS ID, objects.objectid, objects.objectnumber as ObjectNumber,

RTrim(LTrim(Objects.ObjectNumber)) +'.JPG' as FileName,

'\\tms\images\screen' as Path,

'0' as PixelW,

'0' as PixelH,

'0' as ColorDepth,

'0' as FileSize,

'0' as MemorySize,

'' as FileDate,

'' as ThumbNailName,

'' as ThumbNailPath,

'' as RenditionNumber,

'' as RenditionDate,

'' as Photographer,

'' as Scanby,

'' as Technique,

'' as QuantityMade,

'' as CopyrightInfo,

'Image' as MediaType,

'JPEG' as MediaFormat,

‘Front’ as MediaView,

'' as Rank,

'' as ArchiveIDNumber,

'' as ArchCatNum,

'' as ArchVolName,

'' as ArchSubDir,

'' as ArchFilename,

'' as Description,

'' as PublicCaption,

'rwm' as Remarks,

'' as PublicAccess

from objects

The aforementioned fields in the script are in the media plug-in.  As long as you have a batch of records that will have the same values in the media module, you can populate the fields as a batch by exporting this list view into the plug-in.  For each batch, you may need to change some of the values to reflect your data entry, e.g., change remarks for a specific batch, change the media view for a specific batch, etc., etc.  Or, you can go into the Excel or Access table and change field values one by one (which is still quicker than the GUI of the TMS media module).

If anybody has a quicker method that doesn’t involve exporting a list view into Excel, cut and pasting the list view into the plug-in, and then running the plug-in, please contact me.  This is the quickest method I could devise.

Rob Morgan

Baltimore Museum of Art

Let me know if you need the script to create the list view report.  In addition, I can go into further detail at that time.

Rob Morgan

Baltimore Museum of Art

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Fournier, Melissa
Sent: Friday, October 17, 2008 10:28 AM
To: [log in to unmask]
Subject: media record creation/automation

Dear TMS users –

I am interested to hear from any of you that have automated or otherwise developed methods to streamline the creation and population of TMS media records (media type digital images/linked to Objects) as part of your digital imaging workflow.

Anyone out there who has done this and wouldn’t mind answering a few questions?  Please feel free to contact me directly, unless this is of general interest to the list.

Thanks,

Melissa

Melissa Gold Fournier
Associate Museum Registrar
YALE CENTER FOR BRITISH ART

[log in to unmask]

Mailing: P.O. Box 208280, New Haven, CT 06520
Shipping: 161 York Street, New Haven, CT 06511
Fax: 203 432 6780
Phone: 203 432 2834