想把dedecms轉(zhuǎn)換到帝國CMS，但是目前還沒有好用的轉(zhuǎn)換程序，我們經(jīng)過收集整理測試，將手動轉(zhuǎn)換的辦法分享給大家，主要是通過SQL語句升級數(shù)據(jù)庫。
一、批量導(dǎo)入欄目：
insert into phome_enewsclass (classid,bclassid,classname,myorder,classpath,intro,classpagekey) select id,reid,typename,sortrank,typedir,description,keywords from dede_arctype
二、導(dǎo)入文章
insert into phome_ecms_news (id,classid,truetime,onclick,title,titlepic,filename,newstime,lastdotime,smalltext,keyboard) select id,typeid,sortrank,click,title,litpic,filename,pubdate,senddate,description,keywords from dede_archives
三、導(dǎo)入文章來源作者
update `dede_archives` da,mlf_ecms_news_data_1 men set da.source=men.befrom,da.writer=men.writer where da.id=men.id
四、導(dǎo)入文章body（內(nèi)容）
insert into phome_ecms_news_data_1 (id,classid,newstext) select aid,typeid,body from dede_addonarticle men
五、其他可能用的語句（參考）：
1、替換多余的路徑
update phome_enewsclass set classpath = replace(classpath,'{cmspath}/','')
2、批量設(shè)置文章屬性：
UPDATE phome_enewsclass SET lencord = '25', link_num = '10', classtype= '.HTML',newspath = '',filename = '.html',hotline = '10',goodline = '10',newline = '10',hotline = '10',modid = '1',checked = '1',tbname = 'news',down_num = '2',online_num = '2',listorderf = 'id',listorder = 'DESC', reorderf= 'newstime',reorder = 'DESC',jstempid = '1',addreinfo = '1',islast = '1',filetype='.html'listtempid = '1',newstempid = '1' filetype='.html',newspath = ''filetype='.html'
六：常見問題：
1、目錄權(quán)限
2、設(shè)置：欄目父子關(guān)系
