Additional Blogs by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos
1. Input forms (2) contain both structured and free-form textual data, which should be stored in SQL Server for reporting.
2. Input forms must seamlessly upload file attachments into KM.
3. Upon submission of input forms, an automated email must be sent to form submitter thanking them for their submission.
4. In addition to the above, an automated email must be sent to an analyst notifying them of the submission.
5. Ad-hoc field level queries must be supported on form data.
6. Printable ad-hoc reporting must be supported on form data.

OK, how are we going to do this? XML forms are out, as we cannot do a file upload directly from the form until EP6. Our solution? Use JSPs to handle the form presentation, use Beans to handle the application logic, and use Servlets to talk back to KM and SQL server. I've also written a servlet to handle the email submission using a handy little SMTP client class -- sun.net.smtp.SmtpClient.