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:
Re: broken media links
From:
Ella Rothgangel <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Tue, 24 May 2016 14:07:19 +0000
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (2720 bytes) , text/html (10 kB) 
Jeffrey –
Yes, orphaned media records is a good description.  Thanks for the tips below –

Ella

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Monday, May 23, 2016 4:35 PM
To: [log in to unmask]
Subject: Re: broken media links

Ella, Are you talking about looking for Rendition X, where the URI for the file is no longer valid (the path changed, the filename changed, or the file was deleted)?

I have been able to do this with a PHP based spider in the past. But if you are using TMS 2014+, you can use the "Media Module > Maintenance > Image Metadata" option to refresh the cached metadata. The Error Log should be able to tell you which files it couldn't extract metadata from - which would be the result of broken links.

On Mon, May 23, 2016 at 4:38 PM, Smith, Jeffrey <[log in to unmask]<mailto:[log in to unmask]>> wrote:
Ella,

Try this one:

use yourdatasource
select mr.renditionnumber
from mediamaster mm inner join mediarenditions mr on mm.mediamasterid = mr.mediamasterid
where mm.mediamasterid not in
 (select mediamasterid
from mediaxrefs)

And yes, we have some orphaned media records laying around!

From: The Museum System (TMS) Users [mailto:[log in to unmask]<mailto:[log in to unmask]>] On Behalf Of Ella Rothgangel
Sent: Monday, May 23, 2016 4:28 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: broken media links

Has anyone figured out a view, script, report, or query to see only media records where the link has been broken?


Ella Rothgangel
Acting Head of Registration
Saint Louis Art Museum
314.655.5408<tel:314.655.5408>

To unsubscribe, send an email to [log in to unmask]<mailto:[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]<mailto:[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]<mailto:[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.

ATOM RSS1 RSS2