Create custom field mapping for Microsoft Project file import

Map custom fields from Microsoft Project to ServiceNow fields before importing a project.

Before you begin

Create custom fields in your ServiceNowinstance before mapping them with Microsoft Project. For more information, see Add and customize a field in a table.

Role required: it_pps_admin

About this task

Map the custom fields that you create in your ServiceNow instance with custom fields in the Microsoft Project file you plan to import.

The supported data types for field mapping between Microsoft Project and ServiceNow instances are:

True/False
Calendar
Date/Time
Choice
Color
Currency
Decimal
Due Date
Floating Point Number
Date
Date/Time
Duration
List
Time
HTML
Integer
Long
Percent Complete
Phone Number (E164)
Reference
Name -Value Pairs
String
Translated HTML
Translated Text
URL
Wiki

Procedure

Navigate to Project Administration > Project - MSP Import Field Mappings.
Click New.

From the Table list, select the table in which you created the custom field.

Task	Action
If you created a field in the project table	Select Project from the Table list.
If you created a field in the project task table	Select Project Task from the Table list.

In the Microsoft Project Column field, enter the name of the custom field in your Microsoft Project file that you want to map.
In the Destination Column list, select the custom ServiceNow field that you want to map to the Microsoft Project field while importing a project.
Click Submit.

What to do next

Import the Microsoft Project file. For more information, see Import a Microsoft Project file.
Configure the Project form to add the custom fields that you want to see. For more information, see Form configuration.

Create custom field mapping for Microsoft Project file import

Map custom fields from Microsoft Project to ServiceNow fields before importing a project.

Before you begin

Create custom fields in your ServiceNowinstance before mapping them with Microsoft Project. For more information, see Add and customize a field in a table.

Role required: it_pps_admin

About this task

Map the custom fields that you create in your ServiceNow instance with custom fields in the Microsoft Project file you plan to import.

The supported data types for field mapping between Microsoft Project and ServiceNow instances are:

True/False
Calendar
Date/Time
Choice
Color
Currency
Decimal
Due Date
Floating Point Number
Date
Date/Time
Duration
List
Time
HTML
Integer
Long
Percent Complete
Phone Number (E164)
Reference
Name -Value Pairs
String
Translated HTML
Translated Text
URL
Wiki

Procedure

Navigate to Project Administration > Project - MSP Import Field Mappings.
Click New.

From the Table list, select the table in which you created the custom field.

Task	Action
If you created a field in the project table	Select Project from the Table list.
If you created a field in the project task table	Select Project Task from the Table list.

In the Microsoft Project Column field, enter the name of the custom field in your Microsoft Project file that you want to map.
In the Destination Column list, select the custom ServiceNow field that you want to map to the Microsoft Project field while importing a project.
Click Submit.

What to do next

Import the Microsoft Project file. For more information, see Import a Microsoft Project file.
Configure the Project form to add the custom fields that you want to see. For more information, see Form configuration.

How search works:

Topics are ranked in search results by how closely they match your search terms

Create custom field mapping for Microsoft Project file import

Create custom field mapping for Microsoft Project file import

On this page

Create custom field mapping for Microsoft Project file import

Create custom field mapping for Microsoft Project file import

Log in to personalize your search results and subscribe to topics