This seems like it should be pretty complicated, but I want to try it anyway.
Here's my situation: We started our site back in 2005, before I knew what WordPress was. (It's a movie news/reviews website.) For the "news", I was using GreyMatter, so I imported all those posts into WordPress, no problem.
The "Reviews" and "Cast member pages" aren't in any CMS, they're just in their own rows in the same database.
The reviews table has a unique identifier of a 4 digit number, along with all sorts of fields (title, meta keywords, review content, dvd release date, etc.).
The cast table has a unique identifier of a 4 digit number also (the same numbers as reviews, in some cases), and all sorts of other data (first name, last name, number of reviews, etc.)
What I want to do, is move this data into WordPress, as custom fields, and create a "page" for each thing.
I'd do this by hand, but there's 455 reviews, and 1314 cast members, and that'd take quite a while.
Is there a way to automate this process? I've read that an API can be created, but I've never dabbled with that before.
Anyone offer any advice?
I'm pretty clear on how to actually use the custom fields, and create templates. I don't need advice on that. I need the advice on the mass moving of all the data to the corresponding page (which would ideally be auto-created.)
