Import MS Projects
Import Projects allow you to import projects created using Microsoft into SDP MSP with ease. Each MS Project can be imported as a single project. It is necessary that the attributes of MS Projects have to be equivalent to those in Service Desk Plus MSP Projects. Hence the attributes in Microsoft have to match with the attributes in SDP MSP.
'Import MS Project' option is available under Projects>>Import MS Project.
1.Click 'Import MS Project'. Page with 'Browse' option will be displayed.
- On clicking 'Browse', a browse and choose window will appear.
- Select the desired Microsoft project file in MPP format to be imported and click 'ok'.
2.The selected MPP file will be listed as shown below. Click 'Browse' to import more MPP files. The imported MPP file can be deleted from the list by clicking the delete button.
3. The results of the import can be obtained by clicking 'Import results'. If the file has been imported successfully then an immediate success message will be displayed. Detailed results can be viewed under 'Import results'. The successfully imported MS projects can now be viewed in the Project List View.
If the import has failed then an immediate failure message will be displayed. Detailed results along with the errors can be viewed under 'Import results'.
Note:
* If any imported MS project is deleted from the Projects List View page, then the import results with respect to the imported project will also be deleted.
* Importing large files may take time. Please do not proceed with any other action.
Project Files under Microsoft will be mapped as Projects in SDP MSP. Each project file has one project and only one project can be imported at a time. The below table lists the various attributes that have to be mapped with respect to SDP MSP projects.
| MS Projects | SDP MSP Projects |
|---|---|
| Title | Title |
| Subject | Description |
| Actual Work | Actual Hours |
| Actual Cost | Actual Cost |
| Cost | Estimated Cost |
| Comments | Comments |
| Start | Scheduled Start |
| Finish | Scheduled Finish |
| Actual Start | Actual Start |
| Actual Finish | Actual Finish |
| Work | Estimated Hours |
| Created | Created Time |
| Status | |
| At 100% of Completion | Closed |
| Other Cases | Open |
| Priority | |
| Range 0 to 250 | Low |
| Range 251 to 500 | Normal |
| Range 501 to 750 | Medium |
| Range 751 to 1000 | High |
The Task List of MS Projects are mapped as Mile Stones in SDP MSP Projects. Each task list is created as a separate milestone. The below table lists the various attributes that have to be mapped with respect to SDP MSP Milestone
| MS Projects | SDP MSP Projects |
|---|---|
| Name of the task | Title |
| Deadline | Projected On |
| Notes | Comments |
| Start | Scheduled Start |
| Finish | Scheduled Finish |
| Actual Start | Actual Start |
| Actual Finish | Actual Finish |
| Work | Estimated Hours |
| Actual Work | Actual Hours |
| Created | Created Time |
| Status | |
| At 100% of Completion | Closed |
| Other Cases | Open |
| Priority | |
| Range 0 to 250 | Low |
| Range 251 to 500 | Normal |
| Range 501 to 750 | Medium |
| Range 751 to 1000 | High |
The Task and Milestone in MS Projects are mapped as Task in SDP MSP Projects. The below table lists the various attributes that have to be mapped with respect to SDP MSP Task.
| MS Projects | SDP MSP Projects |
|---|---|
| Name of the task | Title |
| Duration | Estimated Effort |
| Percent Complete | Percentage of completion |
| Deadline | Remind Before |
| Notes | Comments |
| Start | Scheduled Start |
| Finish | Scheduled Finish |
| Actual Start | Actual Start |
| Actual Finish | Actual Finish |
| Work | Estimated Hours |
| Actual Work | Actual Hours |
| Created | Created Time |
| Status | |
| At 100% of Completion | Closed |
| Other Cases | Open |
| Priority | |
| Range 0 to 250 | Low |
| Range 251 to 500 | Normal |
| Range 501 to 750 | Medium |
| Range 751 to 1000 | High |