Create custom field mapping for Microsoft Project file import
-
- UpdatedAug 1, 2024
- 2 minutes to read
- Xanadu
- Project Portfolio Management
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
- 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 .
- 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 with the Import module.
- Configure the Project form to add the custom fields that you want to see. For more information, see Form configuration.
Related Content
- Calendars and schedules- Limitations
Some calendar elements from Microsoft Project are not imported into the Project Management application.
- Project field mapping
During an import, values from Microsoft Project overwrite fields in project records.
- Project import from Microsoft Project
Import Microsoft project files into the ServiceNow Project Management application.
- Import project tasks for multiple projects
Import project tasks for multiple projects from an external file system or data source using import sets and transform maps.
- Project export to Microsoft Project
If you are using Microsoft Project to manage project activities, you can export a project to Microsoft Project (mpp) file, an XML file, or a CSV file.