I'm redesigning a site of mine (alpinezone.com) and using a WP backend. As part of that redesign I'm trying to figure out the best way to handle this.
I presently have ski resort profiles on my existing (html) site. Example: http://skiing.alpinezone.com/resorts/detail.htm?resort=sugarbush.
I have over 150 of these and the data on them changes fairly regularly.
I want to recreate these resorts into WordPress pages, but I really don't want to have to rewrite all 150 resorts. Plus, I lose some flexibility if I do that because if I change something (lets say I want to capture a new piece of data or something), I need to go make changes to 150+ pages.
The way it works today on my site is that I have a Filemaker pro database with all the pertinent information. I update in this database and export to a TAB delimited file. I could easily convert that to a CSV.
But want I want is to create a page template that are updateable based on an imported CSV file. For example:
I create a new resort. I want a new page created. Format is the same, but the data changes based on the file.
Any way to do this? Alternatively I could create a new DB in WordPress somehow if that is available to transcode into pages. I'm open for different options. I just don't want to have to type up a zillion different updates every time I make changes.