topic RE: PDF toolkit file conversion from PDF to Excel(XLSX) format in Product Forum

PDF toolkit file conversion from PDF to Excel(XLSX) format

Tejaskumar_Darji — Mon, 27 Jun 2022 06:08:00 GMT

Hi team,

In the Adobe PDF Toolkit VBO, I could not find relevant action to convert PDF to other formats except DOCX.
PDF to Word is working fine but I'm looking for PDF to Excel file conversion using the same VBO.

I tried to tweak certain things with PDF to DOCX action but it did not work.

@Geoff Hirst can you help here

Thank you for your help always.

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

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

RE: PDF toolkit file conversion from PDF to Excel(XLSX) format

devneetmohanty07 — Mon, 27 Jun 2022 06:34:00 GMT

Hi @Tejaskumar_Darji,

Did you try to tweak the code for the PDF to Docx, action with the below highlighted section:

As per the official Adobe Services documentation for this API call: ExportPDFTargetFormat, the ExportPDFTargetFormat() enumerator class can have the following list of enumerator constants:

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: PDF toolkit file conversion from PDF to Excel(XLSX) format

Tejaskumar_Darji — Mon, 27 Jun 2022 07:22:00 GMT

Yes, Devneet that is what we tried but BP freezes while stepping over the code stage for PDF to XLSX fr longer times and ultimately have to kill task from task manager

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

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

RE: PDF toolkit file conversion from PDF to Excel(XLSX) format

devneetmohanty07 — Mon, 27 Jun 2022 07:41:00 GMT

Hi Tejas,

It is bit strange as for me the same is working with a test PDF file. There is an API limit over 200 pages for any given PDF file under the trial license. Can you let us know how many pages does your PDF file has?

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: PDF toolkit file conversion from PDF to Excel(XLSX) format

michaeloneil — Mon, 27 Jun 2022 07:57:00 GMT

Hi Tejaskumar

If you are getting the file as a word doc then you can probably get it into excel with a few additional steps. Once its in a word format open it then save as using file extension .mht which will save the file as a single file web page. You can then open this format in excel and if necessary you can then save as to .xlsx

Hope this helps

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

RE: PDF toolkit file conversion from PDF to Excel(XLSX) format

Tejaskumar_Darji — Tue, 28 Jun 2022 14:54:00 GMT

Thanks for your guidance @devneetmohanty07

Yes, it worked finally. PDF was okay it had 2 pages only.

But what we noticed and tried on 2 different machines is that either it converts properly OR it hangs BP indefinitely.

Not sure if it has to do with some DLL changes we had to make for the PDF toolkit to work but this occurs randomly.

For now, we are trying to build a code stage for the same with better exception handling which will be called from BP that uses the same PDF toolkit.

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

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

RE: PDF toolkit file conversion from PDF to Excel(XLSX) format

GeoffHirst — Wed, 29 Jun 2022 11:41:00 GMT

Hi Tejas,

Sorry for the delay, slightly under the weather at the moment (C19+). I am working to add the additional document types that it seems this toolkit now supports. I am not sure when these were added, my focus with updates to this toolkit have been dealing with framework assembly clashes that occur between assemblies used by Blue Prism and the PDF services toolkit.

Bear with me, I am working on this right now along with adding to the test harness. I will post an update when I am happy with what I have got. My concern lies over your statements of Blue Prism hanging. Now, what I have done, is updated my Visual Studio app as there were a number of referenced assemblies that had updated versions. So, when I have made progress on all this, I will post again.

Thanks for your patience. Appreciated.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------

RE: PDF toolkit file conversion from PDF to Excel(XLSX) format

SumitKewalrama1 — Thu, 05 Oct 2023 03:55:00 GMT

Hi Tejas,

Could you please let me know which object have you used to convert PDF to excel? Is it working for you?

Thanks

Sumit

------------------------------
Sumit Kewalramani
Software Engineer
Commonwealth Bank
Asia/Kolkata
8302925510
------------------------------

RE: PDF toolkit file conversion from PDF to Excel(XLSX) format

Tejaskumar_Darji — Thu, 05 Oct 2023 09:26:00 GMT

check this asset on DX

------------------------------
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
------------------------------

RE: PDF toolkit file conversion from PDF to Excel(XLSX) format

SumitKewalrama1 — Tue, 10 Oct 2023 09:13:00 GMT

Hi All,

Could you please share the object link which is currently supported and working to convert PDF to Excel in BP V6.4.

I tried using DxInDev - PDF To Excel Converter but it is getting stuck while opening the PDF file in word code stage, please suggest If I am missing any configuration DLL or any support would be highly appreciated.

Thanks

Sumit Kewalramani

------------------------------
Sumit Kewalramani
Software Engineer
Commonwealth Bank
Asia/Kolkata
8302925510
------------------------------

RE: PDF toolkit file conversion from PDF to Excel(XLSX) format

Tejaskumar_Darji — Tue, 10 Oct 2023 09:33:00 GMT

Can you tell us the error msg or snapshot of the error?

Also, ensure you are using the latest VBOs for MS Word and all other dependencies from Digital Exchange.

RE: PDF toolkit file conversion from PDF to Excel(XLSX) format

SaiVarada — Thu, 19 Oct 2023 17:27:00 GMT

Hi Tejas,

I can you please help with he pdf tool kit link in the Digital exchange as I am able to find with the name.

Thanks,

Sai

------------------------------
Sai Tharani Macharla
------------------------------

RE: PDF toolkit file conversion from PDF to Excel(XLSX) format

Tejaskumar_Darji — Fri, 20 Oct 2023 05:21:00 GMT

I checked, but I was also not able to find

Does anyone have an idea?

Geoff Hirst

RE: PDF toolkit file conversion from PDF to Excel(XLSX) format

GeoffHirst — Fri, 20 Oct 2023 10:27:00 GMT

Hi,

This asset in its current guise has been archived and is no longer available. The reasons for this are as follows:

Adobe made significant changes to their PDFServicesSDK.dll that rendered it inoperable with Blue Prism. It would cause Blue Prism to hang and it was only possible to recover by killing processes.
Adobe have recently announced they are moving to OAuth2 authentication and have given everyone with accounts on their developer until Jan 2025 to migrate over to this authentication type. This is part of the reasoning behind the previous note.
We have moved over to the following asset, making use of the Adobe PDF Services API, https://digitalexchange.blueprism.com/dx/entry/3439/solution/blue-prism---adobe-pdf-services---export
This asset provides the same functionality with the exception of the form filling and html conversion. This will be added at a future date.

We felt we had no choice but to archive the previous edition to prevent users experiencing the same problems we had seen and the rewrite provides the same functionality. Given that the PDFServicesSDK.dll was a wrapper around their API, very little has changed except this version is quite upfront about it. This type of problem is always a possibility when third party dlls are used.

One thing to bear in mind with the API version, it makes use of AWS services and as such, your documents are transmitted to the storage to be worked upon. From reading the documentation, no documents are retained after conversion. There is an option for you to use your own storage, this is not demonstrated and whilst it does provide additional security for your documents, you would be responsible for the document management.

I hope this explains the situation and the reasoning for our decision.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------