Decipher

 View Only
last person joined: 6 days ago 

A community for Blue Prism Decipher users.

  • 1.  Querying DecipherServerDB for Batch Status

    Posted 05-25-2021 15:08
      |   view attached
    Is there a sql query that can be used to directly query the DecipherServerDB to return the status of a given Batch ID (as shown in the attachment?  I would like to monitor statuses other than just 'Capture performed - ready for Verify' which is returned via Decipher VBO - Has Batches To Verify action

    I have taken a look at the tables in DecipherServerDB but could not find a suitable table that returns the Batch Status.

    ------------------------------
    Howard Blake
    RPA Development Lead
    Sopra Steria
    Europe/London
    ------------------------------


  • 2.  RE: Querying DecipherServerDB for Batch Status

    Posted 05-26-2021 04:27
    I've done some experimentation and found that the Status in the image you've shown likely corresponds to the Batch.Flags column.

    From what I can tell:
    In OCR, flag=1
    Classify performed - ready for ClassVerify, flag=419
    In Class Training..., flag=262147
    In Data Capture, flag=427
    Capture performed - ready for Verify, flag=443

    This is by no means a complete list of the flags, so you would need to doublecheck the flag columns against what you see in the Admin Panel, Batches page. 

    Please double check if this gives the correct result on your end, as I've only arrived at this based on actually pushing documents into Decipher, refreshing the Batches page in the Admin Panel, and monitoring the database to see what data has changed. There's also no guarantee that the flags will remain the same for future versions of Decipher.



    ------------------------------
    James Man
    Professional Services
    Blue Prism
    Asia/Hong_Kong
    ------------------------------

    Original Message


  • 3.  RE: Querying DecipherServerDB for Batch Status

    Posted 05-26-2021 11:25
    James

    Many thanks for taking the time to look into this for me.  It is much appreciated.

    ------------------------------
    Howard Blake
    RPA Development Lead
    Sopra Steria
    Europe/London
    ------------------------------

    Original Message


Related Content

Welcome to the Blue Prism Decipher Community

Blue Prism Decipher IDP is Intelligent Document Processing for Blue Prism RPA. This is a community for Decipher users to get support and discuss the implementation and usage of product.

This community has been set up so that we continue to work closely with our Decipher users, both new and established. As our members join, we will be using this community to share information, and also hope this will allow all members to discuss ideas and issues around Decipher.

Decipher IDP Resources

Download DecipherProduct Help

FAQs

Decipher IDP is a Blue Prism product for Intelligent Document Processing. It allows organizations to easily extract, analyse and understand data from a range of documents whether these are PDFs, email attachments, or even scanned paperwork.
Decipher IDP is currently available without additional cost to Blue Prism customers with Production or Business-Critical support.
Please contact your Blue Prism Account Manager or Customer Success Director for information on accessing Decipher. They will be able to request a license key which is required to be able to install Decipher IDP.
Yes, a trial version is available for Blue Prism customers. Please contact your Blue Prism Account Manager or Customer Success Director for information on accessing Decipher. We are planning to offer a trial version available for download from our DX later this year.
All documentation for Decipher IDP is available online on BP DOCS.
An extended FAQ can be found here.
Decipher IDP is currently available for Blue Prism Enterprise customer for on-premise installation.