Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Integrating Document Registers from Sharepoint to Primavera

No replies
Hans Eberwijn
User offline. Last seen 2 years 40 weeks ago. Offline
Joined: 26 Oct 2015
Posts: 1
Groups: None

Goodday everybody, 

I'm investigating the options to have a reliably integration between the project documents as they are managed in sharepoint, and the document status in primavera.

I see a lot of planners and project teams, delivering a lot of effort to manualy setup and maintain all the documents and their workflow in Primavera. this is done via excel dumps from the document metadata in sharepoint, and than "manualishly" fed into P6. 

Fact is that in my organisation, Sharepoint for document control is a fact to live with, and so is Primavera. 

Anyone some experiance connecting SharePoint document status information in a practical way?

Or as a second question: Does anyone have experiance in reflecting the document register status in Primavera in a pragmatical way? 

P.S. I want to steer away from the discussion if all documents should be in the P6 schedule or not, I found that there are many other forum topics on this matter. 

Kindest regards,

Hans 

Rodel Marasigan
User offline. Last seen 17 weeks 3 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699

If you are familiar with excel XER purser builder you can update the P6 database using xer import/ export. You need 4 tables that must be included on the xer. If you have a existing project using WP & Docs module you can easily export and update only the necessary tables and build the xer. The tables for WPs & Docs are:

  1. DOCCATG - (Document Categories) This table is accessible/ modified in P6 Admin Catergories --> Document Categories
  2. DOCSTAT - (Document Statuses) This table is accessible/ modified in P6 Admin Categories --> Document Status
  3. DOCUMENT - (Work Products and Documents library) This table is accessible/ modified in P6 WPs & Docs module
  4. TASKDOC - (Document Assignments) This table is accessible/ modified in P6 WPs & Docs modules or P6 Activity Detail --> WPs & Docs tab.

The link field for actual location of documents can be set in DOCUMENT table on field private_loc (Private Location) or field public_loc (Public Location).