Create custom field mapping for Microsoft Project import
Map custom fields from Microsoft Project to ServiceNow fields before importing a project.
Before you begin
Create custom fields in your ServiceNow instance 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 All > Project Administration > Project - MSP Import Field Mappings.
Select New.
From the Table list, select the table in which you created the custom field.
Task Steps 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.
Select Submit.
What to do next
- Import the Microsoft Project file. For more information, see Import a Microsoft Project file with the Import module.
- Configure the Project form to add the custom fields that you want to see. For more information, see Form configuration.
Parent Topic:Importing and exporting projects
Related topics
Project import from Microsoft Project
Import project tasks for multiple projects
Project export to Microsoft Project