cbmr777

Quite honestly, I’m not sure what I did differently this last time that I didn’t do previously. I’m not a programmer but I’ll try to explain what I did… ??

1. First although my new photoblog was going to be on a different domain, I created a WordPress “Test Blog” on the same domain as the old PixelPost photoblog.

2. I started with a clean install of WordPress.

3. I grabbed the script from this website:
https://shiftingpixel.com/2006/05/21/new-design-now-wordpress/
You’ll have to look down into the comments section to see the script link. I edited the script in 2 places where it says:

// Import Post data into WordPress

under that section, you’ll find 2 instances of:

'post_content' => $body,

I changed both to read:

‘post_content’ => ‘<img src=”https://www.myurl.com/wp-content/uploads/&#8217; . $image . ‘” alt=”” />’ . $body,

where the url was my actual new domain name. You don’t want to have to change the url for every post once you move it to your new domain. ??

4. I upload the script to the import directory located in the wp-content directory.

5. Now for me, my files were not set at 777 and the import script balked at this during previous attempts. So before running the import script on a clean WP install, I changed it to the correct permissions via FireFTP program in Firefox. I also created under uploads new directories of /2009/07 with 777 permissions. (use your current year/month for the directory names.)

I also uploaded all of my images from pixelpost images directory to my wp-content/uploads directory. You’ll want to upload the images to where you indicated they would reside in the pixelpost import script. (see step 3 above)

6. Go into your WordPress admin to Tools -> Import. You’ll see Pixelpost now listed among the software to import from.

7. Click on “PixelPost”. It will then ask you for your PixelPost configuration such as:
Pixelpost Database User
Pixelpost Database Password
Pixelpost Database Name
Pixelpost Database Host (default is localhost)
Pixelpost Table Prefix (default is pixelpost_ )

When finished inputting information, click “Import Categories”.

7. WordPress will then run the script to import categories, posts, and comments.

8. I then went to a post, clicked “Edit” and changed the URL of the photo to the local Test Blog url. I wanted to verify that I could actually see the image. I viewed my Test Blog and viola! All of my posts and comments were uploaded and viewable.

9. I then went and did a “Quick Edit” on each post to assign each to a category. The categories do import in but the posts did not keep their assignments to the categories. All posts were assigned to “uncategorized”.

10. Finally, I exported my WordPress (Tools -> Export) and imported into the WordPress on my new domain name.

I don’t know if there could have been a easier way of doing this import but at this moment, I’m happy! Now I can concentrate on designing the blog instead of fighting an import! ??

Hope this helps someone!

~ Christine

Well, the script works!

I was ready to handcode the comments into the database when I decided to delete the database and start fresh. After I deleted the database, created it again, and installed WordPress, I re-imported the Pixelpost using the script and for some odd reason, it worked this time! The comments and everything. Was it because I started with a fresh clean installed WordPress?

Again, the while it imported the categories, it didn’t keep the post assignment to them. A minor thing compared to the daunting task of trying hand import the comments directly into the database itself!

YAY!

I used that script tonight importing PP 1.1.1 to WP 2.8.2.

I made the code change as suggested by Krista in the comments section of the post. Everything worked except:

1. It imported the categories but not keep my posts assignment to the categories. It threw the posts into “uncategorized”. I can live with this, though.

2. My comments didn’t get imported, though. Anyone know how I can get these imported?

??