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:
Products
Issue/Introduction
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
Environment
Component:
Feedback
