nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Execl To PDF Python Filer

jgrant161

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.

TX Certificate PDF Fill.yxmd

TX_Cert_Template.pdf

TX_Cert_Template.xlsx

PDF Form Fill.yxmc

Python

Batch Macro

Accepted answers

apathetichell

@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).

All comments

Raj

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

jgrant161

I did a package that includes the macro.

TX Certificate PDF Fill.yxzp

apathetichell

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

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?

TX Certificate PDF Fill.yxzp

apathetichell

@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).

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15911

binu_acs 15783

MarqueeCrew 13710

apathetichell 13703