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]> 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]]
On Behalf Of Ella Rothgangel
Sent: Monday, May 23, 2016 4:28 PM
To: [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
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.
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.
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.