The organization that I work for occasionally conducts surveys of our membership. We'd like to start doing them online, so today I started working on a system to automatically generate the HTML, perl, and database files needed for a survey. The system uses three template files--one each for HTML, perl, and MySQL (like what is generated by mysqldump). When the generator script is run it queries a database to pull a list of attributes that the survey should seek responses for as well as descriptions for those attributes. It then fills in the templates so that
1) a database can be easily created with:
unix prompt# mysql < survey.sql
2. a web page that can process the data and populate the database can be quickly deployed with survey.htm and the associated survey.pl script to pull from the correct fields on the form and insert them into the database.
I'm considering further generalizing my code so that it can be used outside of our organization. Do any of you have any use for something like this? What features would you be looking for?
Thanks! =)
--TWH
