PDF Input tool Error Message

[AT_AYX]

Hi everyone,

I tried the PDF Input tool found in the gallery and I stumbled upon this error : "PDF Input (14): BatchPDFInput (26): Record #1: Tool #2: Error: .onLoad failed in loadNamespace() for 'pdftools' ".

So I followed a link for solving the issue and installing the missing R package from the gallery.

However, the error still persists and I was just wondering why it didn't work.

Please, if you could help me resolve the issue.

Link:  https://www.youtube.com/watch?v=0aM9YqC1Uuo&t=123s&ab_channel=NathanPatrickTaylor

PDF Input: https://gallery.alteryx.com/#!app/PDF-Input/5b685aff0462d710907f7a3b  

Installing R packages: https://gallery.alteryx.com/#!app/Install-R-Packages/5d9264328a933711e447387c 

Snapshot:

 

[Gualigee]

I am running into the same problem. 

I did not see a file called rcpp. @someotherguy @OllieClarke Thank you!

[OllieClarke]

Hi @Gualigee 

RCPP is another R package which needs to be updated if you've upgraded Alteryx. As has been mentioned in this thread by myself and @AnthonyFic the upgrade in R versions requires an update in a number of packages. 

The easiest way to do this is to find the version of R installed with your version of Alteryx ("C:\Users\[username]\AppData\Local\Alteryx\R-[r version]\bin\R.exe" on a non-admin install). Double click R.exe to run it and then use the command

update.packages()

This will then ask you whether you want to update all the packages installed. I said yes to all of them, but the 4 required are (from @AnthonyFic's post)

pdftools

qpdf

tesseract

Rcpp

This should fix your problem

edit:

The reason you don't see Rcpp in your R-library, is that (I believe), for packages installed by default rather than installed by users, the filepath is: "C:\Users\[username]\AppData\Local\Alteryx\R-[r version]\library"

[Gualigee]

Thank you for your reply, @OllieClarke 

I clicked on the above icon. After I ran the command, it says "pdftools will not be updated". 

They kept asking if I needed to installl this and that but I need not see the following:

qpdf

tesseract

Rcpp

Can you please advise what I should do next?

Thank yo u very much.

[OllieClarke]

@Gualigee it looks like you've got multiple R versions installed, and multiple libraries too. That's not an issue in itself though. Once you've updated the packages, and tried to use the PDF Input tool in Alteryx, what happens?

[summarizer]

Hi all... this macro has been a godsend for years.  I came here to ask a question which I'm now editing.  After some trial and error, I found that @AnthonyFic 's comment with the Admin and Non-Admin paths helped us figure out where to place the tools.  In the past, I've had them read in from different places - including my documents which has worked - but not this time.  Once I installed them to the Non-Admin location that worked like a charm.  I'm using 2023.1. 

[summarizer]

Updating this because I just posted on another thread that for some reason I can't find (not showing in my profile).  I have one colleague who has her tools in the non-admin location and they are working fine.  I tried that and couldn't get it to work, but finally put them in the admin location where Rcpp is, and now it's working.  It's weird because we all have Admin versions of Designer, but sometimes it's just like that.  Hope that helps someone.