Question
FFIC
US
Last activity: 24 Oct 2016 13:39 EDT
How to handle old attachment in dataattach table after Pega-FileNet CMIS integration ?
Our application currently uses PRPC DB for storing attachments(out of the box), we are thinking of bringing in filenet for handling attachments. Say after integrating with Filenet using CMIS integration all newly created attachments would use filenet as the storage repository. How about old attachments, how to handle them ?
someone please suggest best way to handle this scneario please.
Our current system is PRPC 7.1.9
***Updated by moderator: Lochan to add Categories***Added helpme user request***
Accepted Solution
Pegasystems Inc.
IN
Hi
If you are moving your attachments to a diff table, then link table also needs to be updated otherwise end user will not be able to find it.
Virtusa IT Consulting
AE
I haven't tried but got an idea from the requirement you mentioned. I would've created an activity do an obj-browse/obj-open on Data-WorkAttach-File get the all files content (as in their attach streams with their attach names) in a pagelist, execute connect-cmis in next step asynchronously in a loop and passing each file content from the pagelist to the request parameter.
FFIC
US
Hi baigh, thanks for the suggestion.
how about updating link table ? i am little confused there.. because there should be a new destination info in the link table right ?
And we should also remove the attachment from data-workattach after it has been sent to filenet?
Virtusa IT Consulting
AE
Perhaps I didn't get the requirement correctly as I didn't understand why you want to update the link table when you want to move the data out of it and place it in some location on Filenet.
For your second question, you can use obj-delete method to delete the record from the database.
Accepted Solution
Pegasystems Inc.
IN
Hi
If you are moving your attachments to a diff table, then link table also needs to be updated otherwise end user will not be able to find it.
FFIC
US
Hi Santanu,
Could you assist me with this, i.e can you explain a bit more on how (what) to update in link table after the attachments are moved to File Net
COFORGE DPA UK LTD
GB
Hi,
I hope you have leveraged Pega OOB Capability to store the Attachement in Filenet. in Application rule, After attachments are enabled, you will continue to have access to work item attachments currently stored in the PegaRULES database. New work item attachments are stored in the content management system.
For more detail. Refer https://collaborate.pega.com/question/storing-emails-attachments-cms