I just did a redesign of my site, AlpineZone.com. I worked with a WP developer on the completion of the site. One thing that was done that I'm not entirely happy with is the way the Resorts section is handled.
Here is an example resort: http://www.alpinezone.com/resorts/sugarbush/
I'm 100% happy with the way it looks. The site used to be in standard PHP and all the data was stored in a tab delimeted file that was read by a PHP script. The tab file was updated in Filemarker Pro and updated. This means that it was in a tabular format so I could easily search for records; find resorts that had X number of lifts or between X and Y vertical feet, etc. basically I had a lot more flexibility in parsing the information.
However, the "data" in the new format comes from the Postmeta table. I believe the fields are done using a plugin called Advanced Custom Fields. As far as I can tell, it's not easily queryable or searchable.
I have other areas of the site, like the Map (http://www.alpinezone.com/skiing/ski-resort-map/), that I would like to pull information from the same source, so I don't need to maintain two sets of records for each resort. Right now the Map is still pulling from the same Tab file it did before. But this means I have the risk of resorts in the Resorts section falling out of sync with the resorts on the Map since the data sources are disparate.
basically: is there a way to create a series of pages based on a table of data with each record becoming a new page and the fields being populated into a page structure? Then, I could update the records by just updating the table and it gives me the other benefits of having a table structure (querying, sorting, advanced searching, and ultimately easier expansion (e.g. if I want to add a new field I don't have to add to 140+ resorts manually I can add a field, update the page template to include that field, and then just populate the fields in the table.).
Edit: i found this; http://www.myreviewplugin.com/importman.html, which kind of sounds like what i want except it is part of this larger package I don't need.