Project and Portfolio Management Practitioners Forum
cancel

How to extract files or attachments to a physical file in PPM Center Database DMS

Highlighted
roms_support
Valued Contributor.

How to extract files or attachments to a physical file in PPM Center Database DMS

Currently we are using PPM File System solution in our attachment and document solution but we are planning to deploy PPM Center Database DMS solution to have a document version control.

 

If we implement PPM Center Database DMS solution, the files won't we stored in attachment folder (server) anymore but it will be stored in DB as BLOB. Our problem is that we are using this physical files in attachment folder in some of our processes and as per HP we cannot have these 2 features at the same time using OOTB PPM.

 

Do you have any suggestion or any customize workaround on how can we obtain these 2 features? document version control and file system inside the server folder.

 

Thanks.  

6 REPLIES
AlexSavencu
Acclaimed Contributor.

Re: How to extract files or attachments to a physical file in PPM Center Database DMS

Hi,

 

you can create a program which would watch the PPM table where the documents are stored and download them to the filesystem.

 

cheers

alex


--remember to kudos people who helped solve your problem
roms_support
Valued Contributor.

Re: How to extract files or attachments to a physical file in PPM Center Database DMS

Thanks Alex.

 

Can you please enumerate it specifically? This program is made of what language?

 

Actually these physical files should not be needed with all the attachments, we only have at least 2 important files:

1. This attachment is needed to be copied to another folder to give a specific user a static view of the request.

2. This attachment is used as a lookup table/data. So basically we already have customized functions that reads a physical file (excel/word) and gets the needed data/information inside.

 

Our current functions/programs were mapped to this File System (attachment folder) but if we implement PPM Center DMS we are not sure how can we get this files.

 

AlexSavencu
Acclaimed Contributor.

Re: How to extract files or attachments to a physical file in PPM Center Database DMS

Hi,

 

you can create a java program (or .net) to reside on the PPM application server machine. In this program you can incorporate the logic to download the files to the desired location and also to make use of the required logic for the lookup tables that you already have.

 

I would recommend to get in touch with a developer from your company who would provide you with more details.

 

cheers

alex


--remember to kudos people who helped solve your problem
Utkarsh_Mishra
Acclaimed Contributor.

Re: How to extract files or attachments to a physical file in PPM Center Database DMS

If you are interested to write a code on your own, then can take reference from these links

 

http://www.dba-oracle.com/t_writing_blob_clob_os_file.htm

 

http://stackoverflow.com/questions/6332032/how-can-i-extract-files-from-an-oracle-blob-field

 

Or can google it... you'll get the answer.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Etienne_Canaud
HPE Expert

Re: How to extract files or attachments to a physical file in PPM Center Database DMS

Here are the relevant DB tables where to look:

 

 KNTA_DOCUMENTS: This table stores PPM documents metadata: file name, check out status, and more importantly, Document ID (the identifier of a document in PPM), and "Parent Entity ID/ Parent Primary Key".

Parent entity ID will tell you whether the document is attached to a request, a project, etc, and parent primary key will give you the ID of the request or project to which this document is attached. That's how you can easily get the list of all documents current attached to request #12345.

 

Now, once you have the document ID of the document you want to download, you should look it up in table KNTA_DOCUMENT_TIP_CONTENTS. This table only contains the tip version, i.e. the latest version of a document (that's typically what you'll want to download). Retrieve the record with the right document ID, and download the BLOB value of "DOC_CONTENT" column into a file, and voilà. Feel free to refer to the links provided by Utkarsh in order to do that.

 

Kind Regards,

Etienne.

Etienne_Canaud
HPE Expert

Re: How to extract files or attachments to a physical file in PPM Center Database DMS

Actually, if all you want is to dump latest version of all PPM attachments as files in a folder, there is a very simple solution:

 

1) Go to admin console, and select "DMS Configuration"

2) Select the "Migrate" option

3) Selection "PPM File System" option

4) Input the path of where you want to export all files. If you have a PPM Clustered installation, it needs to be a shared folder with write access

5) Start Migration. Don't worry, no document will be impacted, at this stage it will simply copy all documents on the file system (note that history versions will not be copied, only latest version of each document)

6) When the migration is completed, just click "Cancel", and you're done. All files have been copied to the (shared) folder. 

 

You can rerun these steps whenever you need a fresh dump of all files, but note it will re-overwrite the files everytime, you cannot just copy the new or modified files.

 

If you want to keep all historical versions of the files or if you want a more "user friendly" folder structure, I cannot think of any solution (well, at least no solution officially supported by HP).

 

Kind Regards,

Etienne.