Import Projects

You can import projects created in MPP, XLS, XLSX, and CSV formats to ServiceDesk Plus.

Roles Required: Project Admin

Refer to the best practices guide before importing projects.

Import MS Projects

You can import MS projects that are saved in MPP format. Click here to learn how.

This page explains the projects import process in the following headings:

The additional fields for the project can be configured under Admin >> Project Management >> Project Additional Fields.

Step 1: Select the file to be imported

Choose the entity from Select a module drop-down.
Select the format of the file from File Format drop-down. By default, XLS is displayed.
Choose how you want to import a file; add and update records, delete existing records and add new ones, or ignore duplicate records.
Click Choose File to select the file to be imported.
Click Next.

Sheet Name field is not displayed for CSV format.

Step 2: Map fields

You can map the fields in the imported file to the project fields.

Map fields for Project

The projects mapping page displays a drop-down containing all fields present in the XLS/XLSX/CSV file and additional fields.

Choose a date and time format from the date and time format drop-down. The date format should be the same as in the imported file. All the date fields in the file should be in the same format.
The fields will be mapped automatically if the field names in the project and imported file are same. Manually map the additional fields and project fields that aren't same as the field names in the import file.
Enable the Create as new refer entities check box to create new refer entities with the value of the refer entities given in the imported file if it does not exist in the product.
Click Import.

Map fields for Milestones

You can import milestones from Projects Import wizard by choosing them in the module field and mapping them with projects by using the Projects ID field.

While importing milestones, it is mandatory to have a module column in the CSV/XLS file to specify the parent entity (project).

The entity name must be singular and case-sensitive.

Milestones can be imported in XLS, XLSX, and CSV formats.
Manually map milestone fields that aren't the same as the field names in the import file.

Map fields for Tasks

You can import tasks from Projects Import Wizard by choosing tasks in the module field and you can map them under milestones or projects in the ServiceDesk Plus Module.

While importing tasks, it is mandatory to have a module column in the CSV/XLS file to specify the parent entity (project/milestone).

The entity name must be singular and case-sensitive.

Parent ID used during import refers to the ID of the milestone or project in the XLS/XLSX/CSV file.
Map the task fields and click Import.

Step 3: Check Import Status

You will be automatically directed to the import status page after clicking the Import button on the mapping page.
You can get a summary of the total records in the import, imported records, and failed records.
By downloading the results in the XLS format, you can view the cause of project/milestone/task import failure. You can also view the ID given in the Reference ID column and the ID created in the product for that entity in the Entity ID column for successful imports.
Click Finish if the import is successful.

Under Import History, you can view the list of all successful and unsuccessful imports and download the results in the XLS format.

Below is the list of fields that can be imported.

Projects-XLS/XLSX/CSV

Additional Fields

Milestones-XLS/XLSX/CSV

Tasks-XLS/XLSX/CSV