Getting file name with Document ID

[Carlos_Medina]

Hello everyone, I was wondering if there is a way to retrieve the file name of the document that I've sent to Decipher, like "Document1.pdf," using the document ID I've obtained from Decipher in Blue Prism.

I'm using a query that is connected as follows:
FROM Document d
INNER JOIN InputFile i ON d.BatchId = i.BatchId AND d.DocumentIndex = i.FileIndex

But in cases where the size of the documents in the batch is different from when I've sent them, for example,

I've sent 3 documents in one batch, but I marked one of them as an exception, and only two were completed to be processed in Decipher. In this case, when that happens, the document I get in the output of the query is different from the respective document in Decipher.

I tried looking for a table with the document ID, but couldn't find one. Is there any table from which I can obtain the file name of the document using the document ID?

------------------------------
Carlos Medina
------------------------------

[BenLyons]

Hi Carlos,

There's no join between file name and document in the Decipher tables. This is because files can contain multiple documents, so you could have a 1 to many join.

Using the reporting tool available in the Decipher portal downloads does perform a function that simulates this join.

This has been updated in v2.3, due out early next year.

Thanks 

------------------------------
Ben Lyons
Senior Product Specialist - Decipher
SS&C Blue Prism
UK based
------------------------------

[lookman]

Hi Carlos.

You could use the Add Metadata and Get Metadata actions from the Decipher VBO. 

When you read the files that you are going to push to Decipher, you can add that information to the batch that they belong to via the Add Metadata action. On the get side, after you've read the batch, you can use the Get Metadata action to retrieve the file name(s) that are associated with the batch.

As Ben pointed out, this information will be part of the data that you get from Decipher in v2.3. As I understand, Add and Get Metadata actions will also be retired. However, if you need this information now and cannot wait for v2.3, this is a pretty easy way to get the file names.

jack

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

[Tejaskumar_Darji]

If you are exporting csv then you can append the original PDF name in export. See below. I generally use this way to track the file name.

C:\Decipher Direct Export\$(DocFileName) - $(CurrentDate-yyyy-MM-dd hh_mm_ss)

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

Thanks & Regards,
Tejaskumar Darji - https://www.linkedin.com/in/tejaskumardarji/
Technical Lead
------------------------------

[BenLyons]

Worth noting this would need to be in a folder the account running the web client (likely a service/system account) will need folder access, as will the person/digital worker looking use the file.

------------------------------
Ben Lyons
Senior Product Specialist - Decipher
SS&C Blue Prism
UK based
------------------------------