Hey, thanks Judith.

I figured my email was already long enough, so I didn't explain the
caveats.  What I did will have issues with two main, but common, things:

1) "forbidden" characters, notable the single apostrophe (O'Keefe) and
semi-colon.  -
https://stackoverflow.com/questions/1976007/what-characters-are-forbidden-in-windows-and-linux-directory-names

2) and this is huge for you...non-English characters.  Seeing that you are
from Zürcher Hochschule der Künste, this is probably a problem.  I think
there is a way around it but I haven't checked.

But it works for a lot of cases.  BTW, I really like the post by Danielle
this AM.

Steve

Steven MOORE

Developer & Database Administrator

Department of Information Technology


The Museum of Modern Art

11 West 53 Street

New York, NY 10019
813.240.0587




On Tue, Feb 26, 2019 at 11:26 AM Scheiber Dahou Judith <
[log in to unmask]> wrote:

> Dear Steve
>
> Thank you very much for this nice feature and your perfect instructions! I
> could detect broken links in no time. But my error list of broken paths
> became huge. I took some samples and checked in TMS – all were working
> paths and files. I guess the check stumbles over divided path information.
> In TMS sometimes a part of the path is entered in the field filename. This
> looks then like this: doc\strunck;M_presse.pdf.
>
> Best regards
>
> Judith
>
>
>
>
>
> —
>
> Zürcher Hochschule der Künste
>
> Zurich University of the Arts
>
> —
>
> Judith Scheiber Dahou
>
> Projektleiterin ITZ Planung
>
> —
>
> Pfingstweidstrasse 96, Postfach, 8031 Zürich
>
> Tel. +41 43 446 22 06
>
> [log in to unmask]
>
> —
>
> www.zhdk.ch / http://www.emuseum.ch/
>
>
>
>
>
>
>
>
>
> *Von:* The Museum System (TMS) Users <[log in to unmask]> *Im
> Auftrag von *Moore, Steven
> *Gesendet:* Montag, 25. Februar 2019 23:06
> *An:* [log in to unmask]
> *Betreff:* Re: images with broken paths
>
>
>
> This question comes up every now and then for IT, DAM, and TMS.  The same
> question occurs for a list of URLs.  So I have a little program that checks
> both.
>
>
>
> First, create a list of TMS files with this query (note: just 100 to test):
>
>
>
> SELECT TOP 100 path = mp.[Path] + mf.[FileName]
> FROM [MediaFiles] mf
> INNER JOIN [MediaPaths] mp ON mf.PathID = mp.PathID
>
>
>
> Save the results as a .txt file.
>
>
>
> Download two files from here (they are safe):
>
>
>
> https://bitbucket.org/smoore4moma/link-checker/downloads/
>
>
>
> Save the files in the same folder.  The file called LinkChecker.exe.config
> has the settings below.  Open in Notepad and edit as needed.
>
>
>
>   <appSettings>
>     <!-- mode choices are "FILE" or "URL" -->
>     <add key="mode" value="FILE" />
>     <add key="links" value="C:\Temp\files.txt" />
>     <add key="errors" value="C:\Temp\errors.txt" />
>   </appSettings>
>
>
>
> - mode: if you are checking files put FILE.  Use URL for web links.
>
> - links:  this is the list of files to check (ie, results from the SQL
> above)
>
> - errors: when done, this will have the list of files that do not exist
> where the database thinks they should be
>
>
>
> "links" and "errors" can be named whatever you want and can point to
> wherever you want.
>
>
>
> Open the path to LinkChecker.exe in a command prompt. and run it like
> this...
>
>
>
> C:\MyMuseum\Misc>LinkChecker.exe
>
>
>
> Check the errors file when it is done.
>
>
>
> Steve
>
>
>
> On Mon, Feb 25, 2019 at 3:21 PM Becky Sanchez <[log in to unmask]>
> wrote:
>
> I am also having this issue. If there is a script or query suggestion, can
> you please send it to me as well? ([log in to unmask])
>
> Thanks!
>
> -----Original Message-----
> From: The Museum System (TMS) Users <[log in to unmask]> On
> Behalf Of Caroline Im
> Sent: Monday, February 25, 2019 12:43 PM
> To: [log in to unmask]
> Subject: images with broken paths
>
> Hello,
>
> We moved servers recently and in the move, some of the image paths got
> changed (although not all). This resulted in objects that have thumbnail
> images that work but broken links to old paths to where the images used to
> be but no longer exist.
>
> I've tried to locate which objects don't have an image manually but it's
> taking quite a bit of time. I'm not even sure if I've found them all or
> not. Is there either an advanced query or a sql script that would help me
> locate images with broken links (but do have thumbnails)?
>
> I'd be happy for any insight, thank you!
>
> 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.
> This email and any files transmitted with it are confidential and intended
> solely for the use of the individual or entity to whom they are addressed.
> If you have received this email in error please notify the system manager.
> This message contains confidential information and is intended only for the
> individual named. If you are not the named addressee you should not
> disseminate, distribute or copy this e-mail.
>
> 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.
>

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.