ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to update Task ID for tasks in bulk


Article ID: 127117


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


Task ID is by default not a mandatory field for tasks. There are many (1000+) tasks which have blank/null Task IDs (prexternalid). Is there a way to update the task ids for these tasks having blank task Ids?


  • Release: 16.0.1
  • Component: ODXOG


If you are using either MSP or OWB, you could user below workaround. We would recommend to do it in OWB if possible over MSP.

A workaround to have those task ID's populated manually in Microsoft Project and save them back to PPM can be done with the following:

  1. Use Excel's autocompletion feature to populate a column of cells with consecutive ID's (i.e. like 1, 2, 3, 4, etc.) 
  2. Copy and paste that column into the project task list in Microsoft Project in the Text1 column (this column will need to be added to your view by selecting it from the drop-down fields) 
  3. Save the project back to PPM (you'll see that the task ID's are now populated)

XOG is not an option to update as it would create another Task as opposed to updating an existing one.

We don't support doing direct database updates because it may cause adverse scenarios.