Peter,
There are still a couple of bugs in the Blogger import script. I’ve made some changes, and sent the updated script to the wordpress faimly, but it hasn’t seen the light of day yet.
Anyway, if you download the following update and replace your old import-blogger.php script, everything should import properly.
http://treetrybe.com/imm/tests/import-blogger.zip
Your script worked excellently, mikhail. Thx much for sharing. 🙂
I ran it and it produced some unusual effects. I think it has to do with the time/date format but I confirmed that I had it formatted properly. Is there anyway I can wipe the post table clean and start over by reimporting Blogger? I don’t think I should have any posts from 11/30/2012 as referenced on my WP index page. 😉
http://gator5.hostgator.com/~korym/blog/
Thx much, in advance, for any help!
Regards,
Kory
You can delete all the posts by a user by demoting the user to zero, and then deleting the user. If the user with all the posts is the admin, and if it is a fresh blog, then I suggest dropping the db table, and installing wordpress afresh before performing the import again.
this NEEDS to be included in the updated download. I just wasted an hour trying to figure out what the hell I was doing wrong. grrrr. thanks for the file mikhail!
As long as you’re not worried about losing ALL your entries (not just imported ones), you can use phpMyAdmin to wipe the appropriate tables clean and start fresh. The following tables can be wiped clean of data: posts, post2cat, and comments. These are the three tables that deal directly with entries.
If you’re really not familiar with phpMyAdmin, I’m more inclined to say drop all the tables and start over. WordPress is a simple install, and with a fresh install the importing should work fine (as long as your data is good).
Since I ran into this problem myself, I figured out some SQL statements that would help me back up my tables, allowing me to take some risks with transfering data.
Here are some SQL commands you can run from the phpMyAdmin admin to copy, backup and create anew the table whose data you want to experiment on:
1. SHOW CREATE TABLE wp_posts (it will show you the sql to create the wp_posts table – copy this code on to your clipboard)
2. RENAME TABLE wp_posts to wp_posts1 (it will keep a back up of all your data)
3. Use the create table SQL created in step 1. to create the table again.
If you want to drop the table completely you can use the ‘Empty’ command in phpMyAdmin.
