Category: General|Aug 12, 2019 | Author: Admin

how to migrate cmsms news + comments to Pressroom (cms 2.3)

Share on

I've been using the combination news + comments as a sort of blog module. Because of the existence and migration i cms 2.3, I wanted to migrate my data to Pressroom. In the following part, I'll show/explain what I have done. 

I've been using the combination news + comments as a sort of blog module. Because of the existence and migration i cms 2.3, I wanted to migrate my data to Pressroom. In the following part, I'll show/explain what I have done. 

The basis is to keep the numbering of news articles equal to cgblog articles. This because it helps you to 'link' comments being made to the blog article.

0. Create a backup of the database and store it in a safe place!!!!
1. Install CGFeedback
2. Insert News-items into Pressroom. Replace 'Your Name' with the writer of the article. In this case, all articles are written by me. If you have more writers, you have to add these names manually. (Or you can use a Custom Field, in order to use Autor name)

insert into cms_mod_pressroom_articles
(`id`, `title`, `content`, `news_date`, `summary`, `start_time`, `end_time`, `status`, `create_date`, `modified_date`, `extra`, `url_slug`)
select
`news_id`, `news_title`, `news_data`, `news_date`, `summary`, `start_time`, `end_time`, `status`, `create_date`, `modified_date`, `news_extra`, NULL
from cms_module_news

3. First, delete all rows from the cgblog_category table, so you have an empty table. Manual action.
4. Insert the news categories into the cgblog categories:

insert into cms_mod_pressroom_articles
(`id`, `name`, `parent_id`, `hierarchy`, `long_name`)
select
`news_category_id`, `news_category_name`, `parent_id`, `hierarchy`, `long_name`
from cms_module_news_categories

5. Insert the relation between the blog categories and the news categories:

insert into cms_mod_pressroom_articles
(`id`, `category_id`)
select
`news_id`, `news_category_id`
from cms_module_news

6. If you have made any field definitions in News, insert these into field defs. from the cgblog module:

insert into cms_mod_pressroom_fielddefs
(`id`, `name`, `type`, `create_date`, `modified_date`, `item_order`, `public`, `attrs`)
select
`id`, `name`, `type`, `create_date`, `modified_date`, `item_order`, `public`, `extra`
from cms_module_news_fielddefs

7. Insert the field values, if any:

insert into cms_mod_pressroom_fieldvals
(`cgblog_id`, `fielddef_id`, `value`, `create_date`, `modified_date`)
select
`news_id`, `fielddef_id`, `value`, `create_date`, `modified_date`
from cms_module_news_fieldvals

8. Make sure you add the correct sequent number:

insert into cms_module_cgblog_seq
(`id`)
select
`id`
from cms_module_news_seq

9. Change the author collum for every post, to your desired username. (new usernames won't be like this unless you manually change it)

UPDATE cms_mod_pressroom_articles
SET author_id = 'Admin'

[Note, this tutorial is not complete, you may comment or send us an e-mail if you have updates.]

Sponsored Ads:

Comments:


Just Don't Ask Nintendo About 'Switch 2'

Category: General|Jun 17, 2024 | Author: Admin

Adobe to adapt terms of service on gen AI training after customer backlash

Category: IT|Jun 16, 2024 | Author: Admin

Microsoft delivers a light Patch Tuesday for June

Category: Microsoft|Jun 15, 2024 | Author: Admin

Ending Android after 14 years

Category: Google|Jun 14, 2024 | Author: Admin

Apple pays nothing

Category: Apple|Jun 13, 2024 | Author: Admin

Netgear WNR614 flaws allow device takeover, no fix available

Category: IT|Jun 12, 2024 | Author: Admin

Malicious VSCode extensions with millions of installs discovered

Category: Microsoft|Jun 11, 2024 | Author: Admin

Brave says May 2024 was its biggest growth month ever

Category: IT|Jun 10, 2024 | Author: Admin

The speedometer can disappear - now in crisis Volvo is updating over 70,000 cars

Category: IT|Jun 9, 2024 | Author: Admin

LastPass says 12-hour outage caused by bad Chrome extension update

Category: IT|Jun 8, 2024 | Author: Admin

Netflix is ‚Äč‚Äčtesting big changes

Category: General|Jun 7, 2024 | Author: Admin

Launcher for macOS and Linux

Category: IT|Jun 6, 2024 | Author: Admin

“Microsoft tracks children”

Category: Microsoft|Jun 5, 2024 | Author: Admin

Microsoft Edge reaches its all-time new high of 13.14% in the desktop browser market

Category: IT|Jun 4, 2024 | Author: Admin

Google warns Chrome users: Adblock may disappear

Category: Google|Jun 3, 2024 | Author: Admin
more