ServiceNow CIS-SPM free question 7 / 10 · Domain 5: Project Management
You want to bring a custom column on tasks in a Microsoft Project file into a field of ServiceNow project tasks, using Project - MSP Import Field Mappings. Which procedure matches the official steps?
- Enter the column name in Microsoft Project Column, and the field in Destination Column is created automatically at import
- Create the custom field on the Project Task table first, then in the mapping select Project Task as Table and the field as Destination Column
- Create the custom field first, select Project Task as Table, then enter the ServiceNow field in Microsoft Project Column and the column name in Destination Column
- Create the custom field first, and write the ServiceNow field name in the Text10 column of the Microsoft Project file
Show the answer and explanation
Answer: B
Why this is correct
Before the import, you create the custom field on the ServiceNow instance and map it to the custom column of Microsoft Project. Under Project Administration > Project - MSP Import Field Mappings, you select New and choose Table according to the table where you created the field (Project Task if you created it on the project task table). You enter the column name of the Microsoft Project file in Microsoft Project Column, choose the ServiceNow field to map to in Destination Column, and Submit. The role required is it_pps_admin.
Why the other options are wrong
"Enter the column name in Microsoft Project Column, and the field in Destination Column is created automatically at import" … The field is not created at import time. The procedure is to create the custom field on the ServiceNow instance first and then create the mapping.
"Create the custom field first, select Project Task as Table, then enter the ServiceNow field in Microsoft Project Column and the column name in Destination Column" … The two fields are swapped. Microsoft Project Column takes the column name from the Microsoft Project file, and Destination Column is where you choose the ServiceNow field to map to.
"Create the custom field first, and write the ServiceNow field name in the Text10 column of the Microsoft Project file" … Text10 is the column used to tell whether a project was exported from ServiceNow: if the sys_id is in this column of the top-level task, the existing project is overwritten with the imported values. Field mapping is done with the mapping.
A way without mappings
Instead of creating fields and mappings, you can create a script include with the Scripted Extension Point MSProjectImportTaskFormatter and map the custom fields that way. With this extension point you can also adjust the data at import. Supported data types include True/False, Choice, Currency, Date, Reference, and String.
Go to the ServiceNow CIS-SPM practice app (10 free questions; purchase unlocks all questions)