Objective: Design and build prototype to generate templates from any MS Word 2000 file and store and edit from MSDE 2000 database and to reconstitute MS Word 2000 file from stored template and data.
1. Import MS word 2000 documents and convert to XML and XLS files.
1a. XML output must handle embedded styles, tables and graphics.
2. "Mark-up" the XML and/or XLS document to identify user defined fields within the document and associated data.
[url removed, login to view] detailed step by step instructions to edit XML and XLS output to create fields and data tags.
3. Provide script to load the marked-up template into MSDE 2000 database.
3a. Store the template as single a record in MSDE database with embedded fields and empty data.
3b. Store any document Properties including standard and custom properties as user defined Fields in a related table.
3c. Store the data indetified in [2a.] as a record in a separate, related table.
3d. Store any other required information such as style data or XLS file in a related table if needed.
3e. Database design must be flexible and table driven to accomodate any number of user defined fields per document.
3f. Provide script to create the database schema automatically.
3g. If imported document already exists, then synchronize updates to template and data.
4. Provide .Net web page for document administration:
4a. Import: Select file (default:for import of single document) or directory (for import of multiple documents).
4b. Create document from Template: Select template from database and dynamically generate web form for data and property input/editing.
4c. Save Edit as a new document record in the database or Cancel Edits.
4d. Select and update document and property data from existing database record and dynamically generate web form for data edit.
4e. Save Edits and update existing document record in database.
4f. Delete document and properties from Database
4g. Delete template and properties from Database
4h. Export: Select path and file for output of single MS Word 2000 document.
4i. Create new, empty database.
5. Provide detailed deployment instructions for web deployment and desktop deployment ( win2k/win XP)
5a. Provide suggestions for future improvements.
5b. Provide "lessons learned"
6. Critical To Quality:
6a. Import/Export Word 2000 document to/from database without error
6b. bi-directional update from Word 2000 document to database and from database to Word 2000 dcocument
6c. Time to delivery
6e. Compatiblity with MS Word 2000.
6f. Compatibility with Win2k and Win XP
6g. Flexible DB design for future enhancements.
6h. Parameterized scripts
6i. Table driven parameters.
6j. Simple, Easy to use interface.
6k. Must run on desktop as standalone (with command line or graphical utility) if no webserver is available.
[url removed, login to view]?frame=true