Monks,

So I'm building a system to survey a staff of around 500 people spread across 25+ organizations. The survey is about folks perceived ability with various applications (word processors, OSs, etc.), preferences when it comes to applications, and perceived needs around technology. It isn't meant to be scientific or statistically perfect, only instructive.

Here's how I'm thinking of doing it, and some random thoughts:

• Use cookies and track the IP of the surveys. Don't restrict multiple submissions on the same terminal, because some folks share computers.
• use CGI.pm and put the list of submitted params into an array, like so:
  @names=$q->param();
• Then, create (if not created already) a mySQL table by looping through each of the params submitted above creating it as a field. Then store the values in the appropriate field, whether or not a table was created.
• I realize that this is potentially inefficient. However, it will allow me to create new surveys by pretty much just editing an HTML file, and since I'll be using CGI::Application, editing the "instance script" to pass along a new table name when I create a new survey.

My questions are:
Besides the obvious (CGI, DBI) and not-so-obvious (HTML::Template, CGI::Application) modules, what other modules can you suggest to make this easier?

How would you do it differently? I've looked at other open-source survey packages and thought they were lacking.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.