[Resolved] Migrate from Pixelpost to WordPress
I never get responses with this request either. We are invisible. 🙁
You need a script to convert it.
If there’s no replies, then that’s usually a good indication there isn’t one.
You could migrate the data by hand… it would take a while but possible if you understand databases and their structures enough..
Would be a case of just creating a couple of test installs and moving data across the databases…
Or wait for someone to write a script…. though i’d not expect that to happen unless someone gets paid to do it, or someone good with code needs such a script and decides to write one.
You could look at doing it in steps…. if you can find the right scripts…
Pixelpost > someformat > someotherformat > wordpress …
Pixelpost > xml > wordpress …
Just ideas… 🙂
Found some info, may help get you started.
I’m sure with some adjustments and hard work you could use that script to migrate… though you’d ideally need a professional to fix any errors, or re-write any areas that don’t work…
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?
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!
Perhaps it would be beneficial to write up a brief run down on what you did to get the job done, for the sake of anyone else looking to do the same.
It’s quite un-documented with exception to the odd page here and there, as i found when googling before..
Glad you got there in the end though…
Like you said, a few incorrectly assigned posts and such is small price if it does work…
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:
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=”http://www.myurl.com/wp-content/uploads/’ . $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!
- The topic ‘[Resolved] Migrate from Pixelpost to WordPress’ is closed to new replies.