Cleanup Inline Links to items that no longer exist

Hi,

Does anyone have a utility for cleaning up inline links to items that no longer exist? It is a tremendous pain as broken links to fix each link manually as they are reported as broken. The closest I've found is the Code Exchange Bulk File Path Update with Reference (which is great, except for DSX-MEDIA-IMAGES).

I would think this is a common problem and probably has been reinvented several times. Anyone willing to share?

-Steve

Find more posts tagged with

Comments

Mario_DAnna

This is something I never had the time to develop.What you can do, and this is pretty easy, is to write a standalone java util (that you can execute from your IDE) that detects all broken links, and for each broken link detects what is the attribute it originates from.Can you do this ?-m________________________________________From: eLink Entry: Vignette V7 and V8 Web Content Management [v7webcontentmanagement@elinkkc.opentext.com]Sent: Thursday, September 16, 2010 4:45 PMTo: eLink RecipientSubject: Cleanup Inline Links to items that no longer existCleanup Inline Links to items that no longer exist Posted by gears@umich.edu (Coffman, Steve) On 2010/09/16 10:44Hi,Hi,Does anyone have a utility for cleaning up inline links to items that no longer exist? It is a tremendous pain as broken links to fix each link manually as they are reported as broken. The closest I've found is the Code Exchange Bulk File Path Update with Reference (which is great, except for DSX-MEDIA-IMAGES).I would think this is a common problem and probably has been reinvented several times. Anyone willing to share?-Steve________________________________[To post a comment, use the normal reply function]Forum: Vignette V7 and V8 Web Content ManagementLivelink Server: knowledge-wlweb01

Steve_Coffman

Thanks. I'm not sure how to detects all broken links. Any pointers?

I think I need to look through all the attributes and parse out all the links anyway, since some have external links to servers that have since had their machine names changed.

I have also written this SQL :

SELECT [link_id],
      [title]
      ,[url]
      ,[channel_id]
      ,[content_id]
FROM [lsa_vcm76mgmt].[dbo].[UOM_Link]
where (content_id != '' AND [content_id] not in (select contentMgmtId from vgnAsMoMetaData)) or
([channel_id] != '' AND [channel_id] not in (select contentMgmtId from vgnAsMoMetaData))