Website Content Migration from Drupal to Wordpress

WordPress is absolutely free and open source content management system (CMS) coded in PHP language. It is simple and easy to use open source technology based on PHP and MySQL framework. It has variety of features such as built in template library, plug in based architecture support. The plug in feature in the website gives superb feel to the bloggers with awesome features and functions. Wordpress provides high customization, robustness and flexibility.

Nowadays many people are thinking of migrating their website from Drupal to WordPress. At first glance, it seems easy but actually it requires a lot of patience and care in doing it. For example: You have a WordPress website installed with its theme and now you want to get all the contents into your WordPress database such as pages, posts, comments, forums etc. from your Drupal website. One way of doing this is you can replicate the data of the comments (from comments table of Drupal to comments table of WordPress), posts (from node and node_revisions table of Drupal to posts table of WordPress) and categories (move data from term_data of Drupal to term_taxonomy table of WordPress).

Hurdles or issues to be taken care of while migrating from Drupal to WordPress

Mapping the URL

The pattern of URL followed in Drupal is more flexible than in WordPress. URL pattern in Drupal can be defined at the node level. So it becomes difficult to have the same URLs when you are replicating the Drupal pages and posts.

Content fields and type

Creating customized types and fields in Drupal is easy but migrating them to WordPress is challenging. In WordPress, each type or field is stored in different table and different structure.

Suppose you have a database called WordPress using ‘wp_’ prefix and a database named Drupal. Now following script should be used.

# To clear all existing WordPress content
TRUNCATE TABLE wordpress.wp_comments; TRUNCATE TABLE wordpress.wp_links; TRUNCATE TABLE wordpress.wp_postmeta; TRUNCATE TABLE wordpress.wp_posts; TRUNCATE TABLE wordpress.wp_term_relationships; TRUNCATE TABLE wordpress.wp_term_taxonomy; TRUNCATE TABLE wordpress.wp_terms;

# To create Categories
INSERT INTO wordpress.wp_terms (term_id, `name`, slug, term_group) SELECT d.tid, d.name, REPLACE(LOWER(d.name), ' ', '_'), 0 FROM drupal.term_data d INNER JOIN drupal.term_hierarchy h USING(tid);

# To import pages / posts
INSERT INTO wordpress.wp_posts (id, post_content, post_date, post_excerpt, post_title, post_name, post_modified, post_type, `post_status`) SELECT DISTINCT n.nnid `id`, FROM_UNIXTIME(n.created) `post_date`, r.body `post_content`, n.title `post_title`, r.teaser `post_excerpt`, IF(SUBSTR(a.dst, 11, 1) = '/', SUBSTR(a.dst, 12), a.dst) `post_name`, FROM_UNIXTIME(n.changed) `post_modified`, n.type `post_type`, IF(n.status = 1, 'publish', 'private') `post_status` FROM drupal.node n INNER JOIN drupal.node_revisions r USING(vid) LEFT OUTER JOIN drupal.url_alias a ON a.src = CONCAT('node/', n.nnid) WHERE n.type IN ('post', 'page', 'article');

# Turn your articles to posts
update wordpress.wp_posts set post_type='post' where post_type='article';

# To update count of category
UPDATE wordpress.wp_term_taxonomy tt SET `count` = ( SELECT COUNT(tr.object_id) FROM wordpress.wp_term_relationships tr WHERE tr.term_taxonomy_id = tt.term_taxonomy_id);

# To import the comments
INSERT INTO wordpress.wp_comments (comment_post_ID, comment_date, comment_content, comment_parent, comment_author, comment_author_email, comment_author_url, comment_approved) SELECT nnid, FROM_UNIXTIME(timestamp), comment, thread, name, mail, homepage, status FROM drupal.comments;

# To fix breaks in post
UPDATE wordpress.wp_posts SET post_content = REPLACE(post_content, '', '');

# To fix images in post
UPDATE wordpress.wp_posts SET post_content = REPLACE(post_content, '"/files/', '"/wp-content/uploads/');

About the Author:
This article is contributed by ValueCoders, a web/mobile development firm, specialized in CMS development, through which you can hire Drupal programmers, Joomla programmers, magento programmers, etc. One can also hire WordPress developer here for effective WordPress development services.

Comments

Post a Comment

Popular posts from this blog

How to construct a B+ tree with example

Image
A B+ tree contains n-1 search key values K1K2…….Kn-1 and have n pointers.   In a B+ tree the data are ordered  sequentially.  The leaf node may hold up to n pointers and must hold at least N/2 pointers. The root node must hold at least two pointers, unless the tree consists of only one node.  Now we construct a B+ tree. Construct a B+ tree for the following set of key values: (2,3,5,7,11,17,19,23,29,31) Assume that the tree is initially empty and values are added in ascending order. Construct a B+ tree where the pointer number is Four. Solution: When a node exceeds n-1 search key value then we split it into two nodes. First node contains (ceiling(n-1)/2) values.  2 nd node contains remaining node. Copy the smallest search key value of the second node to the parent node. Let's start, we know each node has N pointer and has N-1 search key values. In our example pointer number is 4, so the search key value is 4-1=3. So each node has 4 pointers and 3 search key value. The first node i
Read more

How to show only month and year fields in android Date-picker?

Image
Android default DatePicker show day/month/year fields but you have to customize this DatePicker as your requirements. Suppose that you want to show only month and year fields in android datepicker . To do this, you have to customize the Dialog DatePicker source code but it is not an easy task. In this tutorial I will show you a tricky way to solve this problem. Lets see how to show only month and year field in android DatePicker as a dialog.   Step to show only month and year fields in android date-picker: Some days ago I got this same problem and here I am trying to explain this in a sequential manner. I want to show a dialog datepicker when user click on an EditText. So if user click on EditText, A dialog datepicker will be invocked and it will show only month and year fields. To do this, at first we have to create a xml layout to hold the EditText fields. So create an android project and name it DatePickerExample. In the main.xml file just try to write this simple code.  main.xml
Read more

Visitor Counter Script Using PHP

Image
If you have noticed that many websites display their total numbers of visitors.In this tutorial I am going to explain you how to create a simple visitor counter using php. For this, 1) Create one table called “visitor_counter” in your database. 2) Create file named “counter.php”. Step1: Creating “visitor_counter” Table CREATE TABLE `visitor_counter` ( `counts` int(10) NOT NULL default '0' ) Step2: Creating “counter.php” File <?php  // Database Details $host="localhost"; $username="root"; $password=""; $db_name="test"; $tbl_name="visitor_counter"; // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect to server "); mysql_select_db("$db_name")or die("cannot select DB");  $sql="SELECT * FROM $tbl_name"; $result=mysql_query($sql); $rows=mysql_fetch_array($result); $counter=$rows['counts']; // se
Read more