Just wondering if anyone out there currently has something like the following in place:
- A business department creates forms in microsoft word, and requires that agents complete these forms
- The forms must be done in microsoft word and not be web forms, since they must be formatted a specific way.
- After authenticating with the website, users can upload word documents that include form fields with data they enter
- When a file is uploaded, the file is renamed and a status record is created in a sql server table and it is assigned a status
- A windows service that runs nightly, parses the word documents looking for the needed data. Status is updated to indicate missing data or pending review etc
Suggestions / comments please !
Some concerns I have are:
- Letting users upload word documents might introduce the possibility of viruses onto our server
- The files would need to be renamed on the server using something like a guid
- Parsing word documents might require everyone use the same version of word