How do I add thousands of pictures to wordpress?

It’s just a database insert…

in theory you could do a

Select yada yada yada

from the zenphoto database, pulling the caption and file location and etc, and then do an

Insert yada yada yada

into the appropriate wordpress table.

It’s moderately complex sql-fu — but you could do it with nothing but phpmyadmin if you know the table structures.

Matt Mullenweg, founder of WordPress, has been in the process of adding thousands of his own images to his WordPress blog. We’re all waiting anxiously for his report on how he did it. You could ask there.

Matt’s blog is exactly what got me wondering if there was an easier way to do it. Although the more I think about it, the more doable the database insert approach seems.

I have sort of the same issue – I have thousands of images in a custom db. I can easily map the fields from the source dB into the wordpress posts table – and have done a couple of sample inserts – my problem arises in that when I do the import this way wordpress does not generate the alternate medium and thumbnail images that it does when the import is done via the upload interface.

I found a plugin to uplad from server, but this does not add any of the caption and description info that I already have associated with each image in the source dB.

Has anyone com across this and come up with a solution? If so I would greatly appreciate any input.

Thanks in advance.

Can you please tell me what plugin you found?

I am having the same issue…

Thanks!