Free Trial

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
Top Solution Authors