Generic Import functionality

Engineer:?
Work remaining:? weeks
QA effort? week
No. of automated tests?

Description

Develop facility in project.net which will allow importing the users, business list, project list and task list from an xls,csv files

User Stories

* First time user has the user list in his outlook contacts. User should be able to import all "users" in project.net by selecting the csv file exported from outlook

* Existing use is managing the progress of his projects in excel, he should be able to import the project/tasks from the excel document. * User is managing the todo's in his pocket phone. He should be able to import the csv file of todo's in project.net as TASKS in the projects.

Analysis and Design

Note:
* This needs to be completely generic utility. One of the main solution that should be offered by this utility is to map the imported file columns with the required columns for imported entity. If the columns are not available in imported file, use should be able to specify default values to the unavailable columns.

* Data type validation before importing the document shall be performed before importing the document.