Importing from the Announcements Module
Last Post 3/25/2014 10:59 PM by David O'Leary. 0 Replies.
Author Messages
David O'Leary
Efficion Consulting Staff
Basic Member
Basic Member
Posts:151
Avatar

--
3/25/2014 10:59 PM

    Here's a SQL Script to help you get started on importing from the Announcements module to Efficion's Articles module.

    INSERT Article(PortalID, UserId, [CreatedDate],[Title],[Article],[Description],[PublishDate])
    SELECT PortalID,CreatedByUser,[CreatedDate],[Title],'external:'+[URL] as Article, [Description], [PublishDate] FROM [Announcements]
    ORDER BY PublishDate 



    ---