Anand Nataraj

Posts Tagged ‘wordpress’

Cogzidel has several business models and one of the business models that is getting more attention is CogzidelTemplates.Com. So what does CogzidelTemplates.Com offer?

• Specialty templates for successful products like Magento, Clipshare, Dolphin, Joomla, WordPress and many more.
• Products are offered for low cost and for free too.
• Tools, tutorials and information / links related to web design, graphic design & CSS.

Last one month we are getting lots of exposure for low cost & free templates because of which we get lots of customization request. We are also able to get exposure to other businesses like Cogzidel Consultancy Services & Cogzidel Technologies. 
 

I must thank Mr.Major Karthik for all his efforts and single handedly taking this concept for what it is today and we can expect more accomplishments and innovations from him in coming days. We wish him best of luck.

Please let us know if you have any suggestions like adding new specialty templates for new products, marketing CogzidelTemplates.Com and any other suggestion.

I’m a WordPress Bhoy boy looking for a WordPress girl yes for last 2 days I’m using WordPress… Not it is not a fools day prank… You can check this blog is on WordPress… I’ve been using Drupal CMS for my blog for last 4 years and I’ve great love for Drupal… There were lot criticism and cry from Drupal world… Even I got a shout from a buddy in twitter…

tronathan@anandnataraj Why on earth would you go from drupal TO wordpress? please enlighten me…6:19 AM Mar 29th from TweetDeck in reply to anandnataraj

For Drupal lovers or WordPress lovers let me confess I’m still a Drupalian by heart and WordPress is just a mask… I still challenge everyone that Drupal is the best CMS in the world than any other CMS… So, you can ask me why I converted from Drupal to WordPress… Here are my justifications

•  
  • WordPress is quick in giving updates and more happening now-a-days
  • WordPress has all the tools for running a blog, which drupal must improve
  • WordPress admin interface is very simple to use
  • WordPress has more plugins and themes compared to drupal
  • Last but not least I get lot of enquries on wordpress customization… So using the system will help me understand client’s challenges and expectation…

I decided to convert to WordPress a month back, but I researched a lot on reading other blogs on lessons as I didn’t want to take a change… But itz all done within an hour and the process was very simple… This is what I did;

1.)    Installed WordPress in a folder /blog…

2.)    Make sure both wordpress and drupal tables are in same database…

Please use below SQL queries to export the posts and comments from drupal to wordpress 2.7.1. I used phpmyadmin to write queries

This sql will export all posts from drupal to wordpress 2.7.1

# Use the Drupal database

use db261070012;

# Remove all current posts from WordPress

TRUNCATE TABLE wp_posts;

# Insert posts from Drupal into WordPress

INSERT INTO wp_posts (id, post_date, post_content, post_title, post_excerpt, post_name, post_modified, post_type, `post_status`)

SELECT DISTINCT

n.nid `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`,

‘post’ `post_type`,

IF(n.status = 1, ‘publish’, ‘private’) `post_status`

FROM cms_node n

INNER JOIN cms_node_revisions r

USING(vid)

LEFT OUTER JOIN cms_url_alias a

ON a.src = CONCAT(‘node/’, n.nid)

;

            This sql will export all comments from drupal to wordpress 2.7.1

TRUNCATE TABLE wp_comments;INSERT INTO wp_comments (comment_post_ID, comment_date, comment_date_gmt, comment_content, comment_parent, comment_author, comment_author_email, comment_author_url, comment_author_ip, comment_approved)SELECTnid,FROM_UNIXTIME(timestamp),FROM_UNIXTIME(timestamp),comment,0,name,IF(mail=”, CONCAT(REPLACE(LOWER(name),’ ‘, ”), ‘@’, hostname, ‘.localhost’), mail),homepage,hostname,1FROM cms_comments;

This sql will update the number of counts in wordpress posts table

 

# update comments count on wp_posts tableUPDATE wp_posts SET comment_count = (SELECT COUNT(comment_post_id) FROM wp_comments WHERE wp_posts.id = wp_comments.comment_post_id);

3.)    In Drupal, I used url alies which was like /my_post_title_name and I wanted to have the same url alies.
To do this I updated the WordPress Permalink settings:
Custom Structure : %postname%    

4.)    120 posts and 98 comments were successfully imported from drupal to wordpress…

5.)    Finally pointed my site’s destination from /anandnataraj (location where drupal files reside) to /anandnataraj/blog (wordpress files)…

6.)    Changed rewritebase in /anandnataraj/blog/.htaccess from “/blog” to “/”…

7.)    Changed the site URL and blog URL in wp_options table to http://www.anandnataraj.com

It took 30 minutes to migrate from drupal to wordpress 2.7.1… So far, everything seems to be working just fine…

Yesterday I designed my own WordPress, brought a coffee mug and printed it there, also shot some snaps with it …