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?

Document ID : KB000051009
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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.

Solution:

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