Home › Support › Knowledge Base ›

Cleaning Academus Channel Publication for DLM usage after Toro Migration

Knowledge Base: Academus, Academus 2.0, Academus 2.1
Updated: April 16, 2008
How can I update the channel publications so DLM fragments recognize its specified channels after a Toro migration ?
The DLM layouts rely on being able to lookup channels based on a distinct functional name (fname). It will have trouble if there are duplicate fname values. We have to insure there are no duplicates. You can check for duplicates with the following sql query:

select chan_id, chan_fname, chan_class from up_channel where chan_fname in
(select chan_fname from up_channel group by chan_fname having count(chan_class) > 1) order by chan_fname;

Then suppose it returned that the following had multiple publications. You would clean it up with commands similar to:

sphinx=> select * from up_channel where chan_fname = 'Survey Author';
 chan_id |      chan_fname      |                               chan_class                                
---------+----------------------+-------------------------------------------------------------------------
    2013 | Campus Announcements | net.unicon.portal.channels.campusannouncement.CampusAnnouncementChannel
     117 | Campus Announcements | net.unicon.portal.channels.campusannouncement.CampusAnnouncementChannel
    2020 | Campus Resources     | org.jasig.portal.channels.CGenericXSLT
     116 | Campus Resources     | org.jasig.portal.channels.CInlineFrame
    2014 | Discussion Forums    | net.unicon.portal.channels.forums.CForums
     123 | Discussion Forums    | net.unicon.portal.channels.forums.CForums
     130 | Poll                 | net.unicon.portal.channels.survey.poll.CPoll
    2015 | Poll                 | net.unicon.portal.channels.survey.poll.CPoll
    2016 | Survey               | net.unicon.portal.channels.survey.survey.CSurvey
     128 | Survey               | net.unicon.portal.channels.survey.survey.CSurvey
     129 | Survey Author        | net.unicon.portal.channels.survey.surveyauthor.CSurveyAuthor
    2017 | Survey Author        | net.unicon.portal.channels.survey.surveyauthor.CSurveyAuthor

update up_channel set chan_fname = 'Campus Announcements OLD' where chan_id = 117;
update up_channel set chan_fname = 'Poll OLD' where chan_id = 130;
update up_channel set chan_fname = 'Survey OLD' where chan_id = 128;
update up_channel set chan_fname = 'Survey Author OLD' where chan_id = 129;