topic Match original filenames to document IDs in Product Forum

Match original filenames to document IDs

Nkateko_GlenNgu — Mon, 12 Apr 2021 12:41:51 GMT

Please assist, I have a process I am building that requires me to match the input file names to the Decipher work items (or Document IDs) on Blue Prism.

So using the Document IDs from getting Next Completed Batch, I wanted to pull the original filenames by querying the Decipher Server DB directly.

I have tried doing it manually first on the DB server but the filename I get is the name Decipher created instead of the original filename.

If this possible? To get the original filename and if so which table has this information?

Re: Match original filenames to document IDs

zdenek.kabatek — Tue, 13 Apr 2021 14:53:53 GMT

Hi,

here is the link https://portal.blueprism.com/products/developer-jumpstart where you can find Decipher Templates and Decipher Instructions. It contains description how to NOT OBFUSCATE filenames and then there is an sql query which extracts filenames together with Document ID and batch id. If you need more help write me PM.

Regards,

Zdenek

Re: Match original filenames to document IDs

Nkateko_GlenNgu — Tue, 13 Apr 2021 20:45:39 GMT

Hi Zdenek,

Thank you so much for the direction, it resolved my problem.

I used the Decipher Process Template 2 and it updated the work items with the right metadata, which includes the original input file names.

Now I can get the file name together with the data extracted within the same work item.

Regards,
NK