nucleus to wordpress

a little update.

using the tip from the first post in the link above… i was able to move over all of my posts from nucleus by altering the code on the script… taking out the category.

yeah for me!

but.

all the photos are missing. and the photos are the most important part of each post.

any ideas would be most appreciated!

thanks.

i think i’m going to have to reload all 900+ images into each post.

oh no.

i think i’m going to have to reload all 900+ images into each post.

If the img code is totally gone from your posts, then yes you will. If the image URLs are just wrong, then upload your images to your new site and mass change their URLs using something like the Search and Replace plugin.

The nucleus image code is just totally different than the code used for wordpress. Here is an example:

Nucleus image code:
<%image(20060504-lilacs-2.jpg|300|225|Here are some mutant lilacs I photographed.)%>

WordPress image code:
[caption id="" align="alignnone" width="300" caption="Here are some mutant lilacs I photographed."]<img title=”Mutant Lilacs” src=”https://www.novapages.com/media/1/20060504-lilacs-2.jpg&#8221; alt=”Here are some mutant lilacs I photographed.” width=”300″ height=”225″ />[/caption]

I can’t think of how to get rid of the percent signs since mysql thinks they’re supposed to be wild cards ?? I’m going to keep working on this one too … just not tonight; my brain apparently decided to go to bed without me.

-Velda

Good gracious. Well, I’ve finally got my images working. Here’s how, though I would recommend if you’re not comfortable in sql, you should make backups first, or probably hire someone to do this for you.

My images are in the /media/1/ directory (any that weren’t, I’ve just now moved there). So here’s what I did:

UPDATE wp_posts SET post_content=replace(post_content,'<%image(‘,'<img src=”/media/1/’);

UPDATE wp_posts SET post_content=replace(post_content,’)%>’,'” />’);

This next part got a bit hairy, because when I’d first started my blog, I uploaded lots of random sizes. But to get you started, here’s how to replace images that were 300×300…

UPDATE wp_posts SET post_content=replace(post_content,’|300|300|’,'” width=”300″ height=”300″ title=”‘);

And here’s how to replace images that are 300×400…

UPDATE wp_posts SET post_content=replace(post_content,’|300|400|’,'” width=”300″ height=”400″ title=”‘);

There might be a better way to do this, but this worked, once I got all my image sizes figured out ??

-Velda

looks like I can’t edit my posting, but I ended up re-doing my images so they’d have the captions intact, using php’s preg_replace . Drop me a note if you need help with this.

Do you have a copy of the php5 file with the categories removed?