search cancel

Clarity & Microsoft project: Is there a way to tell which projects in Clarity have been updated in Microsoft project? Where are the Project (.MPP) files stored in the database?


Article ID: 51009


Updated On:


Clarity PPM SaaS Clarity PPM On Premise



When you save a Microsoft Project file into Clarity, after the various tables/fields have been updated through the interface, the actual

.mpp file is saved into the table PRDOCUMENT table.


The following queries can be used to identify which projects have been updated in Microsoft Project and that have the .MPP file stored in the database.

(SELECT * FROM PRDOCUMENT WHERE PRRECORDID = <project_numeric_id>) to check a specific project.
(SELECT * FROM PRDOCUMENT) to get a full list of projects that have an MPP file stored in the database.

Where the <project_numberic_id> is the internal 5XXXXXX number designated to the specific project. This can be gotten from:

select id from inv_investments where name='<project name>' and object_type = 'PROJECT'

Keywords: ClarityKB, Microsoft Project, MSP, Prdocument, MPP


Release: ESPCLA99000-12.1-Clarity-Extended Support Plus