Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Execl To PDF Python Filer

jgrant161
5 - Atom

Hello,

 

I used the python code and batch macro that is available to create a work flow that fill out a PDF form. The workflow did its job and the for was filled out properly. The issue I am having is that my input file had three test lines and only one document is being saved. It shows that 3 iterations were ran successfully. I'm not sure if it is in the macro or Python code where the hiccup is happening. I have attached the relative files.

5 REPLIES 5
Raj
16 - Nebula

@jgrant161 
please add a zipped workflow as the workflow attached is missing the macro

jgrant161
5 - Atom

I did a package that includes the macro.

apathetichell
19 - Altair

somebody screwed up the macro. The python script is setup for a batch macro - not a standard macro. someone changed this to a standard macro - even if it's labeled as a batch macro.. The python is fine - but the python is set up to run one time per datastream. With a standard macro - the entire datastream is one python row - one iteration with line one as the template input/output file. The data has to be fed into control parameters - not a macro input.

 

the correct way this is upposed to work is:

1) delete the macro input.

add a text input.

add two fields in the text input called template and filename.

 

add a control parameter

add a second control parameter

label one template

label one filename

3) add two action tools - connect one from template to text input. one from filename to text input.

set one to update one column. one to update the other.

 

4). save.

jgrant161
5 - Atom

Thank you for the reply! I updated the macro and 3 pdfs were created however they are blank. I tried opening in both adobe and using chrome but no data was transferred. Did I miss something in the macro setup?

apathetichell
19 - Altair

@jgrant161 - you are getting there:

set one to update one column. one to update the other.

 

both action tools are setting up the same column. template is being read correctly - filename isn't. swap the second action tool to column 2 (from column 1 in the actoin tool dropdown).

Labels