View source for Extracting data from documents and attachments into a case

Extracting data from documents and attachments into a case / ← Documents and attachments - Ingesting docs, extracting data, and populating cases

You do not have permission to edit this page, for the following reasons:

• The action you have requested is limited to users in the group: editor.
• The action you have requested is limited to users in one of the groups: editor, Administrators.

---

You can view and copy the source of this page.

{{Design pattern|Title=Documents and attachments - Ingesting docs, extracting data, and populating cases|Description=Learn more about how to handle documents and attachments, and how to extract their data into your cases|Version=8.5|Applications=Pega Platform|Capability Area=Data Integration|Owner=Prabhu, abhay}} {{Content moved | newUrl = https://docs.pega.com/bundle/platform-88/page/platform/data-integration/considerations-ingesting-documents-extracting-data-populating-cases.html }} Documents and document handling are essential to any digital application, as they are one of the important sources of required information for work flows. They also serve as a bridge between a Pega application and the personas that cannot directly interact with the application. For example, a customer in a bank loan dispute has to present their income information to their financial institution, but does not have direct access to the institution’s banking application. The customer can thus present the information in an Excel spreadsheet that can then be used to populate the case with the relevant information, with the document attached to the case as proof. When designing a feature around documents, some of the questions that you might ask yourself are: * How will the document be uploaded to the application? * Will any data need to be extracted to the case? * What are the permissible document formats? * Should the document be attached to the case? * What actions are allowed on the attachments - can they be updated or deleted by everyone? == Ingestion, Extraction and Population of attachment data to a Case == The most common way of ingesting a document to a Pega application is by using out-of-the-box flow actions such as ''pxFileUpload'', which uploads documents to the file system on the server, from where they can be used for any other processing, such as sourcing the extraction data or attaching the document to the case. Documents can also be ingested and linked to a case directly by using the [https://community.pega.com/knowledgebase/articles/case-management/85/attaching-content-case Attach Content] smart shape, or the ''pyAttachContent'' flow action in a flow. Based on the document type, a corresponding extraction mechanism can then be configured. For example, if the source file for extracting the information is an Excel spreadsheet, you can use the [https://community.pega.com/knowledgebase/articles/case-management/85/activities-integrating-cases-excel-documents ''pxParseExcel''] file. This mechanism requires the file to be stored on the server file system, hence the use of ''pxFileUpload'' rather than case attachments would be a wise design choice These extraction mechanisms typically populate properties on a given clipboard page or a page list, which can then be directly used to populate a case using standard rules, such as data transforms or activities. == Attachments == Attachments are instances of the ''Data-WorkAttach-File'' class that are stored in a database and are linked to a work object. If you choose to use the Attach Content shape or the ''pyAttachContent'' flow action, the document will be directly attached to the case and no additional configuration will be required. As in the previous example, if a mechanism such as ''pxFileUpload'' is used, then the document will be stored on the server file system and will have to be converted into a ''Data-WorkAttach-File'' instance and linked to the case. You can do this by creating your own activity, or by using the standard Pega API, for example, the ''AttachFile'' activity. Your design can dictate certain restrictions to the user while accessing the attachment, for example, by making their access to it read only, or access only when the user has a certain privilege, etc. These restrictions are governed by the category rules and the configurations (like privileges, access when and create/edit/delete permissions) are housed within those rules. Pega Platform ships with the following five category rules out of the box: * Scanned Document * URL * Note * Screenshot * File Based on your design you can use one of these default categories, extend them, or create more if the restrictions are to be made stricter or more lenient. For more information, see the Pega Community article on [https://community1.pega.com/sites/pdn.pega.com/files/help_v74/procomhelpmain.htm#case-management/case-designer/case-wide-properties/attachment-categories/cm-restricting-access-to-attachments-tsk.htm Creating and configuring categories for case types]. == Additional information == https://community.pega.com/knowledgebase/articles/process/how-create-activities-attach-files-work-objects https://community.pega.com/knowledgebase/articles/case-management/85/activities-integrating-cases-excel-documents https://community.pega.com/knowledgebase/articles/correspondence/how-configure-email-service-use-email-attachment-work-object-attachment https://community1.pega.com/sites/pdn.pega.com/files/help_v74/procomhelpmain.htm#basics/portal/casemanager/cm-adding-case-attachment-from-cmis-repository-tsk.htm https://community.pega.com/knowledgebase/articles/configuring-application-bulk-upload-data-using-excel-spreadsheet

Return to Documents and attachments - Ingesting docs, extracting data, and populating cases.