Creating Wordpress posts from a database

[larrybn]

Is there a simple scvript/plug-in to import the contents of a database and turn it into posts? Basically kinda turn a normal database into one that works with wordpress, (ie. the column names are different and omse columns are merged etc.). Nothing fancy needed.

Thanks in advance

 

[audax]

Automated Data Integration | Contempt recently made a post about doing this if can get it into a CSV.

<shamelessplug> Review Plugin For Wordpress ? Powerful Review Software For Websites also has a very slick CSV import function.</shamelessplug>

You could easily export the database into a CSV file using phpMyAdmin.

 

[argh01]

I'm sort of doing that; I wrote an xmlrpc client to post to a wordpress blog, added a column to the table for "wp_status int(1) not null default 0" and I select one from the database, xmlrpc it to the blog, update the database.

It's a little more involved than that but not much

 

[livingstonmedia]

you'd have to mess with the file a bit to get it to reflect what you want the outcome to look like (I know I did), but this might be a good place to start:

Convert CSV Data Feeds To Wordpress Posts

(fantastic boobs shot, btw. well done!)

 

[spyderman4g63]

i did a quick one using php and the wordpress post by email feature. Just use php to read the db and send the email.