Clarity PPM

Expand all | Collapse all

How to read the file contents from database filestore?

Jump to Best Answer
  • 1.  How to read the file contents from database filestore?

    Posted 12-19-2017 10:36 PM

    Hi,

     

    We are on Clarity v15.2 on-premise. When we upgrade from 13.3 to 15.2, the filestore is moved from application server to database. Now, the filestore is embedded into database. Our GEL scripts were reading the file contents from the application servers previously and are not working now. I tried some other ways to get the data directly from database, but could not succeed. The files are stored as BLOB in database.

    I checked few questions on the community, but they just said when the filestore is in database, we cannot read the contents directly. I found no solution on this.

    Anyone has succeeded in reading the file from database directly using GEL script? If yes, can you please help me in this regard?

     

    Thank You.

    Kind Regards,

    Sajeela.



  • 2.  Re: How to read the file contents from database filestore?
    Best Answer

    Posted 12-19-2017 11:02 PM

    Hi Sajeela,

     

    You are able to read contents by using xog.

    If you do xogout documents from filestore, they will be placed in server directory.

    After that, you will be able to access them by GEL.

     

    There is thread about document xog. It maybe helpful for you.

    Is it possible to send an attachment field via Web Services 

     

    Regards,

    Shoichi 

     



  • 3.  Re: How to read the file contents from database filestore?

    Posted 12-20-2017 02:51 AM

    Thank you so much for the solution, Shoichi.

    I can read the file contents now.

     

    Kind Regards,

    Sajeela.