Module Discussions

Module Discussions

PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 3/25/2014 11:59 PM by  David O'Leary
Importing from the Announcements Module
 0 Replies
Sort:
Please login to post a reply.
Author Messages
David O'Leary
Efficion Consulting Staff
Basic Member
Basic Member
Posts:151


--
3/25/2014 11: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 

    Please login to post a reply.