Project Portfolio Management Prototype

• Project ID:

  6945

• Project Type:

  Fixed

• Budget:

  $20-$100 USD
  

Project Description:

Requirements:
1. MSDE 2000 database
1a. Design Database schema based on all available export fields from MS Project.
1b. Compatible with MS Project 2000.
1c. accommodate master and sub projects. (multiple projects inserted into a master project).
1d. Develop Script to create database schema and indicies.

2. Develop script to import/Upload MS Project Files to Database.
2a. MS Project 2000 files
2b. Parameterize import script to accept directory location and .mpp file name -or- directory name only ( to import multiple Files with .mpp extension.)
2c. When a .mpp file is imported that contains links to sub-projects then import linked subprojects.
2d. Parameterize input script with option to overwrite existing projects or (default: update existing projects).
2e. Accommodate and syncronise the database with any add/delete/changes that occured in any exportable field in .mpp file since last update.
2f. create optional parameter to log event, progress, timestamp and diagnostics to .txt file.
2g. Save last log to Database table.
2h. Make the Log table generic to be able to log progress and errors for different scripts, events and activities.
2i. Provide option to overwrite or append to the log.

3. Develop parameterized utility script to export selected tables.
3a. Accomodate export selected table(s) schema and metadata only.
3b. export selected table(s) data only
3c. export selected table(s) schema, metadata, and Data.
3d. Export to MS access 2000 database.
3e. Export selected schema and data to MSDE database.
3f. Ability to log export event, progress, timestamp, and diagnostics to Log table.

4. Produce .Net web site control panel to administer utility scripts.
4a. Create new, empty database
4b. Import/Export to existing database
4c. Select file or directory for import/export
4e. Select tables for import/export
4f. Select schema, schema & metadata, or data for export.
4g. Toggle logging on or off.

5. Provide graphical utility to manage and administer MSDE database.
5a. Research and select the best free msde administrator utility.

6. Provide detailed deployment instructions for web deployment and desktop deployment ( win2k/win XP)
6a. Provide suggestions for future improvements.
6b. Provide "lessons learned"

7. Critical to Quality:
7a. Time to delivery.
7b. Flexible DB design for future enhancements.
7c. Parameterized scripts
7d. Table driven parameters.
7e. Simple, Easy to use interface.
7f. Must run on desktop as standalone (with command line or graphical utility) if no webserver is available.

8. Resources:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_2003_ta/html/odc_landProject00_ta.asp?frame=true

Skills required:

.NET