topic RE: How to Write Decipher Collection Data To Excel in Product Forum

How to Write Decipher Collection Data To Excel

ChetanNinghot — Wed, 12 Oct 2022 11:23:00 GMT

Hii
I am New User Of Decipher
I Have Get Data Collection One By One Invoice Data From Decipher
How To Stoare those Data Collection To Excel

------------------------------
Chetan Ninghot
------------------------------

RE: How to Write Decipher Collection Data To Excel

Tejaskumar_Darji — Thu, 13 Oct 2022 05:57:00 GMT

Hello there,

1. Get Next Completed Batch Action from Decipher VBO will give you Document IDs in output.

2. You can use the Get Document Data action using the Document ID retrieved from Step 1.

3. Once you get all invoice data then you can format your data collection if needed and store your collection directly to excel using MS Excel VBO

Also in Decipher Admin Panel / Batch Types settings, if you enable CSV export Decipher will automatically export your data in a CSV file.

For this, you need to enable the CSV export option in Batch Types.

Then you can build some logic in BP to fetch this CSV file and use it further.

let us know how it goes for you and if need any further help.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------

RE: How to Write Decipher Collection Data To Excel

ChetanNinghot — Thu, 13 Oct 2022 12:07:00 GMT

Hii
Tejas kumar darji
Thank you for your response

It will try it
It may helpful for me

------------------------------
Chetan Ninghot
------------------------------

RE: How to Write Decipher Collection Data To Excel

lookman — Thu, 13 Oct 2022 13:40:00 GMT

Hi Tejaskumar.

Thank you for the very detailed answer!

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------