Create custom field mapping for Microsoft Project file import

  • Release version: Xanadu
  • Updated August 1, 2024
  • 1 minute to read

    • 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

    1. Navigate to All > Project Administration > Project - MSP Import Field Mappings.
    2. Click New.
    3. From the Table list, select the table in which you created the custom field.
      TaskAction
      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.
    4. In the Microsoft Project Column field, enter the name of the custom field in your Microsoft Project file that you want to map.
    5. In the Destination Column list, select the custom ServiceNow field that you want to map to the Microsoft Project field while importing a project.
    6. Click Submit.

    What to do next