Home

Aug 20, 2018

how to migrate cmsms news + comments to cgblog


Thanks to Gregor for the original tutorial, found on the cmsms forum.

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

Category:Tutorials 
Posted by: Admin

Thanks to Gregor for the original tutorial, found on the cmsms forum.

I've been using the combination news + comments as a sort of blog module. Because of the existence of CGBlog, I wanted to migrate my data to cgblog. 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 CGBlog
2. Install CGFeedback
3. Insert News-items into CGBlog. 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.

insert into cms_module_cgblog
(`cgblog_id`, `cgblog_title`, `cgblog_data`, `cgblog_date`, `summary`, `start_time`, `end_time`, `status`, `create_date`, `modified_date`, `cgblog_extra`, `url`)
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

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

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

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

insert into cms_module_cgblog_blog_categories
(`blog_id`, `category_id`)
select
`news_id`, `news_category_id`
from cms_module_news

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

insert into cms_module_cgblog_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

8. Insert the field values, if any:

insert into cms_module_cgblog_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

9. Make sure you add the correct sequent number:

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

10. 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_module_cgblog SET author='author' WHERE author='1'

Sometimes you need to update the "cms_module_cgblog_seq", as it will be showing the wrong number when making a new cgblog news.

 

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

authorarticle: Master3395

image: 

keywords: cmsms, cms, cgblog, convert, migrate, move, news, blog

Previous Article
Next Article
Discord

Page 1 of 336  >  >>

Now the October update for Windows 10 rolls out

windows10.jpg

Nov 21, 2018 | Category: Microsoft | Comments

Finally - here are the improvements.

Microsoft has had a very hard time rolling out the October update to Windows 10 (version 1809), but now it seems that the pieces fall into place.

read more…

Female is reported to have reset her iPhone under investigation

police-iphone.jpeg

Nov 20, 2018 | Category: Apple | Comments

The phone was used for evidence purposes in a shooting event.

Often information that can be retrieved from phones relevant to the police is being investigated in a criminal case. Such important information can be a lot of things, including an overview of contacts and possible planning of crime - largely the most likely to help criminalize a person.

read more…

CloudFlare's privacy app is here

cloudflare-1.1.1.1-ios-android.png

Nov 19, 2018 | Category: IT | Comments

Free and available now for iOS and Android.

It's been several months since the networking giant Cloudflare showed the DNS service 1.1.1.1 that focuses on privacy, readily available to consumers. Now the application is available for free for Apple devices and Android.

read more…

Page 1 of 336  >  >>