Batch macro using python tool - can't figure out how to pass / read different files

ck2024 — Tue, 30 Apr 2024 11:27:33 GMT

Hi guys

I've been able to get this to work to read the contents of the PDF liberating someones pdf macro tool that was no longer working.

However, for whatever reason i couldn't get it to read the incoming files from the input tool - I resorted to referencing a file name specifically and i got that working. What would be the process to iterate through the folders - i was going to use a batch macro which would update based on the contents of a directory tool but i couldn't get that far:

Working python code

from ayx import Package
Package.installPackages(['pandas','numpy'])

from ayx import Alteryx

import pandas as pd
import pdfplumber

pdf = pdfplumber.open('c:/files/files/INVOICE_3660075585.pdf')
page = pdf.pages[0]
text = page.extract_text()
print(text)

page_df = pd.DataFrame([text])
Alteryx.write(page_df,1)

Also I don't think my pdfs run to 2 pages, but if they did, how would i update the code to grab more than one page?

any help would be appreciated... thank you

Re: Batch macro using python tool - can't figure out how to pass / read different files

Raj — Tue, 30 Apr 2024 17:51:03 GMT

@ck2024
is this the same case
Passing different filenames into python tool to co... - Alteryx Community

topic Batch macro using python tool - can't figure out how to pass / read different files in Alteryx Designer Desktop Discussions

Batch macro using python tool - can't figure out how to pass / read different files

Re: Batch macro using python tool - can't figure out how to pass / read different files