I developed a web site some years ago in PHP and mySQL. I'm wondering if it would be worthwhile to convert it to a CMS like Craft.
The site -- http://blacksmiths.mygenwebs.com -- displays information on historical figures -- "tradesmen". These are arranged by region, so "Devon", for example, contains all people who lived in that region and performed that service.
The lady the site belongs to collects the data and puts it into a spreadsheet and uploads the comma-delimited .csv files to the site. (no, she won't consider abandoning her spreadsheets)
The software reads the .csv files and creates a page for each .csv file
It also uses the CSV file to create the home page (at the link above)
I would like to change the operation slightly
have the uploaded .csv data placed into a database table and the pages be dynamically generated from there (there are only nine fields in each row).
have a form where she can input new data
be able to export the data to the spreadsheet format she likes
- it would be useful to create links between the tradesman table record and the contributor table record.
I can do all this in PHP, but I'd like to see if Craft could make this simpler.
I'm looking for suggestions as to whether going to a CMS like Craft would be a good idea and perhaps some suggestions on how to go about it.