Magento CMS page (or block) mass import

Question

I have 50 CMS pages I want to create in Magento. These are essentially mail merges off of a database with different content (but same structure) in each, so I'd love to be able to import them if possible. I want individual pages so they can be indexed by the search engines. Is there a handy/dandy way to do this?

I could alternatively do it with CMS blocks and categories as well if that is easier. (which will also give me the option of plopping related products in as well.)

Thanks in advance for your help.

Answer 1

At the moment, there is no easy way to import CMS content into Magento. Neither dataflow nor the webservices contain profiles that would help here. On the other hand, the CMS pages and blocks are contained in only a few tables, so you may be able to import them using PHP (or whatever your language of choice is). Take a look in the database at the following tables:

cms_page
cms_page_store
cms_block
cms_block_store

Hope that helps. Thanks, Joe