InfoPath Dev

Hi, I am starting to work on a project and need some guidance as to how to approach this using Infopath.

I am trying to Automate Time Sheets for the company. Currently users fill out a paper form and submit their Timesheet to HR.
1- I need to Fill out this form in Infopath
2 - Get the users signature
3- At the end of the week all the submitted forms need to be converted into a comma delimited text file so that it can be imported into Timberline (our payroll db)

1-- suggestionson how to approach digital certificates? do we need to purchase this or is there something inbuilt I can use?
2-- can I manage to convert all submitted forms to one single comma delimited text file?

Thanks for your help !!!

Hi Vidette,

You should check out the sample Timecard form that comes with InfoPath - it is likely all you will need in order to collect the information you are looking for. I don't have a lot of experience with digital signature, so I'll have to let someone else answer that, but as for the last question, there are a lot of ways to solve this problem. Here are the ones I came up with:

1. Write a SharePoint event handler to watch for timecard uploads and then shred them to a text file
2. Write a command line utility that you can run manually or with a scheduled task to pull all the XML files, parse them, and then shred them to a text file
3. Use our Database Accelerator to shred each form straight into the SQL database as it is submitted.

The third option, of course, is how I would do. Not only do you get codeless shredding with the DBXL webservice, but there are also a slew of other features such as version tracking, fine-grained permissions, indexing, and many others! Try it out here:http://www.qdabra.com/proddetail.asp?prod=QDBXL1

Thanks Matt! I do not have the db accelerator so I ended up submiting my form to a sql table and using SQL Data Transformation Services to build the text file. Thanks for your help.