Project Description Gets Overwritten by MSP Notes when updating existing project

[GSathyaPrakash]

Hi,

After importing a Microsoft Project (.mpp) file using the 'Update an existing project' option, the 'Description' field on the project record is being updated with the value from the 'Notes' field in the Microsoft Project.

I followed the knowledge article below to prevent the description field from being updated when it already contains a value, but I'm not getting the expected result.

Knowledge article -  - https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1383196 

Could anyone please help with this?

[Matthew_13]

Hi Buddy,

 When you use Update an existing project, ServiceNow automatically maps the Notes field from Microsoft Project into the Description field and will overwrite it unless you explicitly stop that behavior.

If the KB steps aren’t working, it’s usually because the logic isn’t applied in the right place or something else is overriding it afterward.

A few I think you should double-check:

• Make sure you updated the transform map for “Update existing project”, not the one for creating a new project. They’re separate.

• Open the Notes → Description field mapping and add logic so it only sets the Description when it’s empty. For example:

  if (!target.description) {
      target.description = source.notes;
  }

• Confirm there isnt another field mapping or transform script later in the same map that also updates Description.

• If it’s still getting overwritten, check for any Project business rules that run on update and touch the Description field.

Basically, the KB approach does work but it has to be on the correct transform map and nothing else can be resetting the field after the transform runs.

Hope that helps my Friend! 🙂

@GSathyaPrakash  Please mark Solution Accepted and Thumbs Up my Friend!!

[GSathyaPrakash]

Hi @Matthew_13 ,

Thanks for your response.

I'm not able to find the transform map “Update existing project”  which you mentioned above.  Could you please share the link?
 

[Matthew_13]

Hi Buddy,

There isn’t a direct link I can share for that transform map, since transform maps are instance-specific. That’s why you won’t find a public URL for “Update existing project.”

To locate it in your instance, try the following:

1. Navigate to System Import Sets → Administration → Transform Maps.

2. In the list view, search for keywords like Microsoft Project or Project.

3. Look for a transform map where the Target table is Project [pm_project].
   You should see separate maps for creating a new project and updating an existing one.

4. The update map may not be named exactly “Update existing project” — the label can vary slightly by version, but it will clearly reference Microsoft Project and updating projects.

Once you open that transform map, check the field mapping where MSP Notes maps to Project Description. That’s where you need to add the conditional logic so the description isn’t overwritten when it already has a value.

@GSathyaPrakash  Please mark Solution Accepted and Thumbs Up my Friend!!