Convert A Wordpress Blog To Blogger Simple And Easy Way

Blogger is a very widely used publishing platform, mostly because its strength lies in its simplicity and ease to use. It is quite easy to use, and is recommended for beginner bloggers who are looking for a quick and easy way to create a presence for themselves online. For bloggers who have created a Wordpress blog, but are at loss to maintain or modify it, they have great option in Blogger.

They can easily migrate their WordPress Blog to Blogger without hitch. In this post, we will talk about how you can shift WordPress to free Blogger.

Normally, such a transfer isn't easy. Data needs to be imported from WordPress first, and the imported to Blogger. Since Blogger doesn't allow any data format expect its own, there needs to be a conversation process that will convert WordPress exported files. Luckily, there's just such a utility available. Here, we will guide you through the simple steps. Following them, you can convert self-hosted WordPress blogs to Blogger, as well as migrate from free WordPress to Blogspot.

There are some steps you have to follow !

Step 1 : Importing From WordPress

Login to your WordPress account (for free WordPress users), and the choose the blog you want to convert into Blogger. Alternatively, you can login to your Blog's Dashboard directly by adding the /wp-login.php  suffix to your blog's home URL (eg yourblog.com/wp-login.php or yourblog.wordpress.com/wp-login.php) .

Navigate through your WordPress menu, and find the Tools option. When you click on it, you'll see further options, among which you will see Export option. Click on it. Choose what to export, you can select Posts, Pages, or feedback, but it is recommended that you select all content to ensure maximum content is transferred. Then click on Download Export File, which will let you save the exported file to your hard drive. You have completed step 1 at this point.

Step 2 : Convert Into Blogger Format

There is a useful little app that will do this job for you. To convert, visit this app's page, and navigate to the button in the middle of the content that says 'Choose File'. Browse to the file you downloaded from WordPress, and upload it here. The click Convert. After the conversion, you will need to save the output file. this file is in Blogger-Friendly format, and will be used inside Blogger.

Step 3 : Import To Blogger

The import process into Blogger is pretty straightforward. Simply login to, or sign up for your Blogger Account, and click on Create a Blog link. I'm assuming you want to create a new blog for your new content. But if you want to, you can import into an existing blog as well.

From the Dashboard, click on Settings >> Other >> Import Blog.

Now, all you need to do is follow the simple instructions, and upload the converted file. You well be guided through a wizard that will import data from this file into Blogger. Once done, you will see all your posts from WordPress ready to be published !

Replace Content In Your Wordpress Using SQL

Like we all know, we can use SQL to replace or remove some content in our Wordpress using phpMyAdmin, on this i will show you How To Replace/Remove Content On Your Wordpress Using SQL. On this trick you can access through phpMyAdmin on your server or using plugin Wp-DBManager and you can direct access through Wordpress Admin panel.

After you install DB Manager or logging into phpMyAdmin, go to run SQL interface and do this code:

UPDATE wp_posts SET post_content = REPLACE ( post_content, 'nofollow ', '' );

On this sample, you will remove all content with nofollow on your post content. Please not you can multiple SQL query too by using this method:

UPDATE wp_posts SET post_content = REPLACE ( post_content, 'nofollow ', '' );
UPDATE wp_posts SET post_content = REPLACE ( post_content, ' nofollow', '' );

UPDATE wp_posts SET post_content = REPLACE ( post_content, ' rel="nofollow"', '' );

This method does the same thing but multiple queries are executed at the same time. You can tweak this code what ever you want, like replace wordpress.org with funisonline.blogspot.com, so all your content with url's to wordpress.org will be replaced into funisonline.blogspot.com using this method.

UPDATE wp_posts SET post_content = REPLACE ( post_content, 'wordpress.org ', 'funisonline.blogspot.com' );

That's all, i hope our tutorial replace or remove content on your Wordpress using SQL worked for you.

How To Display Any External RSS Feed On Your Site

Have you seen other bloggers who display their other blog's feed on their site. You want to do it too for extra promotion and traffic. Well here is the tutorial for you. Simply paste the following code in anywhere in your theme.

<?php include_once(ABSPATH.WPINC.'/feed.php');
$rss = fetch_feed('http://feeds.feedburner.com/funisonline');
$maxitems = $rss->get_item_quantity(5);
$rss_items = $rss->get_items(0, $maxitems);
?>
<ul>
<?php if ($maxitems == 0) echo '<li>No items.</li>';
else
// Loop through each feed item and display each item as a hyperlink.
foreach ( $rss_items as $item ) : ?>
<li>
<a href='<?php echo $item->get_permalink(); ?>'
title='<?php echo 'Posted '.$item->get_date('j F Y | g:i a'); ?>'>
<?php echo $item->get_title(); ?></a>
</li>
<?php endforeach; ?>
</ul>

How To Create A Page That Shows Random Posts In Wordpress

Have you even been to a site and saw this cool feature ? They have a link in their top navigation to something like Stumble ! or Read Random Articles, or some other creative text. Each time you refresh, you are delivered with a new post. Well this trick is just for you then.

You would need to follow the trick # 1 in this post to create a custom page template, and simply paste this code in there:

"<?php
    query_posts(array('orderby' => 'rand', 'showposts' => 1));
    if (have_posts()) :
    while (have_posts()) : the_post(); ?>

    <h1><a href="<?php the_permalink() ?>"><?php the_title(); ?></a></h1>

    <?php the_content(); ?>

    <?php endwhile;
    endif; ?> "

This is a simple Wordpress loop that is running a query to display random posts and the number 1 in there is telling Wordpress to only show 1 post. You can change that number, but most of the time people do it one post a time.