Pixelpost to WordPress Migration

So I made contact on Twitter with @photodreamz who needed to migrate their PixelPost blog to WordPress. The problem is, Pixelpost doesn’t support any type of export interface. This problem was partially solved by Joe Lencioni, over at ShiftingPixel.com and one of his readers, @kristerella of http://kristerella.com. Between the two of them, I believe they have the right solution, yes it could handle a little polish, but it works. I have made my version of the script available here. Below, you will find step by step instructions for installing and using the script.

The features I added to the script were a GUI way to supply the root domain for the WordPress install, and some general debugging. I may end up making this automatically populate from the database, for now I’ll leave it manual. Functioning manually, you can specify a domain, even while running the script on a test environment, which I recommend.

Remember, I can not be held liable for any negative effects this has on your data! Always use a testing environment when performing actions such as these with your data, backup the backup of the backup! The Categories still do not apply to the posts, but it does import them.

Here are the steps I used to get the Pixelpost to WordPress script to work:

  1. Download the script from here: Pixelpost to WordPress Import Script.
  2. Install the script in the “wp-admin/import/” folder.
  3. Copy your images into the root of the “wp-content/uploads/” folder.
  4. In the Dashboard, go to the Tools>Import page.
  5. Select “Pixelpost” from the list of databases available for import.
  6. Provide the login info for the database your Pixelpost data is in. Also specify the domain name you will be using with WordPress, this will ensure the photos show up in the posts.
  7. Click “Import Categories”
  8. Verify the number of Categories imported, then click “Import Posts” (This may take a few minutes, don’t click the button again, and don’t refresh the browser, it will let you know when it’s done.)
  9. Verify the number of posts imported, then click “Import Comments” (This may take a few minutes, don’t click the button again, and don’t refresh the browser, it will let you know when it’s done.)
  10. You’re set! Click “Visit Site” at the top of the page to verify the import completed successfully.

Here are some tips: From what I read, this works best with an empty WordPress DB, it’s best to set up a test environment if you have an existing WordPress installation, import the pixel post into your test environment, the use the mature, XML based, WordPress import/export to move them into your existing WordPress installation.

@acedrew

Reblog this post [with Zemanta]
  • Share/Bookmark
This entry was posted in IT and tagged , , , , , , , , . Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.
  • Rcjay272
    When using this script do it import each photo into a separate post in WP?
  • Yeah it still works, confirmed with Wordpress 3.0 And pixelpost 1.7.3
    Thanks a lot mate....
  • Web-buyer
    It does NOT work with WP 3 at all, crashes and corrupts the database. I opted for the solution mentioned above, http://www.eleventwentysix.com/pp2wp/ Took less than 3 minutes to export and then import into WP 3.
  • mbt
    Here elaborates the matter not only extensively but also detailly .I support the write's unique point.It is useful and benefit to your daily life.You can go those sits to know more relate things.They are strongly recommended by friends.Personally I feel quite well.
    http://www.mbt-outlet-store.com/
    http://www.mbt-outlet-store.com/mbt-women-shoes...
    http://www.mbt-outlet-store.com/mbt-men-shoes.html
  • ahref
    I recently came across your post and have been reading along. I thought I would leave my first comment. I don't know what to say except that it caught my interest and you've provided informative points. I will visit this blog often.

    Thank you,

    Small Business Loans
  • I am trying to import it as well. But in the end it says 0 found for everything.

    Can you be specific where should we domain name, I find no place to put that.
  • Ally
    Doesn't work :-(
  • Thanks for putting this together. I'm having an issue with it and wondered if you could help.

    I keep getting File Not Found when it goes to import the posts.

    "File not found... /images/thefilename.jpg
    Warning: getimagesize...etc.

    Any thoughts? I've tried putting the images everywhere.
    The images are in wp-content/uploads and also in wp-content/uploads/images. I've tried putting the image in the domain root folder as well as the root wp-content for the live site. No dice.
  • I just ran your import script (PP 1.7.1 to WP 2.9.1) and it worked like a charm. Still have to assign categories and tags to images, but the script took care of the heavy-lifting. Thanks!
  • MacDaMoose
    A complete solution to migrating PixelPost to WordPress can be found here: http://www.eleventwentysix.com/pp2wp/

    Pretty painless to use
  • I tried and it didn't work...followed the instructions exactly.

    But at the end of the install it says that there are 0 categories 0 posts and 0 comments.

    Importing to WP 2.8.6 with PixelPost 1.7.

    Any help out there...?
  • Hi Andrew, thanks for this script! I've actually tried to use it to import posts from pixelpost to wordpress but failed. I can send you a link to my website to see what happened. I'd really appreciate if you could take a look, perhaps you have an easy answer to my issue. Thanks!
  • Great work Andrew! Thanks for putting this together, and thanks for the mention. I've had the import script sitting in a folder waiting for me to improve it and test for new versions, but just never get to it.
    What versions of WP and Pixelpost have you used it with?
    I agree with your advice of importing to a blank WP install and then exporting with the WordPress exporter to your main blog, a very good idea!
blog comments powered by Disqus