Home › Forums › LCMS / Other Content Management

How do you change all of the links to HTML snippets at once?

Wed, 2007-11-28 10:39 — donnatn

Our college has several channels within the Luminis interface that point to HTML snippets. We built another content server and now need to change all of those snippet links to reflect the new address. Any ideas on how to change links globally when you don't already have some kind of LCMS?

Thanks for any help:)

Donna

0
No votes yet
‹ SCT Nav and CSS_Nav Tags Javascript or html in Luminis file ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Wed, 2007-11-28 18:07 — uon_david

Update the URLs in the database?

Not sure quite what you mean, but if you wish to bulk change URLs for web proxy channels...

The following SQL will list all webproxy channels that are on layouts (and the usernames of the layout owners) and the URLs:

SELECT DISTINCT
    uc.chan_id,
    chan_name,
    chan_class,
    ucp.chan_parm_val,
    uu.user_name
FROM
    up_layout_struct ULS,
    up_channel UC,
    up_channel_param UCP,
    up_user UU
WHERE
    uc.chan_id = uls.chan_id
    AND uls.user_id = uu.user_id
    AND uu.user_name  LIKE '%-lo'
    AND uc.chan_id NOT IN (1, 10, 19, 92, 99, 203, 150, 7, 130, 140)
    AND uc.chan_id = ucp.chan_id
    AND ucp.chan_parm_nm = 'cw_xml'

ORDER BY
    1,2,3,4,5

From that, you should be able to figure out (however manually) how to update the database rows as necessary.

Hope that helps (a little).

Wed, 2008-01-30 05:58 — libdms

Remote HTML snippets in TCC

If you are not referring to CWebProxy, then my guess is that you are referring to sub-sections of the Targeted Content Channel.

On our Solaris Luminis III.3.3 we have a content folder which contains files like

1236435847123123897.txt (200+ of them actually)

each of which contains the text for the Freeform text/HTML subsections.

I guess that the Database contains the structure of the TCCs, and the parameter settings for the subsections. Fortunately I have not had to delve deeply into this yet.

Derek