家喻户晓，织梦曾经开始免费了，这对国内版权意识加强应该不算好事，但想要收费应用又不想惹麻烦的站长们就有点麻烦了。

有不少敌人来问，咱们 MyCms 支不反对织梦数据迁徙，目前咱们曾经实现一键导入织梦的原文章和商品了，当初简要讲述一下实现过程。

一、连贯数据库

要想实现数据的迁徙导入，那么先要失去数据库信息，所以咱们第一步就要实现填写数据库信息性能。

能够关上织梦网站的 data/common.inc.php 文件对照填写。

单次导入数据字段为执行一次导入多大量的数据，默认100条，这个能够按照本人的服务器来调整。

这一步仅仅是保留数据库信息，别无他用。

附上连贯数据库代码

//$this->config 为保留的数据库信息$dedeConnection = array_merge([    'driver' => 'mysql',    'charset' => 'utf8',    'collation' => 'utf8_unicode_ci',    'prefix' => $this->config['dede_prefix'],], $this->config);config(['database.connections.dedecms' => $dedeConnection]);$this->connection = DB::connection('dedecms');

二、导入分类/文章

1.导入文章分类，并明确上下级关系。

public function articleCategory(){    if (!Storage::exists("dede_article_category")) {        //导入分类        $categories = $this->connection            ->table('arctype')->get();        $catArray = $catParentArray = [];        foreach ($categories as $category) {            $cid = ArticleCategory::insert([                'pid' => 0,                'name' => $category->typename,            ]);            $catArray[$category->id] = $cid;            $catParentArray[$cid] = $category->topid;        }        foreach ($catParentArray as $key => $value) {            if ($value > 0) {                $ac = ArticleCategory::find($key);                $ac->pid = $catArray[$value];                $ac->save();            }        }        Storage::put("dede_article_category", json_encode($catArray));    } else {        $catArray = json_decode(Storage::get("dede_article_category"), true);    }    return $catArray;}

2.要先明确要导入文章的那些信息，而后对应好本身零碎的字段，开始导入。

附上 MyCms 导入的代码给大家参考。

public function article(): JsonResponse{    $date = date('Y-m-d H:i:s');       //最初导入ID    $lastId = Storage::exists("dede_article_last_id") ? Storage::get("dede_article_last_id") : 0;    $articles = $this->connection        ->table('archives')        ->leftJoin('addonarticle', 'aid', '=', 'id')        ->where([            ['channel', '=', 1],            ['id', '>', $lastId],        ])->limit($this->config['batch_number'])->get();    $importLog = [];    $catArray = $this->articleCategory();    foreach ($articles as $article) {        $aid = Article::insert([            'category_id' => $catArray[$article->typeid],            'title' => $article->title,            'content' => $article->body,            'description' => $article->description,            'img' => $article->litpic,            'author' => $article->writer,            'view' => $article->click,            'created_at' => date('Y-m-d H:i:s', $article->senddate),            'updated_at' => date('Y-m-d H:i:s', $article->pubdate),        ]);        if ($article->shorttitle) {            $meta = [                'article_id' => $aid,                'meta_key' => 'short_title',                'meta_value' => $article->shorttitle,            ];            ArticleMeta::insert($meta);        }        $lastId = $article->id;        $tagIds = (new ArticleTag)->insertTags(explode(",", trim($article->keywords, ",")));        (new ArticleTagRel)->insertRel($aid, $tagIds);              //导入记录              $importLog[] = [            'type' => '文章',            'oid' => $article->id,            'mid' => $aid,            'title' => $article->title,            'created_at' => $date,            'updated_at' => $date,        ];    }    Dedecms::insertAll($importLog);       //写入导入最初ID    Storage::put("dede_article_last_id", $lastId);    return $this->result(true);}

三、导入商品

导入商品也是一样的情理，就不多少，间接附上代码。

public function goods(){    $date = date('Y-m-d H:i:s');    $lastId = Storage::exists("dede_goods_last_id") ? Storage::get("dede_goods_last_id") : 0;    $articles = $this->connection        ->table('archives')        ->leftJoin('addonshop', 'aid', '=', 'id')        ->where([            ['channel', '=', 6],            ['id', '>', $lastId],        ])->limit($this->config['batch_number'])->get();    $importLog = [];    $catArray = $this->goodsCategory();    foreach ($articles as $article) {        $aid = Goods::insert([            'category_id' => $catArray[$article->typeid],            'goods_name' => $article->title,            'content' => $article->body,            'description' => $article->description,            'goods_image' => $article->litpic,            'view' => $article->click,            'shop_price' => $article->trueprice ?: $article->price,            'market_price' => $article->price,            'created_at' => date('Y-m-d H:i:s', $article->senddate),            'updated_at' => date('Y-m-d H:i:s', $article->pubdate),        ]);        if ($article->shorttitle) {            $meta = [                'goods_id' => $aid,                'meta_key' => 'short_title',                'meta_value' => $article->shorttitle,            ];            GoodsMeta::insert($meta);        }        $lastId = $article->id;        $importLog[] = [            'type' => '商品',            'oid' => $article->id,            'mid' => $aid,            'title' => $article->title,            'created_at' => $date,            'updated_at' => $date,        ];    }    Dedecms::insertAll($importLog);    Storage::put("dede_goods_last_id", $lastId);    return $this->result(true);}

最初导入胜利，并记录下来。